These rows and columns form a table that looks like the figure below.
Notice that, in addition to columns for the joke text (.
A database is composed of one or more tables, each of which contains a list of items, or things.
For our joke database, we’d probably start with a table called joke that would contain a list of jokes.
Once you’re able to run the command should work too.
In Chapter 1: Installation, we installed and set up two software programs: the Apache web server with PHP, and the My SQL database server.
In this chapter, we’ll learn how to work with My SQL databases using Structured Query Language (SQL).
The advantages of this approach would be twofold: First, instead of having to write an HTML page for each of your jokes, you could write a single PHP script that was designed to fetch any joke from the database and display it by generating an HTML page for it on the fly.
Second, adding a joke to your web site would be a simple matter of inserting the joke into the database.