Build a Project using Node.js, Express JS & MySQL🔥

Hello what's up guys today in this video we will see the back end project using my sequel and nut jas and for the front end we are going to use ejac and caa so guys i would like to tell you that this project which you are seeing URL short, you have seen it at many places It will be where you can add anything here cf.com is basically my IT institute where we take online classes, suppose I have written Thapa blank here, okay I am just writing Thapa and if I click on the shortcut for this Let me give it to you, boom guys, you can see at the bottom, if you look, just now my QRL shortner has been created for what I had created, so right now basically my URL is already short, so there is no such thing We did not have any issue, but yes, if tomorrow there is some such URL, guys, it is very big, right, then if you look at it, if I write it in short, then you will see that guys, at least it is giving a little bit of impact. Hey right, we made this big thing so small and the best part is When you host it live, the local host will not be 3000, whatever your domain will be, let's say it will be short.com or something like that, so this we created was created with the help of first nut as then express then Express plus Mango DB then express plus your Mangos so today we are going to create this through node jas ps express plus my sequel yes guy so my sequel database today we are going to create this whatever user is writing here How can we insert its data and then once it is inserted, how can we read it and display it here and redirect it, so the video is very important but before that I would also like to say that yesterday I watched the video I had uploaded it where you can see guys this video is one how you can work in My Sequel in one video work bench second this one is how you can put both of My Sequel Plots Notes GS together guys connect them The basic code operation that is done in it is called You can perform, believe me, this video is very important, you are going to enjoy it a lot, so guys, now let us start the video without any delay and if you have not checked out this playlist then definitely check it out, okay Hey all right guys so you can see that I am back on my Wasacode editor and this is my previous code through which we are running now in which we used Mangoo okay so seeing and understanding the folder structure is very easy It is more important that first of all we have a config, there is a folder inside which we have our database file and then the validation that we do is here, both of these files will come here, basically the connection one. Code end here your root validation will come and what should we validate our navi variable that your port should be like this ah whatever this is now I am removing it we don't need it you should be the ure string of Mango dev so basically all All these strings must be there in this manner and here I have created the host user name, password and database name and if you see, we have a new file over here. Now we can note in which we can also use n directly. You could also need to install a package for This is the Beauty Elsewhere Palace, so here you can see very clearly that it is in this manner, in which I have just recently added this A that is visible, I have also added this recently, so Here the database host then equal to then your database name will come here, okay so you have to do it in that way, let me do one thing, I will show you something like this, your database host local host root, here I have put the password I have hidden it right now but now I will add that but equal to that and then you have to write the password. Now if it comes to your mind that which password should I write, then whenever you were on the workbench or when you installed my sequel, then You must have been asked for some password, I mean password, so look at this, you are your local host user, your root password, whatever you have here You enter the password here, just enter the same password here, simple, okay, then you can see that the password has come back here, this is it, so this is the only difference, there is nothing else, now I will go to my DV client, this is ours If we go to DV client, first of all we need to create a connection, after that we need to get the URL, I mean what the user is typing here, and store it in the database, and then read it from there and display it here. If necessary, here we are going to perform the guys insert and then read operation and I had already shown it to you here, if you remember, here I showed you in the complete note as in the sequel how you can perform that operation So if you have watched this video carefully then you must have got the idea, so again guys I will not delete it, I will comment, I do n't have any issue, so now guys what I want, I want to connect to my mall server, okay Hey guys how do we do it in notes, look at it guys Simply write import my sequel from my sequel okay and do two because we have installed the one with two and we are using the promise version okay second by default this root comes we don't need it okay here But we will go now this navi djs file we need it because this is where all our data is so do it this way import navi or this is it and guys remember one thing anytime if you node If you are working in react then it is very important for you to put dot js, if you are working in react then we did not need this one but here for some reason we need to write complete yes it is very important to give extension so Guys let's go with my sequel dot and for some reason I am not able to understand it, yaar, I am not able to think of a suggestion, no problem, so we have a sequel and create a connection, you guys have to give me some Kali braces, basically you have to create an object. You should look carefully here Like all this data which we had created here, copy it come here and paste it. Now this part which is visible, delete it and put a comma here. Now this can be done as much as you want. It is visible, I will tell you what to do here, first of all I need to write host and then it goes something like this, so navi dot yours has come, okay, in the same way you have to come here, this is your user, so user will be equal to navi dot basically say user then we have a pass password and this is it guys you have to write it in this manner only this is the syntax we can't do anything here okay and at the end we have a database So what did you write the name of the database? Here you have to write ok database, for that database and navi dot your database name is fine, so guys, that's all you had to do. Now this connection that you have created here, always remember one thing, in the sequel you create a connection and are using a promise version so we need to wait yes we Need to wait and yes now if this connection is successful then some response will come so we are storing it in a constant variable called DV and now I am exporting it this is It's alright guys, our connection has been successful but we haven't run it yet. Now one thing is very important here, first of all the moment, if you run it, then there is no guarantee that your database will be saved. It will be ready which means the connection will be successful but the database that you are adding here, we have not created that database yet so what are we doing or you normal guys can basically run it through the command yes you can create it else i will tell you okay look carefully you have to come to the work bench of my sequel i had already told you in day one how you can install it so you can see that guys i have enter password here But I have added it now one thing you have to keep in mind here is that now you are creating a project using my sequel the most important thing in my sequel is your database and then guys when you create the database then Inside we need to create a table because it's all about your relationship, right, so you need to create a table, then you will insert data on that table, which data, whatever the user is going to type here, and we need a URL in our table or One is URL and the other is short code, only these two are required. So first of all you have to create a database here. Now obviously we can create a database very easily, like create database and I have the name of the database here, in this way You can enter from here, okay, run it in this way, so boom guy see, at the bottom, you can see the create database URL, Han Shaner Han, my sequel is successful, right? Now if I refresh here, then you You will see that this is my project Look, the URL is short, my sequel, so we have created our database very easily, so no tension, I have added the name of the database there, once you create it, the second most important thing is that you double click on it. Do it very well, then you will see that one second for some reason, if guys anyone has an idea that how can I zoom this, how can I increase the font, then let me know in the comment section, I have n't figured it out yet. As for this, you just have to see one thing, whatever are the names of these databases, I have highlighted it in that database, that means I clicked it two-three times and now it has come on it, so I am on it, you see basically This is the command that I have to use in this way. Okay, now basically I have to use it in all these things. It means something like this. Okay, once this is done, then I have a code, I will paste it. I will do it here where you can see what is the name of the create table table Short han under links then it has an id whose data type is integer which will be auto incremented basically automatically and we have kept it as primary key we have kept this short code which is variable character at most we have kept it because it is a short code Not null and it must be unique this is very important and the URL so basically we are entering our own URL for shortening it so now guys we have kept it as 255 not null okay just do this much you have to select it highlight it in this way And then you run it and you can see it very clearly like we have created successfully inside which this is, so you can select star from we have a short underscore link, okay this is your table name, so we will save this Let's do it this way and we'll run it once and see what happens. You can see that what I wanted is the ID short code and then our URL. So basically the database has been created and our table has been created. paid now there is no tension, we just have no tension, okay and we have already connected it, it is not a big deal, now let it remain as it is, let it remain as it is here, meaning now this code is now I can run this, its simple meaning is now this is okay, alright, my work is done, connection is done, now we have to go straight to our controllers, so you can see that this is our controller, where, if you remember, this is it URL dot find then URL dot find and then we have this URL dot five is that all yes that was all so in Mongoose we had to change only these three lines of code but today in this video we have A models if you remember okay so model so this is my code if you look carefully now I am commenting it again I am uncommenting it don't re its source code you can get it absolutely free in description and comment section you will go and get it because all this I have already told you something about it, so now I am just converting it into my sequel database and there is no such thing, so here I will uncomment it like this, so basically what is happening is I am creating a Let me tell you quickly, okay, so this first function is get short page, so guys, what is happening here is that our main purpose is through this function to get the entire index file of our ejax file. And displaying the data that is visible and at the same time providing our data, that's all the work here, at the moment there's nothing else and we'll add our load links, basically the main data, here. I am doing it, that's it, okay, the second one comes with your post, where guys, now we get what the user has written and what we do with it is we check that brother already that short code, I mean short code, is available Is it there or not, meaning it has become a duplicate, so if it is not there then what do we do with it, we can do that in our database Let's save it, okay and then you can see the redirect to sort code, this is the code, I would like to tell you one thing, the main purpose of this code is that this code which you can see here, when I click on it So if I do that, we should get redirected to that particular website which has this short code, I have written its code here. Now why is this whole thing that you are seeing, I will tell you, this first function is get. In short if you look here then you can see it through host and then links so if I go to views index then you can see this here with the help of peas I can get whatever data is there and these are the links With the help of we have applied the map method, end one by one, this URL and then the short code, the short code and then the URL that you are seeing here, we are showing it in this way, so in these four places here, we have to see something There is nothing to do with the controller, all we have to do is that first of all we have to load the data and then our We have to send this ixed file there so that I can run the map and show it to you, you are understanding right, how easy it is, suppose we have a data, suppose we have four data here, I have four days, so this First, I need to get the data of these daily data and what I need to do is after getting it, whatever part is visible here, I need to share it with the index and when we have already passed the data, then it will run a simple loop. It will be easy, right? Now the only question is how will I get the data from my database into these nodes, so for that we have this particular load link function. Okay, if I click on this, I will go directly to my model. Earlier it was like this, I am removing it now, there is nothing to be done here, we just need to get this DV, so guys simply we need to import a DB by the way suggestion is coming. no, I am not getting any suggestion and that is yours, I will tell you dot forward s a dot dot forward s okay okay confide in okay this is it I just need this constant variable named dv from this particular file I will just copy that much you see carefully Now tell me guys if you want to read the data in the table in my sequel if you want to get it then which command will you use, tell me what you thought, that is it, I think I hope That at least 90 of you understood because I explained it very well in the previous video and that is nothing but we need to right select star from where from your table and you already know the name of the table and that is one The second was by doing short links, right? Or this one. Okay, this way short links are done. This is select star from table name. Now I cannot directly write this as it is, in nutshell we have to write it inside a paragraph. or single quote or double quote And before that what we need to write guy remember this much the command of sequel always returns promise so await db now I know why I had imported db dot we have one method which is important and that is execute this is it db d Execute So if you run this, guys now here you will get the data of the table and at the same time you will get the meta data of the field, so basically you get two data in the array, I have already told you, please check that in my previous Video so cost I am destructuring it daily and in return I will do it daily this is it okay so the way it happened was that I got the data from my table of short links, the first one of daily I got my index and returned it here. Okay, my work is done. Now what are we doing here? We need to insert the data into our my sequel database. If I give you some data and I do this. I tell you, now you You insert it on my sequel database, then what command will you use and if you remember, you are understanding, even though I am repeatedly telling this to you guys, I am saying this for your own good only because if you have answered If he gave it then it is good, if he did not give it, then you do not know how to accept it, it will not work just by watching the video, so I have watched this video very carefully, it is 31-30 minutes long, how much hard work must have been put in to make it. I have done this for you people, now take a look at this, I have explained in two ways how you can insert, one is your simple inline statement where in old times it was used to insert into table name then complete in this way The entire feed used to come there, then the values, then its data, but that is wrong, instead we are going to use the prepaid statement, I will tell you how it is and they cannot even do SQL injection in it, so I explained it in this video, please check it out ok anyways no i will tell you please watch carefully What we need to do is insert the data, so if we need to insert it then again, now I am writing the whole thing in one go, await dv dot we need to execute it in this way, you know this much we will have to do now See how to insert into your table, what is the name, short links, here you have to pass those fields, okay and what are the fields we have, we have a short code and URL and make sure that whatever is written there, you will get the same. You have to write it in this way and then we have a URL now here we need to write the values ​​and here put a question mark comma question mark then give a comma and inside an arrow you will put a comma in this way and then a comma so now give this Part is comma and then comma here how will you add the data, tell me so guys till now we don't know where that data is coming from and how will we get it but now you got to know the command, it was not a big deal here so cost end remember this much Whenever you use execute, I have told you thousand times that you get rows and fields, okay, out of which we don't need the fields, we only need the first element, so I am already destructing it and here I don't think it's too much, yes let's write the result, it will be better and return result, okay so guys now we come to our last query, where it is, what is get link by short code, here I Let me tell you, you can see that there is a query, okay, where our parameter is basically the URL, from there we are getting that short code, okay, whatever the user would have typed, we are getting it and we just check that. What are you doing, what is that URL, basically whatever that short code is, basically this short code, this Thapa which I am writing, does it already exist in my short code or not, for example, yes it exists here currently Do not think that no one would have written this to us here, when we read the link When I click, okay, it became blank very quickly, but if you notice, the local host is something like this, so I am getting this, I am searching in my database. I am asking whether this short code exists or not and if it does, if suppose it does not exist then we are redirecting it, meaning it is of no use but if it exists then whatever link Okay, whatever URL this link is connected to, you just redirect it to that URL, you see, let me go back to Link D Y Radolfzel, so we have this short code, so now I just have to check this. In my sequel's database, I have a short code. Okay, when the user clicks, basically this is that short code. If the user clicks on this or clicks on any of these, then this short code is me. I am getting it through my parameters now in your database it is fine basically the table that you have created Apart from that, you have to run the query to check whether this shortcode exists or not or is it already present or not. So now you should think carefully that how can you perform this type of query in My Sequel database. So you should know this much. You know you need to check, it means you don't have to insert, you don't have to update, you don't have to delete, you need to check, so for that obviously select, you know this, right we need to go with select star from your table What is the name of that? It's your short links. Okay, it's your short links. There is no problem till here that brother give me the data from this table, but which data do you want, where the where clause, now this short code that I am writing This is basically the short code of my table, this is its short code, you can see I have a field, it's a field, so is my short code equal to the short code, whatever the user has written, if this happens then you can give me a data Please return it. So this is my query. I don't need this anymore. So how will it happen db so it's await db dot we need to go with the execute okay now yes let's write this as well nothing happens in this also okay in this way where now this part is there I will give it a question mark end Put a comma here and see, I am already getting the short code, I will send it from above, okay in this way, now whatever this data is, we need to store some how and obviously you will get two data inside this array So I am getting the first data by directly destructing it and I will write a simple code here for you guys, where it is okay, where if this is the length of our daily data, if it is greater than zero, it means That short code already exists, so we are returning that row, I am returning the first index of that row, first basically you understand that the data here will be returned, if else is null here If it doesn't match then tap it, you know this much now. Look carefully now I go directly here, look carefully, I got the data, I have got all the data inside that link, okay you can check by doing console, if the link exists right then some data is sent to me here But it must have come and if any data comes to me it means it is true so if negative I mean true then if I use not operator then it will become false or not and in case if it becomes false then I mean look at that, no, it did not get highlighted automatically, it just got removed from the highlight, so this will return this part, whatever data you got, you can redirect it to its URL, okay, in this case here, if they That row match basically short quote does n't match so what are we returning null okay if I make this null then what will happen basically basically if I combine false with not operator then it will become true right opposite of false is true so when this becomes true then guys he will return this and go out and look at this now this Now yours is not getting highlighted so this is how it is working for you okay now you know about the insert one let us quickly see the load links there was no problem here I passed some arguments I am not doing it so the first one is perfect fine we have returned the rose it's a good thing okay we have returned it it went to the links here I also passed the links with the help of these links we can run the loop and complete that entire thing This one which is visible, we are showing this to you as well, there is no issue here, okay now the second one is whenever the user is filling the form, then what should we do after that, we have to store that data in the database, so For that guys you can see we can get it very easily with the help of already requested body and then here I am showing this part about load links one second again it's not a load link it's a save link okay So this part is load links, I am already running it because we We have already written its function where what are we doing, getting the data, once we have got the data, okay, after that you can see it here, now look at this function here, there is a function, isn't it here Pay we don't have any function and so this particular code, I am removing it. What we will do here is wait function name, let me do this for a second. This is the name of a small function. It's a save link, it does one thing, I do this here. But let me do it, it will be better and I am passing this data inside it, okay, I hope guys you are understanding it, it does n't seem a bit tricky, sometimes here, sometimes there, simple, whenever any post method If we are using post method to insert data then we can get that data very easily with the help of request body. URL and short code. URL and then short code is there and we can get the data. Final short code: Basically in case if we write short code then If you forgot then we are creating our own short code and giving it to you, okay so at least this I will add that part here, if it is a short code, else we will create our own and provide it, after that I will get the data from the database, if that data already exists. It is possible that that link and that data is already present, so guys will tell us that the URL with that short code already exists, so basically it's a simple concept, right, why should we add the same short code again and again, so that is happening here and At the end when everything is set up it is brand new now I have to store that data in database so I ran the function on which I am passing in the url and short code so what I do is in a second it shows me First of all I have to insert at the top, I mean I have to import, then over here, instead of links, here we have a URL and then we have a short code, okay so this is the URL and then this is the short code I will very easily add short code and we have this URL so guys This method is called a prepared statement where guys this can save you from the hacker and I would like to tell you one thing that you should not keep this string here because we have already got that data from above. Now this is equal and I had already told you that it is simple that if you want to redirect then this is the code for it, so that was all guys, this part of ours, I will remove it, do npm run and see, in my sequel to promise, this I am facing issue so let's check it out ok guys I want to tell you one thing that actually yours was like this so my bad and that's it guys that prettier was not working you have to write it inside double codes no big deal Now if I go here, still import connect db, one second connect db, where I add the file that is connected, okay guys, now by the way, we do n't need this here, we do n't need this and obviously there is no need for this either. is now Are you understanding us because this connect DB funda was in our Mangas but in my sequel I have already made the connection there and there is no issue now there should not be any issue oh my God ok it is running This is a good thing. Here, I would like to refresh once. Look, the data is perfect. Now, all the data has disappeared. Why? Because our My Sequel database is there. If I run it once again, okay, then there is no data at all. But now if I go here and write codifier IT, I am IT, basically our IT institute, if I click on it, then I am getting an internal server error, so guys we are getting an internal server error, okay let me do one thing, see, as far as I am concerned You know, posting bytecode means that I have to insert the data in the database, so whatever is there is happening right here, look at something or the other, there is no issue in this code, there is no problem even here, now the only thing left is right here now one thing we can do here is if you Remember this get links by short code, if you remember this code, here we are checking with the help of short code, does that short code exist or not, then why don't I copy this code And instead of this, if I paste this, now I am getting this link here only, whether it is there or not, now it is coming to me here, if it exists, then brother, that code already exists which We have written the short code in our table, it already exists, right, so now it has become so easy for us, right, let's try it once because as far as I can see, there is no issue in this Let's go here, codifier, I will write it for now and I will click on shortcut again we are getting internal server error here, just guys, please look carefully, binder meters must not contain undefined two, one thing I want to tell you guys, this is the bind Just understand the basics of parameters that If you are passing any code, basically passing any argument, then it is either null or undefined somewhere, you can understand it this way, okay, so look, it is simple, again we do it, so this is my code, more than this is my There is no code here, first get links by short code, we have a short code, short code, ok, there is no issue in this, we have already seen this, now there is no issue here, insert short link URL, short code at this place We have this short code, insert short link, insert short link and this is it, it happened well, here a simple issue happened that in the short code, the C that we have written is capital in the short code, which I have written here C It is capital, but guys, if you go to our code, the C there is small, now do one thing, this C, make it capital, then if Y becomes capital, then here it will also be your capital. So guys it will happen, it was a small mistake, it was a small mistake Okay so I guess now there shouldn't be any issue okay let's go back here I would like to refresh it once codifier and then it now let's check it out oh my god and boom guys see finally you can see that our This data has been added but still there is a problem and that problem is that whatever URL I have written here, I could not find it here, where is it, it is not there, where is it, like, forward it yes, are you understanding, then wait a second, there is a tap appearing there as well, so I want to tell you one thing, before I click on this, it will not happen, that is obvious, okay, let us run it here once and see, okay this is it So at least the short code has arrived, basically the insert work of that post is done, there is no issue in that, now pay attention to one thing, if I write it again then we will be checking what we remember in the middle. Check if this shortcode exists or not. Check the URL with that shortcode Already exists please choose inside means that this code, this code is correct so the only thing left is this and one more thing I would like to tell you that the data is not coming there, right guys let's do one thing No links, this is our data, let's check it out, after all we are getting it in the links, which are load links, in this basically we are getting complete data or not, now we will know here, I will tell you once Should I refresh it, even after doing just this it should come, see the data is coming to me, right, data, data ID, one short code and then the URL, okay, look the data is coming to me regularly, there is no issue with the data, so this means You are understanding guys, look the code is coming fine to me, there is no issue, so again short code and then we have a URL, okay and this is the data which I am getting complete, I have passed that to our index file Let us go to the index file, this is our code, links, oh friend, the same thing again You can see the problem here, we have made the same mistake, when we are destructing, the actual name of the table will be the same here also, so it's a short code, it's a short code, there will be no rest, I guess or This is it, this was the issue, if I refresh then boom guys finally we have this particular short code, now if I click on it then there is no tension, our codifier IT IT institute page has come up, so ya guys this is it for this video today That's all, I hope you liked the video a lot and it is a very good thing that when an error comes in this way intentionally, then we get to know where the mistake might have happened and specially, you have seen guys, if someone's project is already made If it is there then work in it and how much, although I made it myself so I had the idea but still just look at a small thing, how much time did it take us because of small mistakes, right but whatever it is, you finally got to know that with the help of my sequel to and With the help of Node Express, now you can finally create a backend project, what to say about a backend, how can you create a fully fledged project? Now this is your main stack kind of main stack where instead of React you are using EAC, then that You have made it and shown me, so guys, I mean I am sharing its sort, I mean source code, with you absolutely free in the description and comment section below, okay, so that you do not have any issue, no problem, but I also want that please You should also check out these videos of mine, please like the video and share it with your friends as much as possible and if you have not subscribed yet, then our next target is 8 lakh subscribers, please subscribe and there is a red on the right side Color bell icon a bell will appear, hit it, click so that you do n't miss such awesome videos daily, so I will meet you in the next video till then guys, so guys, I will meet you in tomorrow's video till then guys, thank you so Mach Tech K [Music]