dsq2015 2016-08-11 13:24
浏览 35

无法使用codeigniter与node.js连接

I am building a voting system using codeigniter framework. There is a page in which I am showing a list of 10 people with there total vote and I wanted to make these voting count in realtime e.g voting count should change when user votes.

Voting page

Now to make all the finalist total votes real time, I am using node.js but unfortunately the program is not getting the total count.

var express    = require("express");
var mysql      = require('mysql');

var connection      =    mysql.createConnection({
    host     : 'localhost',
    user     : 'root',
    password : '',
    database : 'voting_sys',
});

var app = express();

connection.connect(function(err){
if(!err) {
    console.log("Database is connected ... nn");    
} else {
    console.log("Error connecting database ... nn");    
}
});

app.get("/",function(req,res){
connection.query("SELECT count('*') as votes from voting where finalist_id_fk=1", function(err, rows, fields) {
connection.end();
  if (!err)
    console.log('The solution is: ', rows);
  else
    console.log('Error while performing Query.');
  });
});

app.listen(3000);

When I run this file it only show database is connection where as I want total votes

enter image description here Please help me. How can I achieve it and how can I run this node.js file.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 matlab数字图像处理频率域滤波
    • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
    • ¥15 ELGamal和paillier计算效率谁快?
    • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
    • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
    • ¥15 Arcgis相交分析无法绘制一个或多个图形
    • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
    • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
    • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)
    • ¥15 用前端向数据库插入数据,通过debug发现数据能走到后端,但是放行之后就会提示错误