DATE_FORMAT(date,format) Formats the date value according to the format string.
Category Archives: MySQL
PHP’s sprintf() on a MySQL query utilizing DATE_FORMAT()
So what’s the solution? You have to “comment-out” the % that aren’t part of your sprintf() substitution. You can do this by putting another % in front of the ‘%’ symbols in the DATE_FORMAT() function. This deems them as a literal percent-sign instead of the start of another sprintf() “variable”.
Real-World OOP With PHP and MySQL
Numerous examples from robots to bicycles have been offered as “easy” explanations of what OOP is. I’ve opted to show you how OOP works with a real-life example, for a programmer. By creating a MySQL CRUD class you can easily create, read, update and delete entries in any of your projects, regardless of how the …
Easy Access With PDO CRUD
Abstract MySQL SQLite Summary Abstract The term CRUD refers to the four basic functionalities used in most PHP applications.
MySQL Scheduler
From the release of MySQL 5.1.6 comes the inclusion of a scheduler. The scheduler, as the name suggests, schedules tasks within the database in the same way as triggers. In fact, the scheduler is just that, a temporal trigger. Many of the tasks assigned to the scheduler have been run from cron, but not everybody …
Introduction to PHP PDO
Introduction to PHP PDO (PHP Data Objects) by Kevin Waterson Contents What is PDO What Databases does PDO support Where do I begin? Connect to a Database Connect to PgSQL Connect to SQLite Connect to MySQL Connect to Firebird Connect to Informix Connect to Oracle Connect to ODBC Connect to DBLIB Connect to IBM There …