I am trying to make a php form on the web that will write data to and query data from an existant database. When I attemp to do this, I get the return info
query($query); if ($result) echo 'Record entered.'; $db->close(); ?>
regardless of whether or not I actually entered any data into the form to begin with. As I understand it, it should be stopping the script at the first if statement when none of the variables have any values. Here is the html form for the input, followed by the php script that should be connecting to my database. I know the php form isn't complete with data input, I removed most of the queries to simplify this. Thanks in advance for any help.
<!--This page is the main php file for the MySQL interface for the UTHookup Database-->
<HTML>
<HEAD><TITLE>
Database
</TITLE></HEAD>
<BODY>
<H2><B>Registration Info</B></H2>
<FORM ACTION="processinfo.php" METHOD="post">
<TABLE>
<TR>
<TD WIDTH=100>First Name:</TD>
<TD><INPUT TYPE="text" NAME="firstname" MAXLENGTH=50>
Last Name: <INPUT TYPE="text" NAME="lastname" MAXLENGTH=50></TD>
</TR>
<TR>
<TD>Current Address:</TD>
<TD><INPUT TYPE="text" NAME="streetaddress" SIZE =50 MAXLENGTH=255></TD>
</TR>
<TR>
<TD>City:</TD>
<TD><INPUT TYPE="text" NAME="city" MAXLENGTH=50 VALUE="Austin"> State: <INPUT TYPE="text" NAME="state" SIZE=2 MAXLENGTH=2 VALUE="TX">
Zip: <INPUT TYPE="text" NAME="zipcode" SIZE=5 MAXLENGTH=5></TD>
</TR>
<TR>
<TD>Telephone:</TD>
<TD><INPUT TYPE="text" NAME="areacode" SIZE=3 MAXLENGTH=3> <INPUT TYPE="text" NAME="telephonenumber" SIZE=7 MAXLENGTH=7>
E-Mail: <INPUT TYPE="text" NAME="email" SIZE=30 MAXLENGTH=50></TD>
</TR>
<TR>
<TD>Gender:</TD>
<TD><INPUT TYPE=RADIO NAME="gender" VALUE=Male>Male<BR>
<INPUT TYPE=RADIO NAME="gender" VALUE=Female>Female<BR>
</TD>
</TR>
<TR>
<TD COLSPAN=2><HR></TD>
<TR>
<TD>Hometown Address</TD>
<TD><INPUT TYPE="text" NAME="hometownaddress" SIZE =50 MAXLENGTH=255></TD>
</TR>
<TR>
<TD>City:</TD>
<TD><INPUT TYPE="text" NAME="hometowncity" MAXLENGTH=50> State: <INPUT TYPE="text" NAME="hometownstate" SIZE=2 MAXLENGTH=2>
Zip: <INPUT TYPE="text" NAME="hometownzipcode" SIZE=5 MAXLENGTH=5></TD>
</TR>
<TR>
<TD COLSPAN=2><HR></TD>
</TR>
<TR>
<TD>Camp:</TD>
<TD><SELECT NAME="campname">
<OPTION VALUE=1>Donkey Kong
<OPTION VALUE=2>Luigi
<OPTION VALUE=3>Mario
<OPTION VALUE=4>Princess
<OPTION VALUE=5>Yoshi
</SELECT>
</TD>
</TR>
<TR>
<TD COLSPAN=2><HR></TD>
</TR>
<TR>
<TD>Notes:</TD>
<TD>
<TEXTAREA ROWS=4 COLS=50 NAME="note" WRAP=VIRTUAL>
</TEXTAREA>
</TD>
</TR>
<TR>
<TD COLSPAN="2"><INPUT TYPE="submit" VALUE="Submit Camper Information">
<INPUT TYPE="reset" VALUE="Reset Form"></TD>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
and the php form is
<HTML>
<HEAD>
<TITLE>Data Entered</TITLE>
</HEAD>
<BODY>
<?php
// create short variable names
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$streetaddress = $_POST['streetaddress'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zipcode'];
$areacode = $_POST['areacode'];
$telephonenumber = $_POST['telephonenumber'];
$email = $_POST['email'];
$gender = $_POST['gender'];
$hometownaddress = $_POST['hometownaddress'];
$hometowncity = $_POST['hometowncity'];
$hometownstate = $_POST['hometownstate'];
$hometownzipcode = $_POST['hometownzipcode'];
$campname = $_POST['campname'];
$note = $_POST['note'];
if (!$firstname || !$lastname || !$streetaddress || !$city || !$state || !$zipcode || !$gender || !$campname)
{
echo 'You have not entered all required information,'
echo 'Please go back and try again.';
exit;
}
if (!get_magic_quotes_gpc())
{
$firstname = addslashes($firstname);
$lastname = addslashes($lastname);
$streetaddress = addslashes($streetaddress);
$city = addslashes($city);
$areacode = addslashes($areacode);
$telephonenumber = addslashes($telephonenumber);
$email = addslashes($email);
$hometownaddress = addslashes($hometownaddress);
$hometowncity = addslashes($hometowncity);
$note = addslashes($note);
}
@ $db = new mysqli('localhost', 'username', 'password', 'database');
if (mysqli_connect_errno())
{
echo 'Error: Could not connect to database. Please contact database admin.';
exit;
}
$query = "INSERT INTO camper VALUES
('', '".$campname"', '".$firstname"', '".$lastname"', '".$gender"')";
$result = $db->query($query);
if ($result)
echo 'Record entered.';
$db->close();
?>
</BODY>
</HTML>
I have of course changed some of the actual info (the mysqli command, for example), but beside that, this is what I have. I have double checked and triple checked to make sure the database is active and listening, that the user I have is able to insert data, and that my fields are all correct. I suspect that the variables aren't getting any values at all to begin with, though, since even if i submit the form with all blanks, it is not stopped at the first if statement. The error I'm getting isn't really even an error, just a line from the script
query($query); if ($result) echo 'Record entered.'; $db->close(); ?>
but the database isn't being connected to. I do have the latest version of php installed, and I am hosting several php pages from my webserver right now that work just fine.
