Hie Everyone
我的问题是计算mysql查询中的行数,并将其存储在$var
中。
表-表_nm/fields-用户ID、用户名、序列号、地址。
php编码部分:
$DB=Function();//this function is to connect to database.
$sql="select UserID,Username,Serialno,Address from Table_nm where UserID='1' and Username='name' and Serialno='20' and Address='Delhi' ";
如果假设对于$sql
有5行,则计数5被存储在$var
中。
如何使用PHP编写这个查询来计算$var
中的行数和数字存储?
这可能会解决问题
$sql=mysql_query("select UserID,Username,Serialno,Address from Table_nm where UserID='1' and Username='name' and Serialno='20' and Address='Delhi'");
$var = mysql_num_rows($sql);
如果您有php<5.5:
$sql="select UserID,Username,Serialno,Address from Table_nm where UserID='1' and Username='name' and Serialno='20' and Address='Delhi' ";
$result = mysql_query($sql);
$var = mysql_num_rows($result);
Mysql扩展是从php5.5中删除的,所以您需要使用mysqli。假设$BD是一个mysqli连接,它将是:
$sql="select UserID,Username,Serialno,Address from Table_nm where UserID='1' and Username='name' and Serialno='20' and Address='Delhi' ";
$result = $DB->query($sql))
$var = $result->num_rows;