Gitlab@Informatics

Skip to content
Snippets Groups Projects
Select Git revision
  • 01e8ba987868521e8d5de29c110f48c8a4342365
  • main default protected
  • revert
  • 64160159
  • 64160292
  • 64160073
  • html-v_page
  • 64160174
  • 64160072
  • 64160295
  • production
11 results

web.php

Blame
  • db.js 1.16 KiB
    // const mysql = require("mysql2");
    // require("dotenv").config();
    
    // const pool = mysql.createPool({
    //   host: process.env.DB_HOST || "localhost",
    //   user: process.env.DB_USER || "root",
    //   password: process.env.DB_PASS || "",
    //   database: process.env.DB_NAME || "mypocketapp",
    //   port: process.env.DB_PORT || 3306,
    // });
    
    // pool.getConnection((err) => {
    //   if (err) {
    //     console.error("❌ Database connection failed:", err);
    //     return;
    //   }
    //   console.log("✅ MySQL Connected...");
    // });
    
    // module.exports = pool;
    
    const mysql = require("mysql2/promise");
    require("dotenv").config();
    
    const pool = mysql.createPool({
      host: process.env.DB_HOST || "localhost",
      user: process.env.DB_USER || "root",
      password: process.env.DB_PASS || "",
      database: process.env.DB_NAME || "mypocketapp",
      port: process.env.DB_PORT || 3306,
    });
    
    // Test the database connection
    (async () => {
      try {
        const connection = await pool.getConnection();
        console.log("✅ MySQL Connected...");
        connection.release(); // Release the connection back to the pool
      } catch (err) {
        console.error("❌ Database connection failed:", err);
      }
    })();
    
    module.exports = pool;