如何在我的php代码中添加搜索消息“notfound”?

jgzswidk  于 2021-06-23  发布在  Mysql
关注(0)|答案(2)|浏览(261)

我想得到“找不到车!”此代码中的消息。请帮帮我。。。如何获取此消息?

<?php 
//Query for Listing count
$brand=$_POST['brand'];
$fueltype=$_POST['fueltype'];
$sql = "SELECT id from tblvehicles where tblvehicles.VehiclesBrand=:brand and tblvehicles.FuelType=:fueltype";
$query = $dbh -> prepare($sql);
$query -> bindParam(':brand',$brand, PDO::PARAM_STR);
$query -> bindParam(':fueltype',$fueltype, PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=$query->rowCount();
?>
<p><span><?php echo htmlentities($cnt);?> Listings</span></p>
</div>
</div>

在哪里编写echo以获取此消息?

$sql = "SELECT tblvehicles.*,tblbrands.BrandName,tblbrands.id as bid  from tblvehicles join tblbrands on tblbrands.id=tblvehicles.VehiclesBrand where tblvehicles.VehiclesBrand=:brand and tblvehicles.FuelType=:fueltype";
$query = $dbh -> prepare($sql);
$query -> bindParam(':brand',$brand, PDO::PARAM_STR);
$query -> bindParam(':fueltype',$fueltype, PDO::PARAM_STR);
$query->execute();
$results=$query->fetchAll(PDO::FETCH_OBJ);
$cnt=1;
if($query->rowCount() > 0)
{
foreach($results as $result)
{  ?>
kkbh8khc

kkbh8khc1#

您已经有了if语句来检查rowcount是否大于0(即,它有返回的内容),并打印出结果。你可以在上面加上一个else,在那里你可以回显你的信息。

piah890a

piah890a2#

在一个 else 条件链接到您的 $query->rowCount() :

if($query->rowCount() > 0) {
    foreach($results as $result) { 
        // Output the successful results
    }
} else {
    echo "Car not found!";
}

相关问题