MySQL Database discord.js

Question

It's my first time working with a database and I ran into a problem. I want to make an embed with information from a database. The Bot can only read those informations and not change anything. I set up the Bot with the Database using npm mysql. Now I got my Database connection ready and the embed ready but I don't really know how to combine those two things. In the Value fields from the embed should the information from the database go. For example, in the database there's a column with male players, and because they change throughout the day I want to make an embed that shows exactly how many male players there are when somebody types in the command info.

Database Connection Code (everything is private for a reason):

    const connection = mysql.createConnection({
        host     : 'private',
        port     : 'private',
        user     : 'private',
        password : 'private',
        database : 'private',
        charset  : 'private'
      });


    connection.connect()

My Code for the embed (in the value fields should the information from the database go):


    if(message.content.startsWith(prefix + 'info')) {
         
        const sembed = new Discord.MessageEmbed()

        .setTitle('Info:')
        .setThumbnail('png')
        .setColor('GOLD')
        .addFields(
            {name: 'Players:', value: ''},
            {name: '👨🏻', value: '', inline: true},
            {name: '👩🏻', inline: true},
            {name: '👧🏻', value: '', inline: true},
        )
        .setTimestamp()

        message.channel.send({embeds: [sembed]})
      }

Did you notice that there's and extra quote (')? You can see where with syntax highlighting — MrMythical
– MrMythical, Commented Oct 22, 2021 at 18:08

Kayes Fahim · Accepted Answer · 2021-10-22 18:11:25Z

1

For database connection use those line of code with proper value.

const connection = mysql.createConnection({
    host     : 'localhost',
    port     : 'your my sql port',
    user     : 'my sql username',
    password : 'user password',
    database : 'database name',
    charset  : 'utf8mb4'
  });

connection.connect()

Hope that may be help to you any query ask me.

answered Oct 22, 2021 at 18:11

Kayes Fahim

7006 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

I need Help Over a year ago

I did that but I put everything in private for obvious reasons. The problem I got is not with the database connection itself but with filling the values in the embed because there should the information from the database go. For example, in the database there's a column with male players, and because they change throughout the day I want to make an embed that shows exactly how many male players there are when somebody types in the command info

Kayes Fahim Over a year ago

For that you have to store all info then you have to filter them by male or female category .

I need Help Over a year ago

I'm so sorry but i have no idea what you mean or what i should do. Like i said that's my first time working with a database

Kayes Fahim Over a year ago

then you have to learn sql first . for that you can go w3schools.com

I need Help Over a year ago

If you mean the database everything is set up there. Everything is filterd and i just need to become the information in the embed

|

Collectives™ on Stack Overflow

MySQL Database discord.js

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related