Update Query issue in php

Question

This is my table 'tbl_size'

**Col Name**        **Data Type**   
size_id            int(11)  
pd_id              int(11)  
size_name          varchar(20)  
size_chart         int(6)   
qty                text

Now I'm trying to update this table with following query

$query="update tbl_size set `qty`='10' where `size_id`=335";

When i run this query in mysql, it works fine but when same thing i tries to do from php then it is updating qty to '0' and not to '10'. I'm not getting why this is happening. Please help me to solve this problem.

New Updated Code :

// $rowvo['od_qty']=10;

// $row_1['qty']=20;

$sql = "SELECT qty  FROM tbl_size WHERE size_id =".$rowvo['size_id'];

$result = dbQuery($sql);

$row_1    = dbFetchAssoc($result);

$pqty=$row_1['qty']-$rowvo['od_qty'];

echo "Total Quantity Available Before Diduction : ".$row_1['qty'];

echo "Sold Quantity : ".$rowvo['od_qty'];

echo "Remaining Quantity : $pqty";

$sql_qty="update tbl_size set `qty`=$pqty where `size_id`=".$rowvo['size_id'];

echo "$sql_qty<br>";

$result_qty=mysql_query($sql_qty) or die('Error : '.mysql_error());

echo "No of Rows Affected : ".mysql_affected_rows()."<br>".mysql_error(); // 1

New Code with PDO :

try {
$b=$a->prepare("update tbl_size set `qty`=:qty where `size_id`=:size");
$b->bindValue(":size",$size_id);
$b->bindValue(":qty",$pqty);
$b->execute();

 } catch(PDOException $ex) {
echo "An Error occured!"; //user friendly message

}

and var_dump($ex)=NULL

Something is going wrong in your PHP code. Most likely due to code injection (I'm guessing). Can we see your actual PHP code where you make the call to the DB? — h2ooooooo
– h2ooooooo, Commented Oct 8, 2013 at 8:05
If the problem is happening with your PHP, then why aren't you showing us your PHP? — Mark Baker
– Mark Baker, Commented Oct 8, 2013 at 8:05
It's most likely because you're injecting variables. This is why you should bind variables. Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial. — h2ooooooo
– h2ooooooo, Commented Oct 8, 2013 at 8:17

Dinesh · Accepted Answer · 2013-10-08 08:24:05Z

2

Check the structure of your table you have text type for qty. It's possible that it is not of type char or varchar (or that it is and has a default value set to '0'). To resolve this you can use phpmyadmin, SQLyog or other MySql admin programs.

change your query

$sql_qty="update tbl_size set `qty`=$pqty where `size_id`=".$rowvo['size_id'];

to

$sql_qty="update tbl_size set `qty`='$pqty' where `size_id`='".$rowvo['size_id']."'";

edited Oct 8, 2013 at 8:24

answered Oct 8, 2013 at 8:09

Dinesh

4,1145 gold badges24 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pankaj Over a year ago

I have updated my code now I have changed data type of my 'qty' col to 'int' from 'text', still i getting same problem.

Mandip Darji · Accepted Answer · 2013-10-08 08:34:50Z

1

Your Code       ==> `qty`= $pqty

Changes to this ==> `qty`='$pqty'

answered Oct 8, 2013 at 8:34

Mandip Darji

7654 silver badges12 bronze badges

2 Comments

Pankaj Over a year ago

now i have changed data type of 'qty' to int that's why qty= $pqty

Mandip Darji Over a year ago

sitll it's not working ? use below query $sql_qty="update tbl_size set qty= '$pqty' where size_id=".$rowvo['size_id'];

jonayreyes · Accepted Answer · 2013-10-08 08:17:29Z

0

try this:

$query="update tbl_size set qty=10 where size_id=335";

answered Oct 8, 2013 at 8:17

jonayreyes

5781 gold badge10 silver badges29 bronze badges

1 Comment

Mandip Darji Over a year ago

qty is text value field type so enter like this way '10'

Collectives™ on Stack Overflow

Update Query issue in php

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related