Update record in SQL through PHP [closed]

Question

how can i update the record from database?

$query = "UPDATE studentinfo SET firstname= '".$student['fname']."' and lastname='".$student['faname']."' and gender = 'Male' WHERE id = '".$student['id']."'";

An UPDATE statement seems like a reasonable way to start. Is something not working? Can you maybe provide some information about the problem? (Also, be aware that this code is wide open to SQL injection attacks.) — David
– David, Commented May 23, 2014 at 12:58
i want to update a student record in db but my query is not working properly. — user2587237
– user2587237, Commented May 23, 2014 at 12:59
@phpisuber01 is trying to demonstrate that this code makes it very easy to delete the complete table, or do other evil things, using SQL injection. See How can I prevent SQL-injection in PHP? for more information. — Nic Wortel
– Nic Wortel, Commented May 23, 2014 at 13:02
Are you paying by the keystroke for your internet? You need to put more effort into your question. — i-CONICA
– i-CONICA, Commented May 23, 2014 at 13:19

Jonathan Leffler · Accepted Answer · 2014-05-24 07:02:19Z

2

UPDATE table SET column1 = 'value1', column2 = 'value2'

Do not use AND to separate terms in the SET clause.

edited May 24, 2014 at 7:02

Jonathan Leffler

759k145 gold badges961 silver badges1.3k bronze badges

answered May 23, 2014 at 12:58

turson

4212 silver badges9 bronze badges

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

Comments

ksealey · Accepted Answer · 2014-05-23 13:00:15Z

1

$query = "UPDATE studentinfo SET firstname= '".$student['fname']."', lastname='".$student['faname']."', gender = 'Male' WHERE id = '".$student['id']."'";

answered May 23, 2014 at 13:00

ksealey

1,7381 gold badge17 silver badges16 bronze badges

2 Comments

user2587237 Over a year ago

i want to get id from auto increament.but not geting through $_get method

Jonast92 Over a year ago

That's a matter for another question, feel free to make it and link to it, but ONLY if you make the question become better than this one. Read about how to post questions on stackoverflow, please.

Jonast92 · Accepted Answer · 2014-05-23 13:07:45Z

AND is used in SQL for multiple-conditions.

To update multiple fields just separate them with a comma:

$query ="UPDATE studentinfo SET firstname = '$student['fname']', lastname = '$student['faname']', gender = 'Male' WHERE id = '$student['id']'";

Collectives™ on Stack Overflow

Update record in SQL through PHP [closed]

3 Answers 3

Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Linked

Related