PHP Help!!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
tr2gg
Forum Newbie
Posts: 1
Joined: Mon Mar 22, 2010 6:31 pm

PHP Help!!

Post 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!
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

Re: PHP Help!!

Post 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.
User avatar
greyhoundcode
Forum Regular
Posts: 613
Joined: Mon Feb 11, 2008 4:22 am

Re: PHP Help!!

Post 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.
User avatar
pickle
Briney Mod
Posts: 6445
Joined: Mon Jan 19, 2004 6:11 pm
Location: 53.01N x 112.48W
Contact:

Re: PHP Help!!

Post 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.
Real programmers don't comment their code. If it was hard to write, it should be hard to understand.
Post Reply