Zend_Db_Adapter

浏览数：32 / 时间：2015年06月12日

一、查询

　　1.所有字段

public function testAction(){
    $order = "sage desc";
    $count = 10;
    $offset = 0;
    $studentModel = new Student();
    
    $db = $studentModel->getAdapter();
    //多个查询条件处理
    $where = $db->quoteInto("sdept=?", "计算机系").$db->quoteInto(" AND sage=?", "22");
    
    $res = $studentModel->fetchAll($where, $order, $count, $offset)->toArray();
    
    print ‘<pre>‘;
    print_r($res);
    print ‘</pre>‘;
    exit();
}

　　2.部分字段注入单个参数

public function test1Action(){
    $studentModel = new Student();
    $db = $studentModel->getAdapter();
    //注入一个参数
    $sql = $db->quoteInto("select sname,sage from student where ssex=?", "M");
    $res = $db->query($sql)->fetchAll();
    
    print ‘<pre>‘;
    print_r($res);
    print ‘</pre>‘;
    exit();
}

　　3.部分字段注入多个参数

public function test2Action(){
    $studentModel = new Student();
    $db = $studentModel->getAdapter();
    //注入多个参数        
    $res = $db->query("select sname,sage from student where ssex=:p1 AND sage=:p2", array(‘p1‘=>‘M‘, ‘p2‘=>‘23‘))->fetchAll();        
    print ‘<pre>‘;
    print_r($res);
    print ‘</pre>‘;
    exit();
}

　　4.根据主键查询

public function test4Action(){
    $studentModel = new Student();
    //查询一个
    //$row = $studentModel->find(‘20040001‘)->toArray();
    //查询多个
    $row = $studentModel->find(array(‘20040001‘, ‘20040002‘))->toArray();
    print ‘<pre>‘;
    print_r($row);
    print ‘</pre>‘;
    exit();
}

　　5.明确知道结果只有一条记录的时候

public function test5Action(){
    $studentModel = new Student();
    $row = $studentModel->fetchRow()->toArray();    
    print ‘<pre>‘;
    print_r($row);
    print ‘</pre>‘;
    exit();
}