PHP & MySQL

The Missing Manual

By: Brett Mclaughlin

Write A Review

Paperback | 20 November 2012 | Edition Number 2

At a Glance

Paperback
600 Pages

Edition Type
Revised

Dimensions(cm)
9.5 x 5 x 3

Boxing Day Sale

Up to 60% off* RRP on a great range of titles.

Ends 12/01/26

View Promotion >

Paperback

Limited Stock Available

RRP $76.00

$30.00

61%OFF

or 4 interest-free payments of $7.50 with

In Stock and Ships in 1-2 business days

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. With step-by-step tutorials, this completely revised edition gets you started with expanded coverage of the basics and takes you deeper into the world of server-side programming.

The important stuff you need to know:

Get up to speed quickly. Learn how to install PHP and MySQL, and get them running on both your computer and a remote server.
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. Master the tools for fixing things that go wrong.
Control operations. Create an administrative interface to oversee your site.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Web Programming O'Reilly Programming & Scripting Languages Booktopia Publisher Services John Wiley & Sons Publishers UK Bargains Non-Fiction Bargains Autobiography and Biography Bargains

The Missing Credits	p. vii
Introduction	p. 1
PHP and MySQL Basics
PHP: What, Why, and Where?	p. 15
PHP Comes in Two Flavors: Local and Remote	p. 15
PHP: Going Local	p. 21
Write Your First Program	p. 38
Run Your First Program	p. 40
But Where's That Web Server?	p. 42
PHP Meets HTML	p. 45
Script or HTML?	p. 46
PHP Talks Back	p. 51
Run PHP Scripts Remotely	p. 54
PHP Syntax: Weird and Wonderful	p. 61
Get Information from a Web Form	p. 62
Working with Text in PHP	p. 69
The REQUEST Variable Is an Array	p. 83
What Do You Do with User Information?	p. 90
MySQL and SQL: Database and Language	p. 91
What Is a Database?	p. 91
Installing MySQL	p. 95
SQL Is a Language for Talking to Databases	p. 104
Dynamic Web Pages
Connecting PHP to MySQL	p. 119
Writing a Simple PHP Connection Script	p. 120
Cleaning Up Your Code with Multiple Files	p. 132
Building a Basic SQL Query Runner	p. 138
Regular Expressions	p. 155
String Matching, Double-Time	p. 156
Generating Dynamic Web Pages	p. 173
Revisiting a User's Information	p. 174
Planning Your Database Tables	p. 175
Saving a User's Information	p. 182
Show Me the User	p. 190
Revisiting (and Redirecting) the Create User Script	p. 208
From Web Pages to Web Applications
When Things Go Wrong (and They Will)	p. 221
Planning Your Error Pages	p. 223
Finding a Middle Ground for Error Pages with PHP	p. 229
Add Debugging to Your Application	p. 237
Redirecting On Error	p. 242
Handling Images and Complexity	p. 253
Images Are Just Files	p. 254
Images Are for Viewing	p. 279
And Now for Something Completely Different	p. 288
Binary Objects and Image Loading	p. 289
Storing Different Objects in Different Tables	p. 290
Inserting a Raw Image into a Table	p. 292
Your Binary Data Isn't Safe to lnsert…Yet	p. 296
Connecting Users and Images	p. 303
Show Me the Image!	p. 313
Embedding an Image Is Just Viewing an Image	p. 324
So, Which Approach Is Best?	p. 330
Listing, Iterating, and Administrating	p. 333
Thinking about What You Need as an Admin	p. 334
Listing All Your Users	p. 337
Deleting a User	p. 345
Talking Back to Your Users	p. 351
Standardizing on Messaging	p. 362
Integrating Utilities, Views, and Messages	p. 369
Security and the Real World
Authentication and Authorization	p. 385
Basic Authentication	p. 386
Abstracting What's the Same	p. 395
Passwords Don't Belong in PHP Scripts	p. 399
Passwords Create Security, But Should Be Secure	p. 413
Cookies, Sign-Ins, and Ditching Crummy Pop-Ups	p. 419
Moving Beyond Basic Authentication	p. 420
Logging In with Cookies	p. 426
Adding Context-Specific Menus	p. 443
Authorization and Sessions	p. 455
Modeling Groups in Your Database	p. 455
Checking for Group Membership	p. 461
Group-Specific Menus	p. 471
Entering Browser Sessions	p. 475
Memory Lane: Remember That Phishing Problem?	p. 486
Why Would You Ever Use Cookies?	p. 489
Appendixes
Installing PHP on Windows Without WAMP	p. 493
Installing MySQL Without MAMP or WAMP	p. 499
Index	p. 513
Table of Contents provided by Ingram. All Rights Reserved.

PHP & MySQL

The Missing Manual

At a Glance

Boxing Day Sale

Up to 60% off* RRP on a great range of titles.

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Web Programming

Coding For Dummies, All New Edition

For Dummies (Computer/Tech)

Python Workout, Second Edition

200 ten-minute exercises

Python All-in-One For Dummies

3rd Edition

Web Engineering

Theory and Practice

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Introduction to Machine Learning with Python

A Guide for Data Scientists

Fluent Python

Clear, Concise, and Effective Programming 2nd Edition

PHP, MySQL, & JavaScript All-In-One For Dummies

For Dummies

Python for Excel

A Modern Environment for Automation and Data Analysis

Learning Go

An Idiomatic Approach to Real-World Go Programming

Python Cookbook

Recipes for Mastering Python : 3rd Edition

Java

An Introduction to Problem Solving and Programming, 8th Global Edition

Developing Graphics Frameworks with Java and OpenGL

Architecture Patterns with Python

Enabling Test-Driven Development, Domain-Driven Design, and Event-Driven Microservices

Cloud Computing

2nd Edition - Concepts, Technology, Security, and Architecture

Data Management at Scale

Modern Data Architecture with Data Mesh and Data Fabric

Learn Python 3 the Hard Way

A Very Simple Introduction to the Terrifyingly Beautiful World of Computers and Code

Python for Finance 2e

Mastering Data-Driven Finance

Flask Web Development, 2nd Edition

Developing Web Applications with Python

Learning Spark

Lightning-Fast Data Analytics

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Mastering Shiny

Build Interactive Apps, Reports, and Dashboards Powered by R

This product is categorised by