PX : code

Simple Search on mysql database by idban secandri
Download this code


//search engine taken from my cheatzone
//http://idban.penguinpowered.com/cheat/

//// filename = search.php3

<form method="post"  action="result.php3"> 
<select name="metode" size="1">
<option value="row_name1">metode1</option>
<option value="row_name2">metode2</option>
</select>
<input type="text" name="search" size="25"> 
<input type="submit" value="Begin Searching!!"> 
</form>


//// filename = result.php3

<?
$hostname = "127.0.0.1";         // Usually localhost.
$username = "username_for_mysql";     // If you have no username, leave this space empty.
$password = "your_password";         // The same applies here.
$usertable = "table_name";         // This is the table you made.
$dbName = "database_name";         // This is the main database you connect to.

MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database");
@mysql_select_db( "$dbName") or die( "Unable to select database");
?>
<?
//error message (not found message) 
$XX = "No Record Found";

$query = mysql_query("SELECT * FROM cheat WHERE $metode LIKE '%$search%' LIMIT 0, 30 ");
while ($row  =  mysql_fetch_array($query))
   {
        $variable1=$row["row_name1"];
        $variable2=$row["row_name2"];
        $variable3=$row["row_name3"];


print ("this is for $variable1, and this print the variable2 end so on..."); 
   }

//below this is the function for no record!!
if (!$variable1) 
{
print ("$XX");
}
//end
?>

Comments or questions?
PX is running PHP 5.2.17
Thanks to Miranda Productions for hosting and bandwidth.
Use of any code from PX is at your own risk.