Exercises, examples and other material relating to training module S159. This topic is presented on public course MySQL
Related technical and longer articlesMySQL version 5, PHP version 5 and mysqli
|Articles and tips on this subject||updated|
|3455||MySQL, MySQLi, PDO or something else - how best to talk to databases from PHP|
One of the consideration that users of Open Source programming languages have make is which one of many ways to do any particular task. Open Source tends to result in lots of very clever facilities being provided, many of which overlap in their use, and many modules being provided via libraries such ...
|2172||PHP4 v PHP5 - Object Model Difference|
In PHP, there was a major change in the object model between version 4 and version 5. This code here - incredibly - runs differently on the two versions and what happens when you assign an object to another variable has changed.
In PHP 4, the object being assigned is duplicated, so that if you change ...
|1754||Upgrade from PHP 4 to PHP 5 - the TRY issue|
It's often the most surprising things that catch you out on language upgrades! Our new web server is running PHP 5 (5.2.6) whereas the old shared service was running PHP 4. No problem with the conversion, PHP wise, except the exchange rate page which goes to the European Central Bank's web site and ...
|104||mysql_connect or mysql_pconnect in PHP?|
If you're connecting to a MySQL database in your PHP application, you'll find that there are two alternative connections - mysql_connect which establishes a new connection "each time" and mysql_pconnect which uses persistent connections. Which should you use?
Mysql_connect opens a new connection each ...
|1455||Connecting to MySQL 5 from PHP on Mac OSX Leopard|
What is the difference between "localhost" and "127.0.0.1"? Everything, it seems, when you're trying to connect MySQL (and I have version 5.0.37 Community at the moment) running on Mac OSX - the latest Leopard release - with their PHP release including the MySQL drivers. It's PHP release 5.2.4.
|1417||What software version do we teach?|
To go with the very latest - even if the customers don't have it in common use yet, or to stay with older and well loved versions even though there is a new model out? A thorny question and one I'm addressing at the moment for the 2008 brochure. I write ...
"""With a few notable exceptions, Open ...
|1131||MySQL - Password security (authentication protocol)|
Ever had this message?
bash> mysql -h www.weekendinwiltshire.co.uk -u weekend -p
Enter password: ******
Client does not support authentication protocol requested by server; consider upgrading MySQL client
The MySQL login password / security model changed between MySQL version 4.0 and version 4.1. ...
|515||MySQL - an FAQ|
We're becoming a serious MySQL resource, with many technical articles, examples, forum posts and blog entries answering those difficult-to-resolve issues you may have come across. You might like to bookmark (or link to) this page.
Eleven recent articles on MySQL ...
Flashbulb moments - facts that ...
|494||MySQL - a score of things to remember|
From the initial raw mass of data through to a fully functional database application .... a long road with many things to learn. I've run two short MySQL courses this week, including some coverage of how to access the data they contain from PHP based web pages and I never cease to amaze myself at how ...
Examples from our training material
Some modules are available for download
as a sample of our material or under an Open Training Notes License
for free download from http://www.training-notes.co.uk
Topics covered in this module
MySQL 3 -> 4 -> 5.
PHP 3 -> 4 -> 5.
The PHP/MySQL driver issue.
Sample code using mysql and mysqli.
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule
Well House Consultants specialise in training courses in
. We run
throughout the UK (and beyond for longer courses), and
at our training centre in Melksham, Wiltshire, England.
It's surprisingly cost effective to come on our public courses -
even if you live in a different
country or continent to us
We have a technical library of over 700 books on the subjects on which we teach.
These books are available for reference at our training centre. Also
available is the Opentalk
Forum for discussion of technical questions.