connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "CREATE DATABASE IF NOT EXISTS $db_name";
if ($conn->query($sql) === TRUE) {
$conn->select_db($db_name);
$sql = "CREATE TABLE IF NOT EXISTS users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
password VARCHAR(255) NOT NULL
)";
if ($conn->query($sql) === TRUE) {
$sql = "INSERT INTO users (username, password) VALUES ('$admin_user', '$admin_pass')";
if ($conn->query($sql) === TRUE) {
$sql = "CREATE TABLE IF NOT EXISTS posts (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
slug VARCHAR(255) NOT NULL UNIQUE,
content TEXT NOT NULL,
featured_image VARCHAR(255),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)";
if ($conn->query($sql) === TRUE) {
$sql = "CREATE TABLE IF NOT EXISTS settings (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
value TEXT NOT NULL
)";
if ($conn->query($sql) === TRUE) {
// Tambahkan data awal ke tabel settings
$conn->query("INSERT INTO settings (name, value) VALUES ('site_name', 'My CMS')");
$conn->query("INSERT INTO settings (name, value) VALUES ('footer_text', 'Footer text')");
$conn->query("INSERT INTO settings (name, value) VALUES ('logo', '')");
$conn->query("INSERT INTO settings (name, value) VALUES ('copyright_text', '© 2024')");
$conn->query("INSERT INTO settings (name, value) VALUES ('favicon', '')");
$config_content = "error;
}
} else {
echo "Error creating posts table: " . $conn->error;
}
} else {
echo "Error creating admin user: " . $conn->error;
}
} else {
echo "Error creating table: " . $conn->error;
}
} else {
echo "Error creating database: " . $conn->error;
}
$conn->close();
}
?>
Install CMS