retrive data from spesific id

alternative

i got some problem on my php codes, i try myself to do a form page and then an action page. i want to retrieve certain row of data by key in the 'id' value on the form pages.

form.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

</body>

daniel_testing.php

<html>
<body>
<?php
trim($id);

//$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 ='%$searchterm%'",$db);
$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 {
// show employee list
$result = mysql_query("SELECT FROM customer",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
printf("<a href=\"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"],$myrow["Company"],$myrow["Business_nature"],$myrow["Contact_person"],$myrow["Position"],
$myrow["Address"],$myrow["Tel"],$myrow["Fax"],$myrow["Handphone"],$myrow["email"],$myrow["Website"],$myrow["Birthday"],$myrow["remarks"]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo "Sorry, no records were found!";
}
}
?>
</body>

</html>

kevinsequeira

what is the problem / error u are getting

also put in this on top of daniel_testing.php

$searchterm = $_POST['searchterm'] ;

where are you getting $id from, there is no id variable in the search form

if ($id) { ????

reg
kevin

alternative

hm...actually

$searchterm = $_POST['searchterm'] ;

is means collect data from the form? POST i mean.

then actually 'id' is one the primary key attribute in database

then how man?

thanx in advance

kevinsequeira

😕 i dont understand what ure saying ..

where are u getting the value of $id from ?

reg
kevin

alternative

ok man..actually i want the let the form have place to type '1'

then later....it will retrieve

http://127.0.0.1/daniel_testing.php?id=1

alll the customer data will be displayed.

like that 1...

thanx in advance

kevinsequeira

can u post the edited form and your code with the changes.

what is the relation between id and searchterm in your form ??

reg
kevin

alternative

this is my form

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

</body>

then u have any new idea on this??

i wanna make somehow like search engines like that 1...
key in number '1' ..then later retrieve the 'id'=1 row.

like that