MySQL PHP Search

MySQL Search is used to search and return a records from a table on the basis of condition specified in where clause.

MySQL PHP Search

MySQL PHP Search

     

MySQL Search is used to search and return a records from a table on the basis of condition specified in where clause.

Understand with Example

The Tutorial illustrate an example from 'MySQL PHP Search'. To understand and illustrate an example we create a table 'MyTable' that has the required fieldnames and datatypes respectively.

Query for creating table named MyTable :

mysql> CREATE TABLE MyTable (
    ->              Empid int(10),
    ->              Empname varchar(60)
    ->              Salary int(90)
    ->            );
Query OK, 0 rows affected (0.13 sec)

Query for inserting data in table:

The insert into adds the records to the table 'MyTable'. 

mysql>   insert into MyTable values(01,'Girish','20000');
Query OK, 1 row affected (0.02 sec)

mysql>   insert into MyTable values(10,'Komal','20000');
Query OK, 1 row affected (0.01 sec)

mysql>   insert into MyTable values(02,'Amit','21000');
Query OK, 1 row affected (0.01 sec)

mysql>     insert into MyTable values(03,'C','22000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(04,'V','23000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(05,'B','24000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(06,'E','25000');
Query OK, 1 row affected (0.00 sec)

mysql>     insert into MyTable values(07,'Q','26000');
Query OK, 1 row affected (0.01 sec)

mysql>     insert into MyTable values(08,'W','27000');
Query OK, 1 row affected (0.01 sec)

mysql>     insert into MyTable values(09,'AS','28000');
Query OK, 1 row affected (0.00 sec)`


Query to view data inserted in table:

mysql> select * from mytable;
+-------+---------+--------+
| Empid | Empname | Salary |
+-------+---------+--------+
| 1     | Girish  |  20000 |
| 10    | Komal   |  20000 |
| 2     | Amit    |  21000 |
| 3     | C       |  22000 |
| 4     | V       |  23000 |
| 5     | B       |  24000 |
| 6     | E       |  25000 |
| 7     | Q       |  26000 |
| 8     | W       |  27000 |
| 9     | AS      |  28000 |
+-------+---------+--------+
10 rows in set (0.00 sec)

Searching data from the table data using php:

The code begins with <?php tag that enclosed the database name, user name, password name and host name that is used to access the records from table 'mytable'.  Once your connection is built and returns the select search records from table 'mytable' on the basis of condition specified in Where Clause. The mysql_fetch_array ( ) help you  to fetch the records based on condition specified name 'girish' from table 'mytable'. 

The echo prints the records from table 'mytable' on your browser.

<?php
$database="girish";
$user="root";
$password="root";
$host="192.168.10.126";
$link= mysql_connect($host,$user,$password) or die("Could not connect: ".mysql_error());
mysql_select_db($database,$link) or die("Error in selecting the database:".mysql_error());
$sql="select * from mytable where Empname=\"girish\"";
mysql_query($sql,$link) or exit("Sql Error".mysql_error());
$sql_result=mysql_query($sql,$link) or exit("Sql Error".mysql_error());

$sql_num=mysql_num_rows($sql_result);
echo "<table border=\"1\" bgcolor=\"#CCCCFF\" >";
echo "<tr><td><b>Empid</b></td><td><b>Empname</b></td><td><b>Salary</b></td>" ;
while($sql_row=mysql_fetch_array($sql_result))
{
$Empid=$sql_row["Empid"];
$Empname=$sql_row["Empname"];
$Salary=$sql_row["Salary"];
echo "<tr>";
echo "<td>".$Empid."</td>";
echo "<td>".$Empname."</td>";
echo "<td>".$Salary."</td>";
echo "</tr>";
} 
echo "</table>";
?>

Output:-