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

PHP CRUD Application – Portfolio Piece

I am super pleased to share that I have completed and uploaded my first (that I can share at least) personal portfolio piece written in PHP to a subdomain on my personal hosting server located at walk.openlamp.tech. Over the better part of the last year, I have developed a custom reporting dashboard written in PHP for my (current) employer, but do not share any of that work as it is proprietary and not owned by me. However, for a personal project, I can share far and wide. In this post, I provide a brief overview of my simple (in theory at least) application/site, built on the LAMP stack using the MVC (Model-View-Controller) design pattern in core PHP along with Bootstrap 4, jQuery, and MySQL.

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

Digital Owl’s Prose End of Year blog post compilation

Like always, I do an end-of-year round-up here on my blog. This year is no different in that aspect, although it has been one crazy year otherwise. With the holidays upon us, I look forward to much-needed time off work, spending time with my family, and catching up on some fantasy novel reading. With that said, here are this year’s top-5 most viewed blog posts from Digital Owls’ Prose. Ironically, for the second year running, none of them were actually written this year! Got to love that evergreen content right!?! Enjoy!

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

PHP technical writing compilation

Having spent the majority of this year programming a custom reporting dashboard for my employer written in PHP and MySQL, it is an understatement to say that I have learned a lot. Nothing beats real-world experience and I really have come into my own with PHP, learning more and more daily as I continue progressing forward on my goal of becoming a Back-End Web Developer. I have written several PHP-related posts this year and wanted to provide them all in one easy-to-access list. Enjoy! [Keep reading for more MySQL database and Python/PHP-centric content >>>]

MySQL Window Function Compilation

If you use SQL on a regular basis, then you are well aware that Window Functions are powerful. They allow us to simplify queries that would otherwise be quite the mess. We can provide meaningful insight across rows of data without collapsing the results into a single value. I have written numerous blog posts on Window Functions, many here recently. I decided to make this blog post a compilation of all the Window Function posts I have written, providing a one-stop source for any readers interested in learning more about Window Functions…

[Continue reading for more PHP/Python/MySQL content >>>]