PHP Forum

**sword07** · 07:43 PM

Hi all!

I have a database set up and have a form to collect data. The database works, and the HTML form works. Bu tthe php code doesnt...

Here it is...

PHP Code:


			
<?php

$con = mysql_connect("localhost","testdatabase","******");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }



mysql_select_db("web165-josh", $con);



$sql="INSERT INTO `qtsdispatches` (`item`, `itemValue`, `shipTo`, `building`, `street`, `townCity`, `postCode`, `refNum`, `collectionDate`, `location`, `courierName`, `consignmentNum`)

VALUES

('$_POST[item]','$_POST[item_value]','$_POST[ship_to]','$_POST[building]','$_POST[street]','$_POST[town_city]','$_POST[post_code]','$_POST[ref_num]','$_POST[collection_date]','$_POST[location]','$_POST[courier_name]','$_POST[consignment_num]')";



if (!mysql_query($sql,$con))

  {

  die('Error: ' . mysql_error());

  }

echo "<h1><b>Database has been updated with one record.</h1></b>";



mysql_close($con)

?>

*** The password, database name, table name ect is all correct. Infact the script runs to the end and displays the message "Database has been updated with one record".

When I look at my database I can see that a new row has been added to it, but EVERY SINGLE field is EMPTY. None of the data from the form was passed onto the database. Why would this be?

So the scripts runs fine, the database has been communicated with in some way because it adds a new row of data (but an empty one!).

I have been scratching my head for days and would very much appreciate it if someone could help me

.

Thanks in advance!!

.

**PaulW** · 12-15-2010, 05:14 AM

Do the keys in the _POST array match form field names? Do an echo $_POST[item_value] before the query - is the value there?

**sword07** · 12-15-2010, 05:19 AM

Hello, thanks for you quick reply!

.

All of the _POST do match my field names. When i echoed the _POST item_value before the query it didn't show. It just said the same: "Database updated with one record".

Thanks again.

**PaulW** · 12-15-2010, 05:25 AM

Quote:

Originally Posted by sword07

When i echoed the _POST item_value before the query it didn't show. It just said the same: "Database updated with one record".

Thanks again.

Just to make sure, try: echo ""***** " . $_POST["ship_to"] . " *****
\n";

**PaulW** · 05:29 AM

all on one line of course! And just one " , not two ( echo "")

**sword07** · 12-15-2010, 10:49 AM

Sorry for my late reply..

I'm not too sure what you want me to do from what you post3d on your most recent reply...

Cold you please explain this to me in more detail?

Many Thanks.

**PaulW** · 07:48 PM

PHP Code:


			
echo "1 *****" . $_POST["ship_to"] . "*****  \n";echo "2 *****" . $_POST[ship_to] . "*****\n";

Put those lines in your code before you do the query and reply here with the output.

**sword07** · 12-17-2010, 04:19 AM

HI again,

OK I added that line before the query and this is what the output was...

1 ********** 2 **********
Database has been updated with one record.

Does that help?

Cheers.

**PaulW** · 12-17-2010, 06:34 AM

It does indeed -- it tells us that the variables values are not being passed over in $_POST. Either that, or the names don't match the HTML form elements -- which you say they do, or you don't have method="POST" on the form. . Check the form again. (Can you post the HTML here?)

**sword07** · 12-17-2010, 07:53 AM

Ah ok thats good then.

Yeah sure, here it is:

<html>
<head>
<title>Dispatches Form</title>
</head>
<body>
<h1>Quayside Technical Services Dispatch Form</h1>
<u><i>Please fill in to the best of your knowledge!</i></u>
<form action="process.php" method="post">
<table>
<tr>
<td>Item:</td>
<td><input type="text" id="item"></td>
</tr><tr>
<td>Item Value (£)::</td>
<td><input type="text" id="item_value"></td>
</tr><tr>
<td>Shipping To:</td>
<td><input type="text" id="ship_to"></td>
</tr><tr>
<td>Business or House Name or Number:</td>
<td><input type="text" id="building"></td>
</tr><tr>
<td>Street:</td>
<td><input type="text" id="street"></td>
</tr><tr>
<td>Town or City:</td>
<td><input type="text" id="town_city"></td>
</tr><tr>
<td>Post Code:</td>
<td><input type="text" id="post_code"></td>
</tr><tr>
<td>Reference Number:</td>
<td><input type="text" id="ref_num"></td>
</tr><tr>
<td>Collection Date: </td>
<td><input type="text" id="collection_date"></td>
</tr><tr>
<td>Collection Location:</td>
<td><input type="text" id="location"></td>
</tr><tr>
<td>Courier Name:</td>
<td><input type="text" id="courier_name"></td>
</tr><tr>
<td>Consignment Number:</td>
<td><input type="text" id="consignment_num"></td>
</tr><tr>
<td> </td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>

Thanks again!

**PaulW** · 08:13 PM

You need to add name attributes to the form fields -- the id isn't what causes the value to be submitted. The string in $_POST["str"] is the value from name=

**PaulW** · 12-17-2010, 08:26 PM

By the way, if someone submits the form with various values unset, your query will insert an empty string for those columns in a record. Is this what you want or should they be set to NULL?