level 1
劉x浩然
楼主
拜託各位大佬救我一下,这裡卡好久了。
我是用node连mysql,现在想让多人同时连上不过卡住了,一执行就会
跳出TypeError: pool.getConnection is not a function
以下是我的程式码
var app = require("express")();
var mysql = require("mysql");
var http = require("http").Server(app);
var io = require("socket.io")(http);
var pool = mysql.createConnection({
host: 'localhost',
port: '3001',
user: 'root',
password: '',
database: 'socket'
});
app.get("/",function(req,res){
res.sendFile(__dirname + '/index.html');
});
io.on('connect',function(socket){socket.on('disconnect', function () {
console.log('user disconnected');
});
pool.connect(function(){
console.log("mysql connect");
});
pool.getConnection(function (err, connection) {
pool.query('SELECT * FROM socket', function (error, result) {
console.log(result);connection.release();
});
pool.query('SELECT * FROM socket', function (error, result) {
console.log(result);connection.release();
});
});
}
http.listen(3001,function(){console.log("Listening on 3001")});
});
2018年05月08日 09点05分
1
我是用node连mysql,现在想让多人同时连上不过卡住了,一执行就会
跳出TypeError: pool.getConnection is not a function
以下是我的程式码
var app = require("express")();
var mysql = require("mysql");
var http = require("http").Server(app);
var io = require("socket.io")(http);
var pool = mysql.createConnection({
host: 'localhost',
port: '3001',
user: 'root',
password: '',
database: 'socket'
});
app.get("/",function(req,res){
res.sendFile(__dirname + '/index.html');
});
io.on('connect',function(socket){socket.on('disconnect', function () {
console.log('user disconnected');
});
pool.connect(function(){
console.log("mysql connect");
});
pool.getConnection(function (err, connection) {
pool.query('SELECT * FROM socket', function (error, result) {
console.log(result);connection.release();
});
pool.query('SELECT * FROM socket', function (error, result) {
console.log(result);connection.release();
});
});
}
http.listen(3001,function(){console.log("Listening on 3001")});
});