Laravel CMS | N-04 | Migration, Models and Adding Categories

hey what's gonna nice how all you were doing welcome to the fourth tutorial on the tutorials use of making a control management system with lyrical however we are in the fourth joy of Thomas watch the last three stones make sure you watch them before coming up and watching this one this particular one we're going to talk about like you know models and but the database and how we're gonna use my sequel with laravel and all this kind of stuff and what is the model and how can I bring the data from database save it save the instance is the lay from it and of course we're gonna go to the little or our control measurement system and hopefully to the category think like insert a category and do a form and we put the category name just press ENTER and gonna be inserted in our database this is the basic think of model thing so little has a really basic or let's say a powerful a model a class that allow you to treat data also put data in the database and supports many database drivers such as my sequel which we're going to use in this particular case you can use any driver you want just search for Google level drivers for the databases I'm gonna have like my sequel my sequel I but I am gonna use personally for my projects my C or you can use whatever you want now for this or you gonna need to setup the database on your environment so on your project open up with code editor as I've said I'm using Visual Studio code feel free to use any code editor you really like now open up the dock environments and go ahead and search for this the environments fine gonna be used go to search for it as you could see this database came in connection by default it uses the my sequel and the house is on our localhost 127.0.0.1 the policy 3 306 and this is what your database name and the username and your password so this the environment found gonna be secret file so when you upload it or you deploy it into your server won't be available for public of course so it's gonna be hidden on the server no one can access this only you with the shell axis so with that we're gonna keep using my sequel and here puts your database name with that we need to create a database so i'm using exam in this particular case you can access your phpMyAdmin or see your databases using localhost first last PHP myadmin and you're gonna get you into this page where you can manage you all in databases data that has been stored in your database so or if you're not using exam make sure you search how you can access PHP myadmin or any other client uses by your software or something make sure just is the data basically database so I'm gonna create a sample database called little touch CMS for the sake of this tutorial then click just creates into the databases of course now under this database we're going to create like need from you to create tear tables so we're not gonna create tables that way this is kind of an odd way but you don't really want to use you can yet well what we are actually going to use is my gracious and my gracious is a model powerful very nice thing from their phone that supports talking or like managing tables in the columns on your database so let's say you do with my gracious then deploys in your server the mica is gonna run like automatically and clean up all of this like tables columns and set them all of you for you so you don't have to do anything right away so for that you're gonna need to use my gracious just after making the database leveled our CMS so you pretty much go ahead and go to you environment file and here gonna put the the database name then you'll be username of course I'm gonna hide this one for these guys this is very like sensitive data so then your password this all you need to do start doing a migration so migration allows to create tables and columns as I've set so for that you're gonna need to go ahead let me close this close the routes and for making us things like a bit tidy for the workspace and go ahead and file the folder called database and there that I'm gonna find on migrations folder in here all migrations all of your migrations gonna go into here so if you're a bit confused migrations there are very simple things just some structure or like my sequel commands gonna be done when you run like PHP artisan my grades gonna be run and just do or create the tables on the specified database and the columns as well for you so you don't really have to care about this when deploying or when moving your things from like let's say you're working on team so when sharing your files with the other team member you don't really want to have happen like grave this table create this column Yeti areata now it's gonna be done quite like my gracious and an automated way so gonna be very simple as I said go to migrations or pretty much we're not gonna create money we're gonna use the PHP artisan command line so make sure you are on your tie directory here the zamp and using the terminal so if you don't know about this again make sure to watch the last three styles before coming up into the fourth part so for this a subset PHP artisan and gonna make my raishin and we're gonna call it make sure you use can just cause instead of spaces between the words one name is the my creature so I'm gonna call creates and make sure you just put the name of this like what's what's is gonna be done by creating a table create the category table create the post it will create the admins table so I called while doing the card body specifically so then do is create category table simple says and we're going believe this all we need to do selfish person make migration and this is gonna do it for us just wait a bit second now create a migration and it's gonna append or prefix the days that this migration has been created on and now if you go to my gracious like you see create this creat user password are pre defined with layer of also if you going to use therefore authentication system this is gonna work for you very well but on the series I don't think I'm going to do a not really think so if we will do like another in series where authentication and login system will not be used this basic stuff we're gonna create our custom things because custom things are very powerful then this is very just basic things after its created successfully let me just minimize this and here as you can see there is the list class create category tables and it tells us a bunch of us illuminate so what's this illuminating is pretty much like saying this is the main core of level so level has pretty much a lot of files like support files which has a helpers that help you build your application so are all under this illuminate so illuminates holds all the L level core files so I'm like just using the schema gonna allow us to connect to the database and create tables on it and the blueprints as well just gonna allow us to create the table and increment great IDs column stuff and this is the my grades the main migration model which we're gonna extends from our class or extend from it so this has two methods one is up and the other one is down the cup is gonna be used for migrating for cleaning the table and the other one for dropping the table so you honestly don't really need this job thing table anyway but into some some it some circumstances you will so the best this is where you need to put your things like terrible increments is gonna create an ID and also increments ID column under the table of countable skitty so if you wanna like change this table name puts a little custom name here like table something gonna be creating your database but I'm gonna leave it as the category which gonna hold all the other categories on this mess so for that we're gonna say until a category gonna have a name so the name gonna have the strength of this so it puts a string here you can check out all the available blueprints methods gonna allow you to create the columns under the table by seeing did a lot of all documentation the all official learn of a documentation but just post by googling laravel blueprints and gonna gives you whatever you want to check out so for that I'm gonna create this called name and you can the second argument can accept how the maximum number of data are gonna can hold I'm just gonna keep give it to 200 okay and this is the same as available trial if you are familiar with databases on my sequel so like you're saying a variable china or string is pretty much the same thing another thing is gonna create as well as string all of our string and they believe is the author so who created this because let's even help much for authors that can connect okay or have access into this control management system or CMS so they should create this respectively like create categories they they should be authored for this category so who created that category so for this we're gonna call it author or we can call it created or let me think for a good name okay author can do the doctor so author and I'm gonna give it about 100 so the author name gonna just the maximum is a hundred you can just this is an optional thing to be done and this time steps thing as you can see like half table then time stamps is just like a time steps other two columns of the time step I created ads column in an updated time crunch so when you hit when you create this kind of this is gonna be for the table so when you creates or odd and you record into this table a time step or the creator are gonna be holding the created date and when you update this special specific record the updated aren't gonna be updated to the specific date you've done the update it's very simple so this time stems out just like a timing things it's very hopeful so you should keep it if you don't really or you want to use yours custom things just remove this and out of the date time time steps here you can use it and as upset you can check out the documentation now this is what I really want to do with that so we can take the name the author let me think give me a second thinking so have needed an author for the category and this is maybe we're gonna have in the features so like a subcategories with that particular category but I think so I'm gonna come in this is a kind of a simple thing as soon as you understand this you're gonna be able to do the other one in a very simple way now for migrating let me clear the screen for you to make it clear enough so we can use Oswald artist and so PHP also I'm gonna say Mike minutes so it cannot migrate this or microwaves and last things for us we're gonna create the table and access the noise for it's not gonna miss arts local host and using a password yes I believe I have a password misconception in here I can put in my password in the wrong way let me check this out guys give me a second so my green again so make sure you put your right password in there let's see when we have access violation but the migration table created successfully but we have also table the users if we don't really need to care about this because this is coming from the users migration file this uses a possible but our quit category migration is working pretty much file as we have seen here like it is working perfectly like migration table created successfully now go ahead and check out our database in here leveled our CMS and we should say users which created by default by level and half hour my gracious but there's no category thing I don't know this is a bit confusing guys let me check out what is going on exactly like something is wrong give me a second ice please now after a bit of direct nights and I've come with you like level has included like there was some kind of and users and migration migration files I've deleted them and that everything was going nice that because once comes in mind tries to my Gracie of your tables it finds an error in the first users table so it's stopping he won't like goes into the creek categories such one we weren't seen anything in the me in our table just the migrations of the e user so we can drop this yeah I don't really need them so like with the selected empty or drop okay dropping yes first drop and that should do the job perfectly so if you have encountered this error make sure you delete all the other languages just create your things like the users and the migrations pop just do the or you your created category migrations file give it that then do PHP artisan my grades and everything should goes in nice and smooth way as you could see successfully migrated now goes back refresh this and we should see the category of the my gracious migrations is being automatically added so don't care about this just care what the category now if we go to the category we see the structure of the author name the created as the updates add time sense that has been added automatically by level for us by this function as if time stamps now I've created this user migration and you have seen what migrations can do now let's move on into the model so model is pretty much like is a database table that an instance of data base to the table through wearable you can save your instance you can update it you can delete it as simple as that so when you create a record in here let's say you wanna add a category called web department and with an offer of is lumpiness and created arts ads 2011 2017 and updated as well 2011 2017 with an ID of zero or one and that you wanted to lay this so you're gonna use a model pointing to that and find it using the ID key or any other like here it's name or author or created to update that we don't usually ask both of these so we're just gonna use the name or the author already ID so they're always very very nice has a very nice collection and poliquin's class that's will help you through this so we're creating a models pretty simple we're gonna use this for this the instance of the category to do that make sure you are on the directory level and do PHP artisan make and for everything like we need make sure you append me then colon then puts a model so a model then name your model make sure the model is gonna be singular mono peeler plural very much sorry and gonna call it category and a couple case at the beginning this is all what we need to do so person answer that we're gonna create a model for us as you can see let's see what we have in there I mean one of these one create a model I'm sorry model within email and I so let me try this again so so if these guys make mando then I got a category as I've said okay Malo should be pretty successful in any clear screen for you and he goes up to the up and you gotta find this just in the app let me just collapse this and go find this category a model extends from the model and other category so for here we can specify which category so by default we're gonna look for the category as the name of the model pretty much so if your name is category gonna go ahead and look on the database for a table named category as we have in here but in case you have another like your model name is different from your database table means so what you can do is just define a protected variable or just specify which table you want so we can say protected not this so gonna table and you put your name of your table for me as a category so and this already need to do so this is the model for us this extends from that what pretty much you need to put under the model thing we don't need to put a lot of things in here maybe the fillable we will talk about this later on so for now this make it as simple as possible now after creating this I'm gonna need to use this point you would controller and for the controller need to make a return for the category specifically because we have just created the controller for pages controlled like for the static pages not for everything so or just for the dashboard and stuff but for this particular thing when I create a category controller which controls category adding removing an age a score we're gonna talk about this all of them on this series so with that as I've mentioned before so artisan make and controller I'm gonna name its category control and making it a resource okay we make it to Vsauce and Calgary controller should be created successfully clear the screen and we goes into the category controller now the index page should point to us or shoot redirect us into our category page and with that we're gonna return of you with name of I'm gonna create it under just let's see you got created under okay pages the category this is all what we need to do now let's go ahead and create this view blade file and we go into our views and the resources and find actually pages and like like new file category don't bleed from PHP okay now we've created the file let me just do the things like extend from the main up we're gonna say well up okay and push the section so mean - row section this is what going to put song so let me create a death as you can see here when I use this tab thing gonna Cora matically complete the elements for me so this called emits and freakin for you we keep the geared with Visual Studio code like from the laces village in Amman so if you really like it you can search for image entry a nice extension so let me put that I'm gonna use bootstrap with this so let me call them medal and I'm gonna give it's about to use it too so we're gonna give it to Nate and then give it to 90 all mean - accountable and simples this we cannot call or give it's all this is gonna be the header so category - later and here we're gonna give its niche for for kotti goings yep another one for like category - container okay and it is gonna be the keychain singles last we're gonna come back for this and create a form for adding categories so going over back into a file in heaven point is into a side area together to this so let me do that and before this actually let's go ahead and add our routes to the web dot PHP run so going to the routes web top PHP and specify all route for the category so categories let's create them and comment them to make it better for you to understand it when you go into the source code and they'll get huh make sure you see this look it helps I'm gonna just call the route for large category I'm not gonna give it to function as we've done in there now I'm gonna point it into the controller so I haven't done this for this I haven't done it for the dashboard actually so I will fix this later on for now now here we're gonna specify the controller name you know how about controller called category controller adds and this specify which function should kit takes care of so with that we have that goes back into the pages or the pages controller neurons not be just control so that's nice I mean the category control okay the category controller and now our index cell that go back into the routes that's odds index and you can name your route to us player on so naming the routes is really really useful for you to access the route when changing like changing the routes point what the rats actually spawn into so this is as I've said report very useful we can name it like category then dot index and this is mimicking is really nice I've used this a lot so make sure you follow this convention because it's very very helpful for you in developing and then there any circumstances actually so he has upset very simple now this is has been honored know what loves for us to do is actually get to the site area and we gotta find this in the deep hole site area and you should go to the category and here we should specify in which route and that's why we have named your route for this as I've said putting this rope deco just what's gonna be in the middle in there so in the middle up there so I'm gonna put routes and this watch function gonna return us about URL and route you're gonna put here the name of the route so the name of routes will be used in there like the category index we need to put it in there so category top index I'm gonna do the job perfectly now let's go ahead refresh our page and see if this is gonna really work for us now so go into the category just wait a bit of time waiting okay now the car going up we should press this gonna take us in the category and it should return okay we have a problem category or does not exist so it can't find let me see this class category controller does not exist can't find the controller is fine at the other but like category control or let's see let's let's see our controller okay you have category okay we're misspelling this so I'm sorry these guys we shouldn't do that so category missing on there and category okay now after make sure you type category correctly now should works perfectly a lot of problems actually profession no it should be taking us into the main page category and as you can see categories can trade and we're not seeing this side area because we haven't included ads and you're the blade of our categories so we can do this impulse possible by going ahead and encoding it's up here as we've done so include just fine the folder is in the record and sign every okay know goes and make sure you see before because you need to save often every single changes you do so they're gonna be done and guess set so for that I believe it is fifteen minutes now we are going to talk about the form in what form we're gonna do is we're gonna use a library called level collective and this little collective is like a lot of those special form things like letter than Cree in a form in the old ways or in the habesha way the team when I create a form into the container of course so I'm gonna name it like this is gonna be able form ingre name its category - porn okay you made all of this so let me do that manually I'm gonna give it an ID of category - form and in there I'm gonna create a subform and put everything but here I'm using the herbal collective you shouldn't take a cup of this so we see this so we have liver collective how to install it as using composer require in which version they added your color of a collective class into the providers and the aliases as well so for opening the form is simple as saying like this special methods of for Oakland and a form closed and everything is gonna be working fine so let's install this in our project we're gonna use composer make sure your nope the project directory and compose your require and I'm just gonna copy all the bats from the sake of time okay this should require the package for us and updating the composer JSON we other than composer whose ball stories you should leave bit in order to complete then we should take this and add it into the providers and let me copy this and the product providers are actually under our configuration files to find in the a folder into the app is or not they are actually yeah the main the main link the app no okay the main directory and you're gonna find the configuration go to the app dot PHP and it believe is there no all right so yes it's been stopped end of the board the app dot PHP can I find the providers goes down and here you can put you provide to us in the middle here it's better to put in the middle so just paste this collected class class make sure you put the comma after that and also on the aliases in C's should find them just in the bottom and you're gonna find you tell your season here or put them actually in here so doing dance form HTML in order to make little organized this the soul dependencies or updating the packages that's so that should be not working no further ado okay now still required for packages now after everything has been successfully done and the level collective has successfully being installed so let's go back and close this and it goes into here and now let's open up the form so we can you can get the extension if you're using digital code from the extension to get this like engine license thing so won't open and here you can put the wall the let's say I believe in here we got puts the route which one's gonna be pointing to from now it's a Nancy and which method is gonna be used and I'm gonna use let's call the method they're gonna give us the [Music] toasts okay course because we're gonna posting get up and make sure you close the form yeah and here you put all your inputs you only have one inputs in one label so form label and for bots and label gotta be category the text of the label gonna be copy or just name and the options here you can put any like bootstrap classes or assignments into the classes assigning classes alright these to it so another one is the inputs the inputs is being done text so instead of putting inputs you can put text of text area so for the name is gonna put it as the same as the label for so category name okay and the Bollywood be empty and here we're gonna have a bootstrap class gonna help us styling this and it's gonna be like form belief form controller actually quite a little bit this console so form control something like this let's put this in there I don't know I just wanna keep remember this if form control or something perform this control tripod control okay no yeah should be should be 0 now let's see let's go ahead and refresh more pages make sure you need to different documentation if you really want to know more about this level collectively use it in a bigger project so we have an else not defined the rouse is not defined that define just accustomed rods in here gonna be called category dot and okay just we're gonna get on this route later on and let's see should work now and I'm not define located defined here you can instead of putting around you can put a URL so it pretty much works like the NAM thingy feel free to use the normal form from within HTML so then go to the web top each being it's like how did Corey and and maybe this video gonna get a bit long so I'm gonna take post request and I'm gonna be a category into this specific and we can take it control control or category control into the specific function of storm okay so I can access of course a request method so I mean I'm gonna be category top ad okay and 12/8 category and that should make things clear a bit now let's refresh and every should go home fine and now I should see the old form showing up of course yeah you can add a bit of style into this container to make it looks a bit nicer than this stacks very basic so name here you can put your name of course there's another I think I forgot about maybe you can add a place holder in here and put like a category name on it and you're gonna put it into the place holder and so I forgot about this so we just scream this place and now let's store the category on our database is gonna be very simple gonna talk about Ajax in maybe in the next tutorial next all the tour after it so another go the controller as we have this fine tune our routes is gonna be under the category controller stores so let's go into the store functions already being defined for us by using - - resource option so before start gonna take a request and request is just like a lot of our requests gonna have all the data being submitted from here so like he using a normal PHP thing or like you'd say post from PHP this is it so let me store this so firstly I'm gonna need to get the ID and for dance are we gonna be much let's we are going to add this so we need to initialize this initialized category so for that we need to include the model into our controller so we can use our backslash and you put whatever your is called so we have counting or three or because we are using the namespace you can just call it a use category oh because we down so we have specify this manner so these guys so stay up category in your PR from over here now you can initialize it by calling the category equals new category create an instance of this and now you can add to it so category even have the name field so the name you can access this up pretty much like a variable so name equals to whatever the name from the request and the name from request to access this you should purchase too much the same as the name of the actual input field so go ahead and check out your angle field like have text this is our input field and this is the name of it so copy this or pretty much the same and it should be here like request Knox is like a variable category name and that should bring guns whatever tax is gonna be put it in here so yeah not an office of an authorization for now we just gonna assign it into step in with a custom authors so I'm gonna say author equals Stan yes okay now after adding all the fields make sure you save it so you see category save and your nest is being saved and you should return like redirecting them into someplace or we do that same with a message so from now we're gonna use a session so we're gonna call the session but we don't have session variables we're gonna talk about the session later on for now we're just gonna reduction into back so you say redirect back and this back made sure my conviction on the last URL but in the world now let's check out this but we don't have a submit button we haven't created a submit button I don't know why so submit things like that bootstrap class so gonna be busy mmm Etienne passion success beauty and - block - make it a bit nice you can learn boss learn or bootstrap classes by googling that's recent so let me check I category let's say the gory and just try to add that category hopefully this will go fine enough so we have a problem doesn't exist CMS categories table narrow bossiness - categories doesn't exist in certain categories so looking for CMS category let's see we have protected table there's bees flying over table in here so why this is not taking in counts so the problem was just pretty much some composer dumped already out so if you have like I've said this the next story the next video [Music] pingas watching after this can wait see you next tutorial oh close it