WooCommerce block product editor | Escaping output in PHP and Laravel | SQL must go | GitHub and MySQL v8. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.
(more…)SQL
5 Websites To Learn More SQL – Substack Repost
SQL is foundational in web and application programming. There are many websites and resources online to learn SQL. I like these 5 websites and think you will too…
(more…)CodeIgniter 4 Database Features Overview in 2022 – Substack Repost
CodeIgniter 4 is a solid, well-designed PHP framework and one I enjoy using and exploring every chance I get. In 2022, the CodeIgniter 4 team released many database-related upgrades. Learn more about the ones I found most significant in this OpenLampTech report.
(more…)OpenLampTech issue #58 – Substack Repost
OpenLampTech is back with another solid newsletter covering the PHP, MySQL, and LAMP stack media for you. I hope you are enjoying these newsletters. I know I learn and enjoy each and every one of them in more ways than one. Be sure and share the publication with someone else you think would be interested in this content. Thank you!
(more…)Simulate LEAD() Window Function using correlated subquery
In my honest opinion, MS Access is one garbage of a database. More likely, database is too strong of a word. While I won’t be using Access in this article, there is a story there (but I’m not here to have an Access bash party). Continue reading for an example of how you may use a correlated subquery and simulate the LEAD() Window Function.
(more…)