Make the leap into server-side programming with this hands-on guide to PHP! We'll cover installation, database design principles, object oriented programming, controlling access, publishing data on the web, and building your own frameworks. It's everything to take you from Novice to Ninja!

PHP & MySQL: Novice to Ninja, 7th Edition

Preface

In this book, I’ll guide you as you take your first steps beyond the static world of building web pages with the purely client-side technologies of HTML, CSS, and JavaScript. Together, we’ll explore the world of building websites, and discover the dizzying array of dynamic tools, concepts, and possibilities they open up. Whatever you do, don’t look down!

Installation

Now that you have your server up and running, it’s time to write your first PHP script. PHP is a server-side language. This concept may be a little difficult to grasp, especially if you’ve only ever designed websites using client-side languages like HTML, CSS, and JavaScript.

Introducing PHP

As I explained in the last chapter, PHP is a server-side scripting language that lets you insert instructions into your web pages that your web server software will execute before it sends those pages to browsers that request them. We’ve looked at a few basic examples, including generating random numbers and using forms to capture input from a user.

Introducing MySQL

This is it—the stuff you signed up for! In this chapter, you’ll learn how to take information stored in a MySQL database and display it on a web page for all to see.

Publishing MySQL Data on the Web

Since Chapter 3, we’ve worked with a very simple database of jokes, composed of a single table named (appropriately enough) joke . While this database has served us well as an introduction to MySQL databases, there’s more to relational database design than can be understood from this simple example. In this chapter, we’ll expand on this database and learn a few new features of MySQL, in an effort to realize and appreciate the real power that relational databases have to offer.

Relational Database Design

Before we plow headlong into the next enhancements of our joke database, let’s spend a little time honing your “PHP-fu”. Specifically, I want to show you a few techniques to better structure your code.

Structured PHP Programming

In the last chapter, I showed you how to break code up into easily reusable functions. This has several advantages:

Improving the Insert and Update Functions

In the last chapter, I showed you how to write generic, reusable functions that could be used to manipulate any database table. In this chapter, we’ll move those functions into a class, to avoid some of the repetition that’s needed when they’re used.

Objects and Classes

Now that you’re able to write a controller with methods, and call those methods from index.php , the next step is to add the rest of the pages for managing the website. Currently, we can add jokes to the database through index.php by specifying an action URL parameter. However, a real website will need to do considerably more than handle basic database operations for a single table.

Creating an Extensible Framework

Now that we’ve done all the hard work of building an extensible framework, it’s time to add some new functionality to the website. We’re going to make it so that users can register accounts on the website with a view to letting them post jokes themselves.

Allowing Users to Register Accounts

In the last chapter, I showed you how users can register accounts on the website. Now it’s time to make those accounts functional, so that users can log in to the website. The process is familiar to web users: they enter a username and password, and get access to content that’s unique to their account.

Cookies, Sessions, and Access Control

As you’ve worked through the construction of the Internet Joke Database website, you’ve had opportunities to explore most aspects of Structured Query Language (SQL). You’ve been introduced to many SQL commands now—from the basic form of a CREATE TABLE query to the two syntaxes of INSERT queries.

Relationships

We’re almost there! We’ve designed a database to store jokes, organized them into categories, and tracked their authors. We’ve learned how to create a web page that displays this library of jokes to site visitors. We’ve even developed a set of web pages that a site administrator can use to manage the joke library without knowing anything about databases.

Unlock This Title

Community Questions