Tutorial: PHP & MySQL. Programming for beginners

Please select a chapter from the "Contents" menu at the very bottom of the page.

PHP & MySQL. Programming for beginners

Chapter 1: Exploring the PHP Environment Introducing the " Tip of the Day " Program Programming on the Web Server Building Basic HTML Pages Using CSS to Enhance Your Pages Using Form Elements Adding PHP to Your Pages Creating the " Tip of the Day " Program Summary Challenges Chapter 2: Using Variables and Input Introducing the Story Program Using Variables in Your Scripts Using Variables for More Complex Pages Working with Numeric Variables Creating a Form to Ask a Question Sending Data without a Form Reading Input from Other Form Elements Returning to the Story Program Summary Challenges Chapter 3: Controlling Your Code with Conditions and Functions Examining the " Petals Around the Rose " Game Creating a Random Number Using the if Statement to Control Program Flow Working with Negative Results Working with Multiple Values Using the switch Structure to Simplify Programming Combining a Form and Its Results Using Functions to Encapsulate Parts of the Program Using Parameters and Function Values Managing Variable Scope Returning to the Petals Game Summary Challenges Chapter 4: Loops and Arrays: The Poker Dice Game Introducing the Poker Dice Program Counting with the for Loop Modifying the for Loop Using a while Loop Working with Basic Arrays Improving " This Old Man " with Arrays and Loops Keeping Persistent Data Writing the Poker Dice Program Summary Challenges Chapter 5: Better Arrays and String Handling Introducing the Word Search Creator Using the foreach loop to Work with an Array Creating an Associative Array Using Built-In Associative Arrays Creating a Multi-Dimensional Array Making a Two-Dimensional Associative Array Manipulating String Values Returning to the Word Search Creator Summary Challenges Chapter 6: Working with Files Previewing the Quiz Machine Saving a File to the File System Loading a File from the Drive System Reading a File into an Array Working with Directory Information Working with Formatted Text Creating the Quiz Machine Program Summary Challenges Chapter 7: Using MySQL to Create Databases Introducing the Adventure Generator Program Using a Database Management System Working with MySQL Creating a Database Writing a Script to Build a Table Working with a Database in SQLyog Creating More Powerful Queries Returning to the Adventure Game Summary Challenges Chapter 8: Connecting to Databases Within PHP Connecting to the Hero Database Returning to the Adventure Game Program Summary Challenges Chapter 9: Data Normalization Introducing the Spy Database The badSpy Database Designing a Better Data Structure Building Your Data Tables Building a Link Table for Many-Many Relationships Summary Challenges Chapter 10: Building a Three-Tiered Data Application Introducing the Spy Master Program Building the Design of the SpyMaster System Writing the Non-Library Code Creating the spyLib Library Module Summary Challenges