Tutorial Searching Data with PHP and Mysql

Desember 31, 2010

Case Study : Create script for searching data in the database
Requirements : Webserver Packages, already installed.

Searching, is a facility that is almost always present in every application, whether web based or desktop applications. Each web page / blog will also equipped with this facility. The following tutorial will provide the basic concept of searching, by doing a search on terstruktu data (database).

Ok, just straight practice.

Step 1 : Prepare the Database

Create database named db_tutorial
Create table named tb_student, the structure is as shown below,
Insert some sample data, just like in this picture.
Done with the database!

Step 2 : Prepare the Work Folder

Create a folder with the name searching in your document root
Save all this file in this tutorial in this folder.

Step 3 : Create script to connect to DB

Type the following script,

<?php
$host = "localhost";
$user = "root";
$pass = "";
$dbName = "db_tutorial";
mysql_connect($host, $user, $pass);
mysql_select_db($dbName)
or die ("Connect Failed !! : ".mysql_error());
?>

Save with the name connect.php

Explanation: The script will be used for linking us with a database application db_tutorial. Customize your username and password from the settings of your mysql.

Step 4 : Create a Searching Form

Type the following script,

<html>
<head>
<title> Halaman Pencarian </title>
</head>
<body>
<form name="formcari" method="post" action="search_exe.php">
<table width="330" border="0" align="center" cellpadding="0">
<tr bgcolor="orange">
<td height="25" colspan="3">
<strong> Student Searching ! </strong>
</td>
</tr>
<tr> <td>  Name </td>
<td> <input type="text" name="name"> </td>
</tr>
<td></td>
<td> <input type="SUBMIT" name="SUBMIT" id="SUBMIT" value="search" > </td>
</table>
</form>
</body>
</html>

Save with the name formsearching.php
Explanation: The script above is a normal HTML script that will display the form. See the part,
action="search_exe.php", bagian ini dimaksudkan bahwa form akan diproses oleh script search_exe.php

Step 5 : Create a processing script and displays the results of searching

Type the following script,

<?php
include "connect.php";
$name= $_POST['name']; //get the nama value from form
$q = "SELECT * from tb_student where name like '%$name%' "; //query to get the search result
$result = mysql_query($q); //execute the query $q
echo "<center>";
echo "<h2> Hasil Searching </h2>";
echo "<table border='1' cellpadding='5' cellspacing='8'>";
echo "
<tr bgcolor='orange'>
<td>No</td>
<td>Nama Mahasiswa</td>
<td>Alamat</td>
</tr>";
while ($data = mysql_fetch_array($result)) {  //fetch the result from query into an array
echo "
<tr>
<td>".$data['no']."</td>
<td>".$data['name']."</td>
<td>".$data['address']."</td>
</tr>";
}
echo "</table>";
?>

Save with the name search_exe.php
The explanation can be found at comment script

Step 6 : Testing Code

Go to http://localhost/searching/formsearching.php. You can see the form like the picture below,
Enter the name of the field name (eg name that has diinsert to the DB, namely june )
Click the search button and you will see results,

Be creative with PHP Happy Coding..
Hal yang juga menarik:

Hak Cipta

Semua skrip dan teknik dalam artikel di itx.web.id boleh digunakan sebagaimana kehendakmu tanpa perlu mencantumkan sumber. Kamu tidak boleh mengkopi seluruh artikel, dalam Bahasa Indonesia ataupun diterjemahkan ke dalam bahasa lain.