PHP Vaccination::find_by_sql示例

示例#1

文件： pet.php 项目： onielmartinjr/cen4010

 public function get_my_vaccinations()
 {
     global $database;
     $sql = "SELECT `v`.* FROM `pet` AS `p` ";
     $sql .= "INNER JOIN `pet_to_vaccination` AS `pv` ON `pv`.`pet_wk` = `p`.`pet_wk` ";
     $sql .= "INNER JOIN `vaccination` AS `v` ON `v`.`vaccination_wk` = `pv`.`vaccination_wk` ";
     $sql .= "WHERE `p`.`pet_wk` = " . $this->pet_wk . " ";
     $sql .= "ORDER BY `v`.`vaccination_name` ASC;";
     //get the resultset
     $this->vaccination = Vaccination::find_by_sql($sql);
 }