PHP & MySQL

by
Edition: 2nd
Format: Paperback
Pub. Date: 2012-11-27
Publisher(s): Oreilly & Associates Inc
List Price: $42.82

Buy New

Usually Ships in 2-3 Business Days
$40.78

Rent Book

Select for Price
There was a problem. Please try again later.

Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$40.79
*To support the delivery of the digital material to you, a non-refundable digital delivery fee of $3.99 will be charged on each digital item.
$40.79*

Used Book

We're Sorry
Sold Out

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

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 quickly discover the power of server-side programming. This second edition provides new code files and expanded coverage of local and server-side programming. The important stuff you need to know: Learn the language. Get up to speed on PHP and SQL syntax quickly. Gain new techniques. Take advantage of the all-new chapter on integrating PHP with HTML web pages. Manage your content. Use the file system to access user data, including images and other binary files. Make it dynamic. Create pages that change with each new viewing. Build a good database. Use MySQL to store user information and other data. Keep your site working. Learn the tools for fixing things that go wrong. Control operations. Create an administrative interface to oversee your site.

Author Biography

Brett McLaughlin is a senior-level technologist and strategist, active in web programming and data-driven customer-facing systems. He designs, manages, and implements large-scale applications from start to finish with mission-critical implementations. Formerly an editor at O'Reilly Media, he's written several technical books, including Java and XML and Head First Object-Oriented Analysis and Design.

Table of Contents

The Missing Creditsp. vii
Introductionp. 1
PHP and MySQL Basics
PHP: What, Why, and Where?p. 15
PHP Comes in Two Flavors: Local and Remotep. 15
PHP: Going Localp. 21
Write Your First Programp. 38
Run Your First Programp. 40
But Where's That Web Server?p. 42
PHP Meets HTMLp. 45
Script or HTML?p. 46
PHP Talks Backp. 51
Run PHP Scripts Remotelyp. 54
PHP Syntax: Weird and Wonderfulp. 61
Get Information from a Web Formp. 62
Working with Text in PHPp. 69
The REQUEST Variable Is an Arrayp. 83
What Do You Do with User Information?p. 90
MySQL and SQL: Database and Languagep. 91
What Is a Database?p. 91
Installing MySQLp. 95
SQL Is a Language for Talking to Databasesp. 104
Dynamic Web Pages
Connecting PHP to MySQLp. 119
Writing a Simple PHP Connection Scriptp. 120
Cleaning Up Your Code with Multiple Filesp. 132
Building a Basic SQL Query Runnerp. 138
Regular Expressionsp. 155
String Matching, Double-Timep. 156
Generating Dynamic Web Pagesp. 173
Revisiting a User's Informationp. 174
Planning Your Database Tablesp. 175
Saving a User's Informationp. 182
Show Me the Userp. 190
Revisiting (and Redirecting) the Create User Scriptp. 208
From Web Pages to Web Applications
When Things Go Wrong (and They Will)p. 221
Planning Your Error Pagesp. 223
Finding a Middle Ground for Error Pages with PHPp. 229
Add Debugging to Your Applicationp. 237
Redirecting On Errorp. 242
Handling Images and Complexityp. 253
Images Are Just Filesp. 254
Images Are for Viewingp. 279
And Now for Something Completely Differentp. 288
Binary Objects and Image Loadingp. 289
Storing Different Objects in Different Tablesp. 290
Inserting a Raw Image into a Tablep. 292
Your Binary Data Isn't Safe to lnsert…Yetp. 296
Connecting Users and Imagesp. 303
Show Me the Image!p. 313
Embedding an Image Is Just Viewing an Imagep. 324
So, Which Approach Is Best?p. 330
Listing, Iterating, and Administratingp. 333
Thinking about What You Need as an Adminp. 334
Listing All Your Usersp. 337
Deleting a Userp. 345
Talking Back to Your Usersp. 351
Standardizing on Messagingp. 362
Integrating Utilities, Views, and Messagesp. 369
Security and the Real World
Authentication and Authorizationp. 385
Basic Authenticationp. 386
Abstracting What's the Samep. 395
Passwords Don't Belong in PHP Scriptsp. 399
Passwords Create Security, But Should Be Securep. 413
Cookies, Sign-Ins, and Ditching Crummy Pop-Upsp. 419
Moving Beyond Basic Authenticationp. 420
Logging In with Cookiesp. 426
Adding Context-Specific Menusp. 443
Authorization and Sessionsp. 455
Modeling Groups in Your Databasep. 455
Checking for Group Membershipp. 461
Group-Specific Menusp. 471
Entering Browser Sessionsp. 475
Memory Lane: Remember That Phishing Problem?p. 486
Why Would You Ever Use Cookies?p. 489
Appendixes
Installing PHP on Windows Without WAMPp. 493
Installing MySQL Without MAMP or WAMPp. 499
Indexp. 513
Table of Contents provided by Ingram. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.