php 添加数据，修改数据，查询数据

     function saveBookId($array = array())
     {
        if(empty($array))
        {
         return;
        }
        //$bookId = '1079' ; //$array["book_id"];   //老师的book_id;
        //$account_id = '1016876';//$array["acount_id"];//老师的account_id; //1016876
        //$grade_num = '1'; //$array["grade_num"];  //老师限定学生上课的年级
        //$class_num = '1';//$array["class_num"];  //老师限定学生上课的班级
        
        $bookId = $array["book_id"];   //老师的book_id;
        $account_id = $array["acount_id"]; //老师的account_id;
        $grade_num =$array["grade_num"];  //老师限定学生上课的年级
        $class_num = $array["class_num"];  //老师限定学生上课的班级
        
          $sql = "SELECT id FROM teachers WHERE account_id='" .$account_id. "'";
         $teainfo = $this->Teacher->query($sql);
         if( !empty($teainfo) )
         {
             $teacher_id = $teainfo[0]['teachers']['id'];
            $sqlTeaBook = "SELECT id,status FROM tea_book WHERE teacher_id='" .$teacher_id. "'";
            $teaBookinfo = $this->Tea_book->query($sqlTeaBook);
            if( empty($teaBookinfo) ) 
            {
                $sqlInsTeabook = "INSERT INTO tea_book(`book_id`,`teacher_id`,`grade_id`,`class_id`) VALUES('".$bookId."','".$teacher_id."','".$grade_num."','".$class_num."')";
                $this->Tea_book->query($sqlInsTeabook);
            } 
            else 
            {
                $sqlInsTeabook = "UPDATE tea_book SET status='1' , book_id='".$bookId."'
                                  , grade_id='".$grade_num."' , class_id='".$class_num."' WHERE teacher_id='".$teacher_id."'";
                
                echo $sqlInsTeabook;
                $this->Tea_book->query($sqlInsTeabook);
            }
         }
         exit;
         echo '<pre>';
         print_r($teainfo);
         echo '</pre>';
         exit;
     }