retrieve data from form's data

alternative

this is my action page

<html>
<body>
<?php
//trim($id); //delete this 1 1st.

//$searchtype = $id;
//$searchterm = $id;

$db = mysql_connect("localhost", "root");
mysql_select_db("client1",$db);
// display individual record
if ($id) {
$result = mysql_query("SELECT * FROM customer WHERE id =$id",$db); //$id
$myrow = mysql_fetch_array($result);
printf("Customer ID: %s\n ", $myrow["id"]);
printf("Company: %s\n ", $myrow["Company"]);
printf("Business Nature: %s\n ", $myrow["Business_nature"]);
printf("Contact person: %s\n ", $myrow["Contact_person"]);
printf("position: %s\n ", $myrow["Position"]);
printf("address: %s\n ", $myrow["Address"]);
printf("tel: %s\n ", $myrow["Tel"]);
printf("fax: %s\n ", $myrow["Fax"]);
printf("handphone: %s\n ", $myrow["Handphone"]);
printf("e-mail: %s\n ", $myrow["email"]);
printf("website: %s\n ", $myrow["Website"]);
printf("birthday: %s\n ", $myrow["Birthday"]);
printf("remarks: %s\n ", $myrow["remarks"]);
} else {
// show employee list

// no records to display
echo "Sorry, no records were found!";

}
?>
</body>

</html>

i plan to do a form page which can allow me to insert customer id number, and then retrieve the data from database.
does anyone know how to do that??

thanx in advance.

barand

This should do it

Form to enter an id. On submit, calls itself and displays details if there is an id

<?php
$id = $_POST['id'];
?>

<html>
<body>

<FORM  action="<?=$_SERVER[PHP_SELF]?>" method="POST">
Id : <INPUT TYPE="TEXT"  name="id" value="<?=$id?>" size="5" maxlength="5"><BR />
<INPUT TYPE="SUBMIT"  name="submit" value="Submit">
</FORM>

<?php

if ($id) {
    $db = mysql_connect("localhost", "root");
    mysql_select_db("client1",$db);
    $result = mysql_query("SELECT * FROM customer WHERE id =$id",$db); //$id
    if (mysql_num_rows($result) != 0) {
        // display individual record
        $myrow = mysql_fetch_array($result);
        printf("Customer ID: %s\n<br>", $myrow["id"]);
        printf("Company: %s\n<br>", $myrow["Company"]);
        printf("Business Nature: %s\n<br>", $myrow["Business_nature"]);
        printf("Contact person: %s\n<br>", $myrow["Contact_person"]);
        printf("position: %s\n<br>", $myrow["Position"]);
        printf("address: %s\n<br>", $myrow["Address"]);
        printf("tel: %s\n<br>", $myrow["Tel"]);
        printf("fax: %s\n<br>", $myrow["Fax"]);
        printf("handphone: %s\n<br>", $myrow["Handphone"]);
        printf("e-mail: %s\n<br>", $myrow["email"]);
        printf("website: %s\n<br>", $myrow["Website"]);
        printf("birthday: %s\n<br>", $myrow["Birthday"]);
        printf("remarks: %s\n<br>", $myrow["remarks"]);
    } else {
        // no records to display
        echo "Sorry, no records were found!";
    }
} else {
        echo "Please enter an id";
}
?>
</body>
</html>

hth

alternative

i copy ur code any then paste it as daniel_testing2.php
but when i enter the ID at the form there..nothing came out..the page out back to the previous 1.

alternative

i edited the code to become like that

<?php 
/*
$id = $_POST['id']; 
*/
?>


<html> 
<body> 

<FORM  action="daniel_testing2.php" method="POST"> 
Id : <INPUT TYPE="TEXT"  name="id" value="<?$_POST['id']?>" size="5" maxlength="5">
<INPUT TYPE="SUBMIT"  name="submit" value="Submit"> 
</FORM> 

<?php 

if ($id) { 
    $db = mysql_connect("localhost", "root"); 
    mysql_select_db("client1",$db); 
    $result = mysql_query("SELECT * FROM customer WHERE id =$id",$db); //$id 
    if (mysql_num_rows($result) != 0) { 
        // display individual record 
        $myrow = mysql_fetch_array($result); 
        printf("Customer ID: %s\n<br>", $myrow["id"]); 
        printf("Company: %s\n<br>", $myrow["Company"]); 
        printf("Business Nature: %s\n<br>", $myrow["Business_nature"]); 
        printf("Contact person: %s\n<br>", $myrow["Contact_person"]); 
        printf("position: %s\n<br>", $myrow["Position"]); 
        printf("address: %s\n<br>", $myrow["Address"]); 
        printf("tel: %s\n<br>", $myrow["Tel"]); 
        printf("fax: %s\n<br>", $myrow["Fax"]); 
        printf("handphone: %s\n<br>", $myrow["Handphone"]); 
        printf("e-mail: %s\n<br>", $myrow["email"]); 
        printf("website: %s\n<br>", $myrow["Website"]); 
        printf("birthday: %s\n<br>", $myrow["Birthday"]); 
        printf("remarks: %s\n<br>", $myrow["remarks"]); 
    } else { 
        // no records to display 
        echo "Sorry, no records were found!"; 
    } 
} else { 
        echo "Please enter an id"; 
} 
?> 
</body> 
</html>

----------------------

but have problem with the output...i means like after i key in number '1', then later it will prompt out the 1st customer data, but after i press refresh, the data still at there..

anyway to settle that problem?

thanx in advance.

barand

The value of variable $id now never gets set !

alternative

then do you have anyway to solve this problem?