how connect with mysql in nodeja code example
Example: js read mysql database
// Use https://github.com/JackChilds/jsmysqldb
// Then once it's setup you can just do this:
// Config that will be sent to server
const config = {
"table" : "customers",
"limit" : "50",
"offset" : "0"
};
// Use the _POST_REQUEST function to send data to the server and get a response
_POST_REQUEST("link-to-server/database.php", 'config=' + JSON.stringify(config), (response) => {
// Convert the response into an array of rows:
var data = JSON.parse(response);
// Now do what you want with data
// data[row index][column name]
});