Amazon Abbreviations
Amazon Sales Rank (ASR): A metric that explains the relationship among products within 1 category based on their sales performance. Amazon Standard Identification Number (ASIN):…
Read more
Hashing Algorithms
The hashing algorithms supported by PHP can be found by using the hash_algos() as shown in the below code: The results are shown below:
Top Technologies by Market Share
Top Technologies by Market Share for 2021 The data is provided by w3techs.com W3TECHS’s goal is to collect information about the usage of various types of…
Transactions
A transaction is an indivisible unit of work. That said, a transaction cannot be divided or separated. In databases, a transaction involves multiple queries that…
PHP: MySQLi Fetch
The following are common methods used to fetch data from a database using MySQLi. mysqli_stmt_fetch() Fetch results from a prepared statement into the bound variables.…
PHP: Abstraction
When we look at abstract classes, we need to focus on the “abstract methods” within the abstract class. In fact, the rule #1 when dealing…
PHP: SPL Autoload Register
PHP allows including files in a very easy way. This is very useful when dealing with multiple classes. The spl_autoload_register(function) registers a function with the…
PHP: Variable Handling
unset() unset() destroys the specified variables. The behavior of unset() inside of a function can vary depending on what type of variable you are attempting to destroy. If…
CSRF Protection
Cross-site request forgery (CSRF), also known as one-click attack or session riding, is a type of malicious exploit of a website where unauthorized commands are…
Laravel: Router Methods
Route::get($uri, $callback); Route::post($uri, $callback); Route::put($uri, $callback); Route::patch($uri, $callback); Route::delete($uri, $callback); Route::options($uri, $callback);
Laravel Helpers: Paths
app_path() base_path() config_path() database_path() public_path() resource_path() storage_path()
Laravel Helpers: Fluent Strings
<?php use Illuminate\Support\Str; //FLUENT STRINGS //after //returns everything after the given value in a string echo “<br>”.Str::of(‘My name is Rabie Akela’)->after(‘My name is’); //Rabie Akela //afterlast //returns everything after the last occurrence of the given value in a string echo “<br>”.Str::of(‘App\Http\Controllers\Controller’)->afterLast(‘\\’); //Controller //append //appends the given values to the string echo “<br>”.Str::of(‘Rabie’)->append(‘ Akela’); //Rabie Akela…
Timeline of e-Commerce
Future Events 2026-04: End of support for MySQL release 8.0 2024-11: End of support for PHP 8.1 2023-11-26: End of support for PHP 8.0 2021-2025…
Laravel Cache
Some of the data retrieval or processing tasks performed by an application could be CPU intensive or take several seconds to complete. When this is…
Laravel API: Routing
The API for Routing in Laravel can be found here: https://laravel.com/api/8.x/Illuminate/Routing.html Common Methods whereAlpha(array|string $parameters) whereAlphaNumeric(array|string $parameters) whereNumber(array|string $parameters) whereUuid(array|string $parameters)
Laravel Helpers: Miscellaneous
Laravel Helpers are a variety of global “helper” PHP functions. The full list of helpers can be found here: https://laravel.com/docs/8.x/helpers Miscellaneous Helpers abort() The abort…
Commands for Laravel
Create a Project Make sure you are in the directory where you will create the project folder. If using XAMPP, change directory to htdocs. or…
Laravel: MVC Design Pattern
MVC Design Pattern Model (Eloquent) A models allows to view, insert, update, and delete records from a database table. Laravel includes Eloquent, an object-relational mapper…
PHP Magic Constants
There are nine magical constants that change depending on where they are used. All these “magical” constants are resolved at compile time, unlike regular constants,…
PHP Release History
DATEEVENT 1995-06-08PHP 1.0 released (as PHP/FI) 1997-11-01PHP 2.0 released (as PHP/FI 2.0) 1998-06-06PHP 3.0 released 2000-05-22PHP 4, powered by the Zend Engine 1.0, was released 2000-10-20Support for PHP 3.0 ends 2001-06-23Support for PHP 4.0 ends 2001-12-10PHP 4.1 released 2002-03-12Support for PHP 4.1 ends 2002-04-22PHP 4.2 released 2002-09-06Support for PHP 4.2 ends 2002-12-27PHP 4.3 released 2004-07-01PHP…
Random and Shuffle
<?php echo ‘Random Number between 1000-9999 : ‘. rand(1000, 9999) . ‘<br>’; echo ‘Shuffle Letters in a String (ABCDE) : ‘. str_shuffle(“ABCDE”) . ‘<br>’; echo ‘Random (10) Bytes : ‘. random_bytes(10) . ‘<br>’; echo ‘bin2hex of 10 Bytes : ‘; var_dump(bin2hex(random_bytes(10))); ?>
PHP Data Types
<?php var_dump(0); var_dump(1); echo'<br>’; var_dump(1.1); echo'<br>’; var_dump(“Rabie”); echo'<br>’; var_dump(array(“ZERO”,1,2,3,4,5)); echo'<br>’; var_dump(true); var_dump(false); echo'<br>’; var_dump(null); echo'<br>’; ?>
PHP Booleans
<?php $x=true; $y=false; if($x) echo ‘(true) returns true<br>’; if(!$y) echo ‘(false) returns false<br>’; $a=1; $b=0; if($a) echo ‘(1) returns true<br>’; if(!$b) echo ‘(0) returns false<br>’; $myString=””; if(!$myString) echo ’empty string returns false<br>’; $myNull = null; if(!$myNull) echo ‘null returns false<br>’; $myArray = array(); if(!$myArray) echo ’emptry array returns false’; $myFloat = 0.0; if (!$myFloat) echo…
PHP Control Structures
if, else, else if while do-while for Example 1: Example 2: Example 3: foreach break continue switch match include, include_once, require, require_once include: throws a…
PHP: Time Zone
<?php date_default_timezone_set(“Asia/Dubai”); echo date(“Y-m-d h:i:sa”); ?>
PHP QR Code
SOURCE: phpqrcode.sourceforge.net PHP QR Code is open source (LGPL) library for generating QR Code, 2-dimensional barcode. Based on libqrencode C library, provides API for creating…
PHP: FPDF Library
SOURCE: fpdf.org FPDF is a PHP class which allows to generate PDF files with pure PHP, that is to say without using the PDFlib library.…
jQuery CDN
Go to www.jquery.com Click on the Download button Find the section ‘Using jQuery with a CDN‘ Click on the link: https://code.jquery.com Select the latest version,…
Connect to a mySQL database (MySQLi OO)
The following is the code to connect to a database using MySQLi Object-Oriented.
Change Database Charset and Collation
Log into phpMyAdmin. Select your database from the left menu. Click on “Operations” from the top menu. In the Collation box, choose your new collation from…
Change Database Engine
Go to phpMyAdmin Select the Database (from the right menu) Select SQL from the top menu Use the following query (change my_table to your table name).
Laws & Regulations
GDPR: General Data Protection Regulation REGULATION (EU) 2016/679 OF THE EUROPEAN PARLIAMENT AND OF THE COUNCIL UAE Federal Law on Combating Cybercrimes Federal Decree-Law no.…
How to not get hacked!
TIP 1: Do not trust user input of any format! Validate EVERYTHING and Sanitise EVERYTHING! TIP 2: Do not run outdated software in production. TIP3:…
Connect to MySQL Database using CMD on Localhost (XAMPP)
In command prompt, change the folder to mysql folder in XAMPP. Enter the following code for connect to your database. Note the code below assumes…
MySQL: Aliases
Aliases make writing queries easier when dealing with multiple tables. It even makes it easier when accessing queries from scripting languages (e.g. PHP). Below is…
Database Indexing
An Execution Plan are the steps the database needs to perform to execute a query, and for that there needs to be an appropriate access…
What Is Strategy? by Michael Porter
Today’s dynamic markets and technologies have called into question the sustainability of competitive advantage. Under pressure to improve productivity, quality, and speed, managers have…
IT Doesn’t Matter by Nicholas Carr
In 1968, a young Intel engineer named Ted Hoff found a way to put the circuits necessary for computer processing onto a tiny piece of…