yourphp的sql语句

1.插入单条数据

$data[0]['cardid'] = $_POST['cardid'];
$data[0]['name'] = $_POST['name'];
$data[0]['mobile'] = $_POST['mobile'];
$data[0]['email'] = $_POST['email'];
$data[0]['address'] = $_POST['address'];
$data[0]['proid']= $_POST['proid'];

M('khmember')->addAll($data);

或者

$data[0]['cardid'] = $_POST['cardid'];
$data[0]['name'] = $_POST['name'];
$data[0]['mobile'] = $_POST['mobile'];
$data[0]['email'] = $_POST['email'];
$data[0]['address'] = $_POST['address'];
$data[0]['proid']= $_POST['proid'];
        
$r = M('khmember')->addAll($data);
if(false!==$r){                
     $this->success(L('成功'));    
    //$this->display();                
 }else{
     $this->error(L('失败'));
 }

 

2.插入多条数据

//方法一
$data[0]['pass'] ='eee';
$data[1]['pass'] ='fff';
 M('kahao')->addAll($data);

//方法二

foreach($list as $key=> $node){
　　$data[$key]['role_id']=$rid;
　　$data[$key]['node_id']=$node['id'];
　　$data[$key]["level"]=$node['level'];
　　$data[$key]["pid"]=$node['pid'];
}

M('kahao')->addAll($data);

 

3.查询数据

$list=M('Node')->where('id in('.$node_id.')')->select();

4.删除数据

$re=M('user')->where('role_id = '.$rid)->delete();

5.where

$where = array('id'=>'1'); 
$M('member')->where($where)->select();

6.更新save

$date['mobile'] = $_POST['mobile'];
$where = array('id'=>'1'); 
 M('member')->where($where)->save($date);