Field in DB won't populate

hbradshaw

Hello:

I'm running a small test query and I'm trying to populate a table. The table has three fields: item_code, price, qty.

When I run my script, price and qty are populated and item_code is not.

Can someone take a look and help me debug this problem?

This is the form which calls the PHP script:

<form method="post" action="test.php">
<input type="hidden" name="item_code" value="VEB120">
<input type="hidden" name="price" value="76.00">
<input type="text" name="qty" size="15">
<input type="submit" name="submit" value="Add to Cart">
</form>

This is the PHP script:

<?php

//connect to database
      $conn = mysql_connect('localhost', 'xx', 'xx') or die(mysql_error());

$db = mysql_select_db("xx") 
  or die(mysql_error());

  //add to product table
  $add_product = "insert into test1 values ('$_POST[item_code]', '$_POST[price]',
                 '$_POST[qty]')";

  mysql_query($add_product) or die(mysql_error());


?>

Also, this is my table structure:
item_code VARCHAR(25)
price INT
qty INT

Thank you for all your help.

devinemke

mysql_connect('localhost', 'xx', 'xx') or exit(mysql_error());
mysql_select_db('xx') or exit(mysql_error());

$sql = "INSERT INTO test1 SET 
item_code = '" . $_POST['item_code'] . "',
price = '" . $_POST['price'] . "',
qty = '" . $_POST['qty'] . "'";

mysql_query($sql) or exit(mysql_error());

hbradshaw

Hi,

Thanks for the reply. I modified my INSERT statement to yours and I received the following message, Query was empty.

I did a phpinfo() and the value for item_code is passing through.

PHP Variables
Variable Value
REQUEST["itemcode"] VEB120
REQUEST["price"] 76.00
REQUEST["qty"] 5
REQUEST["submit"] Add to Cart
POST["itemcode"] VEB120
POST["price"] 76.00
POST["qty"] 5
POST["submit"] Add to Cart

The problem is that my table or my query doesn't like the way item_code is being inserted into the table.

Any thoughts?

kburger

Let's see the exact code you executed. The code posted by devinemke should work.

Edit: Wait a sec... Is it 'item_code' or 'itemcode'. You're using different things in different places.