No more API calls! Communicate with mysql database with socket.io
Broadcasted when a new user is connected to socket
You can get number of users connected as follows:
socket.on('user connect', function (users) {
// `users` contains number of users connected
});
Perform query with parameters. Parameters are optional.
Example of only query:
socket.emit('trigger query', {
query: 'SELECT * FROM users'
});
Example of multiple queries:
socket.emit('trigger query', {
query: 'SELECT * FROM users; SELECT * FROM user_settings; SELECT * FROM user_phones;'
});
Example of query with parameters:
socket.emit('trigger query', {
query: 'SELECT * FROM users WHERE username=? AND password=?',
params: ['jayshah', '000100010']
});
Example of batch insert:
var values = [
['demian', 'demian@gmail.com'],
['john', 'john@gmail.com'],
['mark', 'mark@gmail.com'],
['pete', 'pete@gmail.com']
];
socket.emit('trigger query', {
query: 'INSERT INTO Test (name, email) VALUES ?',
params: [values]
});
Get result of a query as follows:
socket.on('query result', function (result) {
$("#results").html(JSON.stringify(result));
});
Well, thats pretty much it!