Insert query error in mysql using php

Question

sql="insert into gd_stock(Stock_Purchase) values("$a['Quantity']") where Product_Model="$a['Model_No']"";

Here is shows the error :Parse error: syntax error, unexpected '='!

Sorry I got my solution my mistake was I was using where clause with insert query! — Mihir, Dec 20 '16 at 11:14

score 3 · Accepted Answer · answered Dec 19 '16 at 06:03

3

Insert statements doesn't use a where clause except you want to insert into from another table conditionally which will first of all select from the table before inserting if not so your sql should be like this

  sql="insert into gd_stock(Stock_Purchase) values('". 
          $a['Quantity']. "')";

answered Dec 19 '16 at 06:03

Ghost Worker

635
5
16

1

It is strange that he's using a WHERE clause. Also note that `sql=` should probably be `$sql=` – Dec 19 '16 at 06:06
I got my mistake thanks for help! – Mihir Dec 20 '16 at 11:14

score 2 · Answer 2 · answered Dec 19 '16 at 06:02

2

$sql="insert into gd_stock(Stock_Purchase) values("$a['Quantity']") where 
 Product_Model=".$a['Model_No'];
if (!mysqli_query($con, $sql))
{
    echo("Error description: " . mysqli_error($con));
}

answered Dec 19 '16 at 06:02

Awais Mustafa

171
2
9

This will not get pass the if block because I doubt if the query will ever execute – Ghost Worker Dec 19 '16 at 06:10

Fu Xu · Answer 3 · 2016-12-19T05:56:30.800

0

sql="insert into gd_stock(Stock_Purchase) values('{$a['Quantity']}') where Product_Model='{$a['Model_No']}'";

you have a syntax error while you link your query strings. the double quota ends the string
suggest you use {} to warp your variables in string

edited Dec 19 '16 at 05:56

answered Dec 19 '16 at 05:52

Fu Xu

736
2
6
20

still shows same error – Mihir Dec 19 '16 at 05:54
the answer edited @Mihir – Fu Xu Dec 19 '16 at 05:57

Mr. Bhosale · Answer 4 · 2016-12-19T06:01:45.330

0

USE $ symbol to define $sql.

  $sql="insert into gd_stock(Stock_Purchase) values('{$a['Quantity']}') where 
 Product_Model='{$a['Model_No']}'";;

edited Dec 19 '16 at 06:01

answered Dec 19 '16 at 05:55

Mr. Bhosale

2,763
1
16
33

Parse error: syntax error, unexpected '$a' (T_VARIABLE) Now it shows this error! – Mihir Dec 19 '16 at 05:57
@Mihir check update code. – Mr. Bhosale Dec 19 '16 at 06:02

score 0 · Answer 5 · answered Dec 19 '16 at 06:01

0

Try this

$sql="insert into gd_stock(Stock_Purchase) values(". $a['Quantity']. ") where Product_Model=".     $a['Model_No']. "";

You did not concatenate (join) the string with the variable

answered Dec 19 '16 at 06:01

smartnet

87
4

score 0 · Answer 6 · answered Dec 19 '16 at 06:11

0

$dbconn - for your Mysql Database Connection

$insertsql="insert into gd_stock(Stock_Purchase) values("$a['Quantity']") where Product_Model=".$a['Model_No'];
if (!mysql_query($dbconn, $insertsql))
{
    echo("Error Details: " . mysql_error($con));
}

answered Dec 19 '16 at 06:11

Karthik

5,121
14
43
69

aconnelly · Answer 7 · 2016-12-19T05:56:41.583

-1

You need to escape your inner quotation marks.

try this:

$sql="insert into gd_stock(Stock_Purchase) values("$a['Quantity']") where Product_Model=\""$a['Model_No']"\"";

edited Dec 19 '16 at 05:56

answered Dec 19 '16 at 05:52

aconnelly

640
1
6
12

still shows the same error – Mihir Dec 19 '16 at 05:55

Insert query error in mysql using php

7 Answers7