MYSQL / PHP search

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ptysell
Forum Commoner
Posts: 34
Joined: Tue Dec 02, 2003 9:27 pm
Location: USC

MYSQL / PHP search

Post 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.
User avatar
aquila125
Forum Commoner
Posts: 96
Joined: Tue Dec 09, 2003 10:39 am
Location: Belgium

Post by aquila125 »

some more info about your database structure is needed..

take a look at like and the full text search function of mysql..
ptysell
Forum Commoner
Posts: 34
Joined: Tue Dec 02, 2003 9:27 pm
Location: USC

Post 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.
User avatar
aquila125
Forum Commoner
Posts: 96
Joined: Tue Dec 09, 2003 10:39 am
Location: Belgium

Post 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 :)
Nay
Forum Regular
Posts: 951
Joined: Fri Jun 20, 2003 11:03 am
Location: Brisbane, Australia

Post 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
ptysell
Forum Commoner
Posts: 34
Joined: Tue Dec 02, 2003 9:27 pm
Location: USC

Post by ptysell »

ug ok thanks....
Post Reply