如何使用PHP在这个“foreach”循环中多次更新我的数据库？

Question

This is in a PHP web page.

I have a link that the user lands on example: www.example.com/update?attend=1&code[]=4321&code[]=5642&code[]=1842 I need it to update: foreach code attend=1.

My code so far:

...database connect information...

$codes = $_GET['code'];
$invitecode = $_GET['invitecode'];
foreach ($codes as $code) {
print $code;
?><br><?php
$sql = "UPDATE guests SET attend='$isattend' WHERE invitecode=$code";
}

...database close and result...

Renders as:

4321
5642
1842
Record updated successfully 

When I check the database only the last value 1842 is set attend=1. Prints correct but updates only one?

Does anyone understand what I am doing wrong here?

Answer 1

You can execute the each sql in foreach but it is better to use IN clause.so you code hit to database only one time.