How to update database table using PHP Code? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 8 years ago.

Improve this question

I have this following PHP that it will insert data from excel to database, but it won't update it.

Please guide me how to make it done? that If I change something, then it will update into database table rows too.

foreach($dataArr as $val){
$query = $db->query("INSERT INTO employees SET fname = '" . $db->escape($val['1']) . "', lname = '" . $db->escape($val['2']) . "', email = '" . $db->escape($val['3']) . "', phone = '" . $db->escape($val['4']) . "', company = '" . $db->escape($val['5']) . "'");
}

Thanks in advance

I did, I couldn't make it. I'm new in PHP. I highly appreciate if you help me thanks — Amin
– Amin, Commented Dec 19, 2016 at 9:54
Refer to any tutorial on PHP/MySQL. You currently have an INSERT statement, you're looking for an UPDATE statement. — David
– David, Commented Dec 19, 2016 at 9:55
Possible duplicate of inserting data into mysql database using php — mike510a
– mike510a, Commented Dec 19, 2016 at 10:17

Hassaan · Accepted Answer · 2016-12-19 09:56:24Z

1

Replace

INSERT INTO employees

with

UPDATE employees

Update Syntax

UPDATE [LOW_PRIORITY] [IGNORE] table_references
SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
[WHERE where_condition]

answered Dec 19, 2016 at 9:56

Hassaan

7,7207 gold badges34 silver badges53 bronze badges

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

Comments

Shanu k k · Accepted Answer · 2016-12-19 09:56:41Z

0

Not insert use update

$query = $db->query("Update employees SET fname = '" . $db->escape($val['1']) . "', lname = '" . $db->escape($val['2']) . "', email = '" . $db->escape($val['3']) . "', phone = '" . $db->escape($val['4']) . "', company = '" . $db->escape($val['5']) . "'" [WHERE where_condition]);
}

edited Dec 19, 2016 at 9:56

answered Dec 19, 2016 at 9:55

Shanu k k

1,2853 gold badges22 silver badges46 bronze badges

3 Comments

Amin Over a year ago

I got this error Parse error: syntax error, unexpected 'where' (T_STRING), expecting ',' or ')' for this line: foreach($dataArr as $val){

Shanu k k Over a year ago

u should change [WHERE where_condition] like where id=$id

Shanu k k Over a year ago

do you have id?

Collectives™ on Stack Overflow

How to update database table using PHP Code? [closed]

2 Answers 2

Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Linked

Related