Hello, I have created this script and created a Database (Website) and Table (login) to go with it. It has all of the Rows but it wont work for some reason. Please tell me whats wrong!!!
<html>
<head>
<basefont face="Arial">
</head>
<body>
<?php
if (!isset($_POST['submit'])) {
// form not submitted
?>
<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
Choose A Username: <input type="text" name="User">
Choose A Password: <input type="text" name="Pass">
Your Name: <input type="text" name="Name">
Your Email: <input type="text" name="Email">
<input type="submit" name="submit">
</form>
<?php
}
else {
// form submitted
// set server access variables
$host = "localhost";
$user = "Drezard";
$pass = "19316803";
$db = "website";
// get form input
// check to make sure it's all there
// escape input values for greater safety
$User = empty($POST['User']) ? die ("ERROR: Enter a Username") : mysql_escape_string($POST['User']);
$Pass = empty($POST['Pass']) ? die ("ERROR: Enter a Password") : mysql_escape_string($POST['Pass']);
$Name = empty($POST['Name']) ? die ("ERROR: Enter a Name") : mysql_escape_string($POST['Name']);
$Email = empty($POST['Email']) ? die ("ERROR: Enter a Email") : mysql_escape_string($POST['Email']);
// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
// create query
$query = "INSERT INTO symbols.login (User, Pass, Name, Email) VALUES ('$User', '$Pass', '$Name', '$Email')";
// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
// print message with ID of inserted record
// close connection
mysql_close($connection);
}
?>
</body>
</html>
