- Beranda
- Komunitas
- Tech
- Programmer Forum
[Share] Source Code CRUD Node.js & MySQL
![badycool2](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
TS
badycool2
[Share] Source Code CRUD Node.js & MySQL
Meski peminat Node.js di kaskus nampaknya Sepi
....gpp lah siapa tahu ada yg minat. ini adalah contoh simple CRUD Node.js n MySQL. meski kebanyakan developer lbh suka Node.js n Mongoose, ane coba pake MySQL aja. ![Hammer emoticon-Hammer](https://s.kaskus.id/images/smilies/sumbangan/8.gif)
DEMO
sebelumnya ini environment ane :
1. Ubuntu
2. NPM, Express
3. MySQL for Node
beberapa penampakan hasil nya (awas bwk)
Potongan code utama CRUD nya
Source code nya bisa agan download di Github nodecrud.
Maaf krena kepanjangan ane gbsa pajang disini smw tutorial nya![Hammer emoticon-Hammer](https://s.kaskus.id/images/smilies/sumbangan/8.gif)
Tutorial lebih lengkapnya + installasi
![Ngakak emoticon-Ngakak](https://s.kaskus.id/images/smilies/smilies_fb5ohtyfyn16.gif)
![Hammer emoticon-Hammer](https://s.kaskus.id/images/smilies/sumbangan/8.gif)
DEMO
sebelumnya ini environment ane :
1. Ubuntu
2. NPM, Express
3. MySQL for Node
beberapa penampakan hasil nya (awas bwk)
Spoiler for list:
Spoiler for dscsdc:
Potongan code utama CRUD nya
PHP Code:
/*
* GET customers listing.
*/
exports.list = function(req, res){
req.getConnection(function(err,connection){
connection.query('SELECT * FROM customer',function(err,rows) {
if(err)
console.log("Error Selecting : %s ",err );
res.render('customers',{page_title:"Customers - Node.js",data:rows});
});
});
};
exports.add = function(req, res){
res.render('add_customer',{page_title:"Add Customers-Node.js"});
};
exports.edit = function(req, res){
var id = req.params.id;
req.getConnection(function(err,connection){
connection.query('SELECT * FROM customer WHERE id = ?',[id],function(err,rows)
{
if(err)
console.log("Error Selecting : %s ",err );
res.render('edit_customer',{page_title:"Edit Customers - Node.js",data:rows});
});
});
};
/*Save the customer*/
exports.save = function(req,res){
var input = JSON.parse(JSON.stringify(req.body));
req.getConnection(function (err, connection) {
var data = {
name : input.name,
address : input.address,
email : input.email,
phone : input.phone
};
var query = connection.query("INSERT INTO customer set ? ",data, function(err, rows)
{
if (err)
console.log("Error inserting : %s ",err );
res.redirect('/customers');
});
// console.log(query.sql); get raw query
});
};
exports.save_edit = function(req,res){
var input = JSON.parse(JSON.stringify(req.body));
var id = req.params.id;
req.getConnection(function (err, connection) {
var data = {
name : input.name,
address : input.address,
email : input.email,
phone : input.phone
};
connection.query("UPDATE customer set ? WHERE id = ? ",[data,id], function(err, rows)
{
if (err)
console.log("Error Updating : %s ",err );
res.redirect('/customers');
});
});
};
exports.delete_customer = function(req,res){
var id = req.params.id;
req.getConnection(function (err, connection) {
connection.query("DELETE FROM customer WHERE id = ? ",[id], function(err, rows)
{
if(err)
console.log("Error deleting : %s ",err );
res.redirect('/customers');
});
});
};
Source code nya bisa agan download di Github nodecrud.
Maaf krena kepanjangan ane gbsa pajang disini smw tutorial nya
![Hammer emoticon-Hammer](https://s.kaskus.id/images/smilies/sumbangan/8.gif)
Tutorial lebih lengkapnya + installasi
Diubah oleh badycool2 05-03-2015 10:28
0
5.1K
17
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Urutan
Terbaru
Terlama
![Guest](https://s.kaskus.id/user/avatar/default.png)
![Avatar border](https://s.kaskus.id/images/avatarborder/1.gif)
Komentar yang asik ya
Komunitas Pilihan