Hi there I have a form which is supposed to insert into my mysql database but it isnt could anyone help?
The code is below.
<?PHP
include "common.php";
$link = mysql_connect("$server", "$username", "$password")
or die("Could not connect");
mysql_select_db("$db") or die("Could not select database");
if ($action == "add") {
$query = "SELECT * FROM escortsnew WHERE user = '$user'";
$result = mysql_query($query) or die("Query failed");
while ($i = mysql_fetch_array($result)) {
if ($user == $i[user]) {
echo "<font face=arial size=2>Username all ready in use</font>";
die;
}
}
if (empty($user) || $user == "") {
echo "<font face=arial size=2>Bad Username</font>";
die;
}
if (empty($pass) || $pass == "") {
echo "<font face=arial size=2>Bad Password</font>";
die;
}
if (empty($email) || $email == "") {
echo "<font face=arial size=2>Bad E-Mail</font>";
die;
}
if ($auto_validation == "no")
{$query = "INSERT INTO escortsnew (id, user, pass, name, email, country, location, city, rates, description, height, stats, age, status) VALUES ('$id', '$user', '$pass', '$name', '$email', '$country', '$location', '$city', '$rates', '$description', '$height', '$stats', '$age', 'N')";
$msg = "Thank you for submission of your profile to the listings. Your site will be reviewed shortly.";
mail($email,"Welcome $name to the Adult Info 4 U Escort Listings",$msg,"From: $admin_email\nReply-To: $admin_email");
}
if ($new_member == "yes" AND $auto_validation == "no") {
$msg = "GO TO $url_to_folder/admin\n";
$msg.= "User Name : $name\n";
$msg.= "User Email : $email\n";
$msg.= "City : $city\n";
$msg.= "\n";
mail($admin_email,"Escort Requires Validation",$msg,"From: $email\nReply-To: $email");
}
if ($auto_validation == "no")
{
echo "Your listing has been added and waiting for validation.";
}
}
else{
print "<form action=add2.php?page=add method=post enctype=\"multipart/form-data\">";
print "<table width=\"60%\" border=0 cellpadding=2 cellspacing=0 class=\"maintxt\"><tr>";
print "<td width=\"36%\">Username:</td><td width=\"64%\">";
print "<input type=text name=user value=\"$user\" maxlength=\"20\"></td></tr>";
print "<tr><td>Password:</td><td><input type=password name=pass value=\"$pass\" maxlength=\"10\"></td></tr>";
print "<tr><td>Name:</td><td><input type=text name=name value=\"$name\" maxlength=\"50\"></td></tr>";
print "<tr><td>E-Mail:</td><td><input type=text name=email value=\"$email\" maxlength=\"70\"></td></tr>";
print "<tr><td>Country</td><td><input type=text name=country value=\"$country\" maxlength=\"99\"></td></tr>";
print "<tr><td>Location:</td><td><select name=\"location\"><option value=\"London\" selected>London</option>";
print "<option value=\"North\">North</option><option value=\"North East\">North East</option>";
print "<option value=\"North West\">North West</option><option value=\"East Midlands\">East Midlands</option>";
print "<option value=\"West Midlands\">West Midlands</option><option value=\"South\">South</option>";
print "<option value=\"South East\">South East </option><option value=\"South West\">South West</option>";
print "<option value=\"Scotland\">Scotland</option><option value=\"Wales\">Wales</option>";
print "<option value=\"Ireland\">Ireland</option><option value=\"Outside UK\">Outside UK</option></select></td></tr>";
print "<tr><td>City:</td><td><input type=text name=city value=\"$city\" maxlength=\"99\"></td></tr>";
print "<tr><td>Rates:</td><td><input type=text name=rates value=\"$rates\" maxlength=\"99\"></td></tr>";
print "<tr><td>Description:</td><td><textarea cols=20 rows=4 name=description value=\"$description\"></textarea></td></tr>";
print "<tr><td>Height:</td><td><input type=text name=height value=\"$height\" maxlength=\"20\"></td></tr>";
print "<tr><td>Stats:</td><td><input type=text name=stats value=\"$stats\" maxlength=\"20\"></td></tr>";
print "<tr><td>Age:</td><td><input type=text name=age value=\"$age\" maxlength=\"5\"></td></tr>";
print "<tr colspan=2><td><input type=hidden name=action value=\"add\"><input type=submit value=\"Make Your Page!\"></table></form>";
} ?>
