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!
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
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 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 TH-cam 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
@@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
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.
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.
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!!!!!
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.
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');
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.
"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!
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
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.
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!
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 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!
@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
@@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
@@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!
@@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!
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?
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 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.
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)
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
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!
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
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 TH-cam. 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
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
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
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 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
@@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
@@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.
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
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!
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
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???
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
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
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' }))`
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...
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.
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 :)
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?
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
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
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!
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 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!
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
On the view more, let's say you have more than one table let's two. Now you need to view let's time events where every event has its date and you need to list them. The two tables share one common colum fileid. The issue is, if you query using mysql join statements, them yul only have the 1st record since there are files with similar id but repeated on a few occasions. How would you go by this situation to ensure that you have a Master id like in table one and all other records coming under this record.
You kind of answered your own question. You need a relational database where you can ensure one table links to another with a unqiue id. In this case we are working with users. Let's say that we want each user to have a rating table and maybe comment. User: id, first_name, last_name, email etc... Rating: id, rating, user_id (user link), comment_id (comment link) Comment: id, name, description It might be hard to visualise from this, so lookup relational database example. I hope that i have understood your question correctly
@@RaddyDev thanks alot fir your response. I was able to solve it using the same idea. I used the primary key foreign key concept and was able to relate the tables.
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?
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
@@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
It is such an awesome video. I have started my backend dev journey with this and found it to be awesome. Just one noob doubt, how come main.hbs is mapped to the home route. I don't find main.hbs mentioned anywhere in the app.js, user.js or userController.js . I rewatched the concerned portion of the video but couldn't understand it. Please help.
Glad to hear that, Akash. You can build so many things with NodeJs, I absolutely love it. That's because main.hbs is the default / basic usage of express-handlebars. So the views -> layouts -> main is set as default. You can always change it to whatever you like and you can change the layout to a specific route as well
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!
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 🙂
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.
Hi Raddy, I see you use only one table from the database, but how would you read in two tables from the database and put them on the same page and be able to edit,view,add and delete from that same page. Thankyou
Hey Ben, I see that you emailed me too. You can use SQL Joins to combine data from two or more tables. Both questions are fairly common and you should be able to get a lot of examples online. There are a lot of clean axamples on w3 schools under SQL
@@RaddyDev Ive tried looking online but cant really find anything, my task is to have two forms on same page, and the two databases going into a form each. I have my first table form working the way you have, but i repeated the code using a client controller but cannot get the second table data to appear in the form. I think it may be because I have used {{#each rows}} twice, would could i use instead of the term rows? or what could be the solution?
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
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!
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.
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
I was searching for some Node and MySQL combo, glad I found this channel. Awesome content u have bro.
Welcome to the channel 👊🦍 it's good to hear that you like the content. Thanks for the comment!
How can I host this application together with the database for free, it's for my portfolio
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
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!
That sounds awesome and thank you for the sub. What did you end up using for your login system? I like your channel btw 👊😎
@@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 TH-cam 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
@@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
how you implemented the alert feature after clicking the submit button on add user page
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.
Pls help me raddy😭🙏
@@bhargavsolanki6386 Hi, what do you need help with?
{{{body}}} tag is not rendering page
@@bhargavsolanki6386 You could reference the code on my blog or Github. Alternatively, feel free to zip your code and email it to hello@raddy.co.uk
@@bhargavsolanki6386 did it work? I have the same issue
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.
Thank you very much, Andreas! It means a lot!
How can I host this application together with the database for free, it's for my portfolio
@@raphaelmunaki226look into Render, they have free hosting
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!!!!!
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!
@@RaddyDev Appreciate it man !!
How can I host this application together with the database for free, it's for my portfolio
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.
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');
You have a small typo there, but I am sure that people will figure it out
@@RaddyDev once again thank you Raddy, it helped me a lot. I've edited the comment.
man, you are a live saver
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.
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
How can I host this application together with the database for free, it's for my portfolio
Just finish building this. Thank you very much for this.
In 2022 , 15:25 - app.engine('hbs',exphbs({extname:'.hbs'}) change to app.engine('hbs',exphbs.engine({extname:'.hbs'})
Hi Raddy, excellent tutorial, just what I needed to start with a NodeJS full stack using MySQL. Wish yo a great year 2024!
Thank you and I hope that you have an amazing new year!
"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!
😃😃😃 Thank you!
Thanks so much for making the video! I love this tutorial. You save my lifeeeeee
Thanks for the comment, Olivia! I appreciate it and I am glad that you loved the tutorial
Very good tutorial. Thanks!
I am glad that you like it. Thanks for the comment!
I've been tasked at work to create a similar thing, thanks man
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
That's great to hear, thank you!
Congratulations for this great work
A march of days and months that you presented through an interesting, clear and interesting video
Thanks
Thank you! Cheers!
Very very good explanations- Will help me a lot when the next project comes up.
😎👌
Great work Raddy! Thank you so much for your contribution.
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.
That's a great tip I will have to try it. Thank you!
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!
Great tutorial I learnt a lot of things on this, Thanks Raddy!
Glad to hear it, Florent! Thank you for being here
How can I host this application together with the database for free, it's for my portfolio
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❤
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 👊😎
Thank you very much for this awesome tutorial! It was very useful,
Keep it up! :-)
Thank you, Sopda! Glad that you found it useful 😌
How can I host this application together with the database for free, it's for my portfolio
Man you're awsome! U just gave me the solution for a project i'm trying to develop! Thanks a lot!!!
Glad to hear that! Happy Halloween!
@@RaddyDev Subscribe from me on YT and Insta!
@@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!
This is one of the besttt video available on Internet💯❣❣❣
Thank you so much! 👊😎
@@RaddyDev ☺☺ from now 24/7 i'm going to be on your's channel🤭🤭
Thanks man, the video is really good. Just finished it today.
Thank you! I am glad that you liked the video. More to come
man you saved me at my internship. thanks a ton
👊😎
Thank you very much for this awesome tutorial! It was very useful and helped me a lot! Keep it up! :-)
More to come! Thank you very much for the comment!
@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
@@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
@@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!
@@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!
Honestly this is the best video ,thank you man.
That's really kind of you to say! Thank you, I am glad that you liked the video!
indeed the best I have ever learnt so far. Good and cool
Thank you!
BRO , you are a LEGEND
haha thank you
Worked for me!!! cheers up, keep it up buddy.
Great to hear! Thanks for the comment
It is the best tutorial with simple teaching approach. Thank you.
Thank you, Betelhem! 👊🦍
Thanks a bunch, Raddy! You helped me a lot!
I am glad that you found the video helpful, Thiago. Thank you for the comment!
Thanks for the detailed video mate, better if you also would have covered login and authentication.
thanks for updated code in source files
No problem. I am sure that some parts will be out of date again... it's hard to keep up
Great video, helped me a lot ❤️
Thank you 💗
Thank you, Aditya! Glad that you found it useful
I just want to thank you for this video.
I appreciate it, thanks for the comment!
as a UFC fan i approve this list haha, thnx bro helped me alot
Thanks, Ronnie 👊😎
Tnx, i completed this project :)
Nice work! Now build something cool with the knowledge that you've gained
Great tutor to learn from.
Thank you
Many thanks for this awesome video
Thank you very much for this knowledge bro!
Thank you for watching, Silvano! I hope that you build something awesome with it
Great , very useful and very helpful video , Thanks alot ...
Glad to hear that, Ahmed! Have a great weekend my friend!
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?
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
@@RaddyDev But I need 1,2,3 serial. like I delete 2 then 3 replace it 2. how can I do it?
@@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.
Thanks so much it has really helped me for my project...
Great to hear that! A new one using MongoDB coming soon!
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)
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
@@RaddyDev Thanks Mate! It Worked. 😇
Wow 😍 video helped me a lot ❤️ Thank you
I am glad that you found the video useful. Thank you!
Thanks for the effort for making this
I hope that you found it useful. I am working on a more interesting one using MongoDB. Stay tuned 🙂
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
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!
Mr. Abbas brought me here!!!
Много благодаря на Mr. Abbas за подкрепата 👊😊
Great man!!! Good job!!!
Rock on!
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
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 TH-cam. 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
@@RaddyDev thanks Daddy I have saw it yet at another tutorials
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
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?
Can you please create a video in which you take File control tool in form and collect data in backend
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
Thank you I will check that out ..
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
Glad to hear that. Are you talking about a pagination or actual pages that you struggle to create?
@@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
@@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
Many thanks
@@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.
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
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
How can I host this application together with the database for free, it's for my portfolio
At 1:00:15 I got error:
TypeError: (depth0 || alias3).call is not a function
Would be great if you could help.
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!
Subscribed really Awesome ❤️
Thank you, Zahid! I appreciate it
Could you please make a video connect to SQL Server with MVC like this?
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
The best of the best
Thank you! Glad to hear that you like it
mình thích những video như này😊
Thanks a lot! The best tutorial!!
Thank you, Costi!
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???
Hard to say without looking at the code. Do you get any errors? You could reference the code on github. Hopefully that would help
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
I would assume that it's the password. Just add one and try
@@RaddyDev Sure will, thanks for the quick reply.
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
thanks a lot of . this cource helped me
Glad to hear that
Awesome tutorial, Thanks so much ♻️ please post a video about file structure in the server.
Thank You, so much a great video
app.engine('hbs',exphbs({ extname: '.hbs'}));
TypeError: exphbs is not a function
this error occurs
this comment just popped up now and you posted it 3 months ago lol. I hope that you solved the problem
So grateful
Sir I need you to guide me about how to implement login system with register, profile, logout, and update/retrieve information. Using nodeJs MySQL
thanks bro. it's very helpful...
Glad to hear that! Thank you
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' }))`
thanks for this
tHANKS @JULIUS!
thanks a loooot, man)
thanks, that worked!
That's a big help
please make a video on async await promise with mysql2
Okay, no promises but I've added this to the list. Pun intended 😎
Excellent!!
Thanks for share. Help me a lot!
#subscribed
Thank you, Vinicius! I appreceate that
Thank you so much! How can we create a simple login page here
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...
Great video!
Thanks, TimeCrunch! Glad that you like it
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.
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 :)
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?
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
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
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!
@@RaddyDev thanks for your response. I will be so glad so see that.
Thank you for this video, I'm just start learning node.js, I'm using adminLTE template, but not working bootstrap, css?
Make sure that your styles and and js required is linked
Does phpmyAdmin and workbench work the same when it comes to syntax for mysql?
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
@@RaddyDev does ejs use curly bracket or they use greater less than symbol?
@@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!
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.
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
Insightful Reddy ;
😀 thank you
On the view more, let's say you have more than one table let's two. Now you need to view let's time events where every event has its date and you need to list them. The two tables share one common colum fileid.
The issue is, if you query using mysql join statements, them yul only have the 1st record since there are files with similar id but repeated on a few occasions. How would you go by this situation to ensure that you have a Master id like in table one and all other records coming under this record.
You kind of answered your own question. You need a relational database where you can ensure one table links to another with a unqiue id. In this case we are working with users. Let's say that we want each user to have a rating table and maybe comment.
User: id, first_name, last_name, email etc...
Rating: id, rating, user_id (user link), comment_id (comment link)
Comment: id, name, description
It might be hard to visualise from this, so lookup relational database example. I hope that i have understood your question correctly
@@RaddyDev thanks alot fir your response.
I was able to solve it using the same idea.
I used the primary key foreign key concept and was able to relate the tables.
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?
That was meant to be router.delete instead
@@RaddyDev But how I send tha action on HTML?
There is an error occuring that exphbs is not a function
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
@@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
Good luck with the Internship! I hope that you have a great experience and learn a lot
It is such an awesome video. I have started my backend dev journey with this and found it to be awesome.
Just one noob doubt, how come main.hbs is mapped to the home route. I don't find main.hbs mentioned anywhere in the app.js, user.js or userController.js . I rewatched the concerned portion of the video but couldn't understand it. Please help.
Glad to hear that, Akash. You can build so many things with NodeJs, I absolutely love it. That's because main.hbs is the default / basic usage of express-handlebars. So the views -> layouts -> main is set as default. You can always change it to whatever you like and you can change the layout to a specific route as well
@@RaddyDev Thank you so much! You are too fast :)
thanks, nice tutorial! but please explain much more about all tech. things, ex. routers, javascript engine, etc.
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!
Very Nice Sir
Thank you, Ali!
thanks for sharing this
Thank you for watching, Ramy!
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
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 🙂
Thank you so much!!!
👊😎
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.
If you have statics files served from your "public" folder then the link becomes "/css/main.css"
Love from india 😎🤟
👊😎
Hi Raddy,
I see you use only one table from the database, but how would you read in two tables from the database and put them on the same page and be able to edit,view,add and delete from that same page. Thankyou
Hey Ben, I see that you emailed me too. You can use SQL Joins to combine data from two or more tables. Both questions are fairly common and you should be able to get a lot of examples online. There are a lot of clean axamples on w3 schools under SQL
@@RaddyDev Ive tried looking online but cant really find anything, my task is to have two forms on same page, and the two databases going into a form each. I have my first table form working the way you have, but i repeated the code using a client controller but cannot get the second table data to appear in the form. I think it may be because I have used {{#each rows}} twice, would could i use instead of the term rows? or what could be the solution?
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
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