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 | - | $sql="INSERT INTO 'tb_login' ('username', 'password', 'nama_lengkap') VALUES (?, ?, ?)";
|
| 13 | + | $sql="INSERT INTO `tb_login` (`username`, `password`, `nama_lengkap`) VALUES (?, ?, ?)"; |
| 14 | ||
| 15 | $insert = $koneksi->prepare($sql); | |
| 16 | if(!$insert){
| |
| 17 | - | echo "Prepare failed: (" . $mysqli->errno . ") " . $mysqli->error;
|
| 17 | + | echo "Prepare failed: (" . $koneksi->errno . ") " . $koneksi->error;
|
| 18 | ||
| 19 | }else{
| |
| 20 | $insert->bind_param("sss", $username, $password, $nama_lengkap);
| |
| 21 | if($insert->execute()) | |
| 22 | {
| |
| 23 | echo "Tersimpan"; | |
| 24 | } | |
| 25 | else | |
| 26 | {
| |
| 27 | echo "GAGAL INSERT"; | |
| 28 | } | |
| 29 | } | |
| 30 | ?> |
