MySQL 5 and PHP 5

Exercises, examples and other material relating to training module S159. This topic is presented on public course MySQL

Related technical and longer articles

MySQL 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 ...	2011-09-24
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 ...	2009-05-12
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 ...	2008-08-16
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 ...	2008-05-11
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. In ...	2007-12-03
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 ...	2007-11-02
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. ...	2007-04-02
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 ...	2006-06-09
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 ...	2006-06-05 (longer)

Examples from our training material

5,2,5,i.php5	Using PHP mysqli functions - a working example
vlatest.php5	A simple example using PHP mysql functions
vlatesti.php5	How NOT to use mysqli - don't just add an i

Background information

Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from [here].

Topics covered in this module

An overview.
MySQL 3 -> 4 -> 5.
PHP 3 -> 4 -> 5.
The PHP/MySQL driver issue.
OLD_PASSWORD.
Recongnising problems.
Sample code using mysql and mysqli.

Complete learning

If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Ruby, Lua, Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses 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.