Dear Friends
In this tutorial we will learn how find record from the mysql database and display it. To implement this program we have to create three files.
1. Connection.php
2. Find.htm
3. Find.php
Connection.php file contains php code which is used to connect with the Webserver and the databse.
Find.htm file is file contains HTML code for user interface.This user interface contain a textbox and a Submit Button.When user enter rollno and click on submit button, it will execute Find.php file.
Find. php file contains PHP code to fetch data from the mysql database.The mysqli_query function is used to run query in PHP. This function return records from the database.The mysqli_fetch_arry function is used to access single record.
