Re: Re: mysql query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Ethan Rosenberg, PhD
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
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 />';
echo "<br />$upc $qnt $mnf $itm $odrpt $opf
$stk<kbr />";
                           if (!$result2)
                                 die('Could not enter data: ' .

The mysql query fails.  I cannot figure out why.  It works from the
command line.



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?


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 -


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.


PHP Database Mailing List (
To unsubscribe, visit:

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux