Next.js Discord

Discord Forum

Weird error? Route Handling

Unanswered
Black carp posted this in #help-forum
Open in Discord
Black carpOP
import { NextResponse } from "next/server";
import { json } from "stream/consumers";

export async function GET(req) {
    const mysql = require('mysql');
    const connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    });

    connection.connect((error) => {
    if(error){
        return 'Error connecting to the MySQL Database: ' + error;
    }
    return 'Connection established sucessfully';
    });
    connection.query('SELECT * FROM jsmysql.workers', function (error, results, fields) {
        if (error) throw error;
        console.log(NextResponse.json({ content : results }))
        return NextResponse.json({ content : results })
      });
    connection.end((error) => {
        return error
    });
    return 'No Result'
}

6 Replies

return 'bad request': incorrect
return new Response('bad request', { status: 400 }): correct
@joulev you must return a response, not a string
Black carpOP
Why doesnt the result return but the 'No result!'
import { NextResponse } from "next/server";
import { json } from "stream/consumers";

export async function GET(req) {
    const mysql = require('mysql');
    const connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    });
    let outcome = 'No result!'

    function getArray(arr) {
        for (let i = 0; i < arr.length; i++) {
            return [arr[i].name,arr[i].city]
        }
    }

    connection.connect((error) => {
    if(error){
        console.log('Error connecting to the MySQL Database: ') + error;
    }
    console.log('Connection established sucessfully');
    });
    connection.query('SELECT * FROM jsmysql.workers', function (error, results, fields) {
        if (error) throw error;
        return new Response (getArray(results), {status: 200})
      });
    connection.end((error) => {
        return new Response (error, { status: 400 })
    });
    return new Response (outcome, { status: 400 })
}
Erythrina gall wasp
weird