Here are some articles on PHP and MySQL which you may find useful:

Download/Source details
1 Using PHP 4's DOM XML functions to create XML files from SQL data
(amended 22nd August 2004)
2 How to create a Year-to-a-Page calendar view source code
3 How to create a Loan Amortisation and Interest Calculation routine view source code
4 Using PHP 4's Sablotron extension to perform XSL Transformations
(amended 22nd August 2004)
5 How to handle a Many-to-Many relationship with PHP and MySQL
(amended 2nd February 2019)
6 Using PHP Objects to access your Database Tables (Part 1)
7 Using PHP Objects to access your Database Tables (Part 2)
(amended 31st August 2003)
8 A class for validating and formatting dates
(amended 21st November 2011)
view source code
9 Customising the PHP error handler
(amended 15th April 2014)
10 A Binary-Octal-Decimal-Hexadecimal-Base36 converter
(amended 7th April 2004)
view source code
11 How to calculate the elapsed time of an event
12 A reversible password encryption routine for PHP
(amended 16th June 2007)
view source code
13 A Development Infrastructure for PHP
(amended 4th February 2023)
14 Transaction Patterns for Web Applications
(amended 1st June 2021)
15 A Sample PHP Application
(amended 1st August 2011)
sample-application.zip (525KB)
(amended 23rd January 2013)
16 Dealing with null end dates
17 Keeping a history of changes by date
(amended 23rd August 2005)
18 Pagination - what it is and how to do it
19 Back Button Blues
20 Reusable XSL Stylesheets and Templates
(amended 3rd June 2006)
21 The Model-View-Controller (MVC) Design Pattern for PHP
(amended 25 July 2021)
22 A Role-Based Access Control (RBAC) system for PHP
(amended 1st May 2014)
23 FAQ on the Radicore Development Infrastructure
(amended 1st November 2022)
24 Using PHP 5's DOM functions to create XML files from SQL data
25 Using PHP 5's XSL functions to perform XSL Transformations
26 Creating an Audit Log with an online viewing facility
(amended 15th October 2015)
27 A flexible Tree structure
28 User Guide to the Menu and Security (RBAC) System
(amended 1st January 2023)
29 An activity based Workflow Engine for PHP
(amended 1st November 2016)
30 UML diagrams for the Radicore Development Infrastructure
31 Client Clones and Server Sessions
(amended 18th September 2017)
32 A Data Dictionary for PHP Applications
(amended 1st November 2022)
33 Saving PHP's Session data to a database
(amended 21th December 2005)
34 Internationalisation and the Radicore Development Infrastructure (Part 1)
(amended 1st January 2013)
35 The Singleton Design Pattern for PHP
(amended 10th March 2007)
36 Creating a PostgreSQL driver for the Radicore Development Infrastructure
37 Performing client-side XSL transformations
(amended 21st June 2006)
38 RADICORE for PHP - Functions, Methods and Variables
(amended 1st November 2022)
39 Working with a stateless protocol
(amended 19th August 2006)
40 RADICORE - Rapid Application Development Toolkit visit www.radicore.org for details
41 The RADICORE Security Model
(amended 1st January 2023)
42 Is Radicore better than Ruby On Rails?
(amended 18th October 2006)
43 Prototype Product Application
(amended 9th July 2006)
44 Prototype Classroom Scheduling Application
45 Prototype Survey/Questionnaire Application
46 RADICORE for PHP - Inserting optional JavaScript
(amended 1st May 2019)
47 RADICORE for PHP - creating PDF output
(amended 9th January 2020)
48 A flexible method of storing control data
49 RADICORE for PHP - Extending the Validation class
(amended 15th January 2007)
50 Radicore for PHP - Tutorial (Part 1)
51 Radicore for PHP - Tutorial (Part 2)
(amended 1st January 2013)
52 Radicore for PHP - Tutorial (Part 3)
53 Radicore for PHP - Tutorial (Part 4)
54 Radicore for PHP - Tutorial (Part 5)
(amended 1st January 2013)
55 Creating an Oracle driver for the Radicore Development Infrastructure
(amended 1st November 2015)
56 RADICORE for PHP - Implementing Virtual Private Databases
(amended 1st April 2016)
57 Internationalisation and the Radicore Development Infrastructure (Part 2)
58 The use of Cascading Style Sheets within Radicore
(amended 1st June 2011)
59 Using Radicore components in a front-end website
(amended 9th November 2009)
60 Creating a SQL Server driver for the Radicore Development Infrastructure
(amended 1st November 2015)
61 Support for PHP4 stops, support for PHP7 starts
62 How Radicore's Hook System Works
(amended 1st September 2018)
63 How Radicore prevents CSRF attacks
64 How Radicore prevents SQL Injection attacks
65 Evolution of the RADICORE framework
(amended 4th February 2023)

counter