Re: mysql query

On 8/22/2013 9:52 AM, Jim Giner wrote:

On 8/21/2013 7:48 PM, Ethan Rosenberg wrote:

Dear List - I can't figure this out.... mysql> describe Inventory; +-------------+-------------+------+-----+---------+-------+

| Field       | Type        | Null | Key | Default | Extra |

+-------------+-------------+------+-----+---------+-------+

| UPC         | varchar(14) | YES  |     | NULL |       |
| quant       | int(5)      | NO   |     | NULL |       |
| manuf       | varchar(20) | YES  |     | NULL |       |
| item        | varchar(50) | YES  |     | NULL |       |
| orderpt     | tinyint(4)  | NO   |     | NULL |       |
| ordrpt_flag | tinyint(3)  | YES  |     | NULL |       |
| stock       | int(3)      | YES  |     | NULL |       |

+-------------+-------------+------+-----+---------+-------+ Here are code snippets -

                           $upc   = $_SESSION['UPC'];
                           $qnt   = $_POST['quant'];
                           $mnf   = $_POST['manuf'];
                           $itm   = $_POST['item'];
                           $odrpt = $_POST['oderpt'];
                           $opf   = $_POST['ordrpt_flag'];
                           $stk    = $_POST['stock'];

                           $sql2 = "insert into Inventory (UPC, quant,

manuf, item, orderpt, ordrpt_flag, stock)"

                                 ."values ('$upc', $qnt,'$mnf','$itm',

odrpt, 0, $stk)";

                           $result2 = mysqli_query(cxn, $sql2);
                           echo '$sql2<br />';
                           print_r($sql2);
                           echo "<br />$upc $qnt $mnf $itm $odrpt $opf

$stk<kbr />";

                           if (!$result2)
                                 die('Could not enter data: ' .

mysqli_error()); The mysql query fails. I cannot figure out why. It works from the command line. TIA Ethan

Ethan - you are simply missing two dollar signs as pointed out. Once you correct them, if there are any more errors you should then be seeing the message from mysqli_error. And as for the advice to dump single quotes, I'd ignore it. The use of double and single quotes is a very handy feature and makes for very readable code. Escaping double quotes is such a royal pia and makes for more trouble deciphering code later on. The sample you provided for us is some of the best and most understandable code you've ever showed us. Also - Ethan - if you used an editor that was designed for php you probably would have seen these missing $ signs since a good one would highlight php syntax and the lack of the $ would have produced a different color than you expected.