23 lines
618 B
PHP
23 lines
618 B
PHP
<?php
|
|
include "inc/koneksi.php";
|
|
|
|
$queries = [
|
|
"ALTER TABLE tb_kk MODIFY desa VARCHAR(100)",
|
|
"ALTER TABLE tb_kk MODIFY kec VARCHAR(100)",
|
|
"ALTER TABLE tb_kk MODIFY kab VARCHAR(100)",
|
|
"ALTER TABLE tb_kk MODIFY prov VARCHAR(100)",
|
|
"ALTER TABLE tb_kk MODIFY kepala VARCHAR(100)",
|
|
"ALTER TABLE tb_kk MODIFY no_kk VARCHAR(50)"
|
|
];
|
|
|
|
foreach ($queries as $sql) {
|
|
if ($koneksi->query($sql) === TRUE) {
|
|
echo "Success: $sql<br>";
|
|
} else {
|
|
echo "Error: " . $koneksi->error . "<br>";
|
|
}
|
|
}
|
|
|
|
$koneksi->close();
|
|
?>
|