The PHP code would take care of the rest, automatically displaying the new joke along with the others when it fetched the list from the database. Second, adding a joke to your website would be a simple matter of inserting the joke into the database. First, instead of writing an HTML page for each joke, you could write a single PHP script designed to fetch any joke from the database and display it by generating an HTML page for it on the fly. The advantage of this approach is twofold. In this example, the jokes would be stored entirely in the database. For example, you could tell PHP to look in the database for a list of jokes that you’d like to appear on your website.
#MYSQL WORKBENCH VIEW TABLE HOW TO#
In this chapter, we’ll learn what a database is, and how to work with your own databases using Structured Query Language (SQL).Ī database server is a program that can store large amounts of information in an organized format that’s easily accessible through programming languages like PHP. Now, that’s all well and good, but it really gets interesting when a database is added to the mix. We’ve looked at a few basic examples, including generating random numbers and using forms to capture input from a user. Displaying Data from MySQL on the Web: an IntroductionĪs 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.Setting Up Your PHP Development Environment with Docker.In this third tutorial in the series, you’ll learn what a database is, and how to work with your own databases using Structured Query Language (SQL). The following article is an excerpt from PHP & MySQL: Novice to Ninja, 7th Edition, a hands-on guide to learning all the tools, principles, and techniques needed to build a professional web application.
0 kommentar(er)
