How can I build a condition based query in Laravel?

Question

I can do this in Code Igniter:

$this->db->select(); $this->from->('node'); if ($published == true) {     $this->db->where('published', 'true'); } if (isset($year)) {     $this->db->where('year >', $year); } $this->db->get(); 

How can this code be translated so that it works in Laravel?

Answer 1

In Fluent you can do:

$query = DB::table('node');  if ($published == true)     $query->where('published', '=', 1);  if (isset($year))     $query->where('year', '>', $year);  $result = $query->get();