Laravel Course

Laravel's database query builder provides a convenient, fluent interface to creating and running database queries.
- It uses PDO parameter binding to protect your application against SQL injection. There is no need to clean strings passed as bindings.


To perform a basic "inner join", you may use the join() method on a query builder instance.
The first argument is the name of the table you need to join to; the remaining arguments specify the relation of the columns for the join.
- You can join to multiple tables in a single query:
$users = DB::table('users')
 ->join('contacts', '', '=', 'contacts.user_id')
 ->join('orders', '', '=', 'orders.user_id')
 ->select('users.*', '', 'orders.price')
- To perform a "left join" query, use the leftJoin() method, in the same way as the join() method.
$users = DB::table('users')
 ->leftJoin('posts', '', '=', 'posts.user_id')


To "union" two queries together, create an initial query and use the union() method to union it with a second query.
$first = DB::table('users')->whereNull('first_name');

$users = DB::table('users')->whereNull('last_name')

- Documentation: Laravel - Database: Query Builder

Daily Test with Code Example

Which meta tag provides a short description of the page?
<meta content="..."> <meta description="..."> <meta http-equiv="...">
<meta name="description" content="70-160 characters that describes the content of the page" />
Which CSS property is used to stop the wrapping effect of the "float"?
clear text-align position
#some_id {
  clear: both;
Click on the method which gets an array with all the elements in the document that have a specified tag name.
getElementsByName() getElementById() getElementsByTagName()
var divs = document.getElementsByTagName("div");
var nr_divs = divs.length;
Indicate the PHP function which returns the number of elements in array.
is_[) count() strlen()
$arr =[7, 8, "abc", 10);
$nri = count($arr);
echo $nri;        // 4
MySQL Database, Query Builder: Join and Union

Last accessed pages

  1. MouseEvent - Events for Mouse (2268)
  2. HTML5 Quick Tutorial (4688)
  3. Create Array of Unique Random Numbers or Letters (575)
  4. PHP Unzipper - Extract Zip, Rar Archives (18931)
  5. Moving html element to a random direction (3067)

Popular pages this month

  1. PHP Unzipper - Extract Zip, Rar Archives (475)
  2. Courses Web: PHP-MySQL JavaScript Node.js Ajax HTML CSS (455)
  3. SHA256 Encrypt hash in JavaScript (390)
  4. Read Excel file data in PHP - PhpExcelReader (347)
  5. Create simple Website with PHP (330)