My Friendly Medium List

Hey everyone, I’m creating a dedicated page of ‘Friend links‘ for all of my Medium first articles and blogs. Continue reading to learn more and how to gain access to them…

(more…)

5 PHP Date Functions and Their MySQL Equivalents

Anyone working with data is going to encounter date values at some point. Dates are necessary for many reasons. If you’re a PHP/MySQL Developer, you have date function options for both the database and your programming language of choice. In this post, I cover 5 PHP date functions and their (somewhat) MySQL equivalents with examples of each. Continue reading…

(more…)

CodeIgniter 4 Query Builder set() function with update()

CodeIgniter 4 Query Builder class has an update() function used to process UPDATE Data Manipulation Language (DML) commands. Using update() as a standalone function call is perfectly valid. However, there is also a set() function used for setting column values as you would with the SET keyword in an SQL UPDATE statement. Used in conjunction with the Query Builder where() function, you can easily UPDATE column values for an individual row or multiple rows. Continue reading for more information…

(more…)

15 Exciting SQL Project Ideas & Topics for Beginners – 2021

In this era of technology, an aspiring student of computer science has to know SQL programming language. While learning SQL, you will observe that it is being used almost in every website development because it helps in simplifying the data silos. Once you have learned this programming language, it is better to try new and easy real-life projects to sharpen your SQL skills. While working on them, you will hone your SQL and get a chance to sharpen your soft skills, such as problem-solving.

(more…)