目录:表单提交/数据写入(增)/数据读取(查)/数据修改(改)/数据删除(删)/ActiveReocrd模式
//根据表单提交的POST数据,创建数据对象
$user=M('Sks');
echo "<pre>";
//var_dump($user->create());
//接收表单post传来的
/*
$data['name']='德玛西亚';
$data['pass']='160';
$data['date']=date('Y-m-d H:i:s');
var_dump($user->create($data));
//直接覆盖
*/
/*
$data=new \stdClass();
$data->name=$_POST['name'];
$data->pass=$_POST['pass'];
$data->date=date('Y-m-d H:i:s');
var_dump($user->create($data));
//对象获取
*/
//var_dump($user->create($_GET));
//接收get
echo "</pre>";
//数据写入
$user=M('Sks');
echo "<pre>";
/*
$data['name']='alskdjklj';
$data['pass']='160460060';
$data['date']=date('Y-m-d H:i:s');
var_dump($user->add($data));
//add()直接写入
*/
/*
$data=$user->create();
$data['date']=date('Y-m-d H:i:s');
var_dump($user->add($data));
//结合create()方法
*/
/*
$data='name=阿斯蒂芬&pass=147258&date='.date('Y-m-d H:i:s');
var_dump($user->data($data)->add());
//data的连贯方法
*/
//var_dump($user->select());
//显示
echo "</pre>";
//数据读取
$user=M('Sks');
echo '<pre>';
var_dump($user->select());
//读取全部
//var_dump($user->find());
//只读取一条
//var_dump($user->getField('name'));
//读取第一条的name字段值
//var_dump($user->getField('name',true));
//读取所有的name字段值
//var_dump($user->getField('pass,name'));
//pass的值当键名,name的值当键值
//重复的会被屏蔽
//传递多个字段,获取所有
//var_dump($user->getField('id,name,pass',':'));
//[id]=>name:pass
//id冒号分隔
//var_dump($user->getField('id,name,pass',2));
//只有两条信息
echo '</pre>';
//数据修改
$user=M('Sks');
echo '<pre>';
/*
$data['name']='孤魂久客';
$data['pass']='ghjk';
$map['id']=6;
var_dump($user->where($map)->save($data));
//默认主键为条件
*/
/*
$data['id']=7;
$data['name']='阿斯蒂芬';
$data['pass']='asdf';
var_dump($user->save($data));
//默认主键为条件
*/
/*
$user->create();
$user->save();
//接收表单的修改 POST必须包含主键
//结合create
*/
/*
$map['id']=1;
var_dump($user->where($map)->setField('name','爱普生东方'));
//直接修改某个值
*/
/*
$map['id']=1;
var_dump($user->where($map)->setInc('pass',1));
//setInc累加,setDec 累减
//统计累计,累加累减
*/
//var_dump($user->select());
echo '</pre>';
//数据删除
$user=M('Sks');
echo '<pre>';
//var_dump($user->delete(8));
//直接删除主键(id=8)
/*
$map['id']=8;
var_dump($user->where($map)->delete());
//根据id来删除
*/
//var_dump($user->delete(8,9,10));
//批量删除8,9,10
/*
$map['pass']=0;
var_dump($user->where($map)->delete());
//为0,非数字,null
//删除pass为0的值
*/
//var_dump($user->select());
echo '</pre>';
/*
$user=M('Xxx');
echo '<pre>';
//var_dump($user->where('1')->delete());
//删除所有的数据
//小心,不要轻易解封
//var_dump($user->select());
echo '</pre>';
*/
//ActiveReocrd模式,简化CURD操作
$user=M('Sks');
echo '<pre>';
/*
$user->name='艾欧尼亚';
$user->pass='aony';
$user->date=date('Y-m-d H:i:s');
var_dump($user->add());
//直接--增
//添加一条数据
*/
/*
$user->create();
$user->date=date('Y-m-d H:i:s');
var_dump($user->add());
//用表单--增
//结合create POST必须包含主键
*/
//var_dump($user->find(4));
//查
//查找di=4的值
/*
var_dump($user->getByName('德玛西亚'));
//查
//查找name=德玛西亚的值
echo $user->pass;
//当查出来时,可直接输出
*/
//var_dump($user->select('1,3'));
//查
//通过主键查询多个
/*
$user->find(7);
$user->name='孤魂久客';
$user->pass='ghjk';
var_dump($user->save());
//改
*/
/*
$user->find(11);
var_dump($user->delete());
//删
*/
/*
$user->delete(10,11);
//删
*/
//var_dump($user->select());
echo '</pre>';