Learning PHP and MySQL

Chapter 1. Dynamic Content and the Web There are two types of web pages: static and dynamic. A static site provides hyperlinked text and perhaps a login screen, but beyond that, it doesn't require additional participation from the use...

Chapter 2. Installation Developers working with PHP and MySQL often find it convenient to work on a local computer rather than a web server. In general, it is also safer to create and test your applications on a localpreferably privatecom...

Chapter 3. Exploring PHP With PHP, MySQL, and Apache installed, you're ready to begin writing code. Unlike many languages, PHP doesn't require complex tools such as compilers and debuggers. In fact, you'll soon see that you can enter PHP...

Chapter 4. PHP Decision Making In the last chapter, you started to get a feel for programming with PHP and some code basics. Now it's time to expand your knowledge and ability with PHP. We'll start with expressions and statements. Con...

Chapter 5. Functions To write programs in PHP that contain more than just a couple of pages of code and are still organized enough to be useful, you need to understand functions. Functions provide a way to eliminate repeating the same l...

Chapter 6. Arrays Variables are great for storing a single piece of information, but what happens when you need to store data for a whole set of information, like the results of a query? For this, you use arrays. Arrays are a special kind...

Chapter 7. Database Basics We're now going to introduce you to basic database structure so that you have an understanding of databases. Adding MySQL to PHP and combining the applications for your dynamic web site is a great start. But, it...

Chapter 8. Using MySQL Now that we've learned basic SQL information and the essentials of designing a database, it's time to learn how to connect to the MySQL database using the client tools that come with MySQL. We'll also cover how to u...

Chapter 9. Getting PHP to Talk to MySQL Now that you're comfortable using the MySQL client tools to manipulate data in the database, you can begin using PHP to display and modify data from the database. PHP has standard functions for work...

Chapter 10. Working with Forms HTML forms provide a way to send substantial data from the user to the server where it can be processed. You'll be using a lot of the PHP language concepts that you learned about in the first half of the boo...

Chapter 11. Practical PHP In this chapter, we'll start working on some of the more common tasks that you'll perform when writing PHP programs, such as work with strings, display formats for strings, as well as dates and time. We'll also s...

Chapter 12. Modifying MySQL Objects and PHP Data This chapter extends what you learned in Chapter 11 to show you how to perform more complicated database tasks from PHP. We'll learn how to create and modify both data and database objects...

Chapter 13. Cookies, Sessions, and Access Control As your applications grow more complex, you'll need to keep better track of which user your program is working with. Cookies, sessions, and access control all provide an opportunity to int...

Chapter 14. Security Section 14.1. Section 14.2. Session Security Section 14.3. Chapter 14 Questions The CHM file was converted to HTM by Trial ver...

Chapter 15. Validation and Error Handling We've already discussed performing validation within our PHP code. In this chapter, we'll explore our options for validating form data before a form submission. We'll also discuss what to do when...

Chapter 16. Sample Applications You now know enough about PHP and MySQL to build full-featured web applications. These could be practically anything, from web-based mail clients to online stores with shopping carts and checkout capabiliti...

Chapter 17. Finishing Your Journey You've created a blog. You've started out learning the ins and outs of dynamic web development and how the Internet world is changing rapidly. Dynamic web sites are what clients, your employer, and you...