دستور PHP mysql_num_rows()
تعریف و استفاده
دستور mysql_num_rows() تعداد ردیفهای مجموعه نتایج را برمیگرداند.
Syntax
mysql_num_rows(data)
| Parameter | Description |
|---|---|
| data | Required. Result set. This result set is obtained from the mysql_query() call. |
Description
mysql_num_rows() returns the number of rows in the result set. This command is only valid for SELECT statements. To get the number of rows affected by an INSERT, UPDATE, or DELETE query, use mysql_affected_rows().
Tips and Comments
Note:If used mysql_unbuffered_query()If not, mysql_num_rows() will only return the correct value after all the rows in the result set have been extracted.
Example
<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * FROM person";
$result = mysql_query($sql,$con);
echo mysql_num_rows($result);
mysql_close($con);
?>
Output similar to:
3
