From the course: PHP for Web Designers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Loading data into MySQL

Loading data into MySQL - PHP Tutorial

From the course: PHP for Web Designers

Start my 1-month free trial

Loading data into MySQL

The ability to connect to a database and display the results is probably one of the most compelling reasons for learning PHP. And working with the database is what this chapter is all about. Throughout the chapter we'll be working with the mixed arrangements page in the Hansel and Petal site. It currently contains 24 small images with accompanying captions. That are hard-coded into the HTML. Clicking one of the images loads a dummy page for a description of the flower arrangement. By the end of this chapter, we'll have converted both pages so they draw content from a database. The database system that we'll be using is MySQL, which its website describes as the world's most popular open source database, and no wonder, it's powerful and relatively easy to use, and is widely used in combination with PHP. It's the default database system most hosting companies provide with PHP. The built in PHP functions that we'll be using in this chapter are designed to work exclusively with MySQL. But…

Contents