Trying to create a PHP search script

Question

I have been trying to build a basic search script. Having a lot of trouble. I need the search form and search result to be two separate pages. The script is not working.

The search script is taking me to the search_result page, but the inputs are empty.

enter image description here

<html>
<body>

<form action="search_result.php" method="POST">
<input type="text" name="reg" />
<input type="submit" value="Search" />
</form>

</html>
</body>

PAGE 2:

<html>
<body>


<?php
$host="localhost";
$username="XXXXXXXXXXX";
$password="XXXXXXXXXXX";
$db_name="XXXXXXXXXXXX";
$tbl_name="reg_add";
mysql_connect("$host", "$username", "$password") or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");


$record = $_POST['record']; // if coming from e.g. a form
$result=mysql_query(" SELECT * FROM reg_add WHERE reg='" . mysql_real_escape_string($record) . "'");


$row = mysql_fetch_assoc($result);
$first_name = $row['first_name'];
$last_name = $row['last_name'];
$reg = $row['reg'];
?>



<input  name="reg" value="<? echo "$record" ?>">

<input  name="first_name" value="<? echo "$first_name" ?>">

<input  name="last_name" value="<? echo "$last_name" ?>">

</body>
</html>

in what way is it not working? Errors? What's the expected vs the actual result? — Cfreak
– Cfreak, Commented Apr 26, 2012 at 15:40
you did not say anything useful about the problem and the two scripts don't seem to be connected (first one submits something in $_GET on the reg key, the second one expects something in $_POST on the record key) — mishu
– mishu, Commented Apr 26, 2012 at 15:42
The search script is taking me to the search_result page, but the inputs are empty. — Erik
– Erik, Commented Apr 26, 2012 at 15:49
did you even read the comments and answers added here? you should learn the difference between post php.net/manual/en/reserved.variables.post.php and get php.net/manual/en/reserved.variables.get.php — mishu
– mishu, Commented Apr 26, 2012 at 15:52

Nick · Accepted Answer · 2012-04-26 15:47:28Z

1

Looks like you are looking for $_POST['record'] but passing through $_GET['reg']

Other than that the search isn't very good, it'll only find it if the exact reg is found, is that what you require?

answered Apr 26, 2012 at 15:47

Nick

6,3462 gold badges32 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Erik Over a year ago

Yes. I only want to find reg which is the primary field. I have about 40 other fields related to key record.

Erik Over a year ago

I updated the script, but it won't work. I added a picture of the result.

Nick Over a year ago

$record can't be set if you aren't getting output. Again, I see you've changed it from GET to POST now, but the field name is still reg, not record. So be certain you've changed the $record = $_POST['record']; line to $record = $_POST['reg'];

SachinGutte · Accepted Answer · 2012-04-26 15:48:13Z

1

HTML form submit method is GET and you're trying to retrieve it in POST method. Change either one, and check the key/name attributes of form elements too. `

<form action="search_result.php" method="POST">
<input type="text" name="record" />
<input type="submit" value="Search" />
</form>

answered Apr 26, 2012 at 15:48

SachinGutte

7,0655 gold badges38 silver badges59 bronze badges

2 Comments

Erik Over a year ago

I updated the script, but it won't work. I added a picture of the result.

SachinGutte Over a year ago

You are not retrieving what you're posting. Your updated code is still incorrect. If you are submitting text field value with reg as name it can be retrieved using $_POST['reg']. What I can see is you are using $_POST['record']. Just replace your form with one I've posted. That should work.After getting correct data, if your script is not displaying anything that means there's problem with your query or no record might be present. Easiest way to debug is $_POST is , simply use print_r($_POST); .

Collectives™ on Stack Overflow

Trying to create a PHP search script

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related