Happy Codings - Programming Code Examples
Html Css Web Design Sample Codes CPlusPlus Programming Sample Codes JavaScript Programming Sample Codes C Programming Sample Codes CSharp Programming Sample Codes Java Programming Sample Codes Php Programming Sample Codes Visual Basic Programming Sample Codes

Php Programming Code Examples

Php > Searching Code Examples

Search Your Database

Search Your Database //This is the form I use to initiate the script (call this find.php) <form method=post action="search.php"> Search For: <p> User Name: <input type=text name=user size=25 maxlength=25> <p> Password: <input type=text name=passwd size=25 maxlength=25> <p> <input type=submit> </form> //search.php <? //You should now this but be sure to connect to your database or this is useless. :/ if ($user == "") {$user = '%';} if ($passwd == "") {$passwd = '%';} // $user and $passwd are the two column names I used. Change this to fit your database $result = mysql_query ("SELECT * FROM yourtable WHERE user LIKE '%$user%' AND passwd LIKE '%$passwd%' "); if ($row = mysql_fetch_array($result)) { do { PRINT "<b>User Name: </b> "; print $row["user"]; print (" "); print ("<br>"); PRINT "<b>Passwd: </b> "; print $row["passwd"]; print ("<p>"); PRINT "<b>FirstName: </b> "; print $row["firstname"]; print ("<p>"); } while($row = mysql_fetch_array($result)); } else {print "Sorry, no records were found!";} //The end result prints the username / passwd / firstname / lastname / ID / email //you will have to change these fields also to fit your needs ?>