Download PDF MySQL®/PHP Database Applications, Second Edition by Brad Bulger, Jay Greenspan, and David Wall

Sinopsis

Soon we will head off on a fabulous journey, a journey on which we will explore the ins and outs of MySQL and PHP database applications in great detail. It’s goingto be a fun trip; we just know it.
 

Okay, maybe we’re being a bit optimistic. If you’re anything like us, points of this particular journey will be a lot more tedious than they are exciting. Let’s face facts: Application development isn’t always the most exciting thing in the world. And as with any other venture that involves programming, some very frustrating times are sure to be ahead, whether because of a syntax error you can’t find or a piece of code that won’t do what you think it ought to do. But despite all that, here you are, and we think there is a very good reason for that.
 

Web applications are the present and the future. No matter your background, whether you have a history with Visual Basic or COBOL, or maybe just some HTML and JavaScript, your résumé is only going to improve with some Web application development experience. We don’t think there’s a better combination of tools to have under your belt than PHP and MySQL. The numbers bear us out. PHP and MySQL are becoming increasingly popular, and the demand for people who can use these tools will only increase.
 

A bit later in this introduction we go into a more detailed explanation of why you should use PHP and MySQL. However, before we can get to that, we want take a bit of time to go over the architecture of Web applications. Once we’ve done this, we can explain in detail why PHP and MySQL should be the centerpieces of your application-development environment. Once we’ve sold you on these tools, we present
a very quick and grossly under-coded application. As you look over this application, you can see the basic syntax and principles behind PHP and MySQL.

Content

1. Working with MySQL
2. Database Design with MySQL
3. The Structured Query Language for Creating and Altering Tables
4. The Structured Query Language for Inserting, Editing, and Selecting Data
5. Working with PHP
6. Getting Started with PHP Variables
7. Control Structures
8. PHP’s Built-in Functions
9. Writing Organized and Readable Code
10. Simple Applications
11. Guestbook 2003, the (Semi-)Bulletproof Guestbook
12. Survey
13. Not So Simple Applications
14. Threaded Discussion
15. Content-Management System
16. Catalog
17. Problem-Tracking System
18. Shopping Cart
19. XML Parsing
20. SOAP
21. Project Management

Click here to download