Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //query
- users.update = (id_user, name_user, address_user) => {
- return new Promise(( resolve, reject ) => {
- db.query('UPDATE users SET name_user = name_user WHERE name_user = ?"',
- {
- id_user: id_user,
- name_user: name_user,
- address_user: address_user
- },
- (err, results) => {
- if (err) {
- console.log(err)
- return reject({ message: 'Invalid data', error: true })
- }
- return resolve({ message: 'Data has been updated successfully.', error: false, data:results.affectedRows })
- })
- })
- }
- //router
- router.put('/:id', async (req, res) => {
- try{
- let id = req.params.id_user
- let response = await db.update(id,req.body.name_user, req.body.address_user)
- res.json(response)
- }catch(e) {
- console.log(e)
- res.sendStatus(500)
- }
- })
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement