PDA

View Full Version : php search script


ducktape
June 21st, 2001, 19:32
does anyone know of a good fast reliable database search script. and kinda easy to add items to it. i am designing a car audio site with over 3000 products and would like to be able to put products into a database and someone can some and search for something and return the results from the database. i would also like to be able to have a kinda advanced search where the user can define like whether he wants to just search for speakers or just amps or tweeters or etc like the power search function on this site. where you can find a host with say domain hosting, 99 megs...etc.
ducktape
June 21st, 2001, 23:02
come on guys help plz i need this asap
gyrbo
June 22nd, 2001, 09:42
Learn some php, this script you can design in minutes. I would, but I don't have mutch time. Here's a start:


<html>
<head><title>My Page</title></head>
</body>
<?php
$mysql=mysql_connect("localhost","username",password");
mysql_select_db("mydb",$mysql);
$res = mysql_query("SELECT * FROM parts WHERE name like $name",$mysql);
while($row = mysql_fetch_array($res)){
echo "<b>$res['name']</b><br>\n$res['descr']<br>\n";
}
?>
</body>
</html>


You should make a table with the name parts:
id|name|descr
----------------------------
0|speaker|This is a speaker
1|Something|Description

In a html form, you should make a field named "name".

If you type "speaker" in this form, the output would be:
speaker
This is a speaker
lucifer
June 22nd, 2001, 10:16
needs a couple of quote in there but it'd work other than that

for some cash I'll write you a killer app :)
ducktape
June 24th, 2001, 10:27
how much lucifer? im kinda strapped and I'm doing this for gift certificates at this place but give me a price and maybe i will have you do some other stuff ive wanted done for awhile. Also i'd like some kind of interface so that i can login to an admin panel and put in the product name, price, description, etc and write it to the db, so that i come in and add new stuff and remove old stuff quick because there are 3000+ products and i dont have all the time in the world. im currently working on 6 sites work 40+ hours a week and have a wife and 2 kids so easy is good
Woofcat
June 24th, 2001, 14:34
I'll beat lucifer's price and do it better :)
ducktape
June 24th, 2001, 15:32
someone give me a price!!! you see the requirements above
keith
June 24th, 2001, 15:38
http://www.go2php.com/phpsearch/

great script, 39 bucks.
Woofcat
June 24th, 2001, 23:09
You're using MySQL, right?

$20?
Cheap Bastard
June 24th, 2001, 23:52
seems easy enough.
i'd do it but i've got a feeling woofcat can do it better and/or cheaper anyway...
lucifer
June 25th, 2001, 07:02
I admit to being under cut :)

woofcat it's all yours

(better script than mine ~#*!~#'@)