Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var mysql = require('mysql');
- var connection = mysql.createConnection({
- host: 'localhost',
- user: 'root',
- password: 'kucing',
- database: 'latihan'
- })
- connection.connect(function(err) {
- if (err) throw err
- console.log('Anda sedang terhubung ...')
- //connection.query('INSERT INTO pelanggan(idpelanggan,namaawal,namaakhir,alamat,negara,kodepos,email,telepon,kota,tambahmailinglist,catatanpelanggan) VALUES (?,?,?,?,?,?,?,?,?,?,?)',['P0002','jhon', 'kenedy', 'batu ampar rt 20 no 2', 'indonesia', '76111', 'jhon@bpp.com', '054271134', 'balikpapan', 'tidak', 'pelanggan baru'], function(err, result) {
- //if(err) throw err
- connection.query('SELECT * FROM pelanggan', function(err, results) {
- if(err) throw err
- console.log(results[0].idpelanggan)
- console.log(results[0].namaawal)
- console.log(results[0].namaakhir)
- console.log(results[1].idpelanggan)
- console.log(results[1].namaawal)
- console.log(results[1].namaakhir)
- connection.end();
- // })
- })
- });
- // connection.end();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement