這是我的php文件中的一個函數(shù),用于滿足我的android應(yīng)用程序的請求。function checkin($DB, $TechID, $ClientID, $SiteID){ $dbConnection = mysql_connect($DB['server'], $DB['loginName'], $DB['password']); if(!$dbConnection){ die('Error! ' . mysql_error()); } mysql_select_db($DB['database'], $dbConnection); $file2 = "C:/wamp/www/file2.txt"; $data2 = "ClientID:".$ClientID." TechID:".$TechID." SiteID:".$SiteID; file_put_contents($file2, $data2); $result1 = mysql_query("SELECT COUNT(*) FROM Log") or die('Error! ' . mysql_error()); $query = "SELECT `Type` FROM `Log` WHERE `TechID` = '".$TechID."' ORDER BY LogTime DESC LIMIT 1"; $file5 = "C:/wamp/www/file5.txt"; file_put_contents($file5, $query); $result2 = mysql_query($query) or die('Error! ' . mysql_error()); while($row1 = mysql_fetch_array($result1)){ $count = $row1['COUNT(*)']; $file3 = "C:/wamp/www/file3.txt"; $data3 = "ClientID:".$ClientID." TechID:".$TechID." SiteID:".$SiteID." Count:".$count; file_put_contents($file3, $data3); while($row2 = mysql_fetch_array($result2)){ $file4 = "C:/wamp/www/file4.txt"; $data3 = "ClientID:".$ClientID." TechID:".$TechID." SiteID:".$SiteID." Count:".$count; file_put_contents($file4, $data3); /*if($row2['Type']!="Checkin"){ $count = $count+1; $Time = date('Y/m/d H:i'); mysql_query("INSERT INTO Log (LogID, TechID, ClientID, SiteID, LogTime, Type) VALUES (".$count.", ".$TechID.", ".$ClientID.", ".$SiteID.", ".$Time.", Checkin)"); }else{ $query2 = "SELECT TechEmail FROM Tech WHERE TechID=".$TechID; $result3 = mysql_query($query2) or die('Error! ' . mysql_error()); } }*/ } }}您會看到我已經(jīng)隱藏了一些代碼,因為我正在調(diào)試它,所以創(chuàng)建了一些文件只是為了查看代碼的哪一部分無法執(zhí)行。我發(fā)現(xiàn)程序無法進入應(yīng)創(chuàng)建file4的區(qū)域。我已經(jīng)發(fā)現(xiàn)問題可能出在$ query上,當它執(zhí)行時,mysql會響應(yīng)“未知表狀態(tài):TABLE_TYPE”,這我不明白為什么。
3 回答

慕神8447489
TA貢獻1780條經(jīng)驗 獲得超1個贊
簡單的答案應(yīng)該是:
mysql_query("INSERT INTO Log (LogID, TechID, ClientID, SiteID, LogTime, Type)
VALUES (".$count.", ".$TechID.", ".$ClientID.", ".$SiteID.", ".$Time.", Checkin)");
從$ vars中刪除引號?;騿我?。同時刪除點。喜歡:
mysql_query("INSERT INTO Log (LogID, TechID, ClientID, SiteID, LogTime, Type)
VALUES ('$count', '$TechID', '$ClientID', '$SiteID', '$Time', Checkin)");
添加回答
舉報
0/150
提交
取消