Welcome Guest, Not a member yet? Register   Sign In
nodejs tips and tricks
#26

Ok guys the promises seemed to have worked, just need to pass it into the view

Code:
var mysql = require('promise-mysql');

           let tmp =

            mysql.createConnection({
                host: 'localhost',
                user: 'root',
                password: 'root',
                database: 'databasename',
                port: '8889'
            }).then(function(conn){
                var result = conn.query('select `permission` from IGS_permissions');
                conn.end();
                return result;
            }).then(function(rows){
                
                console.log(rows);
                tmp = rows
                return tmp
            });


            return tmp

Which dumps out:

Code:
[{"permission":"email"},{"permission":"permissions"},{"permission":"profile"},{"permission":"users"},{"permission":"menu"},{"permission":"database"},{"permission":"field_builder"},{"permission":"sections"},{"permission":"entries"},{"permission":"asset_lib"},{"permission":"site_settings"},{"permission":"plugins"}]
Practical guide to IgnitedCMS - Book coming soon, www.ignitedcms.com
Reply


Messages In This Thread
nodejs tips and tricks - by ignitedcms - 09-10-2018, 12:42 PM
RE: nodejs tips and tricks - by ciadmin - 09-10-2018, 12:52 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 12:55 PM
RE: nodejs tips and tricks - by ciadmin - 09-10-2018, 01:03 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 01:05 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 01:13 PM
RE: nodejs tips and tricks - by donpwinston - 09-10-2018, 05:42 PM
RE: nodejs tips and tricks - by ignitedcms - 09-10-2018, 10:39 PM
RE: nodejs tips and tricks - by skunkbad - 09-12-2018, 01:08 AM
RE: nodejs tips and tricks - by ignitedcms - 09-12-2018, 03:04 AM
RE: nodejs tips and tricks - by skunkbad - 09-12-2018, 07:54 AM
RE: nodejs tips and tricks - by ignitedcms - 09-12-2018, 10:40 AM
RE: nodejs tips and tricks - by ignitedcms - 09-12-2018, 10:45 AM
RE: nodejs tips and tricks - by ignitedcms - 09-17-2018, 02:20 PM
RE: nodejs tips and tricks - by skunkbad - 09-17-2018, 03:44 PM
RE: nodejs tips and tricks - by ignitedcms - 09-17-2018, 08:52 PM
RE: nodejs tips and tricks - by ignitedcms - 09-18-2018, 06:38 AM
RE: nodejs tips and tricks - by ignitedcms - 09-18-2018, 11:42 AM
RE: nodejs tips and tricks - by skunkbad - 09-18-2018, 02:05 PM
RE: nodejs tips and tricks - by ignitedcms - 09-18-2018, 10:14 PM
RE: nodejs tips and tricks - by ignitedcms - 09-19-2018, 11:55 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 03:48 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 09:25 AM
RE: nodejs tips and tricks - by skunkbad - 09-20-2018, 10:26 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 11:07 AM
RE: nodejs tips and tricks - by ignitedcms - 09-20-2018, 11:45 AM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 09:21 AM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 03:55 PM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 06:37 PM
RE: nodejs tips and tricks - by skunkbad - 09-21-2018, 11:07 PM
RE: nodejs tips and tricks - by ignitedcms - 09-21-2018, 11:31 PM
RE: nodejs tips and tricks - by skunkbad - 09-22-2018, 07:00 AM
RE: nodejs tips and tricks - by ignitedcms - 09-23-2018, 10:17 AM
RE: nodejs tips and tricks - by ignitedcms - 09-24-2018, 10:44 AM
RE: nodejs tips and tricks - by ignitedcms - 09-25-2018, 05:09 AM
RE: nodejs tips and tricks - by ignitedcms - 09-25-2018, 05:18 AM
RE: nodejs tips and tricks - by ignitedcms - 09-25-2018, 12:38 PM
RE: nodejs tips and tricks - by ignitedcms - 09-26-2018, 11:58 AM
RE: nodejs tips and tricks - by dave friend - 09-27-2018, 07:37 AM
RE: nodejs tips and tricks - by ignitedcms - 09-27-2018, 09:16 AM
RE: nodejs tips and tricks - by ignitedcms - 09-28-2018, 10:09 AM
RE: nodejs tips and tricks - by ignitedcms - 09-28-2018, 11:48 PM
RE: nodejs tips and tricks - by ignitedcms - 09-30-2018, 08:52 PM



Theme © iAndrew 2016 - Forum software by © MyBB