I've been exploring the integration of Angular with Node.js and attempting to establish a connection to a MySQL database.
Within my script (server.js), I am utilizing the node mysql module as shown below:
var mysql=require('mysql');
var connection = mysql.createConnection(
{
host : 'localhost',
user : 'root',
password : '',
database : 'mysql',
}
);
connection.connect();
var queryString = 'SELECT * FROM users';
connection.query(queryString, function(err, rows, fields) {
if (err) throw err;
for (var i in rows) {
console.log('Post Titles: ', rows[i].post_title);
}
});
connection.end();
My goal is to execute the js script using Angular in the following manner:
var myApp = angular.module('myApp', []);
myApp.controller('AppListCtrl', ['$scope', '$http',
function($scope, $http) {
$http.get('../scripts/server.js').success(function(data) {
console.dir(data);
});
}
However, this approach does not seem to be working as intended since the js file is not being executed. Should I encapsulate my js code within html tags? Am I approaching this problem incorrectly? My preference is to achieve this solely through JavaScript without relying on php or any other programming language.