I am about in the final stages of my final project and I again have encountered a problem.....my Database is not being populated by the information given from the form....can some one please tell me if you see anything wrong with this code???
The htm form:
<html>
<head></head>
<body>
<Form action ="order.php" Method="post">
<TABLE BORDER=0>
<tr>
<td>Last Name:</td>
<td><INPUT TYPE="text" NAME="lastname" SIZE=30></td></tr>
<tr>
<td>First Name:</td>
<td><INPUT TYPE=TEXT NAME="firstname" SIZE=30></td></tr>
<tr>
<td>Address1: </td>
<td><INPUT TYPE=TEXT NAME="address1" SIZE=45 ></td></tr>
<tr>
<td>Address2: </td>
<td><INPUT TYPE=TEXT NAME="address2" SIZE=45 ></td></tr>
<tr>
<td>City: </td>
<td><INPUT TYPE=TEXT NAME="city" SIZE=30></td></tr>
<tr>
<td>state: </td>
<td><INPUT TYPE=TEXT NAME="state" SIZE=20 > </td></tr>
<tr>
<td>Zip: </td>
<td><INPUT TYPE=TEXT NAME="zip" SIZE=20 > </td></tr>
<tr>
<td>Day Telephone: </td>
<td><INPUT TYPE=TEXT NAME="telephone" SIZE=20 maxlength = 20 >
</td> </tr>
<tr><td>
E-mail Address: </td>
<td> <input type=text name=email size = 40> </td> </tr>
<br/>
<tr> <td> Credit Card Type</td>
<td><SELECT name="credit" >
<OPTION value =" VI">Visa</OPTION>
<OPTION value =" MC">Master Card</OPTION>
<OPTION value =" AX">American Express</OPTION>
</SELECT> </td></tr>
<tr>
<td>Credit Card #</td>
<td><INPUT TYPE=TEXT NAME="creditnum" SIZE=20 ></td></tr>
<td>Exp. date</td>
<td><INPUT TYPE=TEXT NAME="expdate" SIZE=20 ></td></tr>
<td></td>
<td><input type="submit" VALUE="Submit Your Order" /></td></tr>
<td></td>
<td><Input type="reset" value = "Reset"></td>
</table>
</Form>
</body>
</html>
The php being called:
<html>
<head>
<title>Purchase Conformation</title>
</head>
<body>
<h1>Your order has been Processed</h1>
<?
@ $db = mysql_connect("blah", "login", "password");
if (!$db)
{
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("sqlInventorydatabase42");
$query = "insert into customerinfo ( Lastname,Fistname ,Address1 ,Address2 ,City, State,Zip
Telephone,Email ,Credit ,Creditnum,Expdate)
values ('$lastname','$firstname','$address1','$address2','$city','$state',
'$zip','$telephone,'$email,'$credit ','$creditnum','$expdate')";
$result = mysql_query($query);
if ($result)
echo "<h2>".mysql_affected_rows()." Customer inserted into database.</h2>";
?>
<p align ="center" width="200"><a href="index.php">
<img src ="img/logo.jpeg" width="200" height="300"></p>
</body>
</html>
I have checked all the names I they all are correct....
