Guess what? OpenLampTech, the newsletter for PHP/MySQL developers, has a new issue full of great curated content for your reading experience this week. Come on by and read the publication!
(more…)Database
OpenLamp.tech #7 – MySQL Metadata with CodeIgniter 4
After taking the week of Christmas off, OpenLamp.tech – the newsletter for PHP/MySQL developers – is back with a massive issue for you this week to close out the month and the year. In this issue, we are covering MySQL metadata in CodeIgniter 4. Continue reading for more information…
(more…)5 PHP Date Functions and Their MySQL Equivalents
Anyone working with data is going to encounter date values at some point. Dates are necessary for many reasons. If you’re a PHP/MySQL Developer, you have date function options for both the database and your programming language of choice. In this post, I cover 5 PHP date functions and their (somewhat) MySQL equivalents with examples of each. Continue reading…
(more…)CodeIgniter 4 Query Builder set() function with update()
CodeIgniter 4 Query Builder class has an update() function used to process UPDATE Data Manipulation Language (DML) commands. Using update() as a standalone function call is perfectly valid. However, there is also a set() function used for setting column values as you would with the SET keyword in an SQL UPDATE statement. Used in conjunction with the Query Builder where() function, you can easily UPDATE column values for an individual row or multiple rows. Continue reading for more information…
(more…)