Help
Hi,
I have a problem with receiving an 'Error querying database.' message each time I hit the submit button. I have checked the code for the final version of this file (i.e. addemail.php) and it appears to mirror my code. I had no problem with the aliendatabase section.
The code follows:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Make Me Elvis - Add Email</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<?php
$dbc = mysqli_connect ("***", "***", "***", "***")
or die ('Error connecting to MySQL server.');
$first_name = $_POST ['firstname'];
$last_name = $_POST ['lastname'];
$email = $_POST ['email'];
$query = "INSERT INTO email_list (firstname, lastname, email)" .
"VALUES ('$first_name', '$last_name', '$email')";
mysqli_query ($dbc, $query)
or die ('Error querying database.');
echo 'Customer added.';
mysqli_close ($dbc);
?>
</body>
</html>
Am using PHP Version 5.2.15 so mysqli should be no problem - and in any case it worked for the chapter 2 exercise.
Thank you,
Paul Young
COLLECTED BY
Organization: Alexa Crawls
Starting in 1996, Alexa Internet has been donating their crawl data to the Internet Archive. Flowing in every day, these data are added to the Wayback Machine after an embargo period.
Collection: Alexa Crawls
Starting in 1996, Alexa Internet has been donating their crawl data to the Internet Archive. Flowing in every day, these data are added to the Wayback Machine after an embargo period.
TIMESTAMPS
