I'm having a problem with a form to enter data into a MySql database on a web server that I have no control over. I can either get it to redisplay the form, or enter the data into the database, but not both. Can anyone help?
<html>
<head>
<BODY>
<?php
if (isset($HTTP_POST_VARS['add']))
{
// Set Mysql Variables
$host='localhost';
$user='xxxxxxx';
$pass='xxxxxxxxx';
$db='site';
$table='main';
// Set global variables to easier names
$FName=$POST['FName'];
$LName=$POST['LName'];
$DateJ=$POST['DateJ'];
$UName=$POST['UName'];
$PWord=$POST['PWord'];
$EMail=$POST['EMail'];
// Connect to Mysql, select the correct database, and run the query which adds the data gathered from
the form into the database
mysql_connect($host, $user, $pass) or die('Connection died!');
mysql_select_db($db) or die('Selection died!');
$add_all="INSERT INTO $table (FName, LName, DateJ, UName, PWord, EMail) values
('$FName','$LName','$DateJ','$UName','$PWord','$EMail');";
mysql_query($add_all) or die(mysql_error());
}
else
{
?>
<FORM METHOD="post" ACTION="<? echo $HTTP_SERVER_VARS['PHP_SELF']; ?>">
First Name: <INPUT TYPE="text" NAME="FName" ID="FName"><BR><BR>
LAST Name: <INPUT TYPE="text" NAME="LName" ID="LName"><BR><BR>
Date: <INPUT TYPE="text" NAME="DateJ" ID="DateJ"><BR><BR>
User Name: <INPUT TYPE="text" NAME="UName" ID=UName"><BR><BR>
Password: <INPUT TYPE="text" NAME="PWord" ID="PWord"><BR><BR>
Email Address: <INPUT TYPE="text" NAME="EMail" ID="EMail"><BR><BR>
<INPUT TYPE="submit" VALUE="Input" NAME="add" ID="add">
</FORM>
<?php
}
?>
</BODY>
</HTML>
I know it's not pretty - I want to get it working first, then I'll doll it up! :p
