Docker with PHP, MySQL & MVC
Let us dive into the container world and create Dockerfile to build an image for PHP and apache and also create docker_compose.yml file to build mysql 5.7 image and bind all of these together. We will be following MVC pattern to make sure we cover some important aspects of configuration of apache2 server inside our docker
SQL Functions
SQL has some builtin functions (Mainly Numeric, String and Date/Time) which can be used to manipulate data during fetch or insertion. The concept of those functions is same as function in any programming language. The function will accept parameters and return some value. We will explore POW, CURRENT_DATE, ADDATE, SUBDATE, DATEDIF, ROUND, FORMAT, FLOOR, CEILING, TRUNCATE, UPPER, CONCAT, LENGTH, LEFT, MID, IF,
Bunch of SQL Operators and Calculated field
Many SQL operators go unnoticed or do not seem to be used widely. They can be handy to pull data from your database. Like: BETWEEN and NOT BETWEEN, IN and NOT IN, LIKE and NOT LIKE, NULL and NOT NULL, Calculated or Virtual field.
Structure of an SQL query
An SQL query consist of many things. It can be as simple as to get only "First_Name" from a single table or to get a set of data from bunch of tables. Here I will not discuss about the complex structure of an SQL query rather I will go over the very root of an SQL query. That will help us to better understand the advanced level of SQL query. The topic of this article is: Logic & Syntax error, Query Clauses, SQL Expressions, Literal/Constants values, Operators.
PHP framework Laravel Route
Laravel is an PHP framework. It’s one of the most popular framework among a lot of PHP frameworks. Route is the first thing you will come across when you will start learning Laravel. Here I will try to cover some basis of Route like: Route’s structure, Multiple Route, Passing Parameter(s) and Naming Route.
Prior knowledge for database planning
Making a database efficient is extremely important since it determines how fast you could access your data or modify them. Can't forget about space efficiency by eliminating redundancy. If you build an application which stores data in a database then you need to make sure you can tune it in future with minimum effort. This article is not about planning a database rather things you have to consider before starting planning a database.
Overview of SQL
SQL has been used on many different platforms because of its portability. SQL statement written on one platform works on another with little altertion. There are some simple to understand but useful fundamentals I bet some of you don't know. Like: Declarative Programming Language, Relational Database, Entity, Primary key, Record, Data Value, DBMS, RDBMS, ODBC etc.
Homestead for Laravel
Homestead is an official pre-packaged Vagrant box. Homestead accommodates a Vagrant box that creates an elegant development environment with all the necessary server softwares. For instance when you install windows/linux on your Mac using virtual box you have a totally different OS inside your Mac. That OS will never interrupt your Mac OS. Same thing Homestead does by creating a Vagrant box which will never mess up with your computer’s OS.