i am passing images file names via textarea to php script to find information about each image in mysql db .The problem is i am trying to output those image file names that not found in mysql db and inform the user which image file names not found in mysql. my current code fails to output those missing records in db but it correctly outputs information about those images found in db. could any one tell me what i am doing wrong ?
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;
解决方案
You can use mysqli_num_rows() in mysqli
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_array($result))
{
$totalRows++;
echo "
";echo "
" . $row['ID'] ."(".$totalRows. ")";echo "
" . $row['name'] . "";echo "
" . $row['imgPURL'] . "";echo "
" . $row['imgUrl'] . "";echo "
";}
} else {
echo "
Not Found Image:".$line.'';}