使用這個sql語句查詢的時候,報錯了,說對象無法轉(zhuǎn)化為字符串這個是什么意思。咋解決呢,打印了sql是對的,而且再數(shù)據(jù)庫里面我也查詢過,是正確的。


$data = $this->db->query("SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA. TABLES WHERE TABLE_NAME = 'info_linkage_data_".$key."'");
這個是錯誤日志,有人能幫我看下咋回事么
CRITICAL - 2020-02-10 00:37:37 --> Object of class CodeIgniter\Database\MySQLi\Result could not be converted to string
# http://oa.qhbjy.com/admin.php?c=mylinkage&m=list_add&key=3&pid=1
# SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'info_linkage_data_3'
#0 /www/wwwroot/message/dayrui/My/Model/Linkage.php(144): Phpcmf\Extend\Exceptions->errorHandler(4096, 'Object of class...', '/www/wwwroot/me...', 144, Array)
#1 /www/wwwroot/message/dayrui/Core/Controllers/Admin/Mylinkage.php(285): My\Model\Linkage->add_list(3, Object(CodeIgniter\Database\MySQLi\Result))
#2 /www/wwwroot/message/dayrui/System/CodeIgniter.php(847): Phpcmf\Controllers\Admin\Mylinkage->list_add()
#3 /www/wwwroot/message/dayrui/System/CodeIgniter.php(338): CodeIgniter\CodeIgniter->runController(Object(Phpcmf\Controllers\Admin\Mylinkage))
#4 /www/wwwroot/message/dayrui/System/CodeIgniter.php(246): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#5 /www/wwwroot/message/dayrui/Fcms/Init.php(329): CodeIgniter\CodeIgniter->run()
#6 /www/wwwroot/message/index.php(47): require('/www/wwwroot/me...')
#7 /www/wwwroot/message/admin.php(9): require('/www/wwwroot/me...')
#8 {main}
$data = $this->db->query("SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA. TABLES WHERE TABLE_NAME = 'info_linkage_data_".$key."'"); foreach ($data->getResultArray() as $da){ echo $da['AUTO_INCREMENT']; }要這樣寫