Postingan lainnya
bagaimana cara mengetauhi eror di sqli_query
bagaimana cara mengetauhi eror di sqli_query(INSERT INTO) mohon bantuan nya ^_^
2 Jawaban:
coba pakai kek gini mas
<pre> if (!$query) { printf("Error: %s\n", mysqli_error($conn)); exit(); } </pre> code di atas ditulis dibawah mysqli_query() misalnya <pre> $query = mysqli_query($conn,"INSERT INTO mahasiswa(nama,alamat,telepon) VALUES ('$nama','$alamat','$telepon')"; if (!$query) { printf("Error: %s\n", mysqli_error($conn)); exit(); } </pre>
<pre>
<?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "user";
// Buat koneksi $conn = new mysqli($servername, $username, $password, $dbname); // Cek koneksi if ($conn->connect_error) { die("Koneksi gagal: " . $conn->connect_error); }
$sql = "INSERT INTO users (nama, email, password) VALUES ('Baco', 'baco@domain.com', '123')";
if ($conn->query($sql) === TRUE) { echo "Insert sukses"; } else { echo "ada error : " . $conn->error; }
</pre>