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

Summary

Summary

Although you didn't write any PHP at all in this chapter, you did learn how to create a basic data structure using the SQL language. You learned how to work with the MySQL console to create, and use databases. You learned how to return data from your database using the SELECT statement. You know how to modify the SELECT statement to get more specific results. You learned how SQLyog can simplify the creation and manipulation of MySQL databases. You built a data structure for an adventure game.




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