I am making a signup page. Here is the form:
<?php
print "<BR><BR><BR>";
print "<h1>Test for MySQL Tables</h1>";
print "<BR><BR><BR>";
print '<form action="signup_process.php" method="post">';
print 'Desired Username: <input type="text" name="username" maxlength=20><BR>';
print 'Desired Password: <input type="password" name="password" maxlength=20><BR>';
print 'First Name: <input type="text" name="f_name" maxlength=25><BR>';
print 'Last Name: <input type="text" name="l_name" maxlength=25><BR>';
print 'Email Address: <input type="text" name="email" maxlength="60"><BR>';
print 'Age: <input type="text" name="age" maxlength="3"><BR>';
print 'Gender: Male<input type="radio" name="male" value="male"> Female<input type="radio" name="female" value="female"><BR>';
print '<input type="submit" value="Finish signup!">';
?>
and here is the process for it:
<?php
$dbuser = "random";
$dbpass = "random";
$dbname = "random";
$_POST['username'] = $uname;
$_POST['password'] = $pword;
$_POST['f_name'] = $fname;
$_POST['$l_name'] = $lname;
$_POST['email'] = $email;
$_POST['age'] = $age;
$_POST['gender'] = $gender;
if (empty($_POST['username']) || ($_POST['password']) || ($_POST['f_name']) || ($_POST['l_name']) || ($_POST['email']) || ($_POST['age']) || ($_POST['gender'])) {
print "Please fill in all of the required fields!";
}else {
$link = mysql_connect("localhost", $dbuser, $dbpass) or die ("Database Error: Couldn't Connect!");
mysql_select_db($dbname, $link) or die ("Couldn't open $db!");
$query = "INSERT INTO user_info (username, password, f_name, l_name, email, age, gender)
values( '$uname', '$pword', '$fname', '$lname', '$email', '$age', '$gender' )";
mysql_query($query, $link) or die ("Couldn't input data!");
mysql_close($link);
}
?>
All it does is adds a blank space in the database fields. No errors, just blank spaces. Any help would be appreciated.
