Mening sahifam

Choose a category:
Customer ID
Customer Name
Customer Email



“
// Agar shakl ko‘rsatilmagan bo‘lsa–uni ko‘rsatish kerak
if (seenform !="у"):
print $form; else:
// MySQL serverga ulanish va ma’lumot bazasini
// tanlash
@mysql_connect("localhost", "web", "ffttss") or die
("Could not connect to MySQL server!");
@mysql_select_db("company") or die("Could not
Select company database!");
// So‘rovni tuzish va bajarish
$query="SELECT cust_id, cust_name, cust_email
FROM customers WHERE $category=‘$keyword’";
$result=mysql_query($query);
// Agar o‘hshashliklar topilmagan bo‘lsa, axborotni
// chiqarish va shaklni qayta ko‘rsatish
if (mysql_num_rows($result)==0):
print "Sorry, but no matches were found. Please try
your search again:";
print $form;
// O‘hshashliklar topilgan. Formatlashtirish va
// natijalarni chiqarish,
Else :
// Formatlashtirish va maydon ma’nolarni chiqarish.
list($id, $name, $email)=mysql_fetch_row($result);
print "

Customer Information:

";
print "Name: $name
";
print "Identification #: $id
";
print "Email:
$email
";
print "

Order History:

";
// ‘orders’ jadvalga so‘rovni tuzish va bajarish
$query="SELECT order_id, prod_id, quantity
FROM orders WHERE cust_id = ‘$id’