Php Artisan Tinker Database Commands which makes life easy

Hello to all, welcome to therichpost.com. In this post, I will tell you, Php Artisan Tinker Database Commands which makes life easy.

I was working with laravel from last one year but I never used tinker in laravel and today I used it and I felt relax because with the help of laravel tinker, I can get database records easily and fast and these all the reasons which makes laravel better php mvc framework.

I will share some useful laravel tinker database commands with you guys.

Here are some Php Artisan Tinker Database Commands which makes life easy:

1. Very first, you need to run below command set tinker environment:

php artisan tinker

2. Here is the php artisan tinker database command to get all data records from particular table:

>>> DB::table('users')->get();

3. Here is the php artisan tinker database command to get limit of records from particular table:

>>> use App\User;

>>> User::limit(10)->get();

limit_of_records

4. Here is the php artisan tinker database command to add new record in particular table:

>>> $user = new App\User;

>>> $user->name = "Hello laravel";

>>> $user->email = "hello@hellolaravel.com";

>>> $user->password = Hash::make('password');

>>> $user->save();

add_new_data_laravel

5. Here is the php artisan tinker database command to delete record in particular table:

>>> $user = App\User::find(28);

>>> $user->delete();

delete_record_laravel

6. Here is the php artisan tinker database command to count total record in particular table:

>>> App\User::count();

7. Here is the php artisan tinker database command to create dummy record in particular table:

This is very helpful and save lots of time:

>>> factory(App\User::class,10)->create();

dummy_data_laravel

8. Here is the php artisan tinker database command to check database connection status:

>>> DB::connection()->getPdo();

check_database_laravel_tinker

9. Here is the php artisan tinker database command to check database name:

>>> DB::connection()->getDatabaseName();

10. Here is the php artisan tinker database command to check database tables names:

 >>>DB::select('show tables');

11. Here is the php artisan tinker database command to delete particular table:

>>>DB::table('pages')->truncate();

12. Here is the php artisan tinker database command to generate hash dummy password:

>>> echo Hash::make("password");

shah_passpwrd_laravel

If you have any query or you want more tinker commands then do comment below or ask question.

Thank you,

Save Birds,

TheRichPost