By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,521 Members | 1,460 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,521 IT Pros & Developers. It's quick & easy.

Quick Search from huge datas

P: 1
Hi php Grop members..

I am one of the php programmer holding as a next to beginners level.
I got one new site like yellow pages. I need to store more that 10 lakhs of information as well as i have to retrieve data from that huge set using KEYWORD. So that i want to know the easy procedure to get values quickly[Filter datas] using keywords anybody know kindly answer to me.
Feb 28 '08 #1
Share this Question
Share on Google+
3 Replies


rohypnol
P: 54
So that i want to know the easy procedure to get values quickly[Filter datas] using keywords anybody know kindly answer to me.
I think the best approach would be to store everything in the database and filter the information using <SELECT rows FROM table> queries having <WHERE field LIKE 'input'> clauses. Of course you need to sanitize the user input before putting it in the statement.
Mar 21 '08 #2

Markus
Expert 5K+
P: 6,050
Hi php Grop members..

I am one of the php programmer holding as a next to beginners level.
I got one new site like yellow pages. I need to store more that 10 lakhs of information as well as i have to retrieve data from that huge set using KEYWORD. So that i want to know the easy procedure to get values quickly[Filter datas] using keywords anybody know kindly answer to me.
I suggest getting familiar with php and mysql first.

Mysql (database) is a paramount key for this project of yours - it'll save immense amounts of time.

Google for some begginer tutorials
tizag has a good one

Regards.
Mar 21 '08 #3

100+
P: 105
Just to pick up on rohypnols comments, if you have a very large databse then efficiency will also be very important.

If you're going to search a field that holds sentences instead of single words, then its a good idea to enable fulltext on that field and use match() against() pair for your search, eg:

Expand|Select|Wrap|Line Numbers
  1. MATCH(field_name) AGAINST('your_key_word') 
Mar 21 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.