PHP & MySQL: The Missing Manual. 2nd Edition - Helion
ebook
Autor: Brett McLaughlinISBN: 978-14-493-5554-8
stron: 546, Format: ebook
Data wydania: 2012-11-13
Księgarnia: Helion
Cena książki: 126,65 zł (poprzednio: 147,27 zł)
Oszczędzasz: 14% (-20,62 zł)
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.
Osoby które kupowały "PHP & MySQL: The Missing Manual. 2nd Edition", wybierały także:
- SQL. Kurs video. Kompendium wiedzy na podstawie MySQL 159,00 zł, (63,60 zł -60%)
- PHP i MySQL. Kurs video. Tw 149,00 zł, (67,05 zł -55%)
- MySQL. Kurs video. Od podstaw do zagadnień zaawansowanych. Tworzenie i analizowanie baz danych 59,00 zł, (26,55 zł -55%)
- Wydajna praca z MySQL. Efektywne i bezpieczne zarz 89,00 zł, (44,50 zł -50%)
- MySQL. Jak zaprojektowa 129,00 zł, (64,50 zł -50%)
Spis treści
PHP & MySQL: The Missing Manual. 2nd Edition eBook -- spis treści
- PHP & MySQL: The Missing Manual, Second Edition
- SPECIAL OFFER: Upgrade this ebook with OReilly
- The Missing Credits
- About the Author
- About the Creative Team
- Acknowledgments
- The Missing Manual Series
- Introduction
- What PHP and MySQL Can Do
- What Is PHP?
- What Is PHP Like?
- PHP Is All About the Web
- JavaScript Is Loose, PHP IsLess So
- PHP Is Interpreted
- PHP Doesnt Run in the Browser
- What Is MySQL?
- About This Book
- Macintosh and Windows
- FTP: Its Critical
- About the Outline
- About the Online Resources
- Missing CD
- Registration
- Feedback
- Errata
- Safari Books Online
- 1. PHP and MySQL Basics
- 1. PHP: What, Why, and Where?
- PHP Comes in Two Flavors: Local and Remote
- HTML and CSS Run Within a Web Browser
- JavaScript Adds Complexity, but Not Software
- PHP Is Not Part of Your Browser
- Write Anywhere, Run Where Theres PHP
- PHP: Going Local
- PHP on the Windows-Based Computers (WampServer Installation)
- PHP on the Mac (Default Installation)
- PHP on the Mac (MAMP Installation)
- Get Out Your Text Editor
- Write Your First Program
- Run Your First Program
- But Wheres That Web Server?
- The PHP Interpreter Is a Program You Can Run
- But, the HTML Is Coming
- PHP Comes in Two Flavors: Local and Remote
- 2. PHP Meets HTML
- Script or HTML?
- Determination by Extension
- HTML Is Treated as HTML
- PHP Is Not HTML (by Extension)
- PHP Can Be HTMLby Response
- PHP Talks Back
- Write Another PHP Script
- Variables Vary
- Check Things Out Locally
- Run PHP Scripts Remotely
- Upload your HTML, CSS, and PHP
- Run Your Second Program
- Welcome to Programming!
- Script or HTML?
- 3. PHP Syntax: Weird and Wonderful
- Get Information from a Web Form
- Accessing Request Parameters Directly
- Create Your Own Variables
- Working with Text in PHP
- Combine Text
- Searching Within Text
- Changing Text
- Trim and Replace Text
- Removing Extra Whitespace by Using Trim()
- Replacing Characters in Text by Using Str_replace()
- The $_REQUEST Variable Is an Array
- Arrays Can Hold Multiple Values
- PHP Gives You An Array of Request Information
- What Do You Do with User Information?
- Get Information from a Web Form
- 4. MySQL and SQL: Database and Language
- What Is a Database?
- Databases Are Persistent
- Databases Are All about Structure
- Good Databases Are Relational
- Installing MySQL
- The mysql Console Program: Your New Best Friend
- Run the mysql Tool on WampServer
- Find the MySQL Command-Line Program
- Give mysql the Right User and Password
- Run the mysql Tool on MAMP
- Set Up mysql for Your User Profile
- Give mysql the Right User and Password
- Run Your First SQL Query
- SQL Is a Language for Talking to Databases
- Logging In to Your Web Servers Database
- Selecting a Database with USE
- Using CREATE to Make Tables
- Using DROP to Delete Tables
- INSERT a Few Rows
- Using SELECT for the Grand Finale
- What Is a Database?
- 1. PHP: What, Why, and Where?
- 2. Dynamic Web Pages
- 5. Connecting PHP to MySQL
- Writing a Simple PHP Connection Script
- Connect to a MySQL Database
- Select the Database with PHP
- Viewing Your Databases Tables by Using SHOW
- Handling Errors by Determining If Your Results are Not
- Print Out Your SQL Results
- Cleaning Up Your Code with Multiple Files
- Replacing Hand-Typed Values with Variables
- Abstracting Important Values into a Separate File
- Variables Vary, but Constants Stay Constant
- Building a Basic SQL Query Runner
- Creating an HTML Form with a Big Empty Box
- Connecting to Your Database (Again)
- Running Your Users SQL Query (Again)
- Entering Your First Web-Based Query
- Handling Queries That Dont SELECT Information
- Dealing with Humans
- Avoid Changing User Input Whenever Possible
- Writing a Simple PHP Connection Script
- 6. Regular Expressions
- String Matching, Double-Time
- A Simple String Searcher
- Search for One StringOr Another
- Getting into Position
- Ditch trim and strtoupper
- Searching for Sets of Characters
- Regular Expressions: To Infinity and Beyond
- A Little Cleanup: Remove the echo Statements
- String Matching, Double-Time
- 7. Generating Dynamic Web Pages
- Revisiting a Users Information
- Planning Your Database Tables
- Good Database Tables Have ID Columns
- Auto Increment Is Your Friend
- IDs and Primary Keys are Good Bedfellows
- Adding Constraints to Your Database
- Saving a Users Information
- Building Your SQL Query
- Inserting a User
- A First Pass at Confirmation
- Users are Users, Not Programmers
- Show Me the User
- Creating a Mockup of a User Profile Page
- Changing a Tables Structure by Using ALTER
- Building Your Script: First Pass
- Using SELECT to Retrieve a User from Your Database
- Pulling Values from a SQL Query Result
- Passing a User ID into show_user.php
- Revisiting (and Redirecting) the Create User Script
- Updating Your User Signup Form
- Updating Your User Creation Script
- Rounding Things Out by Using Regular Expressions (Again)
- 5. Connecting PHP to MySQL
- 3. From Web Pages to Web Applications
- 8. When Things Go Wrong (and They Will)
- Planning Your Error Pages
- What Should Users See?
- Tell Your Users that a Problem has Occurred
- Bring Down the Panic Level in the Process
- Know When to Say When
- What Should Users See?
- Finding a Middle Ground for Error Pages with PHP
- Creating a PHP Error Page
- Testing Your Solution
- Expect the Unexpected
- Welcome to Security and Phishing
- Phishing and Subtle Redirection
- The Dangers of Request Parameters
- Add Debugging to Your Application
- Whos Using This App, Anyway?
- Now You See Me, Now You Dont
- Moving from require to require_once
- Redirecting On Error
- Update connect.php to show_user.php
- Simplifying and Abstracting Your Code
- redirect Is Path-Insensitive
- Planning Your Error Pages
- 9. Handling Images and Complexity
- Images Are Just Files
- HTML Forms Can Set the Stage
- Uploading a Users Image to Your Server
- Set Up Some Helper Variables
- Did the File Upload with Any Errors?
- Is this Really an Uploaded File?
- Is the Uploaded File Really an Image?
- Move the File to a Permanent Location
- Storing the Image Location in the Database
- Create a New Database Column
- Insert the Image Path Into Your Table
- Check Your Work
- Images Are for Viewing
- SELECTing the Image and Displaying It
- Converting File System Paths to URLs
- Displaying Your Users Image: Take Two
- And Now for Something Completely Different
- Images Are Just Files
- 10. Binary Objects and Image Loading
- Storing Different Objects in Different Tables
- Inserting a Raw Image into a Table
- Beware: getimagesize Doesnt Return a File Size
- The file_get_contents Function Does What You Think It Does
- INSERTing the Image
- Your Binary Data Isnt Safe to InsertYet
- Printing a String to a Variable
- Getting the Correct ID Before Redirecting
- Connecting Users and Images
- Inserting an Image and then Inserting a User
- Joining Tables by Using WHERE
- Connect Your Tables Through Common Columns
- Alias Your Tables (and Columns)
- Show Me the Image!
- Displaying an Image
- Make a Game Plan for Your Script
- Get the Image ID
- Build and Run a Select Query
- Get the Results, Get the Image, and Deal with Potential Errors
- Tell the Browser Whats Coming
- Send the Image Data
- Handling Errors with try and catch
- Test, Test, Always Test
- Displaying an Image
- Embedding an Image Is Just Viewing an Image
- All You Need Is an Image ID
- A Script Can Be an Image src
- So, Which Approach Is Best?
- OK, If You Insist on an Answer
- 11. Listing, Iterating, and Administrating
- Thinking about What You Need as an Admin
- (User Interface) Brevity Is Still the Soul of Wit
- Wish Lists Are Good, Too
- Listing All Your Users
- SELECTing What You Need (Now)
- Building a Simple Admin Page
- Iterating Over Your Array
- Deleting a User
- Surveying the Individual Components
- Putting It All Together
- Deleting Users Shouldnt Be Magical
- Start with a Little Javascript
- Finish with a Change in Linking
- Talking Back to Your Users
- redirect Has Some Limitations
- JavaScript alert Redux
- An All-Javascript Approach
- Your PHP Controls your Output
- alert Is Interruptive
- Standardizing on Messaging
- Building a New Utility Function for Display
- Duplicate Code Is a Problem Waiting to Happen
- View and Display Code Belongs Together
- Integrating Utilities, Views, and Messages
- Calling Repeated Code from a View Script
- Flexible Functions Are Better Functions
- Use Default Argument Values in Display_Messages
- Output a Standard Header with Heredoc
- Update Your Script(s) to Use Display_Head
- Standardizing and Consolidating Messaging in the View
- Building a Function to Call Two Functions
- Just Pass That Information Along
- Thinking about What You Need as an Admin
- 8. When Things Go Wrong (and They Will)
- 4. Security and the Real World
- 12. Authentication and Authorization
- Basic Authentication
- Using HTTP Headers for Basic Authentication
- Basic Authentication IsWell, Basic
- The Worst Authentication Ever
- Getting Your Users Credentials
- Cancel Is Not a Valid Means of Authentication
- Getting Your Users Credentials
- Abstracting Whats the Same
- Another Utility Script: authorize.php
- Passwords Dont Belong in PHP Scripts
- Updating the users Table
- Dealing with Newly Invalid Data
- Getting an Initial User Name and Password
- Inserting the User Name and Password
- Connect authorize.php to Your users Table
- Passwords Create Security, But Should Be Secure
- Encrypting Text by Using the crypt Function
- crypt Is One-Way Encryption
- Encryption Uses Salt
- Basic Authentication
- 13. Cookies, Sign-Ins, and Ditching Crummy Pop-Ups
- Moving Beyond Basic Authentication
- Starting with a Landing Page
- Taking Control of User Sign Ins
- From HTTP Authentication to Cookies
- What is a Cookie?
- Create and Retrieve Cookies
- Logging In with Cookies
- Determining Whether the User Is Already Signed In
- Is the User Trying to Sign In?
- Displaying the Page
- Redirecting as Needed
- Logging In the User
- Blank Pages and Expiring Cookies
- Errors Arent Always Interruptive
- An Option for Repeat Attempts
- Adding Context-Specific Menus
- Putting a Menu into Place
- From HTML to Scripts
- Any HTML File Can Be Converted to PHP
- Challenge: Be Self-Referential with User Creation
- Logging Users Out
- Requiring the Cookie to Be Set
- Moving Beyond Basic Authentication
- 14. Authorization and Sessions
- Modeling Groups in Your Database
- Adding a Groups Table
- The Many-to-Many Relationship
- One-to-One, One-to-Many, Many-to-Many
- Joins are Best Done with IDS
- Use a Join Table to Connect Users with Groups
- Testing Group Membership
- Checking for Group Membership
- authorize.php Needs a Function
- Take in a List of Groups
- Iterating Over Each Group
- Allow, Deny, Redirect
- Group-Specific Menus
- Entering Browser Sessions
- Sessions Are Server-Side
- Sessions Must Be Started
- From $_COOKIE to $_SESSION
- Sessions Must Be Restarted, Too
- $_REQUEST Doesnt Include $_SESSION
- Menu, Anyone?
- And Then, Sign Out
- Memory Lane: Remember That Phishing Problem?
- Why Would You Ever Use Cookies?
- Modeling Groups in Your Database
- 12. Authentication and Authorization
- 5. Appendixes
- A. Installing PHP on Windows Without WAMP
- Installing PHP from www.php.net
- B. Installing MySQL Without MAMP or WAMP
- Installing MySQL
- MySQL on Windows
- MySQL on Mac OS X
- Installing MySQL
- A. Installing PHP on Windows Without WAMP
- Index
- About the Author
- SPECIAL OFFER: Upgrade this ebook with OReilly
- Copyright