NextJs & Mysql

NextJs is a fast growing React Framework that allows you to build super fast statically generated web pages and dynamic web applications.

With NextJs, you can build user-friendly and SEO front-end apps and back-end APIs. You are not required to have a custom sever like Express, Django, or PHP to create APIs for your client app.

In this tutorial, you learn to build a simple Admin dashboard that allows a logged in user to manage users list - search, insert, update, and delete user data from Mysql database.


Before we start the development of the sample demo project, you have to install necessary tools such as NPM and VSC Editor. On my Windows machine, i also have XAMPP installed to manage MySQL database.

Comments

Post a Comment

Popular posts from this blog

User Authentication: Register & Login using JWT in NextJs & MYSQL

Image
 In the earlier tutorial, you learnt data migration to synchronize Sequelize model with MYSQL database . This tutorial teaches you authentication using JWT (JSON Web Token) with MYSQL database.  The app allows a user to simply register an account using username, email, and password. The password is encrypted using bcryptjs . A successful registration will create a new record in users table of the MYSQL database.  To log in, the app requires a user to input username and password. After successful login, the app generates a token on server using jsonwebtoken . Then the token is returned to the client and stored at the client side using js-cookie for further API access.  Run the following commands to install bcrypt, jsonwebtoken, and js-cookie: npm install bcrypt jsonwebtoken js-cookie We build login and registration forms using reactstrap components. Thus, install the following dependencies: npm install bootstrap reactstrap In this project, we use axios to access ser...
Read more

Upload form data with file using Multer & MYSQL in NextJs

Image
The previous tutorial taught you how to create API endpoints to filter MYSQL database, pagination, and protect the API using middleware. This tutorial teaches you how to upload user form data with image file using Multer and delete data from MYSQL database. From the project folder, execute the following command to install Multer: npm install multer Then open api/user/[slug].js file to add post, put, and delete routes. To use multer to parse request body and upload files, you need to disable default body parser by setting bodyParser to false. We use diskStorage() function from multer to configure local storage and file name. Multer needs file field and max count of the file to be uploaded. In this project, we use array() function to specify file field (photo) and the max count of the file to be uploaded (1).  We can access text parts of a submitted form data by extracting body from the request. To access file parts, you need to extract files from the request. ..... import bcry...
Read more