[Resolved] [Resolved] Can someone help me please

k994519

Hi guys

can someone please help me

What I need to do is create a search option where the user enters a user_id number then clicks the submit button which then in turn, goes to another page which displays the results gathered from the database in text fields....
I need it to move to another page without headers,

the table which is being used for the search is as such

users
user_id - search
first name
last name
address
phone number

if anyone can help me I would very much appreicate it. I am willing to pay up to 20 pounds for a good script..... (via paypal)

bike5

So have the form action go to the other page. Why would you use headers there? Although I might not understand correctly? You mean without using the php "header" tag in the script or sending general headers altogether?

k994519

I do not know how to pass the varibles

i.e the $_post[user_id]

to the next page where a query can be run.....

also I thought it was impossible, to pass on to another page without using header

which other method are possible.....

Night4554

Untested code, but it should be fine:

<html>
<body>
<form action"view_profile.php" method="post">
Enter the User ID: <input type="text" name="uid">
<br><input type="submit"></form>
</body></html>

----view_profile.php-----
<html>
<body>

<?php
if(empty($POST['uid']) || !is_numeric($POST['uid']))
{
echo"Error";
}
else
{
//dbconnection
$query="SELECT * FROM users WHERE user_id = '".$_POST['uid'];
$result = mysql_query($query);
$row = mysql_fetch_array($result);

//all your text boxes

}

It's really pretty simple. 🙂

bike5

on the next page, you would get that by calling

$first_name = $_POST['first_name'];

If you want to call it inside "" do
echo "$_POST[first_name]";

Is that what you mean?

If your form method is GET, then

$first_name = $_GET['first_name'];

If you want to have a post and allow someone to be able to manually type in the url and id also then

$first_name = $_REQUEST['first_name'];

sidney

donate the £20 to your favourite charity

  <?php
if(isset($_POST['submit']))
	{
	echo"<table width=\"700\"><tr><td>user_id</td><td>First Name</td><td>Last Name</td><td>Address</td><td>Phone Number</td></tr><tr>";
	$user_id=$_POST['user_id'];
	require_once("connect.php");
	$query="SELECT * FROM users WHERE user_id = '$user_id'";
	$sql=mysql_query($query);
	$row = mysql_fetch_array($sql);
	for($r=0; $r<count($row);$r++)
		echo"<td>".$row[$r]."</td>\n";
	echo"</tr></table>\n";
	}
	else
	{
	?> // the form below can be put on any page just change action to 
                       //to point to this page
	<table width="700">
 <tr>
  <td><form action="<?php echo $PHP_SELF ?>" method="post"><input name="user_id" type="text" size="20" maxlength="30"><input name="submit" type="submit"></form></td>
 </tr>
</table>

<?php
}
?>

drew010

how about this:

--request.html--
...
<form method="POST" action="getdata.php">
Enter User Number:  <input type="text" name="num"><br>
<input type="submit">
</form>
...

--getdata.php--

<?php
if(!isset($_POST['num'])) {
    echo "Incorrect usage of script.";
    exit;
}

$query = "SELECT * FROM users WHERE user_id = $_POST['num']";
$res = mysql_query($query);
if(!mysql_num_rows($res)) {
    echo "User ID Not Found.";
} else {
    $data = mysql_fetch_row($result);

echo <<<END
    User Info for {$data[0]}<br>
    <form method="POST" action="whatever.php">
    <input type="text" name="firstname" value="{$data[1]}"><br>
    <input type="text" name="lastname" value="{$data[2]}"><br>
    <input type="text" name="address" value="{$data[3]}"><br>
    <input type="text" name="phone" value="{$data[4]}"><br>
    <input type="submit">
    </form>
END;

?>

how about something like that?

k994519

Drew,

would I need to create a file called "whatever.php"

or will it work with out it

also if in the second page people were to update the fields i.e address
how would i be able to implement that?

thanks

drew010

the page whatever.php is one i made up but it is where you will need to write some code in order to change the information that the user submitted. first check to make sure they entered the right data, and then issue an update query to the database for the given id number. to do this, you will need to add a hidden field to the form in getdata.php. use <input type="hidden" name="id" value="$POST['num']">
then on the whatever page, after error checking do something like
$query = "UPDATE users SET firstname='" . $POST['firstname'] . "', lastname='" . $POST['lastname'] . "', address='" . $POST['address'] . "', phonenumber='" . $POST['phone'] . "' WHERE user_id = '" . $POST['id'] . "'";

k994519

thanks for ur help drew and everyone else.....

with the code you have given now, is that a universal way of doing what i need to do?

meaning if i need to do this many times but for different databases i only change the varibles and the query?

thanks again for ur help

drew010

yes, its a pretty general thing as far as
1. getting the specific info from a db
2. displaying it so user can change data
3. taking the changed data and updating the db

you could use that code for many different applications of this task.

k994519

thanks drew