The web server software (typically Apache) recognizes that the requested file is a PHP script, so the server fires up the PHP interpreter to execute the code contained in the file.The visitor’s web browser requests the web page using a standard URL.Just so it’s clear and fresh in your mind, this is what will happen when a person visits a page on your database driven web site: It processes the page request and fetches the data from the MySQL database (using SQL queries just like those you used to create a table of jokes in Chapter 2: Introducing MySQL), then spits it out dynamically as the nicely formatted HTML page that the browser expects. At the other end you have the content of your site, which sits in one or more tables in a MySQL database that understands only how to respond to SQL queries (commands).Īs shown in the figure above, the PHP scripting language is the go-between that speaks both languages. So, at one end of the system you have a visitor to your site who uses a web browser to request a page, and expects to receive a standard HTML document in return. The whole idea of a database driven web site is to allow the content of the site to reside in a database, and for that content to be pulled from the database dynamically to create web pages for people to view with a regular web browser. It’s important to understand how these will fit together. We have two powerful tools at our disposal: the PHP scripting language and the MySQL database engine. The Big Pictureīefore we leap forward, it’s worth taking a step back for a clear picture of our ultimate goal. If you’d rather read this tutorial offline, you can download the chapters in PDF format. Now you’re ready to learn how to use these new tools together to create a true database driven web site!
So far, you’ve installed and learned the basics of MySQL, a relational database engine, and PHP, a server-side scripting language.
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.
0 kommentar(er)
