select record from MySQl table is very simple, first connect database page in your page, where you using select query for select data from MySQL table. That’s like
<?php include "db_connect.php"; ?>
Now select table records where MySQL table field match give field value using where clause in php.
Example:
<?php $sql=mysqli_query($con,"SELECT * FROM `table name` WHERE `table field name`='".$_POST['field_name']."'"); $row=mysqli_num_rows($sql); ?>
Or try it
<?php $id=$_POST['id']; $sql=mysqli_query($con,"SELECT * FROM `table name` WHERE `id`='".$id."'"); $row=mysqli_num_rows($sql); ?>
Question and answer is powered by AnsPress.io