School: {$dbFeedbackSchool} User: {$dbFeedbackUser} Type: {$dbFeedbackType} Content: {$fd} ----{$rspv} Love, Solar Feedback System EEMMAAIILLSS; $headers = "To: Admin <{$to}>" . "\r\n"; $headers .= "From: Solar Feedback <{$from}>" . "\r\n"; if (!mail($to, $subject, $message, $headers)) { Bail('Couldn\'t send notification email.'); } else { DebugPrint('<p>Sending email...</p>'); } // SHOW CONFIRMATION // include 'feedback-received.html'; // FIXME there are many ways we can do this, change to be consistent with rest of site /* FIXME an alternative method echo '<h3>Thank you for your feedback</h3>'; if ( $dbFeedbackResponse == 1 ) { echo '<p>We will get back to you soon</p>'; } */ $con->close();
if ($con->query($sql)) { if (!$con->select_db(DB_NAME)) { Bail('Couldn\'t select db after creating?? ' . $con->error); } } else { Bail('Couldn\'t create db: ' . $con->error); } } DebugPrint('<p>Selected db...</p>'); // Create table if necessary // function TableExists($con, $tableName) { return $con->query("SELECT 1 FROM `{$tableName}`"); } if (!TableExists($con, TABLE_NAME)) { DebugPrint('<p>Creating table...</p>'); $sql = 'CREATE TABLE `' . TABLE_NAME . '` ( feedback_id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(feedback_id), school VARCHAR(50), user VARCHAR(50), type VARCHAR(15), content TEXT, response BOOL )'; if (!$con->query($sql)) { Bail('Couldn\'t create table: ' . $con->error); } } echo '<h3>Solar Feedback Form</h3>';