Laravel Tutorial Part 2 - Migrations and Artisan

[@Paeblits]

Great tut man. You explain this so clearly: your voice, comments, etc. Really well done.

[@bnewton149]

I have been programming for a little over a year now and this is my first experience with a framework and this is so cool that I feel high.

[@lambertpatrick1841]

Ths video helps me alot i was starting using laravel 5.3 i didnt know in order to migrate for previous version 5.0 and below you must migrate:install.I was getting error for over weeks till i saw this video salute bro...

[@toorjatoorja2388]

You Laravel tutorials are just great ! So smooth. Thank you.

[@divyabalachandran9611]

Great Tutorial Andrew.....Thanks a lot..

[@andrewperk]

The main benefit of migrations, for me at least, is that it each migration acts like a point in time and you can then easily reset back to that point. It also makes it easy to rollback and completely wipe the database then rerun the migration to create all of the tables again. Migrations also use timestamps so if you work in a team it makes it harder for other programmers to accidentally overwrite what you've done. Another benefit is that you can work with SQL using just one language, PHP.

[@1kalekip1]

A small note: the minute in PHP is not "m" (which is for the month), but "i". So: date('Y-m-d H:i:s')

[@andrewperk]

It's perfectly fine to use PHPMyAdmin if you prefer. Migrations are just a tool and PHPMyAdmin is another tool. Pick whatever tool makes you most productive and gets the job done right.

[@ezekielthemack]

Excellent tutorial Andrew. Thanks very much for your help.

[@Nstsandy12]

Great tutorial, I look forward to seeing more..

[@andrewperk]

You'll need to add the path to your php installation to your system environment variables. Just google "add php to environment variables" and you'll find a buch of results. Afterwards, restart your command line and the php command should work. Good luck!

[@PrideChung]

Really great tutorial, easy to understand.,and short

[@MyTemaSM]

Thanks for your tutors! You have small typo, when inserting data to 'authors' table: date("Y-m-d H:m:s") so you mistaken with minutes, it must be: date("Y-m-d H:i:s")

[@lakshmananr8890]

Very Nice tutorial easily understand and developed ...

[@testvetegromedia]

great vid! but it would be a good thing if you could work on the sound quality. Purchase a better headset and put the pc under the desk to kill these sonor noises in the back. I think that would help a lot. But again, the video's great and i'll watch all videos of this series. Thx for that!

[@museumoftechno]

Hi there If you had 2 authors with the same name - one added via a migration "up" method, one maybe added by someone else by another process, and you ran a migration's "down" method which deleted matching on name, I guess that would delete both authors with the same name? Is that an issue worth worrying about, and if so are there best practices to mitigate the issue? Thanks for the top-quality tutorials!

[@Chellles]

Thanks for your video, this is very useful for me and the comunity.

[@CalicoArchives]

Nice tutorial. When you already have a lot of information in a table that was user generated, how do you generate a migration file similar to Add_Authors so you can move everything to a new table in another database?

[@devthapa609]

very Good Tutorial to understand Laravel. Thanks

[@bobbarker3387]

Nice demonstration of the migration function. Not sure why you demonstrated hard coding the table updates though. Certainly not a best practice and certainly something that would never be done in production.

[@k4f]

That makes perfect sense, similar to how Rails does it. However, if I am the only developer on the project and don't want to worry about rollbacks, etc. (small project) is it okay to simply create the tables myself through phpMyAdmin? Or is there a downside to that other than what you mentioned?

[@triple111111]

nice work, i like your tutorials

[@GrumpyDeveloper]

Nice tutorial. I would be better to add your data fixtures for the insert authors as a task and keep migrations for schema operations

[@carlk7109]

Hey Andrew. As a laravel newb, I just wanted to thank you for the tutorials. One question that I have in this one: it looks like you're doing the initial seeding of the authors table within the migrations directory, rather than using the seeds directory as others suggest. For me, I'd prefer keeping everything in the one directory, as you do here; is there any downside with doing things this way?

[@justinwong1436]

Thank you so much!! Yr video is so informative and pretty helpful to me :D

[@marcelloperri183]

thanks mate, you are very good teacher, but I don't understand the purpose of a programming style like that. We should create something more dynamic and flexible... I hope to understand in the next video.

[@andrewperk]

You're right. I noticed that right after I uploaded the video but it was too late at that point. Thanks though.

[@AnGhaeilge]

When attempting to create the create table script, I get this error: "Command "migrate:make" is not defined." - Apparently, the updated command is "php artisan make:migration [name]"

[@webtjanst6720]

Is there any video that shows how to install Sctipt based on Laravel and Bootstrap in webhosting?

[@RedGlobeMedia]

Did you create the database first (it won't create it for you) and configure the connection in laravel/app/config/database.php?

[@vipinsankhlecha2]

I am getting error on php artisan migrate:install- SQLSTATE[HY000] [1049] Unknown database

[@farhantubeify]

did you fixed it, I'm new to laravel and also facing same problem.

[@jomarmillete3697]

is there's a difference when ill just use and manage the data directly in phpmyadmin? cause it is much easier rather than manually typing the data and commands

[@lazaraleksic4742]

I am following with video , doing everything as u do, but in phpmyadmin section where my autors are i cant see Andew Perkins and Author numbler 2 . It doenst show

[@visheshdwivedi6970]

if i manipulate my table using xampp server.. not by migrations ... then will it affect later in the process..while my making my website??

[@vipinsankhlecha2]

When I created two add migration file and do migrate:rollback both are rollback simultaneously but require only specified file is rollback.Please tell me how can i do........?

[@deepakgoswami0143]

Nice work.. (y). sir, can you please give the name of your Sublime Editor Theme and color scheme settings detail .. I liked that :)

[@coreydoyle4702]

What is the benefit of creating a database table through the migration method? -Cheers

Hi andrew what's your font settings in sublime text ?

[@c101hir]

Thanks Man, it's Awesome ...

[@mailshijith]

Can i use this migration from existing table ?

[@DaveStewartLondon]

Any reason you didn't just insert the SQL natively inside the up function?

[@nacoxify]

you don't need to insert created_at and updated_at manually since timestamps-method does it for you

[@lakshmananr8890]

My question Wamp Only used or else Xamp can i used???

[@thecodes]

HY, I HAVE A LARAVEL PROJECT IN 4.2, NOW I NEED TO UPGRATE IT INTO 5.5, HOW TO DO THIS?

[@ElijahAlcantara]

Does anyone know why in Laravel4 we are getting "Nothing to migrate" with the code?

[@matteusdev23]

Because you've done the migration one time already. execute php artisan migrate:make yourtablename again, and place your code in the up() function right there. Thats the way i do it with no problems. Have you discovered a way to do it?

[@LizardanNet]

unknown column errror, "created at" column not found

[@brian4it]

I love you, man. :)

[@nit11a01]

why i am getting error in command prompting. MY OS is WIN7 32bit Prof

[@TechBroad]

why do you dont need to put the: use Illuminate\Database\Schema\Blueprint; use Illuminate\Database\Migrations\Migration; ??????????????

[@bikramshrestha9380]

Thank you!

[@alexwly7]

I have this problem -Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///var/mysql/mysql.sock)- when I execute in the terminal this "php artisan migrate:install" for those who have problems intalling migrate using mamp.. add this 'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock', in database.php on mysql array configuration right after 'host' => 'localhost', if u want and that should solve the problem..

[@FeliceOstuni]

jut to say, great video, but correct iso timestamp is: date('Y-m-d H:i:s') not date('Y-m-d H:m:s');

[@kavyakhachane7528]

u r great!!

[@rababzein7012]

Is that Laravel 4 or Larvel 5 ??

[@Joe0994]

+Rabab Zein 4

[@bangje8498]

is this laravel 4 or 3?

[@jaycole9119]

certainly not 4

[@coreydoyle4702]

I see, thank you. -Cheers

[@coreydoyle4702]

Why was this marked as spam???

[@triple111111]

same opinion

[@acrolyt]

H:i:s, dude : ) Still, very nice tutorial, thanks and keep up the good work.

[@nit11a01]

i cant user artisan

[@ummarah-baba]

SQLSTATE[HY000] [1049] Unknown database 'database'

[@cefbmail]

i saw that 2 haha

[@paulwesley9364]

so so

[@MrLarsjansen]

Y-m-d H:i:s ;)

[@HoangPhan997]

sir, i'd ask which version of lavarel which you use in above demonstration.. I am a completely newbie, I have just worked with laveral a few days ago, and I am so confused because there many tutorials but ... there are many version and each one of them is different

[@vipinsankhlecha2]

I am getting error on php artisan migrate:install- SQLSTATE[HY000] [1049] Unknown database 'laravel'

[@joshuawedekind3903]

Have you created a database named "laravel" on your local MySQL server?