Creating own cool stuf : server on your pc part 4

Hallo everyone!!!

Today I want to tell you and show you,how to get access to databases without a command line, and how to set nodejs, and configure it in pairs with nginx.

Why do we do this?

On site in the section development is interesting information
https://developers.steem.io/

there is api for nodejs, we will try to use that, but first configure.

We will start with database access ,In the first article I describe how to install mariadb, where we installed the user name and password to the database, hope you saved them.Now we need to download phpmyadmin(-that is link)
or that https://www.phpmyadmin.net/ ))
or that :
phpMyAdmin-4.7.7-all-languages.zip - latest arche for this time.

You have download this arhive , unpack to need folder in nginx server folder and now we will config our database domaine:

• open notepad with administrator rights;
• find on disc C: folder windows\system32\drivers\etc;
• in folder etc open in notepd file hosts;
• add line 127.0.0.1 db.home;

Ok ,now we open our nginx folder go to folder conf open folder conf and open our configuration file. Add this lines to file:

server {
listen 80;
server_name db.home;
access_log D:/nginx/logs/db.acc.log;
error_log D:/nginx/logs/db.err.log;
root D:/nginx/phpmyadmin /; // your path to phpmyadmin
index index.php;
location ~ / {
fastcgi_index index.php;
fastcgi_pass 127.0.0.1:9000;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}

     location ~ \.php$ {
        fastcgi_index  index.php;
        fastcgi_pass  127.0.0.1:9000;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
        include       fastcgi_params;
    }
}

restart your nginx if started or reload!
now in browser adress line go to thwe address http://db.home, and you will see:

cool yes??
Ok,that not all, now in username text box write "root" and in password text box write your password , when you login you willbe see a cool web client for creating and configurating your databases:

On that site https://www.phpmyadmin.net/ you will found cool tutorials for this client , or ask questions in the comments, we will look for a solution together.

---

first some wiki:
Node.js is an open-source, cross-platform JavaScript run-time environment for executing JavaScript code server-side. Historically, JavaScript was used primarily for client-side scripting, in which scripts written in JavaScript are embedded in a webpage's HTML, to be run client-side by a JavaScript engine in the user's web browser. Node.js enables JavaScript to be used for server-side scripting, and runs scripts server-side to produce dynamic web page content before the page is sent to the user's web browser. Consequently, Node.js has become one of the foundational elements of the "JavaScript everywhere" paradigm,[5] allowing web application development to unify around a single programming language, rather than rely on a different language for writing server side scripts.

Though .js is the conventional filename extension for JavaScript code, the name "Node.js" does not refer to a particular file in this context and is merely the name of the product. Node.js has an event-driven architecture capable of asynchronous I/O. These design choices aim to optimize throughput and scalability in Web applications with many input/output operations, as well as for real-time Web applications (e.g., real-time communication programs and browser games).[6]

The Node.js distributed development project, governed by the Node.js Foundation,[7] is facilitated by the Linux Foundation's Collaborative Projects program.[8]

Corporate users of Node.js software include GoDaddy,[9] Groupon,[10] IBM,[11] LinkedIn,[12][13] Microsoft,[14][15] Netflix,[16] PayPal,[17][18] Rakuten, SAP, Tuenti,[19] Voxer,[20] Walmart,[21] and Yahoo!.

https://en.wikipedia.org/wiki/Node.js

---

Ok now we will download and install nodejs on our pc, from official site https://nodejs.org/en/

Installation Steps

-Download the Windows installer from the Nodes.js web site.
-Run the installer (the .msi file you downloaded in the previous step.)
-Follow the prompts in the installer (Accept the license agreement, click the NEXT button a bunch of times and accept the default installation settings).

-Restart your computer. You won’t be able to run Node.js® until you restart your computer.

Test it!</2>
Make sure you have Node and NPM installed by running simple commands to see what version of each is installed and to run a simple test program:

-Test Node. To see if Node is installed, open the Windows Command Prompt, Powershell or a similar command line tool, and type node -v. This should print a version number, so you’ll see something like this v0.10.35.

-Test NPM. To see if NPM is installed, type npm -v in Terminal. This should print NPM’s version number so you’ll see something like this 1.4.28

-Create a test file and run it. A simple way to test that node.js works is to create a JavaScript file: name it hello.js, and just add the code console.log('Node is installed!');. To run the code simply open your command line program, navigate to the folder where you save the file and type node hello.js. This will start Node and run the code in the hello.js file. You should see the output Node is installed!.

now add to your hosts file :
127.0.0.1 steemit.home

open nginx configuration and add:

upstream app_robstodo {
server 127.0.0.1:3000;
}
server {
listen 80;
server_name steem.home;
access_log E:/nginx/logs/steem.acc.log;
error_log E:/nginx/logs/steem.err.log;
location / {
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_set_header Host $http_host;
proxy_set_header X-NginX-Proxy true;
proxy_pass http://app_robstodo/;
proxy_redirect off;
}
}


than create folder for nodjs proj , open and create file "server.js" with content:

var http = require('http');

http.createServer(function (req, res) {
res.writeHead(200, {'Content-Type': 'text/plain'});
res.end('Hello World\n');
}).listen(3000, '127.0.0.1');
console.log('Server running at http://127.0.0.1:3000/');


now start proj in command line i yourfolde like that:

you will see message that server is running!
now relkoad nginx an start in browser steem.home

Ok now you have :

• server nginx;
• sql maria db server with phpmyadmin client!!;
• php 7 interpretator;
• nodejs !!!
  thats realy powerfull stuf for creting cool web applications on your pc, or for your pc!!!

OK thats cool !!!
and thats all for today with this tham!!!
my steem https://steemit.com/@mandarin2016
Follow!!! Upvoite!!
I will be glad to see you all !!!!