Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // koneksi ke database
- $mysqli = new mysqli('localhost', 'root', '', 'db_test');
- // SELECT
- $res = $mysqli->query("SELECT nama,ttl,gender,alamat,telp from tbl_data where iddata='3107'") or die($mysqli->error);
- $data = $res->feth_array(MYSQLI_ASSOC); // atau $data = $res->feth_array();
- echo "Hallo, nama saya ",$data['nama'];
- // UPDATE
- $update = $mysqli->query("UPDATE tbl_data set nama='Ari Julianto', ttl='1988-07-31' where iddata='3107'") or die($mysqli->error);
- if($update) echo 'Data berhasil diupbah...';
- // DELETE
- $delete= $mysqli->query("DELETE tbl_data where iddata='3107'") or die($mysqli->error);
- if($delete) echo 'Data berhasil dihapus...';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement