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:

  1. 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
  2. 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 Primer

PHP Language Constructs

 

PHP Basics - Part 1: Simple PHP Output

PHP Basics - Part 2: Conditions and Loops

PHP Basics - Part 3: Arrays

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

 

Working with Text in PHP

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

Classes and Objects in PHP

PHP Classes: Inheritance and Serialize

Working with Files in PHP

 

PHP and XML: Part 1: XML

PHP and XML: Part 2: Processing XML Documents

PHP and XML: Part 3: WDDX

PHP and XML: Part 4: RSS Feeds

 

PHP and MySQL Basics

Installing MySQL on a Windows PC

MySQL Data Types

 

FREE! PHP and MySQL in Dreamweaver MX Note: PHP 4 Specific

FREE! PHP and Dreamweaver MX Continued

MySQL Search

Advanced Search

 

MySQL Security

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 User comments system

 

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.I

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

File Uploading with PHP

PHP Recordset Paging

 

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

Thumbnail generation with PHP

Saving PHP thumbnail data

PHP: Working with Image colour

 

Graphics in PHP

PHP Shape drawing tools

PHP: Dynamic Arcs, Circles and Polygons

 

Graphing with PHP

Graphing with PHP: Line Graphs

Graphing – dynamic 3D bar charts

 

PHP Graphing – Pie 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

 

Tips for Building A Project

 

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

Ian BlackhamFollowing 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.

See All Postings From Ian Blackham >>