PHP strtoupper() and strtolower() string functions

Manipulating text or string data is such a common task that most all programming languages provide built-in functions for this specific purpose. PHP is no different in that regard. The language comes chock-full of different string manipulating functions. If you need string data in all capitalized or upper-cased letters, you can use strtoupper(). What about all lower-case strings? The strtolower() function takes of that. In this post, we visit some rudimentary examples and gain a feel for how these 2 functions operate.

[Keep reading for more SQL database and PHP/Python-centric content >>>]

CSV resource for SQL and Data professionals

Most any data professional deals with CSV data at some point in their work-flow. Let’s face it, CSV’s are everywhere and are one of the more common data interchange formats. A common task SQL professionals have is loading CSV data into a database table. Or on the converse, extracting SQL data into a CSV file. I have written several posts about CSV’s with MySQL, PostgreSQL, and the Python pandas library, and still to this day, refer to many of those posts for help when working with CSV’s. This compilation post is for SQL and data professionals who would find value in this type of resource as well.

[Keep reading for more SQL database and PHP/Python-centric content >>>]

PHP MVC YouTube videos you should watch

Are you struggling with PHP OOP concepts? Unsure of how the MVC design pattern all fits together? As someone who is learning and using PHP, trust me, I feel your pain. When I decided at the beginning of 2020 to go all in on PHP, OOP and MVC principles were difficult for me to grasp, much less implement. Although I worked out of a fantastic book, PHP & MYSQL: Novice To Ninja (non-affiliate link), something was still missing from my understanding (no fault to the book as it is fantastic). Then I discovered a series of 3 YouTube videos that really helped solidify those OOP and MVC concepts that had eluded me. In this post, I mainly want to share these videos and bring awareness to them so others who need help can benefit from them as well…

[Keep reading for more SQL database and PHP/Python-centric content >>>]

PHP portfolio piece – Analytics data.

I recently published a blog post about a portfolio project I am developing using the LAMP stack, Bootstrap 4, jQuery, and the MVC (Model-View-Controller) design pattern in core PHP. In this post, I will introduce an additional feature I integrated into the existing project.

[Keep reading for more SQL database and PHP/Python-centric content >>>]

PHP date() function for common date formats

Dates and time are everywhere. We live and operate based on date and time values. Work, sleep, or play – dates and time are always a deciding factor. Where on earth would we be without a calendar? I can tell you where I would be… Lost. Speaking of dates, there is not one universal format that I am aware of. People write them in all kinds of ways. If programming in PHP (such as yours truly) you may wish to format a date value in a particular manner. Using the PHP date() function, it’s super easy. In this blog post, I share 3 common date formats you can pull off with the PHP date() function…

[Keep reading for more SQL database and PHP/Python-centric content >>>]