Database Dasar

Koneksi MySQL

<?php
// MySQLi Procedural
$conn = mysqli_connect("localhost", "root", "", "database_name");

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>

Query SELECT

<?php
$sql = "SELECT * FROM users";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    while($row = mysqli_fetch_assoc($result)) {
        echo $row["id"] . " - " . $row["nama"] . "\n";
    }
} else {
    echo "0 results";
}
?>

Query INSERT

<?php
$nama = "Budi";
$email = "budi@email.com";

$sql = "INSERT INTO users (nama, email) VALUES ('$nama', '$email')";

if (mysqli_query($conn, $sql)) {
    echo "Data inserted successfully";
} else {
    echo "Error: " . $sql . "
" . mysqli_error($conn);
}
?>

Prepared Statement (Aman)

<?php
$stmt = $conn->prepare("INSERT INTO users (nama, email) VALUES (?, ?)");
$stmt->bind_param("ss", $nama, $email);

$nama = "Ani";
$email = "ani@email.com";

if ($stmt->execute()) {
    echo "Data inserted successfully";
} else {
    echo "Error: " . $stmt->error;
}
?>