我想运行下面的代码:
但它显示了一个错误。
$stmt = $this->con->prepare("SELECT HEUREDEB , HEUREFIN from reservation
where ID_EMPL = ? and HEUREDEB like ?%");
$stmt->bind_param("ss",$ID_EMPL,$HEUREDEB);
$stmt->execute();
$result=$stmt->get_result();
发布于 2019-05-22 05:31:05
使用CONCAT()
。
$stmt = $this->con->prepare("SELECT HEUREDEB , HEUREFIN from reservation
where ID_EMPL = ? and HEUREDEB like CONCAT(?, '%')");
您也可以将其添加到变量中。
$HEUREDB .= '%';
$stmt = $this->con->prepare("SELECT HEUREDEB , HEUREFIN from reservation
where ID_EMPL = ? and HEUREDEB like ?");
https://stackoverflow.com/questions/56246602
复制相似问题