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 >>>]

MySQL’s AUTO_INCREMENT attribute

Most developers use some form of auto-incrementing integer counter for a given database table, ensuring uniqueness among the rows. Several of the popular SQL dialects implement this facility. For instance, MySQL’s AUTO_INCREMENT attribute is used to provide a unique identity for a table row. What exactly is the behavior of AUTO_INCREMENT? Can you explicitly use a value of your choosing for it if you need to? How does it count? Continue reading and know the answers to these questions and more…

[Keep reading for more MySQL database and Python/PHP-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 >>>]