How To Get Data From MySQL Table to EJS page using NodeJS

[UPDATE: There is an error on loading of images in every post. I am working to resolve this as soon as possible. Screenshots were mere snap of windows so you can still follow the steps written in text and do the work!] 

Welcome to another tech post. In this post, I will be showing you how to get data from the MySQL table which is made using SequelizeJS into our view which is an EJS file in NodeJS.

If you want to learn how to create a table using SequelizeJS, then refer to my other post: How To Create MySQL Table with SequelizeJS (sumitkp.in)


Before starting to read further, make sure you have prior knowledge of NPM packages, NodeJS, SequelizeJS, EJS, JSON and ExpressJs.


Something about the EJS:

  • EJS stands for Embedded JavaScript.
  • EJS is a simple templating language that lets us generate HTML markup with plain JavaScript.
  • It offers fast development time.
  • It has a simple syntax and speedy execution.
  • It is easy to debug EJS errors.
  • EJS has a large community of active users and the library is under active development.
  • Refer to EJS here: EJS -- Embedded JavaScript templates

1. Create a server.js file in the root directory of your project.


Refer to this code snippet to learn how to get all records from the table and convert it into JSON: SequelizeJS - findAll( ) method

2. Create an EJS file under 'views' in the root directory of your project.
To display, use <%-   %>. To learn more about such tags, click here.

This is how our JSON Data is:




After we start the application by typing 'node server.app' in the terminal and go to the URL http://localhost:3000/student', this is what is displayed:



The following code is of index.js and student_models.js files under './models' folder.



The following code is of db_config.js and it is under './config' folder.

Comments

Post a Comment

Popular

How To Create MySQL Table with SequelizeJS

Image
Hello, in this post I will be showing how you can create an SQL table using JavaScript without the knowledge of MySQL. Sequelize is a promise-based  Node.js   ORM tool  for  Postgres ,  MySQL ,  MariaDB ,  SQLite ,  Microsoft SQL Server ,  Amazon Redshift  and  Snowflake’s Data Cloud . It features solid transaction support, relations, eager and lazy loading, read replication and more.
OPEN

How To Read CSV Files in Java as Maven Project

Image
Many of us have problems reading CSV files in Java but not anymore!. In this guide, I will share how to read CSV files as Maven Project. For creating a Maven project: In your Eclipse IDE, click on File > New > Project... > Maven >Maven Project > Next > Check "Create a simple project" checkbox. Under Group Id: The name could be anything. It is same as any package name. E.g. in.sumitkp Under Artifact Id: Same as above It is same as any project name. E.g. maven-demo1 Let the Version be the default. Under Name: Give the name for your project Click Finish. In your Project Explorer, all the necessary files will be automatically generated. Inside the root folder, there will be an XML file auto-generated called  pom.xml . About pom.xml: POM stands for Project Object Model It is an XML file that contains information about the project and configuration details used by Maven to build the project. When running a task, Maven looks for the pom.xml file in the directory. I...
OPEN

How To Create A Hibernate Project in Maven

Image
In this post, I will be showing you how to create a Hibernate project using Maven and how we can add MySQL dependencies to it. Here, is a whole process picture which you can click and follow the steps. The direction of the process has been indicated by arrow icons. Now, configuring the Hibernate XML file: Inside your project folder, right-click on 'src/main/java' and select New > Other... > Type filter text: xml > Under XML folder, click on XML File > Click Next > Under File Name, type: hibernate.cfg.xml > Finish. Inside this hibernate.cfg.xml file, we would now need a dtd line. dtd stands for 'document type definition'. It defines the tagging structure of an XML document. For this, search on Google or any search engine: hibernate dtd. Find for the result that says "Index of /dtd - Hibernate". Click the link or go to  https://hibernate.org/dtd/  . On the next page, click on either of these three links. A dtd file will be downloaded. Open the ...
OPEN