Latest posts for the topic "How to add a search function effectively?"

How to add a search function effectively?

riza — GMT

The following adds a good search capability to the gbook

[code]
// define db parameters in a file called config.php

include("config.php");
$db = mysql_connect($dbhost, $dbusername, $dbpassword);
mysql_select_db($dbname,$db);

?>

// table_name should be book_data if default stuffs are used
$result = mysql_query("select * from Table_Name WHERE column1 LIKE '%$query%' OR column2 LIKE '%$query%'", $db);
while(list($column1, $column2)=mysql_fetch_array($result)){
echo "Result: $column1, $column2
";
}
?>
[/code]

However the problems are 2 :

:?: the result will display the main post only and will miss the comments added onto the guestposts

:?: pagination - if there are say 1000 results it needs to be paginated
If pagination is not possible is it possible to limit the number of results to a prespecified value ?

Any help will be greatly appreciated.

Carbonize — GMT

I am curious as to why people would want to search a guestbook :-/

riza — GMT

1)Many guestbooks have already search function included like xeoman[ xeoman.com/ ]
2)Guestbooks can be searched for certain terms or phrases like "we want more of this and this" by the visitors - this can help to gauge the needs/demands of visitors particularly when one has say thousand or more entries
3)Guestbook is not just guestbook - at certain sites it is like a comment or suggestion book like a science site where one may like to look up certain terms that has been used more than others
4) Some more reasons .....

By the way, do you have any working solution - I will be really grateful

Carbonize — GMT

Not off the top of my head no. I get funny about people downloading a guestbook then using it as something else and complaining that it doesn't do something that a script dedicated to what they want would have. Thats a generic rant btw. The other one I got asked for recently was adding statistics to the guestbook

As a quickies I'd say it would be simple enough. It's just a case of changing the query done for a normal guestbok display to the search query then it would be formated and paginated.

Carbonize — GMT

Oh and as to limitting yes just use LIMIT

Carbonize — GMT

Having looked yes it would be simple(ish) to do. Bit more complicated if you want to do more than search for a single string (ie if you want to use operators in the search). It would be just a case of checking if they aer performing a search in index.php and then creating the query for the search and passing it on to the entry retrieval (echo $gb->show_entries($entry, $SEARCHQUERY) and then adding the new variable to the functions that get called and switching the query in [b]get_entries[/b]

riza — GMT

[quote]I get funny about people downloading a guestbook then using it as something else and complaining that it doesn't do something [/quote]

Hello Carbonize, I am not complaining at all
this script is as wonderful as it can be, and I was just wondering if things further could be done !
However we always grow and uses come into play, like I said, many gbs have this function already implemented.

Even, html does a lot more than what it was intended to be

Adding just LIMIT is not helping and as I said the result page will show the main post or comment and not the comment-on-comments as they belong to different tables

Any REAL help will be greatly appreciated.

Carbonize — GMT

My last post make sense to you?

riza — GMT

Hello Carbonize,

Thanks The last post makes sense.

However ,perhaps I have been unable to explain what I was looking for in my very first post.

[quote]then creating the query for the search [/quote]
the actual problem is at this step. I am no mysql expert and so I was asking for actual codes - the way i create the search query covers only the comments and not the subcomments ( that is comments on comment ). Thus I am dealing with the table book_data , but I also need to deal with table book_com in the same go. How ??

The other part was to paginate the results.

Any further help from anyone will be sincerely appreciated.

Carbonize — GMT

Only realistic way of searching both entries and comments would require you to make your own output format as you couldn't really use the current guestbooks formatting. As to searching both tables possibly a JOIN may do it. Then again maybe not. I'll think about it.