php mysql查询有无记录_如何检查mysql查询是否使用PHP返回没有结果(记录未找到)？...

我通过textarea将图像文件名传递给php脚本,以查找有关mysql db中每个图像的信息.问题是我试图输出那些在mysql db中找不到的图像文件名,并通知用户哪个图像文件名未在MySQL的.我当前的代码无法在db中输出那些丢失的记录,但它正确地输出了有关db中找到的那些图像的信息.谁能告诉我我做错了什么？

foreach ($lines as $line) {

$line = rtrim($line);

$result = mysqli_query($con,"SELECT ID,name,imgUrl,imgPURL FROM testdb WHERE imgUrl like '%$line'");

if (!$result) {

die('Invalid query: ' . mysql_error());

}

//echo $result;

if($result == 0)

{

// image not found, do stuff..

echo "Not Found Image:".$line;

}

while($row = mysqli_fetch_array($result))

{

$totalRows++;

echo "

";

echo "

" . $row['ID'] ."(".$totalRows. ")";

echo "

" . $row['name'] . "";

echo "

" . $row['imgPURL'] . "";

echo "

" . $row['imgUrl'] . ""; echo "";

}

};

echo "";

echo "
totalRows:".$totalRows;