使用PHP无法在MySQL中插入数据连连接成功

Question

---

Hello everyone, I still new in php and now get problem with my code the problem is it cannot save my insert-data into mysql even my connection is success, I don't why and what is wrong with that code, need your advice. Thanks

<?php
$sql_insert= "INSERT INTO pegawai (id_pegawai, nip, nm_pegawai, ttl_pegawai, gender_pegawai, agama_pegawai, alamat_pegawai, tgl_masuk, jenis_pekerjaan, status_pegawai, pangkat_pns, ijazah_terakhir,thn_lulus) VALUES ('$id_pegawai','$nip','$nm_pegawai','$new_ttl','$gender','$agama', $alamat','$masuk','$jenis_pekerjaan','$stts','$pangkat','$ijazah','$jurusan','$thn')";
mysql_query($kon, $sql_insert);
?>

Answer 1

As miker32 explained mysql_query has deprecated you can use mysqli_query instead and we are using prepare bind_baram so it's a little bit safer:

$kon= mysqli_connect("localhost","your_username","your_password","your_dbname");

if (!$kon) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql_insert= mysqli_prepare("INSERT INTO pegawai (id_pegawai, nip, nm_pegawai, ttl_pegawai, gender_pegawai, agama_pegawai, alamat_pegawai, tgl_masuk, jenis_pekerjaan, status_pegawai, pangkat_pns, ijazah_terakhir,thn_lulus) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)");

mysqli_stmt_bind_param($sql_insert, 'issssssssssss', $id_pegawai,$nip,$nm_pegawai,$new_ttl,$gender,$agama, $alamat,$masuk,$jenis_pekerjaan,$stts,$pangkat,$ijazah,$jurusan,$thn);

mysqli_query($kon,$sql_insert);