Page 1 of 1

PHP Help!!

Posted: Mon Mar 22, 2010 6:43 pm
by tr2gg
Hi,

I am currently trying to post to a database but an unsure as to why it is not posting to the database...could someone help please?

PHP...

<?php

$submit = $_POST['submit'];

$email = $_POST['email'];
$house_number = $_POST['house_number'];
$address1 = $_POST['address1'];
$address2 = $_POST['address2'];
$address3 = $_POST['address3'];
$postcode = $_POST['postcode'];
$telephone = $_POST['telephone'];
$card_name = $_POST['card_name'];
$card_number = $_POST['card_number'];
$expiry_date = $_POST['expiry_date'];
$start_date = $_POST['start_date'];
$security = $_POST['security'];
$terms = $_POST['terms'];

if ($submit)
{
$connect = mysql_connect("localhost","root","");
mysql_select_db("phplogin");

$namecheck = mysql_query("SELECT * FROM shopping");


//check for existance
if ($email&&$house_number&&$address1&&$address2&&$address3&&$county&&
$postcode&&$telephone&&$card_name&&$card_number&&$expiry_date&&$start_date&&$security&&$terms)
{
$queryreg = mysql_query("INSERT INTO shopping ('email','house_number','address1','address2','address3','county',
'postcode','telephone','card_name','card_number','expiry_date','start_date','security','terms')
VALUES('$email','$house_number','$address1','$address2','$address3','$county','$postcode',
'$telephone','$card_name','$card_number','$expiry_date','$start_date','$security','$terms')");
}

else
echo "Please fill in <b> all</b> fields!";



}

?>

FORM...

<div id="shoppingForm">
<form name="input" action="shopping.php" method="POST">
<table>
<tr>
<td>
Your chosen seat(s) are:
</td>
<td>
<?php echo "" . $whichCabin; ?>
</td>
</tr>
<tr>
<td>
Name:
</td>
<td>
<?php echo $_POST["$name"]; ?>
</td>
</tr>
<tr>
<td>
Username:
</td>
<td>
<?php echo $_POST["$username"]; ?>
</td>
</tr>
<tr>
<td>
E-Mail:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
House Number/Name:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
Address Line 1:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
Address Line 2:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
Address line 3:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
County:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
Postcode:
</td>
<td>
<input type="text" name="user" size="7"/>
</td>
</tr>
<tr>
<td>
Telephone:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
Card Name:
</td>
<td>
<input type="text" name="user" />
</td>
</tr>
<tr>
<td>
Card Number:
</td>
<td>
<input type="text" name="user" size="4"/>
<input type="text" name="user" size="4"/>
<input type="text" name="user" size="4"/>
<input type="text" name="user" size="4"/>
</td>
</tr>
<tr>
<td>
Expiry Date:
</td>
<td>
<select>
<option>January</option>
<option>Febuary</option>
<option>March</option>
<option>April</option>
<option>May</option>
<option>June</option>
<option>July</option>
<option>August</option>
<option>September</option>
<option>October</option>
<option>November</option>
<option>December</option>
</select>
<select>
<option>2006</option>
<option>2007</option>
<option>2008</option>
<option>2009</option>
<option>2010</option>
</select>
</td>
</tr>
<tr>
<td>
Expiry Date:
</td>
<td>
<select>
<option>January</option>
<option>Febuary</option>
<option>March</option>
<option>April</option>
<option>May</option>
<option>June</option>
<option>July</option>
<option>August</option>
<option>September</option>
<option>October</option>
<option>November</option>
<option>December</option>
</select>
<select>
<option>2010</option>
<option>2011</option>
<option>2012</option>
<option>2013</option>
<option>2014</option>
<option>2015</option>
<option>2016</option>
<option>2017</option>
<option>2018</option>
<option>2019</option>
</td>
</tr>
<tr>
<td>
Security Number:
</td>
<td>
<input type="text" name="user" size="3"/>
</td>
</tr>
<tr>
<td>
By checking the box you are agreeing to the Terms & Conditions
</td>
<td>
<input type="checkbox" name="vehicle" value="Bike" />
</td>
</tr>




</table>
<p><input type="submit" value="Submit" /></p>
<p><input type="reset" value="Reset" /></p>
</form>

</div>

Any help is greatly appreciated!!

Thanks!

Re: PHP Help!!

Posted: Mon Mar 22, 2010 8:08 pm
by JakeJ
well, I don't have time to actually pick through all of your code. But when I'm trying to do a database insert that fails, the first thing I do is echo out all of the data to make sure there is in fact some data.

If the data is all there, then do inserts of one field at a time to find out where it's failing. you could have a wrong data type, something is misspelled, etc. It could be many things.

Re: PHP Help!!

Posted: Tue Mar 23, 2010 4:03 pm
by greyhoundcode
What debugging have you done? Do you know if the If ($submit) { ... } block is being entered into, for example? If so, what about the if ($email && $house_number ... ) block?

It is easy to test this - just echo some text out within each block.

Re: PHP Help!!

Posted: Wed Mar 24, 2010 9:50 am
by pickle
If you want us to take the time to fix your problem, please take the time to post in the right forum, and post your code in [syntax=php] [/syntax] or [syntax=html] [/syntax] tags.

Thread moved.