treehouse : what would you like to learn today?
Web Design Web Development iOS Development

Forums

Illustration by Nick Sirotich

search function

  • jose
    Permalink to comment #
    Hello there

    I was wondering if anyone has a php script for a search box.

    I have the search box but i do not have the script behind that so people can search my website.

    I would be grateful if someone has one and they can let me know, or where to find one.

    Cheers
  • Edwin
    Permalink to comment #
    Well, I think the most easy way to do it is go searching in your database. So you get something like this:


    <?php
     
    $key = addslashes($_POST['key']); //get the variable out of the searchfield and protect it with addslashes() against sql-injections

    $query = mysql_query(\"SELECT * FROM `articles` WHERE `content` LIKE '%$key%';

    etc...

    ?>


    I didn't script for a while and didn't test this, but I think this is the way how to do it...
Add a Comment