Code: Select all
<?php
if (!isset($_POST['submit'])) {
?>
<form action="" method="post">
Order ID: <input type="text" name="orders_id"><br />
Customer ID: <input type="text" name="customers_id"><br />
Customer Name: <input type="text" name="customers_name"><br />
Customer City: <input type="text" name="customers_city">
<input type="submit" name="submit" value="Submit!">
</form>
<?php
} else {
$orders_id = $_POST['orders_id'];
$customers_id = $_POST['customers_id'];
$customers_name = $_POST['customers_name'];
$customers_city = $_POST['customers_city'];
//MySQL string:
$sql = "UPDATE zen_orders SET
orders_id = '$orders_id',
customers_id = '$customers_id'
customers_name = '$customers_name'
WHERE orders_id='$orders_id'";
$result = mysql_query($sql);
//Output a result
if($result){
echo "Update Successful!";
} else {
$message = "Failed to update! This is the MySQL Error output:<br>" + mysql_error();}
}
?>