The variable for $dbc is
Code: Select all
<?php
/* ################################ */
/* ##### Connection Document ###### */
/* ################################ */
DEFINE ('DB_USER'
DEFINE ('DB_PASSWORD
DEFINE ('DB_HOST'
DEFINE ('DB_NAME'
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
if (!$dbc) {
die ('Could not connect to the database');
}
echo 'Alright!';
?>
This returns Alright! so it is connecting.
It also returns Heck Yes 03 in this code
Code: Select all
<?php
include ('config/config.php'); //Add configuration file
if (!$dbc)
{
die('Could not connect: ' . mysqli_error($dbc));
}
else {
echo "Heck Yes 03";
}
mysqli_select_db("survey_answers", $dbc);
$sql="INSERT INTO survey_answers (survey_id,user_id,answer_body) VALUES (3,1,'ID03 ANS01')";
if (!mysqli_query($sql,$dbc))
{
die('Error: ' . mysqli_error());
}
echo "1 record added";
mysqli_close($dbc);
?>
I ran -- INSERT INTO survey_answers (survey_id,user_id,answer_body) VALUES (3,1,'ID03 ANS01')
in myphpadmin and it added the row correctly
I am not sure what's happening
