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

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

Use MySQL BLOB column with PHP to store .pdf file

Like always I am sharing new things I learn here on my blog. I was recently working on a requirement for a LAMP stack web application reporting dashboard in which I needed to store – and eventually – retrieve a .pdf file. I have read in several places (this fantastic book is a great resource) that a viable option is storing images or documents (.pdf in this case) in the actual database table as opposed to on the server file system. MySQL has the BLOB datatype that can be used to store files such as .pdf, .jpg, .txt, and the like. In this blog post, I cover how I accomplished uploading and storing the actual .pdf file in a BLOB column in MySQL using PHP. Any corrections, tips, pointers, and recommendations for best practices are always welcome. We all learn as we go!!!

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

Beginning Perspective on PHP Arrays

Arrays are one of the most important PHP data types. An array is composed of 1 or more key/value pairs and can store any type (E.g., strings, integers, decimal numbers, etc…). Array values (or elements) are accessed via a key (index), which is either numerical-based or a string-based. Arrays composed of string-based indexes are known as associative arrays. Keep reading for an introductory-level coverage of PHP arrays, as I understand them…

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

MySQL Shell Python mode for multiple ALTER TABLE statements – easily

There may come a time you need to rename one or more columns in an existing MySQL table for a variety of reasons. Using ALTER TABLE, to rename a column is an easy enough command. But, suppose there are multiple tables in the same database/schema that have the same-named column and all of those columns need to be renamed. That could be a lot of ALTER TABLE statements to type out. Save your energy and time, avoiding all of those ALTER TABLE commands all-together. If you are lucky enough to be working with a MySQL version > 8.0 then the Shell is your salvation. With just a few lines of Python code in \py mode, all of your trouble(s) and headache(s) are no more…

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