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
转载于:https://my.oschina.net/jack088/blog/639390