madman0428 Posted June 1, 2007 Share Posted June 1, 2007 i am designing a site and i want users to be able to search through our databases. is this possible with php? is it possible to design a search function that allows users this ability? or, is it more possible to index the pages on the site, and then search through indexed pages? any help would be great.. i have NO idea how to do this. thanks in advance! Quote Link to comment https://forums.phpfreaks.com/topic/53815-question-about-php-search-engines/ Share on other sites More sharing options...
saf Posted June 1, 2007 Share Posted June 1, 2007 If you are using a MySQL database, check out the tutorial section (Searching with PHP sub-section) on this website. Here's the direct link to the tutorial: http://www.phpfreaks.com/tutorials/129/0.php Quote Link to comment https://forums.phpfreaks.com/topic/53815-question-about-php-search-engines/#findComment-266034 Share on other sites More sharing options...
madman0428 Posted June 1, 2007 Author Share Posted June 1, 2007 awesome, i was looking for the tutorial section.. im just new to the site. thanks for the help! Quote Link to comment https://forums.phpfreaks.com/topic/53815-question-about-php-search-engines/#findComment-266037 Share on other sites More sharing options...
madman0428 Posted June 1, 2007 Author Share Posted June 1, 2007 i have a follow up question. the nature of the site we are trying to make allows for users to input data--and then allow users to search that data. if i create a full text index on day 1, and a user inputs data on day 2... does the full text index automatically update itself to include day 2's submissions? or would i have to manually update the full text index to include the additions? thanks! Quote Link to comment https://forums.phpfreaks.com/topic/53815-question-about-php-search-engines/#findComment-266055 Share on other sites More sharing options...
saf Posted June 1, 2007 Share Posted June 1, 2007 I have yet to create a search system for my website, but one of my close friends has it on his website and from what I remember, MySQL will automatically index everything that gets added to the table that has been indexed previously. I will not be able to get back to you on this subject until the weekend. Quote Link to comment https://forums.phpfreaks.com/topic/53815-question-about-php-search-engines/#findComment-266062 Share on other sites More sharing options...
madman0428 Posted June 1, 2007 Author Share Posted June 1, 2007 alright, i appreciate your help in the matter, ill check back in a few days... and i'll be sure to update as i test my own site. thank you again for your help! Quote Link to comment https://forums.phpfreaks.com/topic/53815-question-about-php-search-engines/#findComment-266082 Share on other sites More sharing options...
saf Posted June 4, 2007 Share Posted June 4, 2007 Alright...from what I understood, you only need to index your database once...all subsequent entries will be indexed automatically becasue mysql places an index on the table and not the entries, thus a change to the table will automatically execute a change in its index. ~saf Quote Link to comment https://forums.phpfreaks.com/topic/53815-question-about-php-search-engines/#findComment-267898 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.