How to correctly use a Select (*) count in Nodejs(EJS)?

Question

At this moment, in part of the code, I want to display the result of the number of records in a table, but I get an error message [Object Object] I have seen some similar questions but they have not helped me, I do not know if someone can correct me where I'm making the mistake.

app.js

app.get('/dashboard', (req, res) =>{
    connection.query('SELECT COUNT(*) FROM dimensions', function(error, resultsd) {
        if (error) {
            console.log(error);
            res.sendStatus(500);
            return;
        }
        connection.query('SELECT COUNT(*) FROM categorias',function(error, resultsc){
            if (error){
                console.log(error);
                res.sendStatus(500);
                return;
            }
            connection.query('SELECT COUNT(*) FROM subcategoria',function(error, resultss){
                if (error){
                    console.log(error);
                    res.sendStatus(500);
                    return;
                }
                res.render('./dashboard', {
                    resultsd:resultsd,
                    resultsc:resultsc,
                    resultss:resultss
                });
            })
        })

    })
})

Y en views/dashboard.ejs


        
          
            
              
                
                    
                
                
                  Dimensiones
                  <%= resultsd %>
                
              
            
          
          
            
              
                
                    
                
                
                  Categorias
                  <%= resultsc %>
                
              
            
          
          
            
              
                
                    
                  
                
                  Subcategorias
                  <%= resultss %>
                
              
            
          
          
            
              
                
                    
                
                
                  Usuarios
                  $103,430

I am currently managing MYSQL with Phpmyadmin, rendering with NodeJS (EJS).

Also try the following examples;

res.render('./dashboard', {
                    resultsd:resultsd[0],
                    resultsc:resultsc[0].rows,
                    resultss:resultss[0].count
                });

The messages appear more or less like this but do not generate any errors in the log.

Its my console log;

res.render('./dashboard', {
                    resultsd:resultsd,
                    resultsc:resultsc,
                    resultss:resultss
                });
                    console.log("🚀 ~ file: app.js ~ line 468 ~ q2 ~ resultss", resultss)
                    console.log("🚀 ~ file: app.js ~ line 468 ~ q2 ~ resultsc", resultsc)
                    console.log("🚀 ~ file: app.js ~ line 468 ~ q2 ~ resultsd", resultsd)
            })

Console log response

🚀 ~ file: app.js ~ line 468 ~ q2 ~ resultss [ RowDataPacket { 'COUNT(*)': 5 } ]
🚀 ~ file: app.js ~ line 468 ~ q2 ~ resultsc [ RowDataPacket { 'COUNT(*)': 4 } ]
🚀 ~ file: app.js ~ line 468 ~ q2 ~ resultsd [ RowDataPacket { 'COUNT(*)': 5 } ]

And thats my app.js / Configure conection

const express = require('express');
const app = express();
var bodyParser = require('body-parser');
const dotenv = require('dotenv');
const bcryptjs = require('bcryptjs')
const session = require('express-session');
const logger = require('./logger');
const morgan = require('morgan');

//Logs

logger.error('Error log example');
logger.warn('Warn log example');
logger.info('Info log example');


app.use(morgan('tiny', { stream: logger.stream }));

//Conexion A SERVIDOR

app.listen(5600,(req, res) =>{
    console.log('SERVER RUNING IN http://127.0.0.1:5600/ingresar');
})

//Resultados de Variables
//Envio de variables de base de datos
dotenv.config({path:'./env/.env'});


//Uso de urlencoded - BodyParser
app.use(bodyParser.urlencoded({
    extended: false
}));

app.use(bodyParser.json());

//Envio directorio EJS a Publico
var path = require ('path');
app.use(express.static(path.join(__dirname + '/public')));


app.set('views', __dirname + "/views/");
app.set('view engine', 'ejs');



//Express-Sesion

app.use(session({
    secret:'secret',
    resave: true,
    saveUninitialized:true
}))

//- VARIABLES DATA BASE - Invocar al modulo de conexion
const connection = require('./database/db');
const {response, application} = require('express');

Ryan Cahill · Accepted Answer

What it looks like is happening here is that the objects themselves are being passed to views/dashboard.ejs, where you just want the numbers. You can see in the print statements that resultss is [ RowDataPacket { 'COUNT(*)': 5 } ]. So in order to pass that to the template, you need to access resultss[0]['COUNT(*)'], which will equal 5. That's the COUNT(*) element of the first element of the array, resultss. For that whole section, what it looks like you want is the following:

res.render('./dashboard', {
  resultsd:resultsd[0]['COUNT(*)'],
  resultsc:resultsc[0]['COUNT(*)'],
  resultss:resultss[0]['COUNT(*)']
});

How to correctly use a Select (*) count in Nodejs(EJS)?

Answers (1)

Related Questions