Search like google

Posted by Rajanikant on Stack Overflow See other posts from Stack Overflow or by Rajanikant
Published on 2010-05-01T11:04:56Z Indexed on 2010/05/01 11:07 UTC
Read the original article Hit count: 470

Filed under:

I have a task to make a search module in which i have database users and tablename userProfile and i want to search profile when i entered text in text box for ex. if i entered "I am looking for MBA in delhi" or 'mba information in delhi' it will displayed all user registered expertise as mba and city in delhi . this will be like job portal or any social networking portal

my database is
-- phpMyAdmin SQL Dump -- version 2.8.1

-- http://www.phpmyadmin.net

-- Host: localhost -- Generation Time: May 01, 2010 at 10:58 AM -- Server version: 5.0.21

-- PHP Version: 5.1.4

-- Database: `users`

--

-- Table structure for table `userProfile`

CREATE TABLE userprofile ( id int(11) NOT NULL auto_increment, name varchar(50) collate latin1_general_ci NOT NULL, expertise varchar(50) collate latin1_general_ci NOT NULL, city varchar(50) collate latin1_general_ci NOT NULL, state varchar(50) collate latin1_general_ci NOT NULL, discription varchar(500) collate latin1_general_ci NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

--

-- Dumping data for table `userProfile`

INSERT INTO userProfile VALUES (1, 'a', 'MBA HR', 'Delhi', 'Delhi', 'Fortune is top management college in Delhi, Best B-schools in India providing business studies and management training. FIIB is Delhi based most ranked ...'); INSERT INTO userProfile VALUES (2, 'b', 'MBA marketing', 'Delhi', 'Delhi', 'Fortune is top management college in Delhi, Best B-schools in India providing business studies and management training. FIIB is Delhi based most ranked ...'); and search.php page

                  <?php
                      include("config.php");
                        include("class.search.php");
                         $br=new search();
                     if($_POST['searchbutton'])
                       {
                          $str=$_POST['textfield'];
                          $brstr=$br->breakkey($str);

                       }

                    ?>


                         <html xmlns="http://www.w3.org/1999/xhtml">
               <head>
           <title>Untitled Document</title>
                      </head>

          <body>

                   <table width="100%" border="0">
             <form name="frmsearch" method="post">


<tr>
    <td width="367">&nbsp;</td>
    <td width="300"><label>
      <input name="textfield" type="text" id="textfield" size="50" />
    </label></td>
    <td width="294"><label>
      <input type="submit" name="searchbutton" id="button" value="Search" />
    </label></td>   </tr></form>   <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>   </tr>   <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>   </tr> </table> </body> </html>

and config.php is

<?php 
error_reporting(E_ALL);
$host="localhost";
$username="root";
$password="";
$dbname="users";
$con=mysql_connect($host,$username,$password) or die("could not connect database");
$db=mysql_select_db($dbname,$con) or die("could not select database");

?>

and class.search.php is

      <?php
class search
{

    function breakkey($key)
    {
        global $db;

        $words=explode(' ',$key);
         return $words;

    }

    function searchitem($perm)
    {
        global $db;
        foreach($perm as $k=>$v)
        {
            $sql="select * from  users"
        }
    }


}
?>

Developer IT