PHP/MySQL Articles on DMXzone
Bewildered by the depth of our PHP articles? Confused by the range and scope? Perturbed by the DMXzone browsing system (don't worry that's high on the agenda in the next redesign)?
Well hopefully this laundry list of the DMXzone premium content articles covering the areas of PHP, MySQL and a few related topics will be of great assistance the next time you're looking for a nugget of PHP knowledge.
PHP/MySQL Articles on DMXzone
The majority of these articles were written using PHP 4, please note PHP 5 was released in July 2004. As regards these articles the two important changes between the two versions are:
- PHP 5 includes SQLite (a SQL database engine that can be embedded directly into your applications) bundled in the download and support is enabled by default
- MySQL is not enabled by default and the supplied extension needs to be specifically activated
PHP 5 specific articles are identified in the appropriate section.
eB = Article features as a chapter in the the DMXzone e-book PHP Web Applications for Dreamweaver: Juicy Solutions for the Busy Developer.
If you're interested in getting a number of articles covering PHP applications the e-book might present an economic way forward. If that doesn't appeal, take a look at our discount coupon scheme for example the 10 article coupon or the 20 article coupon (although others are available).
PHP Language and Syntax
PHP Basics - Part 1: Simple PHP Output
PHP Basics - Part 2: Conditions and Loops
PHP Basics - Part 4: Functions
PHP Basics - Part 5: Forms, GET and POST
PHP Basics - Part 6: Email contact forms
PHP Basics - Part 7: Connecting to a MySQL Database
PHP Basics - Part 8: Cookies and Sessions
PHP Basics - Part 9: Working with Objects
PHP Basics - Part 10: String Handling in PHP
PHP Basics - Part 11: Working with Files
PHP advanced text functions: These are a few of my favourite strings
PHP Regular Expressions Made Easy .. well, easier.
Working with Session Variables in PHP
PHP Classes: Inheritance and Serialize
PHP and XML: Part 2: Processing XML Documents
PHP and XML: Part 4: RSS Feeds
PHP and MySQL Basics
Installing MySQL on a Windows PC
FREE! PHP and MySQL in Dreamweaver MX Note: PHP 4 Specific
FREE! PHP and Dreamweaver MX Continued
Preventing SQL Injection Hacks
Backing up MySQL Databases made easy with PHP
Shiny New MySQL - Current and forthcoming
PHP 5 Specific
Installing PHP 5 under Windows
SQLite: new PHP-bundled database
SQLite 2: The Killer Features (and the sadly lacking)
PHP Applications
Creating a Dynamic News Feed in PHP
Creating a Simple Email Form in PHP
Creating Calendars in PHP - Part 1 (eB)
Creating Calendars in PHP - Part 2 (eB)
Creating Calendars in PHP - Part 3 (eB)
Creating Calendars in PHP – Part 4 (eB)
PHP Custom Web Statistics - Part 1 (eB)
PHP Custom Web Statistics - Part 2 (eB)
PHP Custom Web Statistics - Part 3 (eB)
PHP Custom Web Statistics – Part 4: Graphing the Statistics (eB)
PHP/ CSS Image Gallery - Part 1 (eB)
PHP/ CSS Image Gallery - Part 2 (eB)
PHP/ CSS Image Gallery - Part 3 (eB)
PHP/ CSS Image Gallery - Part 4 (eB)
PHP: Registration and confirmation system - Part 1 (eB)
PHP: Registration and confirmation system - Part 2: Validation Code Image (eB)
PHP: Registration and confirmation system - Part 3 (eB)
PHP: Password Encryption and Retrieval (Optional extension to above series) (eB)
User-Customised Content - Building content based on user profiles
Advanced User-Customised Content
A PHP Based Opinion Poll: Pt. II
Building an XML Flash Application with PHP and MySQL Pt.I
Building an XML Flash Application with PHP and MySQL Pt.II
More Advanced PHP Topics
Creating a Custom Database Class
PHP: External Debugging With Sockets
Generating PDF Files with PHP: Pt. 1
Generating PDF Files with PHP: Pt. 2
PHP and Image Handling
Creating Dynamic Images from PHP
PHP: Working with Image colour
Graphics in PHP
PHP: Dynamic Arcs, Circles and Polygons
Graphing with PHP: Line Graphs
Graphing – dynamic 3D bar charts
PHP Graphing: Pie Charts Coloured and Exploded
PHP Graphing: 3D-Effect Pie Charts
PHP, MySQL and Dreamweaver
Setting up a PHP Site & MySQL Connection in Dreamweaver MX
Dreamweaver MX and PHP Recordsets explained
Dreamweaver MX 2004 PHP Server Behaviors
Related Technologies
MySQL: Exporting Data to Excel I
MySQL: Exporting Data to Excel II: Going straight to Excel
MySQL: Exporting Data to Excel III: BiffWriter for Dummies
Getting Started with the Firebird Database
Connecting to the Firebird Database
Interacting with the Firebird Database: Using PHP to Insert, Update and Delete Records
Ian Blackham
Following a degree in Chemistry and a doctorate in Scanning Tunneling Microscopy, Ian spent several years wrestling with acronyms in industrial R&D (SEM with a side order of EDS, AFM and TEM augmented with a topping of XPS and SIMS and yet more SEM and TEM).
Feeling that he needed a career with more terminology but less high voltages, Ian became a technical/commissioning editor with Wrox Press working on books as diverse as Beg VB Application Development and Professional Java Security. After Wrox's dissolution and a few short term assignments Ian became content manager at DMXzone.
Ian is a refugee from the industrial Black Country having slipped across the border to live in Birmingham. In his spare time he helps out with the website of a local history society, tries to makes sure he does what his wife Kate says, and worries that the little 'un Noah is already more grown up than he is.