PHP Search, Form, Method Agghhh

[Frostie]

Have major problems, just running a search for some reason, on mySQL database.

This is what I have so far;

<FORM NAME="form" action="product_search.php" method="get" > <input type="text" name="search" size="16"> <input type="submit" name="Submit" value="Go" /> </FORM>

My problem is, when it type in text, and click on the button, it just refreshes the page and doesn't even load up product_search.php as set out in the action - let alone producing any errors

If, however I try going direct such as...
mydomainname.com/product_search.php?search=keyring
....then the page loads all fine and dandy, showing anything with keyring in the description

Where am I going wrong?

[Fraser]

I've just copied and pasted your exact code and it works fine for me. Can't see anything wrong with it either.

Not that this is a particularly helpful reponse, sorry mate!

Is it online somewhere and I could take a look in the context it's being used?

[Ste]

If your code works on some sites and not on others, then it looks like you have register_globals set to Off, which it should be!

So you will need to add the following line to your product_search.php page before the output:

$name = $_POST[name];

and also change the method=”GET” in your form line to method=”post”

Or if you have to use method="GET then change the above instance to $name = $_GET[name];


Or it could simply be you have the input box name twisted If you are using name="search” This will give the use of product_search.php?search=$name
So you should have the variable $name in your output page. We have all done it backward, by using $search instead!!

Might be worth checking ..

[dmorison]

My problem is, when it type in text, and click on the button, it just refreshes the page and doesn't even load up product_search.php as set out in the action

This behaviour could be indicative of a mis-matched <form> tag elsewhere on your page...

[Frostie]

This behaviour could be indicative of a mis-matched <form> tag elsewhere on your page...

Nail on the head Thank you a gazillion times DM

Ste - cheers for your info. Globals are on and this is what drove me nuts cos I had it working on other sites, using the same server.

Fraser - thanks for just re-confirming that I wasn't infact going mad and missing something blindingly obvious - 6 hours I was at it, if you know what I mean

Cheers all