Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Mysql-table MySQL PHP Search

Related Tutorials


 
 

Share on Google+Share on Google+

MySQL PHP Search

Advertisement
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 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:-

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 16, 2009

Related Tutorials

Discuss: MySQL PHP Search  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com