MySQL is one of the most popular open source database management system for the development of interactive Websites.
Category Archives: MySQL
PHP SQL queries using ezSQL
Nowadays, most websites and web applications are database driven, which means that you, the developer, have to query the database to get the requested information. Let’s take a look at a very useful tool to handle SQL queries easily and efficiently on small to medium projects.
ezSQL
ezSQL is an open source PHP database class that I wrote a while back. It’s used on over 100k websites and is the backbone of many open source projects such as WordPress. The class makes it ridiculously easy to use mySQL, Oracle8, SQLite (PHP), within your PHP script. Includes lots of examples making it very …
MySQL group by day, month or year using a timestamp column
In Ruby on Rails, created_at and updated_at columns are MySQL timestamp columns. GROUP BY is pretty useless on a timestamp column, unless you are trying to group rows that were added at the same second. I needed to group by just the date, so in order to do this I had to manipulate the …
Continue reading “MySQL group by day, month or year using a timestamp column”
mysql Reserved Words
Reserved Words Certain words such as SELECT, DELETE, or BIGINT are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions.
SQLite PHP tutorial
About this tutorial This is a PHP programming tutorial for the SQLite database. It covers the basics of SQLite programming with PHP language. There are two ways to code PHP scripts with SQLite library. We can use procedural functions or OOP objects and methods. In this tutorial, we use the classical procedural style. You might …