Card image cap

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

Coding
507
0
Read
Card image cap

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,

Coding
473
0
Read
Card image cap

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.

Coding
1014
0
Read
Card image cap

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.

Coding
1034
0
Read
Card image cap

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.

Coding
918
0
Read
Card image cap

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.

Coding
855
0
Read
Card image cap

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.

Coding
864
0
Read
Card image cap

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.

Coding
1077
0
Read