Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
20.9.2014 - We have just updated our course layouts and descriptions and added our 2015 schedule.


Well House Consultants
You are on the site of Well House Consultants who provide Open Source Training Courses and business hotel accommodation. You are welcome to browse and use our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java Resources
Well House Manor Resources
Perl Resources
Python Resources
PHP Resources
Object Orientation and General topics
MySQL Resources
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
Extras Resources
C and C++ Resources
Ruby Resources
Tcl/Tk Resources
Web and Intranet Resources
MySQL module S159
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 subjectupdated
3455MySQL, 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
 
2172PHP4 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
 
1754Upgrade 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
 
104mysql_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
 
1455Connecting 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
 
1417What 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
 
1131MySQL - 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
 
515MySQL - 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
 
494MySQL - 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 http://www.training-notes.co.uk.
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 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. Also available is the Opentalk Forum for discussion of technical questions.


You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/resources/S159.html • PAGE BUILT: Thu Sep 18 11:03:17 2014 • BUILD SYSTEM: WomanWithCat