Forms
| From: | Chiew, Richard | Date: | Mon, 25 Feb 2002 22:37:28 +0000 |
| Subject: | Forms | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86169@lists.php.net to get a copy of this message | ||
Hi there, i have the following php code that works fine. But when i
click on the submit button and then it takes me to the next page, it
displays the following error mesage at the top
Warning: MySQL: A link to the server could not be established in
c:\program files\nusphere\apache\nsdocs\mug_world.php on line 129
(the line that is in bold and highlighted in red)
Everything works fine except the above line. (The information i filled
in did go in the table that i created in mysql...)
<?php
# Global variables
$script_name = 'mug_world.php';
$db_name = 'mug_world';
$db_host = 'localhost';
$db_username = 'webuser';
$db_password = 'customer';
function view_products() {
# explicity request to use these global variables
global $script_name, $db_name, $db_host, $db_username,
$db_password;
# connect to database
$link = mysql_connect($db_host, $db_username, $db_password)
or die("Connection failed: " . mysql_error());
# select our table
mysql_select_db($db_name)
or die("Database selection failed [$db_name]: " .
mysql_error());
# send a query
$sql = "SELECT * FROM products ORDER BY product_id";
$result = mysql_query($sql)
or die("Query failed: " . mysql_error());
echo "<H2>Welcome to Mug World</H2>\n";
echo "<FORM METHOD=POST ACTION=\"$script_name\">\n";
echo "<TABLE BORDER=1>\n";
echo "Name: <INPUT TYPE=TEXT NAME=\"name\">\n";
# print the product selection table
$table_row = "<TR>";
$table_row .= "<TH> </TH>";
$table_row .= "<TH>Mug Quote</TH>";
$table_row .= "<TH>Price</TH>";
$table_row .= "</TR>";
echo "$table_row\n";
while ($row = mysql_fetch_array($result)) {
$table_row = "<TR>";
$table_row .= "<TD><INPUT TYPE=RADIO NAME=\"product\"";
$table_row .= " VALUE=\"$row[product_id]\"></TD>";
$table_row .= "<TD>$row[quote]</TD>";
$table_row .= "<TD>$row[cost]</TD>";
$table_row .= "<TR>";
echo "$table_row\n";
}
echo "</TABLE>\n";
echo "<INPUT TYPE=SUBMIT NAME=\"button\" VALUE=\"Submit
Order\">\n";
echo "<INPUT TYPE=SUBMIT NAME=\"button\" VALUE=\"View
Orders\">\n";
echo "</FORM>\n";
mysql_free_result($result);
mysql_close($link);
}
function view_orders() {
# explicity request to use these global variables
global $script_name, $db_name, $db_host, $db_username,
$db_password;
# connect to database
$link = mysql_connect($db_host, $db_username, $db_password)
or die("Connection failed: " . mysql_error());
# select our table
mysql_select_db($db_name)
or die("Database selection failed [$db_name]: " .
mysql_error());
# send a query
$sql = "SELECT
orders.order_num,orders.name,orders.product_id,";
$sql .= "products.quote,products.cost ";
$sql .= "FROM orders ";
$sql .= "LEFT JOIN products ON
orders.product_id=products.product_id ";
$sql .= "ORDER BY orders.order_num";
$result = mysql_query($sql)
or die("Query failed: " . mysql_error());
echo "<H2>Current Mug World Orders</H2>\n";
echo "<TABLE BORDER=1>\n";
# print the product selection table
$table_row = "<TR>";
$table_row .= "<TH>Order Number</TH>";
$table_row .= "<TH>Name</TH>";
$table_row .= "<TH>Product</TH>";
$table_row .= "<TH>Cost</TH>";
$table_row .= "</TR>";
echo "$table_row\n";
while ($row = mysql_fetch_array($result)) {
$table_row = "<TR>";
$table_row .= "<TD>$row[order_num]</TD>";
$table_row .= "<TD>$row[name]</TD>";
$table_row .= "<TD>$row[quote]</TD>";
$table_row .= "<TD>$row[cost]</TD>";
$table_row .= "<TR>";
echo "$table_row\n";
}
echo "</TABLE>\n";
echo "<FORM METHOD=POST ACTION=\"$script_name\">\n";
echo "<INPUT TYPE=SUBMIT NAME=\"button\" VALUE=\"Back to Order
Page\">\n";
echo "</FORM>\n";
mysql_free_result($result);
mysql_close($link);
}
function save_order($name, $product) {
# explicity request to use these global variables
global $script_name, $db_name, $db_host, $db_username,
$db_password;
# connect to database
$link = mysql_connect($db_host, $db_username, $db_password)
or die("Connection failed: " . mysql_error());
# select our table
mysql_select_db($db_name)
or die("Database selection failed [$db_name]: " .
mysql_error());
# send a query
$sql = "INSERT INTO orders ";
$sql .= "SET name='$name',product_id='$product'";
mysql_query($sql)
or die("Query failed: " . mysql_error());
mysql_close($link);
return mysql_insert_id();
}
?>
<HTML>
<HEAD><TITLE>Welcome to Mug World</TITLE></HEAD>
<BODY>
<?php
# main routine
switch ($button) {
case 'Submit Order':
save_order($name, $product);
view_products();
break;
case 'View Orders':
view_orders();
break;
default:
view_products();
}
?>
</BODY>
</HTML>