saya mau update beberapa id, totalnya ada 30. Itu gimana caranya ya ? rencana mau update id berdasarkan setiap provinsi, tapi pas pake ini gak mau.

$servername = "localhost";

$user = "xxxx";

$password = "xxxx";

$dbh = new PDO('mysql:dbname=xxxxx;host=127.0.0.1', $user, $password);



$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);



$stmt   = $dbh->prepare('UPDATE laporan_gini SET id_provinsi="1" WHERE nama_item_vertical_variabel="INDONESIA"');

$stmt   = $dbh->prepare('UPDATE laporan_gini SET id_provinsi="11" WHERE nama_item_vertical_variabel="ACEH"');

$stmt   = $dbh->prepare('UPDATE laporan_gini SET id_provinsi="12" WHERE nama_item_vertical_variabel="SUMATERA UTARA"');

$stmt   = $dbh->prepare('UPDATE laporan_gini SET id_provinsi="13" WHERE nama_item_vertical_variabel="Sumatera Barat"');

$stmt   = $dbh->prepare('UPDATE laporan_gini SET id_provinsi="14" WHERE nama_item_vertical_variabel="RIAU"');

$stmt   = $dbh->prepare('UPDATE laporan_gini SET id_provinsi="15" WHERE nama_item_vertical_variabel="JAMBI"');

$stmt   = $dbh->prepare('UPDATE laporan_gini SET id_provinsi="16" WHERE nama_item_vertical_variabel="SUMATERA SELATAN"');





if ($stmt->execute()) {

 echo "[removed]alert('data telah diupdate');[removed]";

} else {

    echo "[removed]alert('ada masalah.');[removed]";

}