User Management System - Nodejs, Express, MySQL & Express-Handlebars

[@shadowslayer2248]

Crystal clear explanations at each step and also finally found someone who codes, makes mistakes and solves how to fix it in real-time. Really helps us think and logically understand what is going on. Incredibly awesome work sir keep going!

[@LeticiaCMZ]

thank you so much for this video, i'm doing my first project in a company that i just started internship. Your video helped me and taught me a lot.

[@RaddyDev]

Hey Letícia, I am glad to hear that you found the video helpful! Good luck with the internship, I hope that you enjoy it and thank you for the kind message

[@Study-Easy-nw4wc]

I am just done this project by using EJS template facing lots of problem and solve them ..and learn lots of thing... thank you so much for your video

[@worldman3670]

In 2022 , 15:25 - app.engine('hbs',exphbs({extname:'.hbs'}) change to app.engine('hbs',exphbs.engine({extname:'.hbs'})

[@andraspenne6642]

This is amongst the best tutorials available on the internet. You are awesome. I just solved the problem at 1:30:00 on my own, with no prior knowledge in nodejs. You really make me learn the concepts along the way.

[@RaddyDev]

Thank you very much, Andreas! It means a lot!

[@raphaelmunaki226]

How can I host this application together with the database for free, it's for my portfolio

[@tonypreetz]

@@raphaelmunaki226look into Render, they have free hosting

[@gopinathkrm58]

I was searching for some Node and MySQL combo, glad I found this channel. Awesome content u have bro.

[@RaddyDev]

Welcome to the channel 👊🦍 it's good to hear that you like the content. Thanks for the comment!

[@raphaelmunaki226]

How can I host this application together with the database for free, it's for my portfolio

[@danielkavale]

Thanks for a such help. For those who face an error on express-handlebars 6.0.X for engine: const {engine} = require('express-handlebars'); app.engine('hbs', engine ((extname:'.hbs')); app.set('view engine', 'hbs');

[@RaddyDev]

You have a small typo there, but I am sure that people will figure it out

[@danielkavale]

@@RaddyDev once again thank you Raddy, it helped me a lot. I've edited the comment.

[@foxynewgames]

man, you are a live saver

[@codefoxx]

Just what I needed. I combined this with the login system I had. I did use EJS and CSS instead of handlebars and bootstrap but I was able to follow along just fine. Now, I have completed the website I made for the nonprofit company I volunteered at. Excellent tutorial, liked and subscribed!

[@RaddyDev]

That sounds awesome and thank you for the sub. What did you end up using for your login system? I like your channel btw 👊😎

[@codefoxx]

@@RaddyDev I did it all with NodeJS and MySQL. I also used Nodemailer for sending account verification and reset password emails. If you know of a better service or an npm package that can send emails I'd love to hear about it. Thanks for liking my channel. I still have a long way to go as you probably know it takes a lot of hard work and dedication to get your channel off the ground. Btw, I made a KZbin 2 mp3 converter app with NodeJS tutorial not too long ago and after watching your tutorial, I realized you are much better at explaining this stuff than me. Haha I seriously thought that as I watched your tutorial

[@RaddyDev]

@@codefoxx NodeJs, MySQL + Nodemailer is perfect. The other approach that I like is to use something like Firebase that handles the authentication and data. haha I wouldn't say that I am better than you. Your explanations are perfect 👌 It does take a lot of hard work. We just need to keep pushing

[@mohankadam1070]

how you implemented the alert feature after clicking the submit button on add user page

[@anithakadri133]

Thank you so much for making this video as well as for the related learning URL's. Awesome! Very clear explanation. Really helped me to understand node js + MySQL database combination.

[@ankandas]

I've completed this tutorial and just finished building it. This is super cool and easy to kick start my node.js journey. Got more values along the tutorial . please make more video on Nodejs + Mysql database. Take Love bro!!!!!

[@RaddyDev]

Glad to hear that you found it useful. Node.js is pretty awesome! I am definitely going be making more Node.js videos soon. Thanks for the comment!

[@ankandas]

@@RaddyDev Appreciate it man !!

[@raphaelmunaki226]

How can I host this application together with the database for free, it's for my portfolio

[@thedestruction67]

Just finish building this. Thank you very much for this.

[@guilhermeagostini9247]

Very good tutorial. Thanks!

[@RaddyDev]

I am glad that you like it. Thanks for the comment!

[@arzoobapna5148]

i did this for a school project to try out nodejs. worked out amazing. great explanation! works perfectly. this was great for learning and practicing as a beginner. i even like nodejs now! thanks.

[@RaddyDev]

That's great to hear, Arzoo! I am glad that you like Node.js now. It's pretty cool and very powerful. I appreciate your comment, thank you

[@raphaelmunaki226]

How can I host this application together with the database for free, it's for my portfolio

[@Gui.castro]

"Ok, the search input has no name yet, let's call him John!" Hahahaha Very nice video man, thanks for the content, I've followed along using a remote mysql database and it worked perfectly!

[@RaddyDev]

😃😃😃 Thank you!

[@kooyaw4445]

I've been tasked at work to create a similar thing, thanks man

[@RaddyDev]

I hope that you find the video useful. Smash the like button and consider subscribing! PLEASE READ THE UPDATES BELOW & Also Included in the written article. 🙂 👉 UPDATES 1) The bodyparser is now deprecated. Everything still works, but you might want to update the following: // Parsing middleware // app.use(bodyParser.urlencoded({ extended: false })); // Remove app.use(express.urlencoded({extended: true})); // New // app.use(bodyParser.json()); // Remove app.use(express.json()); // New 2) Express Handlebars has been updated and you might get the following error: exphbs is not a function referencing the code line " app.engine('hbs', exhbs({extname : '.hbs'}) Fix: 1) Update to 6.0.1 2) At the top of 'app.js' add: const exphbs = require('express-handlebars'); 3) Replace the Template Engine Code to: const handlebars = exphbs.create({ extname: '.hbs',}); app.engine('.hbs', handlebars.engine); app.set('view engine', '.hbs'); 😒 I didn't use the ConnectionPool correctly. I am planning to do a follow-up video. Sorry! 😒 You don't need the MySQL connection in app.js as we will move it to the controllers.

[@bhargavsolanki6386]

Pls help me raddy😭🙏

[@RaddyDev]

@@bhargavsolanki6386 Hi, what do you need help with?

[@bhargavsolanki6386]

{{{body}}} tag is not rendering page

[@RaddyDev]

@@bhargavsolanki6386 You could reference the code on my blog or Github. Alternatively, feel free to zip your code and email it to [e-mail]

[@arzoobapna5148]

@@bhargavsolanki6386 did it work? I have the same issue

[@oliviazhai1831]

Thanks so much for making the video! I love this tutorial. You save my lifeeeeee

[@RaddyDev]

Thanks for the comment, Olivia! I appreciate it and I am glad that you loved the tutorial

[@getcoded246]

Well done Raddy. I am new t nodejs world and look many tutorials before... but this one on target... Its like I just waste so many days on other tutorials

[@RaddyDev]

That's great to hear, thank you!

[@ampinkus]

Hi Raddy, excellent tutorial, just what I needed to start with a NodeJS full stack using MySQL. Wish yo a great year 2024!

[@RaddyDev]

Thank you and I hope that you have an amazing new year!

[@codepractices7]

man you saved me at my internship. thanks a ton

[@RaddyDev]

👊😎

[@lolofghiol9587]

Mr. Abbas brought me here!!!

[@RaddyDev]

Много благодаря на Mr. Abbas за подкрепата 👊😊

[@weachris7412]

BRO , you are a LEGEND

[@RaddyDev]

haha thank you

[@andreasrother428]

Very very good explanations- Will help me a lot when the next project comes up.

[@RaddyDev]

😎👌

[@aemde]

thanks for updated code in source files

[@RaddyDev]

No problem. I am sure that some parts will be out of date again... it's hard to keep up

[@livingston8267]

I am a intern and i was assigned a project. I had to make use of node js, express, handlebars, mysql and my part was working with database itself.. And bro literally you helped me with this.. Thank you so much.. Greateful to you❤

[@RaddyDev]

That's awesome, Lobo! Glad that you found the videos useful for your project. I wish you all the best with your internship! You'll smash it 👊😎

[@khari_baat]

Great work Raddy! Thank you so much for your contribution.

[@barreddimensions7155]

Thank you so much. This is really helpful. ❤❤ Also you can write the start script as -- "start": "nodemon app.js -e js,hbs" This restart the nodemon everytime you save the hbs and js file.

[@RaddyDev]

That's a great tip I will have to try it. Thank you!

[@gabrielleon2545]

indeed the best I have ever learnt so far. Good and cool

[@RaddyDev]

Thank you!

[@mytourx]

Honestly this is the best video ,thank you man.

[@RaddyDev]

That's really kind of you to say! Thank you, I am glad that you liked the video!

[@florenti1529]

Great tutorial I learnt a lot of things on this, Thanks Raddy!

[@RaddyDev]

Glad to hear it, Florent! Thank you for being here

[@raphaelmunaki226]

How can I host this application together with the database for free, it's for my portfolio

[@jredvaldo1976]

Great man!!! Good job!!!

[@RaddyDev]

Rock on!

[@four.letters]

Thanks man, the video is really good. Just finished it today.

[@RaddyDev]

Thank you! I am glad that you liked the video. More to come

[@mcaddit6802]

Worked for me!!! cheers up, keep it up buddy.

[@RaddyDev]

Great to hear! Thanks for the comment

[@RahulSharma-ke7wg]

I just want to thank you for this video.

[@RaddyDev]

I appreciate it, thanks for the comment!

[@ncv-nocopyrightvideos4475]

This is one of the besttt video available on Internet💯❣❣❣

[@RaddyDev]

Thank you so much! 👊😎

[@ncv-nocopyrightvideos4475]

@@RaddyDev ☺☺ from now 24/7 i'm going to be on your's channel🤭🤭

[@charlenepeters2423]

This is an amazing video and one of the first repos I have been able to work through and figure stuff out. I just needed to add the correct password in the .env file that I had to create from downloading the github repo and add the schemas manually and it worked like a charm!

[@Gadrawingz]

Great tutor to learn from.

[@RaddyDev]

Thank you

[@kurtreicelnunez3482]

Thanks for the effort for making this

[@RaddyDev]

I hope that you found it useful. I am working on a more interesting one using MongoDB. Stay tuned 🙂

[@JamilAlqam]

Many thanks for this awesome video

[@pybest9932]

Congratulations for this great work A march of days and months that you presented through an interesting, clear and interesting video Thanks

[@RaddyDev]

Thank you! Cheers!

[@dev.antunes]

Thanks a bunch, Raddy! You helped me a lot!

[@RaddyDev]

I am glad that you found the video helpful, Thiago. Thank you for the comment!

[@betelhemtesfaye7838]

It is the best tutorial with simple teaching approach. Thank you.

[@RaddyDev]

Thank you, Betelhem! 👊🦍

[@codewithabdullah3496]

So grateful

[@codewithabdullah3496]

Sir I need you to guide me about how to implement login system with register, profile, logout, and update/retrieve information. Using nodeJs MySQL

[@Rmch456]

as a UFC fan i approve this list haha, thnx bro helped me alot

[@RaddyDev]

Thanks, Ronnie 👊😎

[@josefvillanueva3671]

Error: ENOENT: no such file or directory, open 'C:\Users\User\Desktop\smu-prj\server\views\layouts\main.hbs' having error on app.get //router 18:24

[@RaddyDev]

It's because you've put your 'views' folder in a 'server' folder. Remove the 'server' folder and it will work. Alternatively, look at the HBS documentation where they show you how to set a custom folder. I hope this helps!

[@ahmedbar5233]

Great , very useful and very helpful video , Thanks alot ...

[@RaddyDev]

Glad to hear that, Ahmed! Have a great weekend my friend!

[@tuanatnguyen6199]

mình thích những video như này😊

[@hectorjuliocastro4922]

The best of the best

[@RaddyDev]

Thank you! Glad to hear that you like it

[@ankesh251]

Thanks for the detailed video mate, better if you also would have covered login and authentication.

[@randomdude0nyoutube]

If you run into the error `TypeError: exphbs is not a function"` setting up app.js Change `app.engine('hbs', exphbs({ extname: '.hbs' }))` to `app.engine('hbs', exphbs.engine({ extname: '.hbs' }))`

[@architjain9935]

thanks for this

[@geeteshdubey3047]

tHANKS @JULIUS!

[@Fayzibe]

thanks a loooot, man)

[@CarolinaNT]

thanks, that worked!

[@mcloughman]

That's a big help

[@wattown]

Great video!

[@RaddyDev]

Thanks, TimeCrunch! Glad that you like it

[@sopdahassan3982]

Thank you very much for this awesome tutorial! It was very useful, Keep it up! :-)

[@RaddyDev]

Thank you, Sopda! Glad that you found it useful 😌

[@raphaelmunaki226]

How can I host this application together with the database for free, it's for my portfolio

[@leslymahagueheme7283]

Thanks so much it has really helped me for my project...

[@RaddyDev]

Great to hear that! A new one using MongoDB coming soon!

[@costiptr4505]

Thanks a lot! The best tutorial!!

[@RaddyDev]

Thank you, Costi!

[@Livanskiy_tv]

Tnx, i completed this project :)

[@RaddyDev]

Nice work! Now build something cool with the knowledge that you've gained

[@xfilercuba]

Thank you very much for this knowledge bro!

[@RaddyDev]

Thank you for watching, Silvano! I hope that you build something awesome with it

[@luvameta1492]

Code: 'ER_NO_DB_ERROR', errorno: 1046, sqlMessage: 'No database selected', sqlstate: '3D000' , The data from user table : Undefined. Hey i am running into an error and I'm stuck (I have no idea about this)

[@RaddyDev]

You need to select a database. Double check your database credentials such as name. And obviously make sure that you have the database created and so on

[@luvameta1492]

@@RaddyDev Thanks Mate! It Worked. 😇

[@ZahidAli-jz9gs]

Subscribed really Awesome ❤️

[@RaddyDev]

Thank you, Zahid! I appreciate it

[@AViStudioMoldova]

Man you're awsome! U just gave me the solution for a project i'm trying to develop! Thanks a lot!!!

[@RaddyDev]

Glad to hear that! Happy Halloween!

[@AViStudioMoldova]

@@RaddyDev Subscribe from me on YT and Insta!

[@AViStudioMoldova]

@@RaddyDev Hi Raddy! Tell me please, if I need to load different js files for different pages , where should I add link to them? And how about AJAX requests in this case (jQuery for instance), how to render jus a small piece of data , not entire page, using handlebars? Thanks!

[@adityadas5138]

Great video, helped me a lot ❤️ Thank you 💗

[@RaddyDev]

Thank you, Aditya! Glad that you found it useful

[@md.taufiqurrahman6819]

This is amongst the best tutorials available on the internet. Thank you so much. But when I delete the user then its ID did not maintain serial. how can I resolve it?

[@RaddyDev]

Thank you for saying this! What do you mean when you say maintain serial. Like if you have 1,2,3 and you delete 2, you are left with 1,3? That's the way it should be. Every id should be unique and that's not a problem at all

[@md.taufiqurrahman6819]

@@RaddyDev But I need 1,2,3 serial. like I delete 2 then 3 replace it 2. how can I do it?

[@RaddyDev]

@@md.taufiqurrahman6819 You shouldn't have to do that. It can get fairly complex and inefficient in a relational database. What is your reasoning behind this? If it's just to look pretty, remove the id column or you can use Ordered Lists with CSS - ol.

[@uknowwhoiam4232]

At 1:00:15 I got error: TypeError: (depth0 || alias3).call is not a function Would be great if you could help.

[@RaddyDev]

Double check your handlebards code. Don't leave things like this " {{ this. }} ", make sure you use a pair for example " {{this.email}} ". I hope this helps!

[@mdohidulalam566]

Wow 😍 video helped me a lot ❤️ Thank you

[@RaddyDev]

I am glad that you found the video useful. Thank you!

[@usama_khalid]

thanks bro. it's very helpful...

[@RaddyDev]

Glad to hear that! Thank you

[@siam734]

Thank you very much for this awesome tutorial! It was very useful and helped me a lot! Keep it up! :-)

[@RaddyDev]

More to come! Thank you very much for the comment!

[@8ashastiraagavk.g760]

@RaddyTheBrand bro can please make this video simple with ejs and with few files can you please please please please make it soon i have freelance order please the no such good video on the internet

[@RaddyDev]

@@8ashastiraagavk.g760 ah bro, it takes a lot of time to plan, create, record, edit and publish a video. I haven't been able to publish anything in the past 3 weeks as I am currently struggling with time. You could use the MySQL queries and logic from this video, and just use EJS. I have a few tutorials on EJS that will get you going. Feel free to join us on discord if you haven't and if you get stuck, you can always ask questions. Don't rush it, take your time and you'll get there. I understand that there is a little bit of pressure, but you'll smash it

[@siam734]

​@@RaddyDev Just want to give you some more feedback. It has been 6 months now when I started my little project with the help of your tutorial. It's now pretty big with a lot of new features I've added. We're actually using this now in our company to track tasks what needs to be done (so it's kinda a Task Management System). It improved our work flow extremely. So, again, thank you so much! You definetly deserve a lot more subscribers! Keep it up!

[@RaddyDev]

​@@siam734 wow that's pretty cool. Glad that you made good use of it. Feedback like this definitely inspires and motivates me to make more videos. Thank you for the comment!

[@nikunjpadia2970]

Thank You, so much a great video

[@merdanbazarow221]

thanks a lot of . this cource helped me

[@RaddyDev]

Glad to hear that

[@faviocabral2675]

the best tutorial with express-handlebars thats great , just I would like to know how would you do it with login you will create in a home page and then go to the main page where the dashboard is it ? thanks

[@RaddyDev]

Thank you! There are plenty of options for login. Maybe you could try something like passport. I think that there are some tutorials on this already on KZbin. I will have to make soon. The issue is that, it could get complicated and long. You could beast a login system fairly quick tho

[@faviocabral2675]

​@@RaddyDev thanks Daddy I have saw it yet at another tutorials

[@octavioteixeira8304]

I learned a lot by watching the video, which is well constructed and enough explanatory. I re-wrote the code to apply it to my case and it works perfectly. But I am struggling to adapt it to have move active navigation links and execute the CRUD operations on other tables. No luck…. Can you please suggest an approach to achieve this? Many thanks, Octavio

[@RaddyDev]

Glad to hear that. Are you talking about a pagination or actual pages that you struggle to create?

[@octavioteixeira8304]

@@RaddyDev Many thanks for being so kind and spend your time in responding. I was able to reproduce your code for a specific table of mine. The fact is that I need to use it on other tables by adding another nav-link and following the same code steps and structure to deal with this new one table. I was no lucky because I think you designed you code to apply to just one table...and also because I am new to this... Many thanks Octavio

[@RaddyDev]

@@octavioteixeira8304Any time :). If you wish to create another page with another table the process would be the same. There are no limitations of what you can do with pages. You can create a route / page and then do a database query to grab the data that you want and then display on the page using handlebars. If you have Discord, feel free to message me and hopefully I'll be able to help. The link should be under the youtube about section or alternatively it's on the side of my blog

[@octavioteixeira8304]

Many thanks

[@octavioteixeira8304]

@@RaddyDev Carefully followed this video a second time and now I have a fully working web app dealing with the management of a local lodging company. Thanks a million and congratulations for your excellent explanations.

[@ramyokasha3092]

thanks for sharing this

[@RaddyDev]

Thank you for watching, Ramy!

[@aliahmad4132]

Very Nice Sir

[@RaddyDev]

Thank you, Ali!

[@balizaz]

Could you please make a video connect to SQL Server with MVC like this?

[@RaddyDev]

I did that a while back, but it's probably out of date. It should be under my NodeJs playlist if you wish to check it out. Also I am pretty sure that I did a written blog post as well. Could do a refresh at some point, but it might not be soon

[@chamilsachintha9698]

Thank you so much!!!

[@RaddyDev]

👊😎

[@viniciusfranciscopradosilv2121]

Excellent!! Thanks for share. Help me a lot! #subscribed

[@RaddyDev]

Thank you, Vinicius! I appreceate that

[@shimailakhan5730]

hi raddy, If i start mysql in xampp at 3307 port, do i need to change anything in program ? as i am not able to start mysql in xampp at 3306 port 1:53:16 [mysql] Port 3306 in use by "Unable to open process"! 11:53:16 [mysql] MySQL WILL NOT start without the configured ports free! 11:53:16 [mysql] You need to uninstall/disable/reconfigure the blocking application 11:53:16 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port this error is coming , PLZZ REPLY

[@RaddyDev]

No that should be fine now as long as it runs. You've changed it to 3307 which is good. What errors are you getting now?

[@79_rishabhrajput_cs96]

app.engine('hbs',exphbs({ extname: '.hbs'})); TypeError: exphbs is not a function this error occurs

[@RaddyDev]

this comment just popped up now and you posted it 3 months ago lol. I hope that you solved the problem

[@jayaatkakkar2701]

Can you please create a video in which you take File control tool in form and collect data in backend

[@RaddyDev]

I created something like that recently but I sued React as the front end. Maybe you can take the NodeJS part and just do the front end in the language that you want. It's the MERN Books one - MERN Starter Tutorial for Beginners

[@jayaatkakkar2701]

Thank you I will check that out ..

[@Princyy]

Insightful Reddy ;

[@RaddyDev]

😀 thank you

[@amazingstuffs937]

Awesome work. But I noticed the Handlebars only work in the terminal (I use vscode). It does not render to the browser. I did all possible manipulations I could but still didn't work. No error with database connection either. Kindly help.

[@RaddyDev]

What do you mean by Handlebars only working in the terminal? The rendering is done on the server level if this is what you mean. It's not like Angular or React where is a client side rendering. The closest language I can think of is probably PHP. To make it work you need to install "express-handlebars" and "express". Let me know what happens and I will try to help :)

[@nomadsoulkarma]

at 43:50 when trying to connect, my error message is 'Connected as ID undefined' I checked code, pool, database name and just about everything else. I don't know if it is because I've never used a password for my localphpmyadmin and just use root as a user? Is ok to say DB_Pass = ""? not sure how to deal with this. There are no other errors, just not connecting. Was wondering if anyone else has this error? I don't want to carry on until it's fixed

[@RaddyDev]

I would assume that it's the password. Just add one and try

[@nomadsoulkarma]

@@RaddyDev Sure will, thanks for the quick reply.

[@nomadsoulkarma]

If anyone has this problem with the password here's what I did: in the .env file I deleted the password variable and in userControl.js I commented out the password process in the pool. Not a good thing to do on the real Internet for sure. But it connected. I tried leaving the DB_PASSWORD null but it kept yapping for a pwd. I didn't want to add a pwd to the database, I break things too easy. I'm from php but this stuff is new for me. --BTW great stuff Raddy. Thanks and Cheers Mate

[@elizabethflores6007]

Hello. I am new at programming. Thanks for share this tutorial it is help me a lot. I have a question, Why I could not get the Hello word that you get in minute 20???? And I have to intall bootstrap in my computer???

[@RaddyDev]

Hard to say without looking at the code. Do you get any errors? You could reference the code on github. Hopefully that would help

[@habeebka2328]

good work

[@RaddyDev]

Thank you!

[@habeebka2328]

@@RaddyDevplease more vedios for grid with multiple control

[@umeshvishwakarma2973]

Love from india 😎🤟

[@RaddyDev]

👊😎

[@umeshvishwakarma2973]

Super bro 👍

[@RaddyDev]

Thanks, brother!

[@coyotearbjj4949]

Solid tutorial, thanks a lot for this! I'm trying to implement a login/register on top of this, with a jwt token stored in localstore. Would be awesome if you did a tutorial in this same subject, maybe using this same CRUD! New sub

[@RaddyDev]

I've started one a while back and left as it was taking too long and I was a too busy. I need to make it happen

[@raphaelmunaki226]

How can I host this application together with the database for free, it's for my portfolio

[@bayasgalanmongolia970]

Thank you for this video, I'm just start learning node.js, I'm using adminLTE template, but not working bootstrap, css?

[@RaddyDev]

Make sure that your styles and and js required is linked

[@RetroFortniteZB]

Thanks 🔥

[@RaddyDev]

Thank you for watching 🔥🔥🔥

[@pcprodoc]

This was a learning experiance and a half. I am going to dive into this more later on and see why things were messing up as I was building this. Did not make sence as to why I was getting some strange errors. Mainly do to typos from trying to type too quickly to keep up. But in all, it was a PIA in these new updates. Is there a new version of this out here somewhere perhaps?

[@RaddyDev]

One thing that you can do is to use the same versions as me on the video. Later on, you can update everything and try to solve the problems. Unfortunately, that's the reality with NPM packages. At some point, I will re-make a few of my Node.js videos to have them up to date as much as possible. No new version at this point

[@kiarashclassic]

Awesome tutorial, Thanks so much ♻️ please post a video about file structure in the server.

[@Busyboy_shubro]

please make a video on async await promise with mysql2

[@RaddyDev]

Okay, no promises but I've added this to the list. Pun intended 😎

[@yusufumar6738]

Thanks for this video. It helps me so much. What if I want to include an admin account with authentication(register and login) then each admin can add his own separate user like(one to many relationships) Can you please add that this video. Thanks

[@RaddyDev]

It's something that I want to do, but it takes so much time to create a full-on authentication. I started doing one a while back and I might have to pick it up again. Thanks for the comment, Omar!

[@yusufumar6738]

@@RaddyDev thanks for your response. I will be so glad so see that.

[@raphaelmunaki226]

Thank you so much! How can we create a simple login page here

[@RaddyDev]

For yourself as Admin or so people can register and use your platform? You could use Passport js, or any modern auth platform, like Auth0, Clerk Authentication, Firebase etc...

[@renesalvacion6169]

Does phpmyAdmin and workbench work the same when it comes to syntax for mysql?

[@RaddyDev]

SQL is the programming language. MySQL and Workbench are the database management tool. In short, yeah you can use SQL for both and the syntax is exactly the same

[@renesalvacion6169]

@@RaddyDev does ejs use curly bracket or they use greater less than symbol?

[@RaddyDev]

@@renesalvacion6169 EJS uses the greater and less than symbols " " and Handlebars uses curly brackets " {{ hello }} ". I like EJS, but I find it really hard to type. I think that you can modify the symbols to whatever you like. It would be funny if you modify it to "" :-D You also have other options such as Pug, Haml, Nunjucks, Blade and a few others. A lot of choice!

[@tanphathuynh2222]

why when i create a user, the database in my mysql workbench shows up, but in the home.hbs section, it doesn't show that user

[@RaddyDev]

So you have the data in the database, but you can't display it on your home page? Double check your query and start simple. Even do it manually to check "SELECT * FROM user WHERE id = 1" (example). Then console log the rows to see if you get the data. Let me know if you struggle, I am here to help 🙂

[@suryaprakashrao7749]

There is an error occuring that exphbs is not a function

[@RaddyDev]

That's because handlebars was recently updated to 6.0.X... You can either use the version that I have in the video, or you can upgrade the code slightly. If you want to use the latest change: Replace with this at the top: const exphbs = require('express-handlebars'); Replace with this in the middle: const handlebars = exphbs.create({ extname: '.hbs',}); app.engine('.hbs', handlebars.engine); app.set('view engine', '.hbs'); There is also a note on my blog. Unfortunately, I can't update the video unless I re-record it which is not an easy task

[@suryaprakashrao7749]

@@RaddyDev sir i have changed only const {engine} = require("express-handlebars"); And code worked Currently i am in a internship you saved me. Thank you

[@RaddyDev]

Good luck with the Internship! I hope that you have a great experience and learn a lot

[@amritamazumder7335]

What should I do if for adding user, the data is getting stored in the database, but not showing on the user table on the browser.

[@RaddyDev]

Since our View user query is set to only show active users, make sure that the user that you are storing has active status set on it. SELECT * FROM user WHERE status = "active" You can remove the "WHERE status = "active" " and see if it works like that. I guess it's gonna be something to do with that section of the code. Let me know how it goes and I hope that you fix it

[@lexxsumy]

thanks, nice tutorial! but please explain much more about all tech. things, ex. routers, javascript engine, etc.

[@RaddyDev]

Glad that you like the tutorial. That's a good point. I will try to include more information in the next one I make. Thanks for the feedback, I appreciate it!

[@Mike-vz8de]

How to custom the CSS to affect the Handlebars template? Once link to the CSS file under public/css/main.css then it has no any affect to the page. Please advise.

[@RaddyDev]

If you have statics files served from your "public" folder then the link becomes "/css/main.css"

[@goncalo05]

Hi, I was watching this video until the part you use the DELETE with get. This is not correct at all and I tried to search how to really call the delete method in NodeJS. Could you please tell me how to do it? And how can I verify the body fields?

[@RaddyDev]

That was meant to be router.delete instead

[@goncalo05]

@@RaddyDev But how I send tha action on HTML?

[@brian21m30]

If using EJS instead of Handlebars, rather than changing the format as EJS and edit a code in app.js then have anything need to change in .ejs and Controller? Thanks

[@RaddyDev]

The controller will be fine, but you do need to change all EJS pages to handlebards. The extension of the files and the code inside