Laravel Tutorial Part 5 - CRUD - Retrieving Data with Eloquent

[@AbbeyRoadkill1]

Laravel is wonderful. The best framework I've worked with. I'd love to see you make more tutorials for it, you do a great job. Thanks!

[@CamiloSanchez1979]

I don't think we were ready for this, you needed to make more Cakephp tutorials, there is just so much uncovered bro

[@mrjitz]

After watching your videos,now i am fan of you

[@GerardoBelot]

I've seen all your laravel and tutorials are very interesting, I'm used to using a framework called kumbiaphp, which is excellent, but I'm always reviewing new options for web development. Thaks for the videos

[@AbbeyRoadkill1]

Awesome, awesome. You're a life saver, man. I just got a new web dev job and have to learn Laravel pronto. Thanks!

[@PlayerRPG85]

Your tutorials are great, thanks for the time and work you put on them!

[@desidarlingly]

These videos are so amazing. I can't thank you enough for making them!

[@MacWorksMPLS]

Nice! Been looking at going with CodeIgniter && PHP ActiveRecord for a new and very database intensive project, but after reading that others have moved on to Laravel ... well your tutorials definitely have me turned on Laravel. From my very cursory experience with CI, Laravel seems to follow a similar pattern but makes up for what CI lacks.

[@ElijahAlcantara]

For laravel 4 , here is what worked for me: Class Author extends Eloquent { protected $table = 'authors'; }

[@bkrisselink]

Just removing static worked for me.

[@paudelsun]

One more thing,change order_by to orderby...

[@el07694]

Chris is Risen Thanks for your video.

[@sauer.voussoir]

You can use seed for adding sample data in your database. Thank you for the series of tutorial :)

[@andrewperk]

The link_to_route method definition says that the parameters are to be passed in as an array in order to accept multiple URI parameters at once. For instance if your route accepted two params you need to use the array. But yes, if you're just needing to pass in one param you don't need to use the array. Just passing in the id with no array will work fine.

[@andrewperk]

It made more sense to me for the URI to be singular since I'm requesting one author that's why my URI is author/:id. You can use authors if you'd prefer.

[@russazsuraj630]

This is very very helpful tutorial, thank you so much for making it :)

[@paxvidz4727]

Very clearly demonstrated tutorial. I'm quite new to Laravel and currently using notepad++ Wherever there is the @ sign I notice it does not change to blue and there is no way, I make the automatically build methods appear e.g here is order_by() Is there something missing in my installation or please suggest me some other software required to use? Thank you

[@svenvandevenne517]

it's orderBy in the new version ;-)

[@Jason_NZ]

Keep up the laravel tutorial, there fantastic!

[@GrumpyDeveloper]

Named route is great to know. Thanks

[@andrewperk]

Because using that sets up your URI's using the controller and action name.

[@rajasekharreddyb5760]

Changes in Laravel 4 ->with('authors', AuthorModel::orderBy('name','desc')->get()); order_by() has changed from snake case to Camel case orderBY

[@frankmyatthu2406]

orderBy, y is small case

[@MohamedDembele]

thanks dude!!! www.modemb.com

[@andrewperk]

Sorry for the lack of new CakePHP tutorials. I've been really getting into Laravel and wanted to make some videos about it.

[@aaBeben]

just for adjustment for someone who using new version of laravel at author model no need to type public static $table = 'author' just declare class that extends Eloquent with empty body.

[@diegoslinger1254]

Pretty good and useful video

[@Wj3399]

Was debugging this for a bit in Laravel 5: I had my Models folder directly under app ** In author.php:

[@CorporalPoon]

+Jason W awesome thank you

[@rajasekharreddyb5760]

Laravel 4 changes: {{HTML::link_to_route('author', $author->name, array($author->id)) }} need to change as below for Laravel 4 {{link_to_route('author', $author->name,$parameters = array($author->id)) }}

[@frankmyatthu2406]

{{ HTML::linkRoute('author', $author->name, $parameters = array($author->id)) }}

[@MohamedDembele]

wow thanks again man www.modemb.com

[@knowledgebase7284]

Hello, do u know how to save a multiple rows of records from one database table to another table at the same database? Thanks.

[@JOKBO1]

For those who are getting the "whoops" error during this series, turning on the debug option inside app.php will show you the real error. Also, if you are using Laravel 4, they replaced the underscored with CamelCase so things like "order_by()" are now "orderBy()"

[@gyanen1229]

thanks man

[@opeyemi3220]

in Laravel 5.1, use , {{!! link_to_route('author', $author->name, $parameters= array($author->id)) !!}} if you don't put the "!!" symbol, it would not bring up a hyperlink

[@mulathetraveler]

Thanks it worked but put only one curley braces in 5.1.4 {!! link_to_route('author', $author->name, $parameters= array($author->id)) !!}

[@opeyemi3220]

yeaaa, just one curly brace

[@80938096]

Great tutorial. thanks a lot :).

[@andrewperk]

The error message is not as descriptive as I'd hope. Did you look on line 16 of your view file to see if you've made a syntax error?

[@richaagiwal1537]

brilliant tutorials..gud job!! thnks a ton :)

One more correction for Laravel 4 have to use {id} instead of (:any). At least for me (:any) didn't work. Route::get('author/{id}', array('as'=>'author', 'uses'=>'authorsController@get_view'));

[@kennethpatricktrivino5524]

put a ->where(array('id'=>value)) after Route::get() method

[@andrewperk]

Hi Felipe, is that the entire error message? If not, can you provide the entire error message for me? Thanks.

[@keosamnith6705]

hi could you create vedio for how to correct error in laravel and built websit? thank i hope i can watch these video.

[@liaoruochen7281]

takes me a long time to find the bug: in model, public static $table = "authors"; should be changed to public $table = 'authors';

[@waraiotoko2415]

Can you help me with removing public from url, i read about moving folders and change paths, but i dont know if this is how you do it.

[@aleksandrkravtsov8727]

very usefull. thank you

[@miro-hristov]

I got "Trying to get property of non-object" I did not reset the database so my author id was 4,5,6 etc (not 1,2,3) just test with /author/4 (Check your database to see if you have that id)

[@MrMikaelo1]

Do you really have to communicate with database through controller in Laravel? I think it is not good practise to use stuff like like "order_by" etc in controller. This should be used in model. Or does Laravel require this approach?

[@jitendragosavi4676]

how can I add my css file in html with base url, I am new to learn laravel

[@ilu1994]

Use {{ HTML::linkRoute("author", $author->name, array($author->id)) }} On Laravel 4

[@MaheshThobhani]

hi; i m mahesh thobhani; i follow your tutorial for laravel 4; i got error in eloquent when save date. error is : Symfony \ Component \ Debug \ Exception \ FatalErrorException Call to undefined method Resources::save() ' Resources ' is class that extends Eloquent. can u plz help me; coz i m facing this error from last three days & still, not get any solution.

[@styxie21]

I think for Laravel 4+ you need to use this syntax in your controller: ->with('authors', Author::orderBy('name')->get());

[@SumitJain]

Thank you great video

[@coreydoyle4702]

Try the Laravel documentation. It's updated frequently, and has everything you need to get acquainted with 4x. However I wouldn't worry about it right now, as I think 4x is still in beta stage. Link to docs: laravel(dot)com/docs

[@DeepeshSingh16]

query part should be in model why you are writing query in controller ?? I have seen many tutorials doing the same thing. can you make the simple example how to make select query in model and how to call that function in controller if you don't have time to make video can you please expliin how to achieve that

[@Siegieee1]

Laravel seems rather picky about the closing php tag. In my authors.php (controller) I didn't put one because in your tutorial there isn't one either. It 404'd on the author/2 request. Is this normal?

[@andrewperk]

I have not had this problem before. Make sure there's no extra lines/whitespace at the beginning or end of your file. I'm sorry I can't be of more help.

[@Wj3399]

I managed to get into the authors/1 page but somehow i'm getting a blank page. Please help, I think I'm not getting the right $id

[@WarrioW]

Laravel 5, in route, change the parameter (:any) to {id}.

[@tobiassen23]

Route::get('author/(:any)' isnt working. It should be Route::get('author/{id}'

[@JahidulIslam-rm5bw]

*****yes he is correct

[@honey1761990]

It seems that code was for old Laravel versions (lower than 4.2 - current version). For new versions, Route::get('author/{id}' is the working code.

[@TemaSMirnov]

chaitanya khurana Yep, sure, on movie Andrew using old version (cause 2012 year)

[@JOKBO1]

+Tobias Willi In Laravel 5 it'll probably be something completely different. |-(

[@bgdazzz]

I have a problem with creating an author page. The Error is:Symfony\Component\HttpKernel\Exception\NotFoundHttpException …\vendor\laravel\framework\src\Illuminate\Routing\Router.php1429 How can I fix this problem?

[@zzzwb]

in the routes.php,you should write like:Route::get('/author/{id}', array('as' => 'author', 'uses' => 'AuthorsController@view'));pay attention to {id}

[@andrewperk]

No you do not. You can easily create a static method in your Author model to run the order_by query: public static function yourMethodName() { return static::order_by('name')->get(); } Then call this method from your controller if you wanted: Author::yourMethodName(); It's just such a simple query I feel no need to move this into a method to use in my model. I agree with you though if the query becomes more complex it definitely should go in the model, but this one is very simple.

[@chm1220]

also to piggy back this for Laravel 4 in the routes.php Route::get('author/{:any}', ... did not work for me, instead i had to change it to Route::get('author/{id}', ...

[@CorporalPoon]

couldn't get past the link_to_route part in laravel 5. keep getting undefined

[@davecote8388]

+CorporalPoon link_to_route has been renamed to linkRoute. Also, Html in illuminate is deprecated and you must now use HTML from collective\Html. I made a blog post to explains this, step by step. debugdave.net/2016/01/24/migrating-from-an-earlier-laravel-version-to-laravel-5-common-problems/

[@someshvyas]

{{ excellent }}

[@gabrieleugen2003]

Don't forget the "s" from 'author'.

[@dipenmehta822]

I tried to list all the records but it's not working. Following is my code and out put: $view->authors=Author::all(); echo ''; print_r($view->authors); // Out put Illuminate\Database\Eloquent\Collection Object ( [items:protected] => Array ( [0] => Author Object ( [table:protected] => authors [connection:protected] => [primaryKey:protected] => id [perPage:protected] => 15 [incrementing] => 1 [timestamps] => 1 [attributes:protected] => Array ( [id] => 1 [name] => Author 1 [bio] => bio 1 [created_at] => 2016-04-10 00:00:00 [updated_at] => 2016-04-10 00:00:00 ) [original:protected] => Array ( [id] => 1 [name] => Author 1 [bio] => bio 1 [created_at] => 2016-04-10 00:00:00 [updated_at] => 2016-04-10 00:00:00 ) [relations:protected] => Array ( ) [hidden:protected] => Array ( ) [visible:protected] => Array ( ) [appends:protected] => Array ( ) [fillable:protected] => Array ( ) [guarded:protected] => Array ( [0] => * ) [dates:protected] => Array ( ) [touches:protected] => Array ( ) [observables:protected] => Array ( ) [with:protected] => Array ( ) [morphClass:protected] => [exists] => 1 ) [1] => Author Object ( [table:protected] => authors [connection:protected] => [primaryKey:protected] => id [perPage:protected] => 15 [incrementing] => 1 [timestamps] => 1 [attributes:protected] => Array ( [id] => 2 [name] => Auhor 2 [bio] => bio 2 [created_at] => 2016-04-11 00:00:00 [updated_at] => 2016-04-11 00:00:00 ) [original:protected] => Array ( [id] => 2 [name] => Auhor 2 [bio] => bio 2 [created_at] => 2016-04-11 00:00:00 [updated_at] => 2016-04-11 00:00:00 ) [relations:protected] => Array ( ) [hidden:protected] => Array ( ) [visible:protected] => Array ( ) [appends:protected] => Array ( ) [fillable:protected] => Array ( ) [guarded:protected] => Array ( [0] => * ) [dates:protected] => Array ( ) [touches:protected] => Array ( ) [observables:protected] => Array ( ) [with:protected] => Array ( ) [morphClass:protected] => [exists] => 1 ) ) ) Please can you help me?

[@Lamrinthapa]

laravel is great but somewhere down the line, I think documentation should be more up to date... and too many changes in syntax with the previous laravel, hope that wouldnt be the case with upcoming laravel

[@HafizAmeerHamza]

Hi everyone..i am new here. friends this is my final year in computer science and i want to make a project in laravel...please give me some ideas for project, your suggestions & openion for my project...!!

[@Lamrinthapa]

For anyone who is annoyed with ... link_to_route. Replace it with linkRoute()

[@nabaus6170]

This is from 2012 ?

[@whitemamba00]

+Nab Aus yeah

[@beamway317]

хах ты разместил панельку как в ubuntu))