## Tutorial Menghubungkan Database ke Website dengan PHP dan MySQL
### 1. Struktur Proyek
Susun folder proyek seperti ini:
```
/proyek-website
�-- /css
�-- /js
�-- /images
�-- [Link]
�-- [Link]
�-- [Link]
�-- [Link]
```
### 2. Membuat Database MySQL
Gunakan **phpMyAdmin** atau jalankan SQL ini di MySQL:
```sql
CREATE DATABASE website_db;
USE website_db;
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
email VARCHAR(100) NOT NULL,
password VARCHAR(255) NOT NULL
);
```
### 3. Konfigurasi Koneksi Database ([Link])
Buat file **[Link]** untuk koneksi PHP ke database:
```php
<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "website_db";
$conn = mysqli_connect($host, $user, $password, $database);
if (!$conn) {
die("Koneksi gagal: " . mysqli_connect_error());
}
?>
```
### 4. Membuat Form HTML ([Link])
Tambahkan formulir pendaftaran:
```html
<!DOCTYPE html>
<html lang="id">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Form Registrasi</title>
<link rel="stylesheet" href="css/[Link]">
</head>
<body>
<h2>Registrasi</h2>
<form action="[Link]" method="POST">
<input type="text" name="username" placeholder="Username" required><br>
<input type="email" name="email" placeholder="Email" required><br>
<input type="password" name="password" placeholder="Password" required><br>
<button type="submit">Daftar</button>
</form>
</body>
</html>
```
### 5. Memproses Data dengan PHP ([Link])
Tangkap data dari formulir dan simpan ke database:
```php
<?php
include '[Link]';
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$username = $_POST["username"];
$email = $_POST["email"];
$password = password_hash($_POST["password"], PASSWORD_DEFAULT); // Hashing
password
$sql = "INSERT INTO users (username, email, password) VALUES ('$username',
'$email', '$password')";
if (mysqli_query($conn, $sql)) {
echo "Registrasi berhasil!";
} else {
echo "Error: " . mysqli_error($conn);
}
}
?>
```
### 6. Menampilkan Data User
Buat halaman untuk menampilkan daftar user:
```php
<?php
include '[Link]';
$result = mysqli_query($conn, "SELECT * FROM users");
?>
<!DOCTYPE html>
<html>
<head>
<title>Data User</title>
</head>
<body>
<h2>Daftar Pengguna</h2>
<table border="1">
<tr>
<th>ID</th>
<th>Username</th>
<th>Email</th>
</tr>
<?php while ($row = mysqli_fetch_assoc($result)) { ?>
<tr>
<td><?php echo $row["id"]; ?></td>
<td><?php echo $row["username"]; ?></td>
<td><?php echo $row["email"]; ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
```
### 7. Menggunakan JavaScript untuk Fetch Data Tanpa Reload
#### Update [Link]:
```html
<button onclick="loadData()">Tampilkan Data</button>
<div id="data"></div>
<script>
function loadData() {
fetch('get_users.php')
.then(response => [Link]())
.then(data => [Link]("data").innerHTML = data);
}
</script>
```
#### Buat file get_users.php:
```php
<?php
include '[Link]';
$result = mysqli_query($conn, "SELECT * FROM users");
while ($row = mysqli_fetch_assoc($result)) {
echo "<p>Username: " . $row['username'] . " | Email: " . $row['email'] .
"</p>";
}
?>
```
Dengan langkah-langkah ini, website kamu bisa terhubung dengan database menggunakan
**PHP & MySQL**. Jika ada pertanyaan atau ingin fitur tambahan, tinggal
tanyakan! ??