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

Black Friday Sale

Up to 80% off RRP* across a great range of titles

Ends 03/12/25

View Promotion >

Paperback

RRP $76.00

$39.75

48%OFF

or 4 interest-free payments of $9.94 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

Black Friday Sale

Up to 80% off RRP* across 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)

Learning Go

An Idiomatic Approach to Real-World Go Programming

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Python All-in-One For Dummies

3rd Edition

Web Engineering

Theory and Practice

Fluent Python

Clear, Concise, and Effective Programming 2nd Edition

Beginner's Step-by-Step Coding Course

Learn Computer Programming the Easy Way

Building Web Apps with Bolt

Unlock the Future of AI-First Development

Building Event-Driven Microservices

Leveraging Organizational Data at Scale

Architecture Patterns with Python

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

Python for Excel

A Modern Environment for Automation and Data Analysis

Introduction to Machine Learning with Python

A Guide for Data Scientists

Flask Web Development, 2nd Edition

Developing Web Applications with Python

Building Micro-Frontends

Distributed Systems for the Frontend

Python Cookbook

Recipes for Mastering Python : 3rd Edition

Cloud Computing

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

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

For Dummies

Mastering Regular Expressions

OREILLY

Information Architecture

For the Web and Beyond : 4th Edition

Building Microservices

Designing Fine-Grained Systems 2nd Edition

Programming TypeScript

Making Your JavaScript Applications Scale

Spring Boot: Up and Running

Building Cloud Native Java and Kotlin Applications

Mastering Shiny

Build Interactive Apps, Reports, and Dashboards Powered by R

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

This product is categorised by