router.get('/albums', function(req, res){ req.getConnection(function(err,connection){ var query = connection.query('SELECT * FROM album',function(err,rows) { if(err) console.log("Error Selecting : %s ",err ); res.render('albums',{page_title:"albums - Node.js",data:rows}); }); //console.log(query.sql); }); });
//delete data curut2.delete(function(req,res,next){ var user_id = req.params.user_id; req.getConnection(function (err, conn) { if (err) return next("Cannot Connect"); var query = conn.query("DELETE FROM t_user WHERE user_id = ? ",[user_id], function(err, rows){ if(err){ console.log(err); return next("Mysql error, check your query"); } res.sendStatus(200); }); //console.log(query.sql); }); });
/*Save the album*/ router.post('/albums/save', function(req,res){ var input = JSON.parse(JSON.stringify(req.body)); req.getConnection(function (err, connection) { var data = { title : input.title, artist : input.artist, release_year : input.release_year }; var query = connection.query("INSERT INTO album set ? ",data, function(err, rows) { if (err) console.log("Error inserting : %s ",err ); res.redirect('/albums'); }); // console.log(query.sql); get raw query }); });
router.get('/albums/delete/:id', function(req,res){ var id = req.params.id; req.getConnection(function (err, connection) { connection.query("DELETE FROM album WHERE id = ? ",[id], function(err, rows) { if(err) console.log("Error deleting : %s ",err ); res.redirect('/albums'); }); }); });
//show the CRUD interface | GET curut.get(function(req,res,next){ req.getConnection(function(err,conn){ if (err) return next("Cannot Connect"); var query = conn.query('SELECT * FROM t_user',function(err,rows){ if(err){ console.log(err); return next("Mysql error, check your query"); } res.render('user',{title:"RESTful Crud Example",data:rows}); }); }); });
router.post('/albums/edit/:id', function(req,res){ var input = JSON.parse(JSON.stringify(req.body)); var id = req.params.id; req.getConnection(function (err, connection) { var data = { title : input.title, artist : input.artist, release_year : input.release_year }; connection.query("UPDATE album set ? WHERE id = ? ",[data,id], function(err, rows) { if (err) console.log("Error Updating : %s ",err ); res.redirect('/albums'); }); }); });
// SHOW EDIT USER FORM app.get('/edit/(:id)', function(req, res, next){ req.getConnection(function(error, conn) { conn.query('SELECT * FROM users WHERE id = ?', [req.params.id], function(err, rows, fields) { if(err) throw err // if user not found if (rows.length <= 0) { req.flash('error', 'User not found with id = ' + req.params.id) res.redirect('/users') } else { // if user found // render to views/user/edit.ejs template file res.render('user/edit', { title: 'Edit User', //data: rows[0], id: rows[0].id, name: rows[0].name, age: rows[0].age, email: rows[0].email }) } }) }) })
// DELETE USER app.delete('/delete/(:id)', function(req, res, next) { var user = { id: req.params.id } req.getConnection(function(error, conn) { conn.query('DELETE FROM users WHERE id = ' + req.params.id, user, function(err, result) { //if(err) throw err if (err) { req.flash('error', err) // redirect to users list page res.redirect('/users') } else { req.flash('success', 'User deleted successfully! id = ' + req.params.id) // redirect to users list page res.redirect('/users') } }) }) })
//get data to update curut2.get(function(req,res,next){ var user_id = req.params.user_id; req.getConnection(function(err,conn){ if (err) return next("Cannot Connect"); var query = conn.query("SELECT * FROM t_user WHERE user_id = ? ",[user_id],function(err,rows){ if(err){ console.log(err); return next("Mysql error, check your query"); } //if user not found if(rows.length < 1) return res.send("User Not found"); res.render('edit',{title:"Edit user",data:rows}); }); }); });
// SHOW LIST OF USERS app.get('/', function(req, res, next) { req.getConnection(function(error, conn) { conn.query('SELECT * FROM users ORDER BY id DESC',function(err, rows, fields) { //if(err) throw err if (err) { req.flash('error', err) res.render('user/list', { title: 'User List', data: '' }) } else { // render to views/user/list.ejs template file res.render('user/list', { title: 'User List', data: rows }) } }) }) })
router.get('/albums/edit/:id', function(req, res){ var id = req.params.id; req.getConnection(function(err,connection){ var query = connection.query('SELECT * FROM album WHERE id = ?',[id],function(err,rows) { if(err) console.log("Error Selecting : %s ",err ); res.render('edit_album',{page_title:"Edit albums - Node.js",data:rows}); }); //console.log(query.sql); }); });
//show the CRUD interface | GET curut.get(function(req,res,next){ req.getConnection(function(err,conn){ if (err) return next("Cannot Connect"); var query = conn.query('SELECT * FROM t_user',function(err,rows){ if(err){ console.log(err); return next("Mysql error, check your query"); } res.render('user',{title:"RESTful Crud Example",data:rows}); }); }); });
//delete data curut2.delete(function(req,res,next){ var user_id = req.params.user_id; req.getConnection(function (err, conn) { if (err) return next("Cannot Connect"); var query = conn.query("DELETE FROM t_user WHERE user_id = ? ",[user_id], function(err, rows){ if(err){ console.log(err); return next("Mysql error, check your query"); } res.sendStatus(200); }); //console.log(query.sql); }); });
// DELETE USER app.delete('/delete/(:id)', function(req, res, next) { const user = { id: req.params.id } req.getConnection(function(error, conn) { conn.query('DELETE FROM users WHERE id = ' + req.params.id, user, function(err, result) { //if(err) throw err if (err) { req.flash('error', err) // redirect to users list page res.redirect('/users') } else { req.flash('success', 'User deleted successfully! id = ' + req.params.id) // redirect to users list page res.redirect('/users') } }) }) })
//get data to update curut2.get(function(req,res,next){ var user_id = req.params.user_id; req.getConnection(function(err,conn){ if (err) return next("Cannot Connect"); var query = conn.query("SELECT * FROM t_user WHERE user_id = ? ",[user_id],function(err,rows){ if(err){ console.log(err); return next("Mysql error, check your query"); } //if user not found if(rows.length < 1) return res.send("User Not found"); res.render('edit',{title:"Edit user",data:rows}); }); }); });