Simple PHP Search

My CMS search function never worked, but I like the software. Have been trying for a long time to find a script tutorial that would help me understand what was happening within the code so I could finally get a search function on my site. THIS ROCKS! I still have some things to do with the script, but this script tutorial gave me a huge leg up!

Many thanks!!!

I think what you’re trying to teach is interesting. Also, just to let you know that I’ve found something called MySearchParser at

http://www.addedworth.com/welcome/MySearchParser.php

which generates the search queries automatically. Also, it supports AND,
OR, NOT and Phrase searches. In short, it allows multiple keyword searches as opposed to single keyword searches.

Thanks for your tutorial. It was very helpful.

i fond error when install it.

Results

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/domain.info/index.php on line 39

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/domain.info/index.php on line 51
Sorry, but we can not find an entry to match your query

Searched For: example

First of all, I would like to thank you.

I did, excatly you have showed in your page, but myone doesn’t work.

Please help.

Thanks

Hi,
I have also done exactly as it is shown in the tutorial and nothing shows up? no print no error messages nada…
help

Hi,

I’m not getting any error messages, just a blank page after submtting the form, please can some one help. Is it MySQL database messedup? PHP. When I write scripts out of the php book without any forms I get results as soon as i use forms I get error messages unless the code is correct and then i get a blank page.

Someone please e-mail me to offer help, e-mail address mustobaby@googlemail.com

thanks

i used this code but i cant ale to get the results. at the same time i dont get any error too.. please me i need this….

Your Coding gave me a big boost and motivation.It`s easy to understand and up to the level

thank you sooo much

Chanuka

i hape try it your script. but when i click button Search it’s still blank
any 1 can help me

Hi,
i have done what you did in the tutorial but i do not get any results.(i only get blank page) i use wamp and save it as search.php in www directory. should i change my directory? Can you please help?

It keep showing this warning message->
Warning: mysql_fetch_array():
I think it seems not working in actual search query =>$query = “select * from profile where upper($field) like ‘%$find%’ “;
Can anyone please leave the comment or solution for this??

The problem most of you are having (blank page, no results) is caused by the fact that no where in the script is anything catching the POST data from the form and converting it into a variable. To correct this issue, simply insert this code at the very top of your PHP:

// Grab POST data sent from form
$field = @$_POST['field'] ;
$find = @$_POST['find'] ;
$searching = @$_POST['searching'] ;

Everything else in the script “should” work.

Still didnt work for me. I still get nothing at all. Any other suggestions?

Joshua’s solution is right, but if you copy and paste it the symbols around field, find, and searching are not right. Try this one.

$field = $_POST['field'] ;
$find = $_POST['find'] ;
$searching = $_POST['searching'] ;

Hi,

I’ve followed the script to the letter however when i submit the search the form returns itself but there isn’t any results or error messages…

I have checked out the comments and tried adding the fix above but still no joy.

I’m using xampp.

Please help q8-(

Im Not Experienced using mysql or php at all. im only beginning to learn it and i was just looking for tutorial for a search engine, i found this and used it but was wondering how to edit it. If someone is willing to help please reply.

I’m having the same problem as everyone else, Click submit and don’t get any results, and no error.

Even if I leave the field blank, and hit submit i don’t get the warning about not entering anything.

I’ve tried both fixes that were listed earlier, and that didn’t help either.

Does this code just not work?

Thanks

I’ve tried as you say but it doesn’t show anything nor any error or warning message. Please help

I was experiencing the same problems as everyone else here with nothing happening to the script.

1)Change this line form.html
“>
to:

2) Makes sure the form is a html file not php!!eg form.html NOT form.php

3) Drop in this code at the very top of search.php underneath the

Thanks for the code, and thanks to the comments that helped me.
A tip that would to help:
I change the line:action=”">
to
action=”">

And was successfull!

Uhm… the code was broken… again then…

change in the form, line action PHP_SELF
to search.php

Hope will be usefull

I have tried all of the sugested fixes and nothing has worked. I key something in the search field, select an option, hit search and the page resets.

I have no idea what I’m doing wrong.

As soon as I load the page, it comes up with the parse error.
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in

Then it’s funny because it will say “no matching results found” below that. So THAT part works;)

Now what it appears to not like is the $data in the line where you are passing mysql query to that variable. And then using that as an argument. Why it refers to that I don’t know though:(
For mine I changed the names as I’m using a different table than users but the concept is the same.

Online Recipe Search Results”;
}

?>

Any ideas on this ?
Otherwise great tutorial. I know more about searches anyways better than before I started to read it.

Hey People, I think I know why this works from some people and not others (If I’m wrong please let me know, or I’ll bumbling about thinking I’m right on this one for a while )
This works perfect of my webhosts server and not my own testing server, think I have found the missing link, my host runs PHP 4.3.2 I run 5.2.8. A difference is that register_globals is turned off by default in the recent one and on in the older one. Now I think that this script relies on register globals being on, as it is a few years older and reasons mentioned earlier.
I’ve just started diggin on this one and from what I can gather the r_g (register_globals) setting allows variables and arrays to be passed through a script without being registered or defined, i.e. in the form above, without any $find=$POST_['find'], which would define the variable find from the form.
r_g was deprecated as it left open too many security issues etc see here
To find out if your r_g is on look in your info.php file, tutorial here.

Like I say I’m new to this so this could be wrong but I’ve got a hunch. Meanwhile I still havent found another simple search script!! I’m gonna mess around with this one, so ill write back if I get it sorted and share the love.

best wishes Caroline

Hey People,
I think I know why some people are having problems with this but if I’m wrong let me know or I’ll be bumbling about thinking Im right, doh!

My Proposal: The code relies on register globals being turned on, which is turned off by default since php version 4.2.0, to check if its on and which version your running check your info.php learn how here.

The reason I say this is because it works perfect on my site, hosted by server using php version 4.3.2, and their r_g (register_globals) is on and not on my testing server php 5.2.8, where it is off.
From what I can gather the r_g set to on allows variable that havent been defined as anything to be registered within your script, as in this one, so the form data i.e.name=”find” is recognised as $find with r_g on but not with it off.

To elaborate when r_g is turned off it doesn’t automatically become $find, it needs to have something like this $find=$_POST['find'] to make it register
and r_g turned on makes this magical transformation happen, and also our troublesome code.
Think it was changed to off due to security issues, read more.

I think this may also have something to do with people mentioning arrays, as there is also a setting for register_long_arrays. Then again this could be me (2+2=5)
So if I solve it I’ll share the love and post my solution, If this makes sense for anyone else, please post back so I know I’m on the right track.

best wishes Caroline

thanks for the tip Joshua/Patrick,
although I made another alteration, my script is now:

Results”;

etc Not forgetting to change method to get in the 1st lines,

thanks people
xxx caroline

that should have been:

*input name=”search” type=”submit” value=”search”*
*/form*

*?php

$find = @$_GET['find'] ;

//If we submitted the form
if(isset($_GET['search']))
{
echo *”Results”*;

school boy error sorry, should have guessed this comment box would strip tags, I’ve replaced them here with *’s

This seemed to work fine for me, I was also wondering if the problems had anything to do with the registered globals being set to off in new versions of php. I say this because this script works fine when its on, and spits out error messages about defining variables when its not.
Just a hunch but if other people could test it with it on and off and maybe we could solve this bugger xx

your codes are very friendly..keep it up.. you helpinh us to are project…hehehehe thank you a lot… can ihave your email so that i can ask you more question…if thats ok with you..im shea from philippines….

Actually, just to add to my previsou comment…
I am using cpanel to build my site and in the preview all of this works, but as soon as I publish it… poof nothing works. Please Help!

hi, i want to create the form that can search the identity card(ic) number through the database, but i dont know how to connect the form to the data base, For example, if the customer want to check their request have been approved or not, they must fill their ic number to the form then they will click the button check. Then they will informed either their request have been approved or not.. can some one hel me about the coding.. Thank you..

you have to define $searching, $find and $field

to do so, right after “

Had the same problems as everyone else, and didn’t understand some of the comments above as they seemed to finish in mid sentence. I put the form in search.html and the php in search.php. In the html file I changed the action to be action=”search.php”. In search.php define the vars $field, $find and $searching; e.g. $field = $_POST["field"] before the test of $searching. Everything worked then.

ok, i found the error

these 3 lines were not included, therefor the script would not know to get the values.

$field = $_REQUEST['field'];
$searching = $_REQUEST['searching'];
$find = $_REQUEST['find'];

Please help!
How can I use multiple search words using
explode function
thx.

i am getting blank page…please help me in this regard….r else u can mark a mail to my mail id msrayudu1@gmail.com