Updating SQL using PHP - Error

Question

Right so i have php code to update a SQL table. If i replace $_GET['emailID'] with a number say 1 the database IS updated. But otherwise no update. What seems to be wrong here

Table: emails

Fields: mailbox, emailID

$query = 'UPDATE `emails` SET `mailbox`=\'trash\' WHERE `emailID`='.(int)$_GET['emailID'];

Do you get any errors from mysql? Can you print $query before you execute it? — user4035
– user4035, Commented Nov 25, 2013 at 10:07
@Veerendra yes the data type is int in the table. But the transformation (int) is giving out as 0 if i print $query — stud91
– stud91, Commented Nov 25, 2013 at 10:51

Shankar Narayana Damodaran · Accepted Answer · 2013-11-25 10:01:32Z

1

Do like this

$query = "UPDATE `emails` SET `mailbox`='trash' WHERE `emailID`=".intval($_GET['emailID']);

answered Nov 25, 2013 at 10:01

Shankar Narayana Damodaran

68.6k43 gold badges102 silver badges129 bronze badges

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

6 Comments

user4035 Over a year ago

I am not sure. Doesn't (int) $var convert $var to int? php.net/language.types.type-juggling#language.types.typecasting

Shankar Narayana Damodaran Over a year ago

@user4035, Yeah it does. echo (int)$str='23test'; gives you 23.

user4035 Over a year ago

@ShankarDamodaran So, his code must give the same result as yours. Frankly, I don't see any errors in this query except for missing parameter escaping. Maybe, the error is somewhere else?

Shankar Narayana Damodaran Over a year ago

@user4035, Right. @Haroon, What does this query give you on SQL , UPDATE emails SET mailbox='trash' WHERE emailID=1 ?

stud91 Over a year ago

So my code now is $query = "UPDATE emails SET mailbox=\'trash\' WHERE emailID=".intval($_GET['emailID']); print $query; print "<b>".$_GET['emailID']."</b>"; Output: UPDATE emails SET mailbox='trash' WHERE emailID=0'1'

|

Krish R · Accepted Answer · 2013-11-25 10:05:25Z

1

Can you try this,

 $query = 'UPDATE `emails` SET `mailbox`=\'trash\' WHERE `emailID`="'.(int)$_GET['emailID'].'" ';

answered Nov 25, 2013 at 10:05

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

3 Comments

stud91 Over a year ago

print $query; print $_GET['emailID']; gives me ==> UPDATE emails SET mailbox='inbox' WHERE emailID="0"'2'

Krish R Over a year ago

What is your Email id value ?

Krish R Over a year ago

Can you post your complete url with query string?

plusodinminus · Accepted Answer · 2013-11-25 10:16:39Z

0

Value of attribut must be selected by single quotes. Try this:

$query = "UPDATE `emails` SET `mailbox` = 'trash' WHERE `emailID` = '" . intval($_GET['emailID']) . "'";

answered Nov 25, 2013 at 10:16

plusodinminus

11 bronze badge

Comments

Bhaskar Bhatt · Accepted Answer · 2013-11-25 10:21:21Z

0

$query = "UPDATE `emails` SET `mailbox`='trash' WHERE `emailID`= ".$_GET['emailID'];

Try this one sure it will work

answered Nov 25, 2013 at 10:21

Bhaskar Bhatt

1,48113 silver badges19 bronze badges

Collectives™ on Stack Overflow

Updating SQL using PHP - Error

4 Answers 4

6 Comments

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related