select one record from MySQL table use where clause. First include database connection page and select one field from database use where id equal some id value. after select record print the record how many record count using mysqli_num_rows()
Follow the example and try it in you web application:
<?php require_once('db_connect.php'); $sql=mysqli_query($con,"SELECT * FROM table name WHERE id='5'"); $row=mysqli_num_rows($sql); echo $row; ?>
Question and answer is powered by AnsPress.io