1. Home
  2. Programming
  3. PHP & MySQL. Programming for beginners

Challenges

Challenges

  1. Design a basic database. Start with something simple like a phone list.

  2. Create your database in SQL.

  3. Write a batch program to create and populate your database.

  4. Use SQLyog to manipulate your database and view its results in other formats.




Chapter 1: Exploring the PHP Environment
Chapter 2: Using Variables and Input
Chapter 3: Controlling Your Code with Conditions and Functions
Chapter 4: Loops and Arrays: The Poker Dice Game
Chapter 5: Better Arrays and String Handling
Chapter 6: Working with Files
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
Chapter 9: Data Normalization
Chapter 10: Building a Three-Tiered Data Application