Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3

Thread: Search Form

  1. #1
    Regular Coder
    Join Date
    May 2011
    Posts
    122
    Thanks
    23
    Thanked 0 Times in 0 Posts

    Search Form

    Using this: http://php.about.com/od/phpwithmysql...p_search_2.htm

    I'm trying to create a search form. But whenever I search it loads, but doesn't load results. It doesn't even give me an error. Can you tell me whats wrong.

    I have the mySQL database information correct. Just want to, you know, release it to the public. :P

    PHP Code:
    <html><head><title>Search form</title></head><body> <h2>Search</h2> 
     <form name="search" method="post" action="<?=$PHP_SELF?>">
     Seach for: <input type="text" name="find" /> in 
     <Select NAME="field">
     <Option VALUE="ServerIP">Server IP</option>
     <Option VALUE="Port">Port</option>
     <Option VALUE="Password">Password</option>
     <Option VALUE="Hamachi">Hamachi</option>
     <Option VALUE="Owner">Owner</option>
     </Select>
     <input type="hidden" name="searching" value="yes" />
     <input type="submit" name="search" value="Search" />
     </form>
     <? 
     
    //This is only displayed if they have submitted the form 
     
    if ($searching =="yes"
     { 
     echo 
    "<h2>Results</h2><p>"
     
     
    //If they did not enter a search term we give them an error 
     
    if ($find == ""
     { 
     echo 
    "<p>You forgot to enter a search term"
     exit; 
     } 
     
     
    // Otherwise we connect to our Database 
     
    mysql_connect("""""") or die(mysql_error()); 
     
    mysql_select_db("") or die(mysql_error()); 
     
     
    // We preform a bit of filtering 
     
    $find strtoupper($find); 
     
    $find strip_tags($find); 
     
    $find trim ($find); 
     
     
    //Now we search for our search term, in the field the user specified 
     
    $data mysql_query("SELECT * FROM server WHERE upper($field) LIKE'%$find%'"); 
     
     
    //And we display the results 
     
    while($result mysql_fetch_array$data )) 
     { 
     echo 
    $result['ServerIP']; 
     echo 
    " "
     echo 
    $result['Port']; 
     echo 
    "<br>"
     echo 
    $result['Password']; 
     echo 
    "<br>"
     echo 
    $result['Hamachi']; 
     echo 
    "<br>"
     echo 
    $result['Owner']; 
     echo 
    "<br>"
     echo 
    "<br>"
     } 
     
     
    //This counts the number or results - and if there wasn't any it gives them a little message explaining that 
     
    $anymatches=mysql_num_rows($data); 
     if (
    $anymatches == 0
     { 
     echo 
    "Sorry, but we can not find an entry to match your query<br><br>"
     } 
     
     
    //And we remind them what they searched for 
     
    echo "<b>Searched For:</b> " .$find
     } 
     
    ?></body></html>
    Here's the actual site: http://www.forthelols.com/search.php

  • #2
    Master Coder mlseim's Avatar
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,380
    Thanks
    8
    Thanked 1,075 Times in 1,066 Posts
    Where is this variable defined: $field ??

    I don't see it.



    .

  • #3
    Regular Coder
    Join Date
    May 2011
    Posts
    122
    Thanks
    23
    Thanked 0 Times in 0 Posts
    Code:
     <Select NAME="field">
    Btw I got it to work. Thanks though.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •