搜索

/**
 * 根据title查询
 * @param $id_title
 * @return array
 */
public function referByTitle($id_title)
{
    $car = array();
    $m = 0;
    $mysql = Conn::getlink();
    $sql = "SELECT car.* ,type.name  FROM car,type  WHERE car.type_id=type.id  AND car.title LIKE '%$id_title%'  ";
    $bool = $mysql->query($sql);
    while ($row = $bool->fetch_assoc()) {
        $car[$m] = $row;
        $m++;
    }
    $bool->free();
    $mysql->close();
    return $car;
}