After I submit an order in my order form, I have my order form set to then call another php script called, “orderform.php” to process an order and automatically send the order to MySQL. However, when I test it out, I keep getting an error that I can’t query.
Any toughts. Here is my orderform.php code:
[CODE]
<!DOCTYPE html>
<head><title>PoemScribe Order Form</title>
</head>
<body>
<h2>PoemScribe</h2>
<?php
$first_name = $_POST[‘firstname’];
$last_name = $_POST[‘lastname’];
$email = $_POST[’email’];
$select_poem_type = $_POST[‘selectpoemtype’];
$key_names = $_POST[‘keynames’];
$specific_words = $_POST[‘specificwords’];
$poem_is_for = $_POST[‘poemisfor’];
$relationship = $_POST[‘relationship’];
$occasion = $_POST[‘occasion’];
$over_all_message = $_POST[‘overallmessage’];
$anything_else = $_POST[‘anythingelse’];
$dbc = mysqli_connect(‘localhost’, ‘login’, ‘password’, ‘database’)
or die(‘Error connecting to MySQL server.’);
$query = “INSERT INTO tuxandp1_poem_orders (first_name, last_name, email, select_poem_type, key_names, specific_words, poem_is_for, ” .
“relationship, occasion, over_all_message, anything_else,) ” .
“VALUES (‘$first_name’, ‘$last_name’, ‘$email’, ‘$select_poem_type’, ‘$key_names’, ‘$specific_words’, ‘$poem_is_for’, ” .
“‘$relationship’, ‘$occasion’, ‘$over_all_message’, ‘$anything_else’)”;
$result = mysqli_query($dbc, $query)
or die (‘Error querying database.’);
mysqli_close($dbc);
?>
</body>
</html>