Protected: Medium Friendly List

This content is password protected. To view it please enter your password below:

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…)

OpenLamp.tech issue #6

Hey all good folks! I’ve published another issue of your favorite newsletter, OpenLamp.tech, the newsletter for PHP/MySQL developers. This issue (like all the rest) is loaded with fantastic curated content. Enjoy and do share with others!



Self-Promotion:

If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!


I enjoy writing and curating the OpenLamp.tech newsletter. If you would like to support my efforts and you are finding value in the weekly publication, please share this post or an issue with someone you think would value the content as well.

The Newsletter for PHP and MySQL Developers

In this week’s issue, we have great curated content covering:

  • Temporal types in the MySQL Document store
  • A great read on the building of the Symfony Station site
  • PHP error for headers already sent in WordPress
  • A primer on MySQL Window Functions

Please consider supporting my blog and the OpenLamp.tech newsletter by tossing some spare change in my Tip Jar. Thank you so much!πŸ™


You can read the latest issue of OpenLamp.tech here

The final issue this month (and year) of OpenLamp.tech will be humongous! In addition to the curated content, this issue is the monthly featured piece and we are covering MySQL Metadata with CodeIgniter 4 Query Builder.

Don’t miss an issue or wait on me to repost the latest here. Subscribe so each one lands directly in your inbox.

Are you a Medium member? If so, receive an email notification each time I publish a blog post if you prefer the Medium platform. Not a member? No worries! Use my sign-up link (I will get a commission at no extra cost to you) and join. I really enjoy reading all the great content there and I know you will too!!!

The Newsletter for PHP and MySQL Developers

How can I help you?

  • Are you thinking of starting up a blog? I use WordPress for my blog. Let’s both save money on the plans offered. πŸ’Έ
  • Grab a Gmail HTML Email Signature template from my Etsy shop and make your emails pop and stand out. βœ‰οΈ
  • Need hosting for your next web application or WordPress site? I use and highly recommend Hostinger. They have great pricing and service.
  • I enjoy reading Refind: The essence of the web, every morning in your inbox. Subscribe for free. Help me get a premium subscription by signing up yourself with my referral link.
  • Grab a free pack of mobile Creator wallpapers.

Disclosure: Some of the services and products links in this post are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.

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…)