$sql2 = "insert into Inventory (UPC, quant, manuf, item, orderpt,
ordrpt_flag, stock) values ('$upc', '$qnt','$mnf','$itm', '$odrpt', 0,
$stk)";
Looks like, you have the ' ' missing for $qnt and odrpt had the $ and the
'' missing.
The above query should work, I haven't tested it though.
Also for no error, have you turned off the PHP error reporting?
It probably is working on the command line, since you posted actual values
there and in the PHP code, you are using the variables which I think were
not wrapped in the query correctly?
On Thu, Aug 22, 2013 at 12:51 PM, Michael Oki <mikeoki.oki@xxxxxxxxx> wrote:
> Try the insertion like this:
> $sql2 = mysql_query("insert into Inventory (`UPC`
> , `quant`, `manuf`, `item`, `orderpt`, `ordrpt_flag`, `stock`)"
> ."values ('$upc', $qnt,'$mnf','$itm',
> '$odrpt', '0', '$stk') " ) or die(mysql_error());
>
> On 22 August 2013 05:10, Daniel Krook <krook@xxxxxxxxxx> wrote:
>
> > Ethan,
> >
> > What about:
> >
> > $result2 = mysqli_query(cxn, $sql2);
> >
> > Doesn't look like you're sending it a connection link as a variable
> ($cxn)
> > and that's passed through as a literal?
> >
> >
> >
> >
> > Thanks,
> >
> >
> > Daniel Krook
> > Software Engineer, Advanced Cloud Solutions, GTS
> >
> > IBM Senior Certified IT Specialist - L3 Thought Leader
> > The Open Group Certified IT Specialist - L3 Distinguished
> > Cloud, Java, PHP, BlackBerry, DB2 & Solaris Certified
> >
> >
> >
> >
> >
> >
> > Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx> wrote on 08/21/2013
> > 11:59:19 PM:
> >
> > > From: Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx>
> > > To: Daniel Krook/White Plains/IBM@IBMUS
> > > Cc: PHP Database List <php-db@xxxxxxxxxxxxx>
> > > Date: 08/21/2013 11:59 PM
> > > Subject: Re: mysql query
> > >
> > > On 08/21/2013 11:30 PM, Daniel Krook wrote:
> > > Ethan,
> > >
> > > It's hard to tell from the code formatting in your email what the
> > > exact problem might be, but a few reasons that this might fail in
> > > PHP rather than when sent to MySQL with hardcoded values:
> > >
> > > 1. var_dump/print_r $_POST to see what you're getting as input is
> > > what you expect (and sanitize!).
> > >
> > > 2. Check that the SQL statement concatenation in PHP is building
> > > the string you're expecting. It looks like you're joining 2 strings
> > > when defining $sql2 that doesn't leave a space between the close
> > > parentheses and "values." Compare this against what you're sending
> > > "on the command line."
> > >
> > > 3. Get rid of all single quotes... escape your double quotes where
> > > needed. This will avoid any variable-in-string interpolation errors
> > > and may help you find the issue with input data. Same with your echo
> > > $sql2 statement... that's not going to give you the same thing as
> > > the print_r below it.
> > >
> > >
> > >
> > > Thanks,
> > >
> > >
> > > Daniel Krook
> > > Software Engineer, Advanced Cloud Solutions, GTS
> > >
> > > IBM Senior Certified IT Specialist - L3 Thought Leader
> > > The Open Group Certified IT Specialist - L3 Distinguished
> > > Cloud, Java, PHP, BlackBerry, DB2 & Solaris Certified
> > >
> > >
> > >
> > >
> > > Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx> wrote on 08/21/
> > > 2013 07:48:12 PM:
> > >
> > > > From: Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx>
> > > > To: PHP Database List <php-db@xxxxxxxxxxxxx>
> > > > Date: 08/21/2013 07:48 PM
> > > > Subject: mysql query
> > > >
> > > > 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
> > > >
> > > Daniel -
> > >
> > > Thanks.
> > >
> > > Tried all your suggestions.
> > >
> > > Sorry, no luck.
> > >
> > > Ethan
>
