增删改查

1.第一个查询，多条件查询 

 

  /*
    查询
  */
  public function executeIndex($request)
  {
    $c1 = new Criteria();
    $c1->add(UsersPeer::ID,1);
    $adminOne=UsersPeer::doSelect($c1);
    //一维数组
    // $this->info=UsersPeer::retrieveByPK(1);
    var_dump($adminOne);
  }
  /*
    批量查询
  */
  public function executeIndexs($request)
  {
    $c1 = new Criteria();
    $adminOne=UsersPeer::doSelect($c1);
    var_dump($adminOne);
  }

 

2.第二个删除，批量删除

 

  /*
    删除
  */
  public function executeDelete($request){
    $c1 = new Criteria();
    $c1->add(UsersPeer::ID,9);
    $adminOne = UsersPeer::doDelete($c1);
    if($adminOne){
      echo 111;die;
    }else{
      echo 000;die;
    }
    return sfView::NONE;
  }
  /*
    批量删除
  */
  public function executeDeletes($request){
    $c1 = new Criteria();
    $c1->add(UsersPeer::ID,2,Criteria::NOT_IN);
    $adminOne = UsersPeer::doDelete($c1);
    if($adminOne){
      echo 111;die;
    }else{
      echo 000;die;
    }
    //没有前台页面时，添加。
    return sfView::NONE;
  }

 

3. 第三个添加

 /*
   添加
  */
  public function executeInsert($request)
  {
    $c1 = new Criteria();
    // $c1->add(UsersPeer::ID,1);
    $c1->add(UsersPeer::USERNAME,'zyx');
    $c1->add(UsersPeer::PWDPASS,123);
    $adminOne=UsersPeer::doInsert($c1);
    var_dump($adminOne);
    if($adminOne){
      echo 111;die;
    }else{
      echo 000;die;
    }
  }

4 修改

  /*
   修改
  */
  public function executeUpdate($request)
  {
    $c1 = new Criteria();
    $c1->add(UsersPeer::ID,95);
    $adminOne=UsersPeer::doSelectOne($c1);
    $adminOne->setUsername('小明');
    $adminOne->setPwdpass('13835489251');
    $adminOne->save();
    var_dump($adminOne);
    if($adminOne){
      echo 111;die;
    }else{
      echo 000;die;
    }
  }

   

注意没有写前台，只是模拟的数据而已