imported>Kostya nad: /* createConnection */

2017-11-06T17:00:33Z

createConnection

Новая страница

== Plugin ==
MySQL is a NodeJS plugin. You must download NodeJS recommend version fron [https://nodejs.org/en/ official site (https://nodejs.org/en/)] and install it with
<code>npm install mysql</code>
OK. We installed MySQL. In our index.js write this:
<syntaxhighlight lang="javascript">
var mysql = require('mysql');
</syntaxhighlight>

So. Functions for working with MySQL:
=== createConnection ===
Create information for connection but do not open it.
<syntaxhighlight lang="javascript">
var mysqlc = mysql.createConnection({
host:'127.0.0.1',// host of server
user:'kostya_nad',// MySQL user
password:'MyStrongPassword',// MySQL password
database:'gmgta'// MySQL database
});
</syntaxhighlight>

=== connect ===
Open connection to database
<syntaxhighlight lang="javascript">
mysqlc.connect(function(e) {
if(e) {
console.log("Error connecting to the database with error "+e);
}
else {
console.log('Database connected!')
}
});
</syntaxhighlight>

=== end ===
Close connection to database

<syntaxhighlight lang="javascript">
mysqlc.end();
</syntaxhighlight>
=== query ===
Send a MySQL query to database
<syntaxhighlight lang="javascript">
mysqlc.query("SELECT * FROM `users` WHERE `nickname`=", [], function(e, r) {
if(e) {
console.log('Error on connection ... ');
throw e;
}
else {
console.log('Password is '+r[0].passcode);
}
});
</syntaxhighlight>

MySQL - История изменений

imported>Kostya nad: /* createConnection */