**********************************************************
Code: Select all
<?php
extract($_POST);
if(empty($username) || empty($password) || empty($question) || empty($answer) || empty($email)) {
echo 'Please hit the back button and make sure you filled in the fields correctly';
} else {
$db_address = 'localhost';
$db_name = 'slices_net';
$table_name = 'ebayuser';
$db_user = 'slics';
$db_pass = 1;
$connection = mysql_connect($db_address, $db_user, $db_pass) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());
$sql = "INSERT INTO $table_name(username, password, question, answer, email) VALUES('" . $username . "', '" . $password . "', '" . $question . "', '" . $answer . "', '" . $email . "')";
$result = mysql_query($sql, $connection) or die(mysql_error());
echo $result;
mysql_free_result($result) or die(mysql_error());
mysql_close($connection) or die(mysql_error());
}
?>
**********************************************************
nick2 wrote:$db_address = "localhost"
Absent semi-colon.
**********************************************************
nick2 wrote:$sql = "INSERT INTO $table_name (username, password, question, answer, email) VALUES ('$_POST[username]', '$_POST[password]', '$_POST[question]', '$_POST[answer]', '$_POST[email]');
Absent trailing/closing double-quote.
Code: Select all
$sql = "INSERT INTO $table_name(username, password, question, answer, email) VALUES('$_POSTїusername]', '$_POSTїpassword]', '$_POSTїquestion]', '$_POSTїanswer]', '$_POSTїemail]')";
**********************************************************
nick2 wrote:Print $result
Yet another absent semi-colon.
**********************************************************
Select the database.
Code: Select all
mysql_select_db($db_name) or die(mysql_error());
**********************************************************
nick2 wrote:$connection = @mysql_connect($db_address, $db_user, $db_pass) or die(mysql_error());
Absolutely pointless.
Code: Select all
$connection = mysql_connect($db_address, $db_user, $db_pass) or die(mysql_error());
**********************************************************
nick2 wrote:$result = @mysql_query($sql, $connection) or die(mysql_error());
Again - absolutely pointless.
Code: Select all
$result = mysql_query($sql, $connection) or die(mysql_error());
**********************************************************