32 lines
518 B
PHP
32 lines
518 B
PHP
<?php
|
|
|
|
include 'koneksi.php';
|
|
|
|
$queries = [
|
|
|
|
"ALTER TABLE jalan
|
|
MODIFY COLUMN id INT NOT NULL AUTO_INCREMENT,
|
|
ADD PRIMARY KEY (id)",
|
|
|
|
"ALTER TABLE parsil
|
|
MODIFY COLUMN id INT NOT NULL AUTO_INCREMENT,
|
|
ADD PRIMARY KEY (id)",
|
|
|
|
"ALTER TABLE spbu
|
|
MODIFY COLUMN id INT NOT NULL AUTO_INCREMENT,
|
|
ADD PRIMARY KEY (id)"
|
|
|
|
];
|
|
|
|
echo "<h2>Hasil Perbaikan</h2>";
|
|
|
|
foreach ($queries as $sql) {
|
|
|
|
if(mysqli_query($conn,$sql)){
|
|
echo "✅ Berhasil<br>";
|
|
} else {
|
|
echo "❌ ".mysqli_error($conn)."<br>";
|
|
}
|
|
|
|
}
|
|
?>
|