Publisher: O'Reilly Media / Pogue Press Released: November 2011 Pages: 500
If you can build websites with CSS and JavaScript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, you’ll soon discover the power of server-side programming. The important stuff you need to know: - Get a running start. Write PHP scripts and create a web form right away.
- Learn the language. Get up to speed on PHP and SQL syntax quickly.
- Build a database. Use MySQL to store user information and other data.
- Make it dynamic. Create pages that change with each new viewing.
- Be ready for mistakes. Plan error messages to help direct users.
- Manage your content. Use the file system to access user data, including images and other binary files.
- Control operations. Create an administrative interface to oversee your site.
|
-
PHP and MySQL Basics -
Chapter 1 PHP: What, Why, and Where? - Gathering Your Tools
- Writing Your First Program
- Running Your First Program
- Writing Your Second Program
- Upload Your HTML, CSS, and PHP
- Running Your Second Program
-
Chapter 2 PHP Syntax: Weird and Wonderful - Get Information from a Web Form
- Working with Text in PHP
- The $_REQUEST Variable
- What Do You Do with User Information?
-
Chapter 3 MySQL and SQL: Database and Language - What Is a Database?
- Installing MySQL
- SQL Is a Language for Talking to Databases
-
Dynamic Web Pages -
Chapter 4 Connecting PHP to MySQL - Writing a Simple PHP Connection Script
- Cleaning Up Your Code with Multiple Files
- Building a Basic SQL Query Runner
-
Chapter 5 Better Searching with Regular Expressions - String Matching, Double-Time
-
Chapter 6 Generating Dynamic Web Pages - Revisiting a User’s Information
- Planning Your Database Tables
- Saving a User’s Information
- Show Me the User
- Redirection and Revisitation of Creating Users
-
From Web Pages to Web Applications -
Chapter 7 When Things Go Wrong (and They Will) - Planning Your Error Pages
- Finding a Middle Ground for Error Pages with PHP
- Add Debugging to Your Application
- Redirecting on Error
-
Chapter 8 Handling Images and Complexity - Images Are Just Files
- Images Are For Viewing
- And Now for Something Completely Different
-
Chapter 9 Binary Objects and Image Loading - Storing Different Objects in Different Tables
- Inserting a Raw Image into a Table
- Your Binary Data Isn’t Safe to Insert…Yet
- Connecting Users and Images
- Show Me the Image
- Embedding an Image Is Just Viewing an Image
- So Which Approach is Best?
-
Chapter 10 Listing, Iterating, and Administrating - Some Things Never Change
- Listing All Your Users
- Deleting a User
- Talking Back To Your Users
- Standardizing on Messaging
- Integrating Utilities, Views, and Messages
-
Security and the Real World -
Chapter 11 Authentication and Authorization - Start with Basic Authentication
- Abstracting What’s the Same
- Passwords Don’t Belong in PHP Scripts
- Passwords Create Security, But Should Be Secure
-
Chapter 12 Cookies, Sign-ins, and Ditching Crummy Pop-ups - Going Beyond Basic Authentication
- Logging In with Cookies
- Adding Context-Specific Menus
-
Chapter 13 Authorization and Sessions - Modeling Groups in Your Database
- Checking for Group Membership
- Group-Specific Menus
- Entering Browser Sessions
- Memory Lane: Remember that Phishing Problem?
- So Why Ever Use Cookies?
|
- Title:
- PHP & MySQL: The Missing Manual
- By:
- Brett McLaughlin
- Publisher:
- O'Reilly Media / Pogue Press
- Formats:
-
- Print
- Ebook
- Safari Books Online
- Print:
- November 2011
- Ebook:
- November 2011
- Pages:
- 500
- Print ISBN:
- 978-0-596-51586-7
- | ISBN 10:
- 0-596-51586-3
- Ebook ISBN:
- 978-1-4493-1887-1
- | ISBN 10:
- 1-4493-1887-8
|
-
Brett McLaughlin Brett McLaughlin has become one of the most well-known authors and programmers in the Java and XML communities. He's worked for Nextel Communications, implementing complex enterprise systems, at Lutris Technologies, actually writing application servers, and most recently at O'Reilly Media, Inc., where he continues to write and edit books that matter. His most recent book, "Java 5.0 Tiger: A Developer's Notebook", was the first book available on the newest version of Java, and his classic Java and XML remains one of the definitive works on using XML technologies in Java. View Brett McLaughlin's full profile page. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
 |
|
 |
|
|
|
Recommended for You
|
Recently Viewed
|
 |
|
By Carla Sinclair
November 2010
By Jennifer Smith, AGI Creative Team
By Fred Gerantabee, AGI Creative Team
November 2007
|
Customer Reviews
2/12/2012 (3 of 3 customers found this review helpful) 2.0PHP & MySQL : The Missing Manual By Mat from Bentonville, AR 1/9/2012 1.0A Failure in the Missing Manual Series By FatBear from Toronto, ON About Me Designer, Developer - Difficult to understand
- Too many errors
1/4/2012 (0 of 1 customers found this review helpful) 1.0Where is the missing CD code 12/29/2011 (3 of 3 customers found this review helpful) 1.0Errors, errors and more errors. - Easy to understand
- Well-written
- Not comprehensive enough
- Too many errors
12/18/2011 (1 of 1 customers found this review helpful) 4.0straightforward yet comprehensive By David Briddock from UK About Me Designer, Developer, Educator - Easy to understand
- Helpful examples
- Well-written
12/14/2011 (1 of 1 customers found this review helpful) By AmeJane from Phildelphia, PA About Me Designer, Developer - Easy to understand
- Helpful examples
|
|
|
Merchant response: I'm sorry for the inconvenience. The files are now available for download from the Missing CD page http://missingmanuals.com/cds/phpmysqlmm/
The direct link to download the zip file is http://examples.oreilly.com/9780596515867/PHPMySQLMissingCD.zip