I’m in the process of converting one of our web applications from CodeIgniter to Laravel. However at this moment we don’t want to add the updated_at / created_at fields to all of our tables as we have a logging class that does all this in more depth for us already. I’m aware I can set … Read more
I’d like to be able to add a custom attribute/property to an Laravel/Eloquent model when it is loaded, similar to how that might be achieved with RedBean’s $model->open() method. For instance, at the moment, in my controller I have: public function index() { $sessions = EventSession::all(); foreach ($sessions as $i => $session) { $sessions[$i]->available = … Read more
I’m stuck on a simple task. I just need to order results coming from this call $results = Project::all(); Where Project is a model. I’ve tried this $results = Project::all()->orderBy(“name”); But it didn’t work. Which is the better way to obtain all data from a table and get them ordered? 12 Answers 12
I created a migration with unsigned user_id. How can I edit user_id in a new migration to also make it nullable()? Schema::create(‘throttle’, function(Blueprint $table) { $table->increments(‘id’); // this needs to also be nullable, how should the next migration be? $table->integer(‘user_id’)->unsigned(); } 11 Answers 11
I have two tables, User and Post. One User can have many posts and one post belongs to only one user. In my User model I have a hasMany relation… public function post(){ return $this->hasmany(‘post’); } And in my post model I have a belongsTo relation… public function user(){ return $this->belongsTo(‘user’); } Now I want … Read more
I want to sort multiple columns in Laravel 4 by using the method orderBy() in Laravel Eloquent. The query will be generated using Eloquent like this: SELECT * FROM mytable ORDER BY coloumn1 DESC, coloumn2 ASC How can I do this? 5 Answers 5
How do you check if a field is not null with Eloquent? I tried Model::where(‘sent_at’, ‘IS NOT’, DB::raw(‘null’))->… but it gives IS NOT as a binding instead of a comparison. This is what DB::getQueryLog() says about it: ‘query’ => string ‘select * from my_table where sent_at = ? and profile_id in (?, ?) order by … Read more
This may be a trivial question but I am wondering if Laravel recommends a certain way to check whether an Eloquent collection returned from $result = Model::where(…)->get() is empty, as well as counting the number of elements. We are currently using !$result to detect empty result, is that sufficient? As for count($result), does it actually … Read more
I’ve found the concept and meaning behind these methods to be a little confusing, is it possible for somebody to explain to me what the difference between has and with is, in the context of an example (if possible)? 2 Answers 2
How can I select a random row using Eloquent or Fluent in Laravel framework? I know that by using SQL, you can do order by RAND(). However, I would like to get the random row without doing a count on the number of records prior to the initial query. Any ideas? 18 Answers 18
