在PHP中,我試圖執(zhí)行一個(gè)長(zhǎng)的MySQL查詢,該查詢?nèi)Q于用戶輸入。但是,我的查詢失敗,并顯示以下消息,"Query Failed".實(shí)際上,每當(dāng)查詢失敗時(shí),我都會(huì)打印此消息,但是我很難找到此失敗背后的原因。不幸的是,我找不到它,因?yàn)樵撳e(cuò)誤未在網(wǎng)頁(yè)上指定。有沒(méi)有辦法在網(wǎng)頁(yè)上顯示導(dǎo)致失敗的錯(cuò)誤消息?這是我的代碼,$from = "Findings";$where = "";if ($service != null){ $from = $from . ", ServiceType_Lookup"; $where= "Findings.ServiceType_ID= ServiceType_Lookup.ServiceType_ID AND ServiceType_Name= ". $service; if ($keyword != null) $where= $where . " AND ";}if ($keyword != null){ $where= $where . "Finding_ID LIKE '%$keyword%' OR ServiceType_ID LIKE '%$keyword%' OR Title LIKE '%$keyword%' OR RootCause_ID LIKE '%$keyword%' OR RiskRating_ID LIKE '%$keyword%' OR Impact_ID LIKE '%$keyword%' OR Efforts_ID LIKE '%$keyword%' OR Likelihood_ID LIKE '%$keyword%' OR Finding LIKE '%$keyword%' OR Implication LIKE '%$keyword%' OR Recommendation LIKE '%$keyword%' OR Report_ID LIKE '%$keyword%'";}$query = "SELECT Finding_ID, ServiceType_ID, Title, RootCause_ID, RiskRating_ID, Impact_ID, Efforts_ID, Likelihood_ID, Finding, Implication, Recommendation, Report_ID FROM ".$from . " WHERE " . $where;echo "wala 2eshiq";$this->result = $this->db_link->query($query);if (!$this->result) { printf("Query failed: %s\n", mysqli_connect_error()); exit;}$r = mysqli_query($this->db_link, $query);if ($r == false) printf("error: %s\n", mysqli_errno($this->db_link));
添加回答
舉報(bào)
0/150
提交
取消