Press Ctrl-C to quit. Start success.
1PDOException: SQL:SELECT id FROM collect_device WHERE unique_identification_number= user SQLSTATE[42S22]: Column not found: 1054 Unknown column 'user' in 'where clause' in C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\Applications\YourApp\Connection.php:1774
Stack trace:

0 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\Applications\YourApp\Connection.php(1954): Workerman\MySQL\Connection->execute('SELECT id FROM ...', Array)

1 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\Applications\YourApp\Events.php(81): Workerman\MySQL\Connection->single()

2 [internal function]: Events::onMessage('7f0000010b54000...', '{"type":"bind",...')

3 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\vendor\workerman\gateway-worker-for-win\src\BusinessWorker.php(384): call_user_func('Events::onMessa...', '7f0000010b54000...', '{"type":"bind",...')

4 [internal function]: GatewayWorker\BusinessWorker->onGatewayMessage(Object(Workerman\Connection\AsyncTcpConnection), Array)

5 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\vendor\workerman\workerman-for-win\Connection\TcpConnection.php(629): call_user_func(Array, Object(Workerman\Connection\AsyncTcpConnection), Array)

6 [internal function]: Workerman\Connection\TcpConnection->baseRead(Resource id #28)

7 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\vendor\workerman\workerman-for-win\Events\Select.php(286): call_user_func_array(Array, Array)

8 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\vendor\workerman\workerman-for-win\Worker.php(856): Workerman\Events\Select->loop()

9 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\vendor\workerman\gateway-worker-for-win\src\BusinessWorker.php(190): Workerman\Worker->run()

10 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\vendor\workerman\workerman-for-win\Worker.php(473): GatewayWorker\BusinessWorker->run()

11 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\vendor\workerman\workerman-for-win\Worker.php(382): Workerman\Worker::runAllWorkers()

12 C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\Applications\YourApp\start_businessworker.php(35): Workerman\Worker::runAll()

13 {main}

process C:\phpStudy\PHPTutorial\WWW\kaiwu\vendor\GatewayWorker-for-win\Applications\YourApp\start_businessworker.php terminated and try to restart
報(bào)了這一堆

SELECT id FROM collect_device WHERE unique_identification_number= user 語句感覺有點(diǎn)奇怪 這個(gè) user 是什么?。?br /> unique_identification_number 這個(gè)是int型字段string字段類型？

報(bào)的錯(cuò)誤是 collect_device 這個(gè)表中無 user 字段

我要在表中查找unique_identification_number（varchar）的值為user的一條數(shù)據(jù)

哥 加單引號(hào)才可以 不然數(shù)據(jù)庫會(huì)認(rèn)為 user是字段名，不是 值

$db->select('ID')->from('Persons')->where("sex= 'F' ")->single(); 例如這樣子

getawayworker數(shù)據(jù)查詢查詢不到的時(shí)候會(huì)直接報(bào)錯(cuò)嗎，我想知道我遇到的這個(gè)錯(cuò)誤正不正常。有沒有辦法判斷表中是不是已經(jīng)存在某條數(shù)據(jù)。謝謝了

不會(huì)，你這是SQL語句錯(cuò)誤

  $result=$db->select('id')->from('collect_device')->where("unique_identification_number= '{$fromid}' ")->single();  這樣子寫語句，應(yīng)該不會(huì)報(bào)錯(cuò)了 

然后再根據(jù)查詢的結(jié)果判斷是否存在

沒有報(bào)錯(cuò)了，多謝。因?yàn)槲以诖a里那個(gè)位置添的是$fromid，所以沒加''.我直到現(xiàn)在也不是很明白，我加的$fromid確實(shí)是個(gè)變量。按照你說的問題確實(shí)解決了，萬分感謝

這樣寫容易sql注入，最好按照手冊 bindValues 那樣傳參數(shù)

$fromid 如果不加單引號(hào)，會(huì)直接認(rèn)為是一個(gè) 字段名稱的

明白了