MiKo PiKKo

<?php
header("Content-Type:text/plain");
$sql_server = "localhost:7272";  // Hostname
$sql_username = "root";          // MySQL username
$sql_password = "MiKoPiKKo";     // MySQL Password
$sql_database = "DaTaBaSeBaRu";     // MySQL Password

// Membuat Koneksi Ke MySQL
$conn = mysqli_connect($sql_server, $sql_username, $sql_password, $sql_database);

// Cek Koneksi MySQL
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

// Data yang akan masukkan
$id = 'dataID'; // unique ID
$nama = 'dataNama';
$jenis = 'dataJenis';


// Mengambil data dari Tabel `DaTa`
$sql = "SELECT * FROM DaTa where id = '".$id."'";
$res = mysqli_query($conn, $sql);
// Cek jika data sudah ada
if (mysqli_num_rows($res) > 0) {
    echo "Data dengan ID ".$id." sudah ada";
} else {

// Memsukkan data ke tabel `DaTa`
$sqlInsert = "INSERT INTO DaTa (id, nama, jenis)
VALUES ('".$id."', '".$nama."', '".$jenis."')";
// Cek data
if (mysqli_query($conn, $sqlInsert)) {
    echo "Data berhasil disimpan";
} else {
    echo "Error: " . $sql . "\n" . mysqli_error($conn);
}


}

mysqli_close($conn);
?>