MySQL unions used to combine the results of multiple SELECT
statements into one result. MySQL supports both UNION
and UNION ALL
for joining SELECT
results.
Tag: php
Working With MySQL Joins
In PHP applications, Retrieving data from relational tables generally require the use of joins. MySQL joins enable developers to select data from multiple tables with a single SQL statement. Let’s explore MYSQL joins.
How To Install Dependencies With PHP Composer
Composer is a dependency management tool for PHP developers. It allows you to define all libraries that your application depends on and automatically download these libraries with a simple command. Composer solve many problems, you know if your application depends on many libraries and these libraries depend on other libraries like frameworks ,It will be cumbersome to make all these libraries up to date.
Laravel Requests and Inputs Part1
Laravel has awesome methods to retrieve, change, create and store request data. It allows you to handle both $_GET
and $_POST
data and store in session or cookies. Let’s look at some methods of accessing request data.
Laravel ORM Part2
We discussed later how to retrieve rows as objects and perform basic CRUD methods on them. Well,there are other good tasks that eloquent can perform. Let’s discuss some of them and the rest will be discussed in subsequent parts.
Laravel ORM Part1
Laravel is a MVC PHP framework so it ships with its own ORM component called “Eloquent”. Eloquent will take care of records retrieval for us. We don’t have to write any SQL line. Let’s explore eloquent basic CRUD methods .
Laravel Migrations Part2
In Laravel Migrations Part1 ,I discussed how to create ,run and update your migrations. It seems you need more and fortunately laravel still have many features to enhance your application migrations. Let’s explore some of them.