Advertisement
arijulianto

Dasar Penggunaan mysqli

May 20th, 2014
349
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.65 KB | None | 0 0
  1. // koneksi ke database
  2. $mysqli = new mysqli('localhost', 'root', '', 'db_test');
  3.  
  4. // SELECT
  5. $res = $mysqli->query("SELECT nama,ttl,gender,alamat,telp from tbl_data where iddata='3107'") or die($mysqli->error);
  6. $data = $res->feth_array(MYSQLI_ASSOC); // atau $data = $res->feth_array();
  7. echo "Hallo, nama saya ",$data['nama'];
  8.  
  9. // UPDATE
  10. $update = $mysqli->query("UPDATE tbl_data set nama='Ari Julianto', ttl='1988-07-31' where iddata='3107'") or die($mysqli->error);
  11. if($update) echo 'Data berhasil diupbah...';
  12.  
  13. // DELETE
  14. $delete= $mysqli->query("DELETE tbl_data where iddata='3107'") or die($mysqli->error);
  15. if($delete) echo 'Data berhasil dihapus...';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement