01.<?php
02.$con=mysqli_connect("localhost","my_user","my_password","my_db");
03.
04.if (mysqli_connect_errno())
05. {
06. echo "Failed to connect to MySQL: " . mysqli_connect_error();
07. }
08.
09.$sql="SELECT Lastname,Age FROM Persons ORDER BY Lastname";
10.
11.if ($result=mysqli_query($con,$sql))
12. {
13.
14. $rowcount=mysqli_num_rows($result);
15. printf("Result set has %d rows.\n",$rowcount);
16.
17. mysqli_free_result($result);
18. }
19.
20.mysqli_close($con);
21.?>
