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.

Joins

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', 'users.id', '=', 'contacts.user_id')
 ->join('orders', 'users.id', '=', 'orders.user_id')
 ->select('users.*', 'contacts.email', 'orders.price')
->get();
- To perform a "left join" query, use the leftJoin() method, in the same way as the join() method.
$users = DB::table('users')
 ->leftJoin('posts', 'users.id', '=', 'posts.user_id')
->get();

Unions

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')
->union($first)->get();


- Documentation: Laravel - Database: Query Builder

Daily Test with Code Example

HTML
CSS
JavaScript
PHP-MySQL
Which tag defines the clickable areas inside the image map?
<map> <img> <area>
<img src="image.jpg" usemap="#map1">
<map name="map1">
  <area shape="rect" coords="9, 120, 56, 149" href="#">
  <area shape="rect" coords="100, 200, 156, 249" href="#">
</map>
Which CSS property defines what is done if the content in a box is too big for its defined space?
display overflow position
#id {
  overflow: auto;
}
Click on the event which is triggered when the mouse is positioned over an object.
onclick onmouseover onmouseout
document.getElementById("id").onmouseover = function(){
  document.write("Have Good Life");
}
Indicate the PHP variable that contains data added in URL address after the "?" character.
$_SESSION $_GET $_POST
if(isset($_GET["id"])) {
  echo $_GET["id"];
}
MySQL Database, Query Builder: Join and Union

Last accessed pages

  1. Contact page - CoursesWeb (7906)
  2. Tabs effect with CSS (8620)
  3. Get Attribute (ID, Class, Name, Title, Src) with jQuery (57370)
  4. Making DIV Contents Scroll Horizontally, with multiple Div`s inside (14440)
  5. Insert, Select and Update NULL value in MySQL (36592)

Popular pages this month

  1. Making DIV Contents Scroll Horizontally, with multiple Div`s inside (1826)
  2. Contact page - CoursesWeb (1755)
  3. Tabs effect with CSS (1748)
  4. Insert, Select and Update NULL value in MySQL (1030)
  5. PHP getElementById and getElementsByTagName (707)