Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // query database
- var mysql = require('mysql');
- // Membuat koneksi ke database MySQL
- var koneksi = mysql.createConnection({host: 'localhost', database: 'latihan', user: 'root', password: ''});
- koneksi.connect(function(error) {
- if (error) {
- console.error('gagal tersambung: ' + error.stack);
- return;
- }
- koneksi.query ('SELECT * FROM pegawai', function (error, rows, field) {
- if (!error)
- console.log(JSON.stringify(rows))
- else
- console.log('Terjadi error: ', error.stack)
- // konversi hasil query ke bentuk JSON
- // console.log(JSON.stringify(rows))
- return;
- })
- koneksi.end(function(error) {
- if(error){
- console.error('gagal memutus koneksi: ' + error.stack)
- }
- })
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement