اتصال به دیتابیس MariaDB در برنامه‌های NextJS

npm install mariadb

DB_HOST=bromo.liara.cloud
DB_PORT=32703
DB_USER=root
DB_PASS=5T7kBqMMGLQYDGAkVdAtvd3L
DB_NAME=upbeat_rosalind

import mariadb from 'mariadb';

const pool = mariadb.createPool({
  host: process.env.DB_HOST,
  port: process.env.DB_PORT,
  user: process.env.DB_USER,
  password: process.env.DB_PASS,
  database: process.env.DB_NAME,
  connectionLimit: 5
});

export async function connectToMariaDB() {
  const connection = await pool.getConnection();
  return connection;
}

import { connectToMariaDB } from '@/lib/mariadb';

export default async function handler(req, res) {
  const connection = await connectToMariaDB();
  connection.release();

  res.status(200).json({ message: 'Connected to MariaDB successfully' });
}

import { useEffect, useState } from 'react';

export default function Home() {
  const [data, setData] = useState(null);
  const [error, setError] = useState(null);

  useEffect(() => {
    async function fetchData() {
      try {
        const res = await fetch('/api/mariadb');
        const result = await res.json();
        setData(result);
      } catch (err) {
        setError(err);
      }
    }

    fetchData();
  }, []);

  return (
    <div>
      <h1>Database Connection Test</h1>
      {error ? (
        <p>Error: {error.message}</p>
      ) : data ? (
        <pre>{JSON.stringify(data, null, 2)}</pre>
      ) : (
        <p>Loading...</p>
      )}
    </div>
  );
}