使用PHP在新页面上回显SQL查询

Question

I know this is probably a really amateur question, but I can't figure this out and I don't know much about PHP or MySQL.

So I have a really simple script that basically allows a user to submit a couple lines of text and their zipcode, then it write it to a database and returns the results on the site. It's a shoutbox essentially.

My client wants the users to be able to filter the results by zipcode. So I have it all setup, and I have a search input where people type in their zipcode, search, and then the PHP returns the submissions from that zipcode.

While I can get the results to show by themselves echoed from the PHP script, how do I get them to display within a specified div within the site? I want it essentially to store a variable, the zipcode, that a user search by, and then use that once the page refreshes to display an updated list that filters out the results that aren't from that zipcode.

Thanks so much for the help.

Chris

Answer 1

Without getting into rewriting etc.:

1. When you redirect your page, add a query at the end of it that is the zipcode making sure that you don't send any whitespace and that you have an input in a given format:

   search.php?zipcode=90210

2. Then on your search results page, fetch the variable passed and work as usual:

   $zipcode = $_GET['zipcode'];

3. make sure that the zipcode is properly escaped and filtered for nasties.