setupmysqlfor my node code example
Example 1: how to manage a db connection in javascript
const mysql = require('mysql2');
const connection = mysql.createPool({
host: "localhost",
user: "",
password: "",
database: ""
});
module.exports = connection;
const connection = require('../util/connection');
async function getAll() {
const sql = "SELECT * FROM tableName";
const [rows] = await connection.promise().query(sql);
return rows;
}
exports.getAll = getAll;
Example 2: js read mysql database
const config = {
"table" : "customers",
"limit" : "50",
"offset" : "0"
};
_POST_REQUEST("link-to-server/database.php", 'config=' + JSON.stringify(config), (response) => {
var data = JSON.parse(response);
});