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
erosenberg@xxxxxxxxxxxxxxxxxxxx
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
