PHP-ThinkPhpフレームワーク学習---よく使われるCRUD方法
1584 ワード
class CRUDAction extends Action {
public function addStu() {
$student = new Model ( 'Student' );
//
$data ['name'] = ' -02';
$data ['age'] = '45';
$data ['sex'] = ' ';
$count = $student->add ( $data ); //
echo $count;
}
public function updateStu() {
$student = new Model ( 'Student' );
$data ['id'] = 39;
$data ['name'] = ' -01';
$count = $student->save ( $data ); //
echo $count;
}
public function delStu() {
$student = new Model ( 'Student' );
$count = $student->where ( "sex = ' '" )->delete (); // 。
// $count = $student->delete (78); //
echo $count;
}
public function findById() {
$student = new Model ( 'Student' );
$obj = $student->find ( 39 );
var_dump ( $obj );
}
public function findAll() {
$stdent = new Model ( 'Student' );
$array = $stdent->select ();
var_dump ( $array );
}
// ------ Sql
public function stuBySql() {
$student = new Model ();
//
$sql_add = "insert into think_student(name,sex,age)
values (' -V2.0',' ','20');";
//
$sql_update = "update think_student set name = ' ...V2.0' where id =83";
//
$sql_del = "delete from think_student where think_student.id = 89; ";
//$count = $student->execute ( $sql_del ); //
//echo $count;
// --
$sql_query = "select * from think_class