MySQL, MySQLi and PDO Compared

MySQL

[link] Your PHP website - how to factor and refactor to reduce growing pains
[link] Reading and using emails including enclosures on your web server.
[link] Which or ATOC - who reads train fares right?
[link] Why would you want to use a Perl hash?
[link] A threat in the post? Poor marketing practise from Smiletrain?

MySQLi - structured approach

[link] Take the dog on a lead - do not carry her. Perl references.
[link] Getting more log information from the Apache http web server
[link] A demonstration of how many Python facilities work together
[link] Pressing ^C in a Python program. Also Progress Bar.
[link] Research is exciting. But should routine be automated?

MySQLi - Object approach

[link] Sundays - and over eating
[link] Exceptions - a fail-safe way of trapping things that may go wrong
[link] 3 digit HTTP status codes - what are they, which are most common, which should be a concern?
[link] Ruby at both extremes of your website
[link] Sigils - the characters on the start of variable names in Perl, Ruby and Fortran

PDO (accessing the same MySQL database in this case)

[link] Divide 10000 by 17. Do you get 588.235294117647, 588.24 or 588? - Ruby and PHP
[link] 1 + 1 + 1 + 1 = 12?
[link] Assigning values to variables within other statements - Ruby
[link] Ruby off the Rails?
[link] Making best use of the new enthusiasm for Melksham

The four sections above show the outputs from four separate database connections and data accesses - each does essentially the same thing but in a very different way (we have selected to look at records which are current, from last week, and the week before to make it a bit more interesting). There will be a "view source" button below if you're looking at this script on our live training server ... so you can examine and compare the code.

Training sample © 2024, WELL HOUSE CONSULTANTS LTD
This is http://www.wellho.net/demo/approach.php
See source code here • More examples - same topic here
Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
Phone: +44 (0) 1225 708 225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net