note 108827 added to function.isset
| From: | hex | Date: | Mon, 28 May 2012 11:49:24 +0000 |
| Subject: | note 108827 added to function.isset | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-188265@lists.php.net to get a copy of this message | ||
a good example
<?php
$conn = mysql_connect("localhost", "twastudent", "prac3") or
die(mysql_error());
mysql_select_db("warehouse", $conn) or die(mysql_error());
$errMsg = '';
if(isset($_POST['custID']) && $_POST['custID'] != '')
$custID = $_POST['custID'];
else
$errMsg .= '<p>No Customer ID was entered!</p>';
if(isset($_POST['shipped']) && $_POST['shipped'] != '')
$shippedStatus = $_POST['shipped'];
else
$errMsg .= '<p>No Shipped status was selected!</p>';
$numResults = 0;
if($errMsg == '')
{
$sql = "SELECT
firstName, lastName, suburb,
orderNumber, orderDate, shippingDate
FROM customer, orders
WHERE customer.customerID = '$custID' AND
shipped = '$shippedStatus'
ORDER BY orderDate
DESC";
$query = mysql_query($sql) or die(mysql_error());
$numResults = mysql_num_rows($query);
}
?>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"
xml:lang="en" lang="en">
<head>
<title>Quiz 2 Question 2 Form</title>
</head>
<body>
<h1>Customer Orders</h1>
<?php
if($errMsg != '')
echo $errMsg;
?>
<p>Enter a customer ID and then select whether you want to view orders that have been shipped
or not shipped:</p>
<form id="question2" action="orders.php" method="post">
<table>
<tr><td>Customer ID: </td><td><input type="text"
name="custID" size="12" /></td></tr>
<tr><td>Show me</td><td><input type="radio"
name="shipped" value="Y" /> Shipped</td></tr>
<tr><td> </td><td><input type="radio"
name="shipped" value="N" /> Not-shipped</td></tr>
<tr><td> </td><td>orders for this customer</td></tr>
<tr><td> </td><td><input type="submit"
value="Show Orders" /> <input type="reset"
value="Reset" /></td></tr>
</table>
</form>
<?php
if($numResults > 0)
{
echo '<ul>';
while($row = mysql_fetch_assoc($query))
{
echo '<li><a
href="view.php?orderNumber='.$row['orderNumber'].'">'.$row['orderNumber'].'</a></li>';
}
echo '</ul>';
}
?>
</body>
</html>
----
Server IP: 113.20.13.217
Probable Submitter: 122.108.33.226
----
Manual Page -- http://www.php.net/manual/en/function.isset.php
Edit -- https://master.php.net/note/edit/108827
Del: integrated -- https://master.php.net/note/delete/108827/integrated
Del: useless -- https://master.php.net/note/delete/108827/useless
Del: bad code -- https://master.php.net/note/delete/108827/bad+code
Del: spam -- https://master.php.net/note/delete/108827/spam
Del: non-english -- https://master.php.net/note/delete/108827/non-english
Del: in docs -- https://master.php.net/note/delete/108827/in+docs
Del: other reasons-- https://master.php.net/note/delete/108827
Reject -- https://master.php.net/note/reject/108827
Search -- https://master.php.net/manage/user-notes.php