Page 1 of 1
MYSQL / PHP search
Posted: Wed Dec 24, 2003 5:15 am
by ptysell
I have a MYSQL driven web site that has all of the content data contained in a MYSQL database.
I am looking for a PHP script that performs a search on my "site".
I have found a lot that have the ability to search static pages but none that are for a "dynamic" site. I am too lazy to write my own and would love to find one.
Thanks.
Sorry about spelling errors but it is 4 AM and time for bed. Also refer to the Lazy factor.
Posted: Wed Dec 24, 2003 6:47 am
by aquila125
some more info about your database structure is needed..
take a look at like and the full text search function of mysql..
Posted: Thu Dec 25, 2003 4:07 am
by ptysell
Ok like i said, i am looking for a script that has been written that will search my database and return results all nice. There are many that have been written for flat file sites. I need one for MYSQL.
my content pages have stuff such as
title
content text
section
subsection
datemod
ect
i would like one if at all possible to search for key words.
i have found ones such as iSearch, siteSearch, ect.
Thanks.
If i wanted to write my own i would but i am very lazy and dont really have time for it. I know that there must for a free one out there somewhere as a lot of people share their code.
Posted: Thu Dec 25, 2003 11:00 am
by aquila125
It's not very easy to write this kind of script.. you need to know the database structure, primare/foreign key constraints, columns which are accessible to the public and wich ones not...
trust me.. you won't find any existing script

Posted: Thu Dec 25, 2003 11:07 am
by Nay
So tell me is your 'MYSQL driven web site' is utilizing phpNuke or something? Okay, that was a stupid one O.o.
But if that's the case, there's a search thing somewhere in there. Second, of all, you've got to understand that each programmer's method and brain is different. That means different table names, method of searching and it won't really work from one table to another without some customization.
So here's it, it's either you're going to have to write your own or customize (heavily) someone else's.
Both are about the same, but much different results.
Good luck,
-Nay
Posted: Thu Dec 25, 2003 12:15 pm
by ptysell
ug ok thanks....