View difference between Paste ID: zaWhZB9R and H2EbwAvL
SHOW: | | - or go back to the newest paste.
1
<?php
2
$koneksi = new mysqli("localhost", "root", "", "db_oop");
3
//Jika Koneksi Gagal
4
if(mysqli_connect_errno())
5
{
6
    trigger_error("Tidak Dapat Terkoneksi Dengan Database");
7
}
8
$koneksi->set_charset('UTF-8');
9
$username = $_POST['username'];
10
$password = $_POST['password'];
11
$nama_lengkap = $_POST['nama_lengkap'];
12
13-
$insert = $koneksi->prepare("INSERT INTO 'tb_login' ('username', 'password', 'nama_lengkap') VALUES (?, ?, ?");
13+
$sql="INSERT INTO 'tb_login' ('username', 'password', 'nama_lengkap') VALUES (?, ?, ?)";
14-
$insert->bind_param("sss", $username, $password, $nama_lengkap);
14+
15-
if($insert->execute())
15+
$insert = $koneksi->prepare($sql);
16
if(!$insert){
17-
    echo "Tersimpan";
17+
	echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
18
19-
else
19+
}else{
20
	$insert->bind_param("sss", $username, $password, $nama_lengkap);
21-
    echo "GAGAL INSERT";
21+
	if($insert->execute())	
22
	{
23
    		echo "Tersimpan";
24
	}
25
	else
26
	{
27
    		echo "GAGAL INSERT";
28
	}
29
}
30
?>