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