I am not entirely sure but it looks like the values being posted by my forms e.g. Text1 for my first text box, are not being recognized by PHP.
Been wrestling with it all night, hopefully someone can help? Thanx.
<?php
$dbhost = 'localhost';
$dbuser = 'xeuser';
$dbpass = 'xepass';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$sql = 'INSERT INTO `amis_q1`.`crop1_8_9` (
`IDENTIFICATION` , `ADD` , `MARKET` , `DISTRICT` , `ENUMERATOR` , `Seller` , `Name_of_Unit` , `Number_of_Sellers` , `Average_Weight` , `Estimated_Weights` , `Type_of_Seller` , `Tramsport` , `Source` , `Remarks` , `CHECKED` , `BY` , `SUPERVISOR` , `OFFICE` , `DATE` , `INITIALS`
)
VALUES
( $_POST['Text1'],'$_POST[Text2]','$_POST[Text3]','$_POST[Text4]','$_POST[Text5]','$_POST[Text6]','$_POST[Text7]','$_POST[Text8]','$_POST[Text9]','$_POST[Text10]','$_POST[Text11]','$_POST[Text12]','$_POST[Text13]','$_POST[Text14]','$_POST[Text15]','$_POST[Text16]','$_POST[Text17]','$_POST[Text18]','$_POST[Text19]','$_POST[Text20]'
)';
mysql_select_db('amis_q1');
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
print 'Inputted';
mysql_close($conn);
?>
Overarching problems: don't use mysql functions, and read about SQL injection, as your code (and the correct code below) are both extremely flawed from a security perspective.
Other than that, the problem lies in your use of single quotes in $sql. Here's the correct way to do the last half of the variable:
$sql = ') VALUES (' . $_POST['Text1'] . ', ' . $_POST['Text2'] . ')';
...this is the correct way to concatenate strings in PHP.