Re: [PHP-DB] Re: mysql query

On 8/22/2013 8:08 PM, Ethan Rosenberg wrote:
>
> Ethan Rosenberg, PhD
> /Pres/CEO/
> *Hygeia Biomedical Research, Inc*
> 2 Cameo Ridge Road
> Monsey, NY 10952
> T: 845 352-3908
> F: 845 352-7566
> [email protected]
> On 08/22/2013 06:56 PM, Jim Giner wrote:
>> On 8/22/2013 4:14 PM, Ethan Rosenberg wrote:
>>> On 08/22/2013 11:54 AM, Jim Giner wrote:
>>>> 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.
>>>>
>>> Jim -
>>>
>>> I  used Netbeans.  All it said is "variable unused is scope", which is
>>> a  error that I often find does not mean anything.  I am as pressurized
>>> as you are.  Any suggestions as to an editor?
>>>
>>> Ethan
>>>
>>>
>> Did you mean to say "unused IN scope"?  That would be telling you that
>> it is not yet defined and that could be a problem if you expect to be
>> already defined.
>>
>> Several other posts here have listed their favorites.  Notepad ++
>> seems to be a favorite.  I use HTML-kit Tools as my developing
>> environment. Handles highlighting for php, html and js, as well as
>> project organization.  Also includes an ftp engine to allow me to
>> modify, upload and then go test my code very quickly. (I don't run php
>> or apache locally.)
> Jim -
>
> Thanks.
>
> unused IN scope - correct.
>
> There are lots of editors mentioned in this email trail.  I thank all
> for the suggestions.
>
> Netbeans, Aptana Studio, etc will all highlight code and show the errors
> the code would generate in a browse. The problem here was two missing $
> signs.
>
> I'm probably wrong, but in some contexts; eg, sql query, $ signs are not
> used.  I tried and added the incorrect $ sign, and Netbeans did not
> complain.  If anyone knows of an editor that will able to spot this kind
> of error, please inform the list.
>
> Ethan
>
Wrong in one sense - all php vars must have a $ sign.  When building a 
query statemtent, if the editor doesn't tell you something (by not 
colorizing it) Sql is going to tell you when you attempt to run it. 
That's why one should ALWAYS include an error check after any operation.

BTW - this line
echo '$sql2<br />';

isn't going to give you what you want.