You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
40 lines
1.2 KiB
40 lines
1.2 KiB
// Next.js API route support: https://nextjs.org/docs/api-routes/introduction
|
|
import { OkPacket, QueryError, RowDataPacket } from "mysql2";
|
|
import type { NextApiRequest, NextApiResponse } from 'next';
|
|
var pool = require("../../server/db/connect");
|
|
|
|
type Data = {
|
|
row: string,
|
|
}
|
|
|
|
const queryString = "SELECT name, types FROM product_categories WHERE status=1";
|
|
|
|
export default function handler(
|
|
req: NextApiRequest,
|
|
res: NextApiResponse<Data>)
|
|
{
|
|
pool.getConnection(function(err: QueryError, rows: RowDataPacket[0]){
|
|
if (err) {
|
|
connection.release();
|
|
throw err;
|
|
}
|
|
connection.query(query,function(err,rows){
|
|
connection.release();
|
|
if(!err) {
|
|
callback(null, {rows: rows});
|
|
}
|
|
});
|
|
connection.on('error', function(err) {
|
|
throw err;
|
|
return;
|
|
});
|
|
});
|
|
|
|
pool.query(
|
|
queryString,
|
|
(err: QueryError, rows: RowDataPacket[0]) => {
|
|
res.status(200).json(rows);
|
|
}
|
|
);
|
|
pool.releaseConnection(conn);
|
|
}; |