Re: [PHP-DB] Re: mysql query

On 08/22/2013 09:51 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.
Jim -

Thanks for the complement.

Ethan