Re: [PHP-DB] Re: mysql query

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