Thomas is an undergraduate student from the UK who is currently studying at the university of Portsmouth. He has a strong interest in PHP, object-oriented design, database management systems, and system administration.
This series aims to raise awareness among developers who still use the old MySQL extension, to inform them of its problems, and to help them switch over to an alternative extension like MySQLi or PDO. This is the second part in the two-part series, and we focus on PDO – PHP Data Objects.
Experienced developers eschew the original MySQL extension because of its abandoned status in PHP. Nascent web developers, however, may be completely oblivious to its dormant past and dying future. It’s the intention of this two-part series to raise awareness among developers who still use it, to inform them of its problems, and to help them switch over to an alternative extension. After all, who really wants to write a script knowing that it won’t work in a near-future version of PHP? In this part we focus on MySQLi.
When put to good use, MySQL triggers can have not only a positive impact on your site’s performance, but will also save you from writing out numerous lines of PHP to handle related actions. This article will give you some insight into the creation and usage of MySQL triggers, so that by the end of you’ll be able to make use of them in your own projects.