Help php code

Discussion on PHP Scripting
no avatar
Posts: 2
Joined: Thu Mar 07, 2013 2:01 am

Help php code

by spluskhan » Fri Mar 08, 2013 8:45 pm

suppose i have 10 products in my database
iphone 2 - iphone 3g - laptop i3 - laptop i7 - nokia n96 etc

when i enter iphone in my search i see all records stored in database thats my prob!

what i want ?
suppose if i enter laptop i7 or laptop then i get result for laptop i7 or laptop

here is my code..

Code: Select all
// Connects to your Database
mysql_connect("", "userr", "pass") or die(mysql_error());
mysql_select_db("products") or die(mysql_error()); [/font][/color]
[color=#000000][font=verdana, geneva, lucida,]$data = mysql_query("SELECT * FROM Products")
or die(mysql_error());
Print "<table border cellpadding=3>";
while($info = mysql_fetch_array( $data ))
Print "<tr>";
Print "<th>Name:</th> <td>".$info['name'] . "</td> ";
Print "<th>new:</th> <td>".$info['new_price'] . "</td> ";
Print "<th>old:</th> <td>".$info['old_proce'] . "</td> ";
Print "<th>faulty:</th> <td>".$info['Faulty_price'] . " </td></tr>";
Print "</table>";

if any one have better code then please give me tankxx

Return to PHP Script