[sohaib]

hello,

I will be really gratefull if any one could direct me or make me a simple php search script which will read the following content in my mysql file i.e.

CREATE TABLE IF NOT EXISTS tblLinks (
`ID` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`URL` VARCHAR(255) UNIQUE NOT NULL,
`Title` VARCHAR(255),
`Keywords` VARCHAR(255),
`Description` VARCHAR(255),
`ModifiedDate` DATE DEFAULT '0000-00-00' NOT NULL) TYPE=MyISAM;

INSERT IGNORE INTO tblLinks (`URL`,`Title`,`Keywords`,`Description`,`ModifiedD ate`) VALUES
('http://www.page1.com','Page1_Title','Page1_Keywords','Pag e1_Description',CURDATE()),
('http://www.page2.com','Page2_Title','Page2_Keywords','Pag e2_Description',CURDATE()),
('http://www.page3.com','Page3_Title','Page3_Keywords','Pag e3_Description',CURDATE())


Search display would be like google - only 10 results per page and than next previous page.

Thanks

[tophat]

well, first of all, there are a lot of search scripts out there that you can download that work pretty good. One that I know of is entropy search, which I use on my site. the only downfall is that it reads meta tags, not MySQL, and is written in cgi... Anyways, you can even build your own using google api keys. you can get one at api.google.com.

[eq1987]

This is easily done.

connect to MySQL and open the database

PHP Code:

$MySQL_Connect = mysql_connect("localhost", "user", "password") or die(mysql_error());

mysql_select_db("DatabaseName", $MySQL_Connect) or die(mysql_error()); 

Next, you need to SELECT all the rows that meet your criteria

PHP Code:

$KeyWords = addslashes(htmlentities($_GET['Keywords'])); // assuming you have a keyword search form, using method="GET"

$SQL = mysql_query("SELECT * FROM tblLinks WHERE Description LIKE '%$KeyWords%' ORDER BY Title ASC LIMIT 15") or die(mysql_error());

while($SQLRes = mysql_fetch_array($SQL)) {

 $DisplayVar .= '<a href="'.$SQLRes['URL'].'">'.$SQLRes['Title'].'</a><br>';

} 

then echo the $DisplayVar where you want the results to display

PHP Code:

echo $DisplayVar;