Detailed explanation of basic nodejs operation methods-PHP Tutorial-php.cn

Detailed explanation of basic nodejs operation methods

小云云

Release： 2023-03-21 18:30:02

Original

3337 people have browsed it

The previous project used PHP for high-frequency collection and settlement, which greatly reduced the efficiency of our PHP, and PHP blocking prevented our web pages from running normally. So find a language that can replace PHP for database operations and collection, and perfectly integrate with PHP.

Node.js is a JavaScript runtime environment based on the Chrome V8 engine. Node.js uses an event-driven, non-blocking I/O model, making it lightweight and efficient. Node.js's package manager npm is the world's largest open source library ecosystem.

First introduction to nodejs

nodejs, just like our PHP composer, you can use the npm command to download nodejs related plug-ins.
You can only use the front-end javascript to operate basic functions, and the cost of learning is greatly reduced.

Normal operation

nodejs link database

At this time we will rely on npm to download the mysql module
Switch to our project, npm install mysql -save
Create a file that runs sql mysql.js

//连接数据库var mysql = require(&#39;mysql&#39;);var connection = mysql.createConnection({
    host: &#39;localhost&#39;,
    user: &#39;root&#39;,
    password: &#39;root&#39;,
    database:&#39;carbird&#39;});

connection.connect();//查询connection.query(&#39;select * from `think_order`&#39;, function(err, rows, fields) {
    if (err) throw err;
    console.log(&#39;查询结果为: &#39;, rows);
});//关闭连接connection.end();

Copy after login

Run the js. At this time, most functions can be implemented, including regular settlement functions, sharing the pressure of php, including collecting data

Make an example of nodejs collecting 1680210 lottery tickets and storing them in the database

Create pacong.js

var http = require("http");var iconv = require(&#39;iconv-lite&#39;);var option = { 
hostname: "api.api68.com",
path: "/klsf/getLotteryInfo.do?issue=&lotCode=10005"}; 
var req = http.request(option, function(res) {res.on("data", function(chunk) {console.log(JSON.parse( iconv.decode(chunk, "utf-8") ));
}); 
}).on("error", function(e) {console.log(e.message);
});
req.end();

Copy after login

where var iconv = require('iconv-lite'); This module needs to be downloaded and introduced by npm to solve the problem The Chinese garbled code problem

The result is:

{ errorCode: 0,
  message: &#39;操作成功&#39;,
  result:
   { businessCode: 0,
     message: &#39;操作成功&#39;,
     data:
      { preDrawIssue: 2018030717,
        preDrawCode: &#39;03,13,10,11,01,18,07,12&#39;,
        drawIssue: 2018030718,
        drawTime: &#39;2018-03-07 12:01:20&#39;,
        preDrawTime: &#39;2018-03-07 11:51:20&#39;,
        drawCount: 17,
        firstDragonTiger: 1,
        lastBigSmall: 0,
        sumBigSmall: 1,
        sumNum: 75,
        sumSingleDouble: 0,
        fourthDragonTiger: 0,
        secondDragonTiger: 0,
        thirdDragonTiger: 1,
        frequency: &#39;&#39;,
        lotCode: 10005,
        iconUrl: &#39;http://webapp.1680180.com/images/icon/3x/gdkl@3x.png&#39;,
        shelves: 0,
        groupCode: 3,
        lotName: &#39;广东快乐十分&#39;,
        totalCount: 84,
        serverTime: &#39;2018-03-07 11:53:50&#39;,
        index: 100 } } }

Copy after login

The cheerio module is introduced to collect and process more complex data, and the crawler website

var express = require(&#39;express&#39;);var app = express();var request = require(&#39;request&#39;);var cheerio = require(&#39;cheerio&#39;);

app.get(&#39;/&#39;, function(req, res) {

  request(&#39;http://www.zhongjiantang.com/index.php?c=detail&id=57&#39;, function(error, response, body) {
    if (!error && response.statusCode == 200) {
      $ = cheerio.load(body);
      res.json({
          cat: $(&#39;h1&#39;).text()
      });
    }
  })
});var server = app.listen(3000, function() {
  console.log(&#39;listening at 3000&#39;);
});

Copy after login

combined with the operation of nodejs sql can insert the data into the database. Or other related operations

Use nodejs to make web pages and implement routing functions

Use npm to introduce express

Create a web.js

var express = require(&#39;express&#39;);var app = express();//  主页输出 "Hello World"app.get(&#39;/&#39;, function (req, res) {
   console.log("主页 GET 请求");
   res.send(&#39;Hello GET&#39;);
})//  POST 请求app.post(&#39;/&#39;, function (req, res) {
   console.log("主页 POST 请求");
   res.send(&#39;Hello POST&#39;);
})//  /del_user 页面响应app.get(&#39;/del_user&#39;, function (req, res) {
   console.log("/del_user 响应 DELETE 请求");
   res.send(&#39;删除页面&#39;);
})//  /list_user 页面 GET 请求app.get(&#39;/list_user&#39;, function (req, res) {
   console.log("/list_user GET 请求");
   res.send(&#39;用户列表页面&#39;);
})// 对页面 abcd, abxcd, ab123cd, 等响应 GET 请求app.get(&#39;/ab*cd&#39;, function(req, res) {   
   console.log("/ab*cd GET 请求");
   res.send(&#39;正则匹配&#39;);
})var server = app.listen(8081, function () {

  var host = server.address().address  var port = server.address().port

  console.log("应用实例，访问地址为 http://%s:%s", host, port)

})

Copy after login

We visit 127.0 .0.1:8081 You can access the response page, or operate

The packaging of related operations of the database

Click to download the package file

Look first How to use

        db.select({            table: &#39;数据表&#39;,            where: &#39;字段名称=&#39;查询条件&#39;,
            success: function (result) {
                   //查询成功之后相关操作
                }
                ，})

Copy after login

Take select as an example
Create sql:

exports.select = function(obj){
    if(!obj){
        log(&#39;对象不存在&#39;);        return;
    }    if(!obj.hasOwnProperty(&#39;field&#39;)){
        obj.field ="*";
    }    var Sql = &#39;SELECT &#39;+obj.field+&#39; FROM &#39;+obj.table ;    if(obj.hasOwnProperty(&#39;where&#39;)){
        Sql+=&#39; WHERE &#39;+obj.where;
    }    if(obj.hasOwnProperty(&#39;limit&#39;)){
        Sql+=&#39; LIMIT &#39;+obj.limit;
    }    // console.log(Sql);
    db_query(Sql,obj);
};

Copy after login

Execute sql:

function db_query(Sql,obj){
    var db_client=mysql.createClient(config.dbinfo);
    db_client.query(Sql,function(err,data){        if(err){            if(obj.error){                if(obj.hasOwnProperty(&#39;error&#39;)){
                    obj.error(err);
                }
            }else{
                log(&#39;数据库出错：&#39; + err.message);
            }
        }else{            if(obj.hasOwnProperty(&#39;success&#39;)){
                obj.success(data);
            }
        }        if(obj.hasOwnProperty(&#39;callback&#39;)){
            obj.callback(err,data);
        }
    });
    db_client.end();
}

Copy after login

How to reference a packaged js file

    var db = require(&#39;db&#39;),

Copy after login

Summary: Database operation is an asynchronous process. It can greatly improve the work efficiency of nodejs, and at the same time

analyze an asynchronous example

//代码示例3//注意还是那个Add，精髓也在这里，随后说到function Add(a, b){
    return a+b;
}//LazyAdd改变了，多了一个参数cbfunction LazyAdd(a, cb){
    return function(b){
        cb(a, b);
    }
}//将Add传给形参cbvar result = LazyAdd(1, Add)// 这个时候去做一些其他的程序，等条件成立之后再去执行result = result(2); // => 3

Copy after login

How nodejs sends data to php through http

function requestKj(number) {
    var postData = JSON.stringify(number);    var option = {
        host: 网址,
        path: 地址,
        method: &#39;POST&#39;,
        headers: {            "Content-Type": &#39;application/json&#39;,            "Content-Length": Buffer.byteLength(postData)
        }
    };    var req = http.request(option, function (res) {
        res.on(&#39;data&#39;, function () {
        });
        res.on(&#39;end&#39;, function () {
            console.log(&#39;成功前端给php&#39;);
        });
    });
    req.write(postData);
    req.end();
    setTimeout(function () {
        yuegengxin(number);
    },1000)
}

Copy after login

php side receives the nodejs delivery Information

    public function nodejs_get_data(){
        $data= json_decode(file_get_contents(&#39;php://input&#39;),true);        //对$data数据的相关操作
    }

Copy after login

Summary

Nodejs is still the tip of the iceberg, and there is a lot to learn.
nidejs collection Api demo
nodejs master blog tutorial

The above is the detailed content of Detailed explanation of basic nodejs operation methods. For more information, please follow other related articles on the PHP Chinese website!