Join David Powers for an in-depth discussion in this video Loading data into MySQL, part of PHP for Web Designers.
…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 PHP is capable of working with a wide range of other databases.…
Author
David Powers
Released
12/9/2013Note: This course was recorded with Adobe Dreamweaver, but you can use the code editor of your choice to follow along.
- How to use PHP in a webpage
- Storing and displaying text and numbers in variables
- Using functions
- Adding comments to your PHP scripts
- Moving common page elements to include files
- Displaying different content on a page
- Working with multiple values in arrays and loops
- Getting form input sent by the POST method
- Using PHP sessions to preserve data
- Storing data in session variables
- Connecting to and querying a database
- Handling errors
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 30s
-
Using the exercise files5m 13s
-
-
1. Introduction to PHP
-
How to use PHP in a web page6m 43s
-
2. Using Server-Side Includes for Common Page Elements
-
3. Using Conditions to Change Page Output
-
How PHP makes decisions3m 30s
-
-
4. Working with Multiple Values in Arrays and Loops
-
Labeling array elements7m 22s
-
5. Getting User Input from a Form
-
Calculating the order total6m 34s
-
6. Displaying Content from a Database
-
Loading data into MySQL5m 37s
-
Connecting to the database7m 47s
-
Querying the database6m 15s
-
Linking to a details page2m 40s
-
-
7. Handling Errors
-
Dealing with PHP errors4m 15s
-
Tracking down parse errors4m 32s
-
-
Conclusion
-
What's next?2m 26s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Loading data into MySQL