如何在 PHP 函数中从 MySQL 返回 TRUE 或 FALSE - How do I return TRUE or FALSE from MySQL within PHP function?

How do I return TRUE or FALSE from MySQL within PHP function?

本文关键字：返回 MySQL TRUE FALSE PHP 函数 | 更新日期: 2023-09-27

我正在试验PHP。这是我的功能.php

function returnBlankStylist(){
$sql=mysql_query("SELECT * FROM `".$dbn."`.`stylist` WHERE `stylist`.`customer_id`='1'");
if (mysql_affected_rows()==0) {
 return false;
} else {
 return true;
}
}

这是我的页面.tpl

<?php if (returnBlankStylist==false){?>
<div class="center graybox"> Please enjoy this discount since this you have never filled out a query before</div>
<? }?>

如果客户 ID 1 存在，则显示消息，

如果客户 ID 1 不存在，则显示消息？

Page.tpl

<?php if (returnBlankStylist() == false) : ?>
    <div class="center graybox">
        Please enjoy this discount since this you have never filled out a query before
    </div>
<? endif; ?>

或

<?php if (!returnBlankStylist()) : ?>
    <div class="center graybox">
        Please enjoy this discount since this you have never filled out a query before
    </div>
<? endif; ?>

或

<?php if (returnBlankStylist() == false) { ?>
    <div class="center graybox">
        Please enjoy this discount since this you have never filled out a query before
    </div>
<? } ?>

你错过了括号..

if(returnBlankStylist()==false){
    //your code...
}

希望它能为你工作

请将您的代码if (mysql_affected_rows()==0)替换为if (mysql_num_rows()==0);

并尝试这个：

<?php if (!returnBlankStylist()){?>
<div class="center graybox"> Please enjoy this discount since this you have never filled out a query before</div>
<? }?>