如何在PHP中获取MYSQL数据库返回的数据的行数?

2025-3-26 / 0 评论 / 2 阅读

mysql_num_rows 可得到查询记录数

mysql_num_rows()或者select count(*) from table;#

<?php

$con= <a class="baidu-highlight" href="https://www.baidu.com/s?wd=mysql_connect&tn=SE_PcZhidaonwhc_ngpagmjz&rsv_dl=gh_pc_zhidao" data-ke-src="https://www.baidu.com/s?wd=mysql_connect&amp;tn=SE_PcZhidaonwhc_ngpagmjz&amp;rsv_dl=gh_pc_zhidao" target="_blank">mysql_connect</a>(``"localhost", ``"hello", ``"321");

if(!``$con)

  {

  die``('Could not connect: '``. mysql_error());

  }

$db_selected= <a class="baidu-highlight" href="https://www.baidu.com/s?wd=mysql_select_db&tn=SE_PcZhidaonwhc_ngpagmjz&rsv_dl=gh_pc_zhidao" data-ke-src="https://www.baidu.com/s?wd=mysql_select_db&amp;tn=SE_PcZhidaonwhc_ngpagmjz&amp;rsv_dl=gh_pc_zhidao" target="_blank">mysql_select_db</a>(``"test_db",``$con);

$sql= ``"SELECT * FROM person";

$result= mysql_query(``$sql,``$con);

echo<a class="baidu-highlight" href="https://www.baidu.com/s?wd=mysql_num_rows&tn=SE_PcZhidaonwhc_ngpagmjz&rsv_dl=gh_pc_zhidao" data-ke-src="https://www.baidu.com/s?wd=mysql_num_rows&amp;tn=SE_PcZhidaonwhc_ngpagmjz&amp;rsv_dl=gh_pc_zhidao" target="_blank">mysql_num_rows</a>(``$result);

mysql_close($con``);

?>