Nodejs Course

- Create Database

Node.js can be used in applications with MySQL database.
If you haven't MySQL database installed on your operating system, you can download a free MySQL database at:
//dev.mysql.com/downloads/mysql/

Once you have MySQL up and running on your computer, you can access it with Node.js.
To access a MySQL database with Node.js, you need a MySQL driver. This tutorial will use the "mysql" module, from NPM.
To install the "mysql" module, open the Command Line interface and execute the following:
npm install --save mysql
Now, you can connect to MySQL, and perform SQL queries in your Node.js applications.

Connect to MySQL

To connect to MySQL server, include "mysql" module (with require()), and use the mysql.createConnection() method, with the "username" and "password" from your MySQL database; then the connect() method to establish the connection.
- Here is an example of connecting to MySQL server:
const mysql = require('mysql');

const con = mysql.createConnection({
  host: 'localhost',
  user: 'name',
  password: 'pass'
});

con.connect(err=>{
  if(err) throw err;
  console.log('Connected to mysql');
});
Save the code above in a file called "mysql_con.js" (for example, in a "test/" folder in "nodejs") and run the file in command line interface:
node test/mysql_con.js
Which will give you this result:
Connected to mysql
- To terminate a connection, you can use the con.end() or con.destroy() method. The end() method takes a callback argument.
con.end(err=>{
  if(err) throw err;
  console.log('Connection is terminated');
});

Create Database

The connection object created in the example above ("con"), has a query() method for querying the database.
The query() method establishes the connection; it takes a sql statements as a parameter, and returns the result in a callback function.
Will use this method to perform SQL queries, to create the database, and to read from (or write to) a MySQL database.

To store data in MySQL, you need to create a database. You can create a database with the "CREATE DATABASE" statement.
- Lets create a database called "nodedb"
const mysql = require('mysql');

const con = mysql.createConnection({
  host: 'localhost',
  user: 'name',
  password: 'pass'
});

let sql ='CREATE DATABASE nodedb';

con.query(sql, (err, res)=>{
  if(err) throw err;
  console.log('Database created.', res);

  con.end(err=>{
    if(err) throw err;
    console.log('Connection is terminated');
  });
});
Save the code above in a file called "mysql_create_db.js" and run the file:
node test/mysql_create_db.js

If you notice that the default collation of MySql is set to "latin1_swedish_ci", to change the default collation to "utf8_general_ci" in MySql:
- Open the "my.ini" file (mysql/bin/my.ini), find the text [mysqld] and add these lines:

character-set-server = utf8
collation-server = utf8_general_ci

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which HTML5 tag is indicated to be used as container for menu with navigation links in Web site?
<section> <nav> <article>
<nav><ul>
 <li><a href="http://coursesweb.net/css/" title="CSS Course">CSS Course</a></li>
 <li><a href="http://www.marplo.net/jocuri/" title="Flash Games">Flash Games</a></li>
</ul></nav>
Which CSS property shifts an item horizontally to the left or right of where it was?
text-align clear float
.some_class {
  width: 30%;
  float: left;
}
Click on the Math object method which returns x, rounded downwards to the nearest integer.
Math.ceil(x) Math.abs(x) Math.floor(x)
var num = 12.34567;
num = Math.floor(num);
alert(num);       // 12
Indicate the PHP function which returns the number of characters in string.
mb_strlen() count() stristr()
$str = "string with utf-8 chars åèö";
$nrchr = mb_strlen($str);
echo $nrchr;        // 30
Node.js with MySQL Database

Last accessed pages

  1. Select in MySQL, Output results in HTML Table (16003)
  2. Display / Simulate a Loading Progress Bar (2003)
  3. Add and Remove HTML elements and Content with jQuery (28990)
  4. Node.js Move and Copy file (22609)
  5. New Form elements and attributes in HTML5 (5394)

Popular pages this month

  1. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (522)
  2. PHP Unzipper - Extract Zip, Rar Archives (423)
  3. SHA256 Encrypt hash in JavaScript (403)
  4. Read Excel file data in PHP - PhpExcelReader (360)
  5. Create simple Website with PHP (335)