Company logo
  • Empleos
  • Bootcamp
  • Acerca de nosotros
  • Para profesionales
    • Inicio
    • Empleos
    • Cursos y retos
    • Preguntas
    • Profesores
    • Bootcamp
  • Para empresas
    • Inicio
    • Nuestro proceso
    • Planes
    • Pruebas
    • Nómina
    • Blog
    • Calculadora

0

78
Vistas
SQL and JS, how i can read text from SQL (discord)

I'm writing code for Discord, this is my code:

var mysql = require('mysql');
var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "",
    database: "mydb"
});

    var name = 'name';
    var id = '1';
    var sql = 'SELECT * FROM customers WHERE name = ? OR id = ?';
    con.query(sql, [name, id], function(err, result) {
        if (err) throw err;
        console.log(result);
});

The code works and it shows me what I have in the table, now I want to design it nicely, and I have the following design:


client.on('message', message => {
if (message.content.startsWith(prefix + [name])) {
           const logo = ''
           const embed = new MessageEmbed()
               .setTitle("name is: " + [name])
 }
  message.channel.send(embed);
});

Now it's working. But my problem is that I want it to be offered to me from SQL.

This means that instead of the name I have listed every name I want I want to get results from SQL in case there is no result that will show me an error message.

Can anyone help me on this?

7 months ago · Juan Pablo Isaza
Responde la pregunta
Encuentra empleos remotos

¡Descubre la nueva forma de encontrar empleo!

Top de empleos
Top categorías de empleo
Empresas
Publicar empleo Planes Nuestro proceso Comercial
Legal
Términos y condiciones Política de privacidad
© 2023 PeakU Inc. All Rights Reserved.