reklama - zainteresowany?

Head First PHP & MySQL. A Brain-Friendly Guide - Helion

Head First PHP & MySQL. A Brain-Friendly Guide
ebook
Autor: Lynn Beighley, Michael Morrison
ISBN: 978-14-493-3155-9
stron: 814, Format: ebook
Data wydania: 2008-12-22
Księgarnia: Helion

Cena książki: 135,15 zł (poprzednio: 157,15 zł)
Oszczędzasz: 14% (-22,00 zł)

Dodaj do koszyka Head First PHP & MySQL. A Brain-Friendly Guide

Tagi: MySQL - Programowanie | PHP - Programowanie

If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.

Head First PHP & MySQL offers the same visually rich format that's turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.

  • Use PHP to transform static HTML pages into dynamic web sites
  • Create and populate your own MySQL database tables, and work with data stored in files
  • Perform sophisticated MySQL queries with joins, and refine your results with LIMIT and ORDER BY
  • Use cookies and sessions to track visitors' login information and personalize the site for users
  • Protect your data from SQL injection attacks
  • Use regular expressions to validate information on forms
  • Dynamically display text based on session info and create images on the fly
  • Pull syndicated data from other sites using PHP and XML
Throughout the book, you'll build sophisticated examples -- including a mailing list, a job board, and an online dating site -- to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.

Dodaj do koszyka Head First PHP & MySQL. A Brain-Friendly Guide

 

Osoby które kupowały "Head First PHP & MySQL. A Brain-Friendly Guide", wybierały także:

  • Mastering Amazon Relational Database Service for MySQL
  • Big Data and Analytics
  • PHP i MySQL. Kurs video. Tw
  • SQL. Kurs video. Kompendium wiedzy na podstawie MySQL
  • MySQL. Kurs video. Od podstaw do zagadnieÅ„ zaawansowanych. Tworzenie i analizowanie baz danych

Dodaj do koszyka Head First PHP & MySQL. A Brain-Friendly Guide

Spis treści

Head First PHP & MySQL. A Brain-Friendly Guide eBook -- spis treści

  • Head First PHP & MySQL
  • Dedication
  • A Note Regarding Supplemental Files
  • Advance Praise for Head First PHP & MySQL
  • Praise for Head First HTML with CSS & XHTML
  • Praise for Head First JavaScript
  • Author(s) of Head First PHP & MySQL
  • How to Use This Book: Intro
    • Who is this book for?
    • Who should probably back away from this book?
    • We know what youre thinking
    • We know what your brain is thinking
    • Metacognition: thinking about thinking
    • Heres what WE did:
    • Heres what YOU can do to bend your brain into submission
    • Read Me
    • The technical review team
    • Acknowledgments
    • Safari Books Online
  • 1. Add Life to your Static Pages: Its Alive
    • HTML is static and boring
    • PHP brings web pages to life
    • Dogs in space
    • A form helps Owen get the whole story
    • Forms are made of HTML
    • The HTML form has problems
    • HTML acts on the CLIENT
    • PHP acts on the SERVER
    • PHP scripts run on the server
    • Use PHP to access the form data
    • PHP scripts must live on a server!
    • Get your PHP scripts to the server
    • The server turns PHP into HTML
    • Deconstructing Owens PHP script
    • A few PHP rules to live code by
    • Finding the perfect variable name
    • Variables are for storing script data
    • $POST is a special variable that holds form data
    • $POST transports form data to your script
    • Creating the email message body with PHP
    • Even plain text can be formatted... a little
    • Newlines need double-quoted strings
    • Assemble an email message for Owen
    • Variables store the email pieces and parts
    • Sending an email message with PHP
    • Owen starts getting emails
    • Owen starts losing emails
    • Your PHP & MySQL Toolbox
  • 2. Connecting to MySQL: How it fits together
    • Owens PHP form works well. Too well...
    • MySQL excels at storing data
    • Owen needs a MySQL database
    • Create a MySQL database and table
    • The INSERT statement in action
    • Use SELECT to get table data
    • Let PHP handle the tedious SQL stuff
    • PHP lets data drive Owens web form
    • Connect to your database from PHP
    • Insert data with a PHP script
    • Use PHP functions to talk to the database
    • Get connected with mysqli_connect()
    • Build the INSERT query in PHP
    • Query the MySQL database with PHP
    • Close your connection with mysqliclose()
    • $POST provides the form data
    • Owen needs help sifting through his data
    • Owens on his way to finding Fang
  • 3. Create and Populate a Database: Creating your own data
    • The Elvis store is open for business
    • Elmer needs an application
    • Visualize Elmers application design
    • It all starts with a table
    • Make contact with the MySQL server
    • Create a database for Elmers emails
    • Create a table inside the database
    • We need to define our data
    • Take a meeting with some MySQL data types
    • Create your table with a query
    • Getting the cart table in front of the horse database
    • USE the database before you use it
    • DESCRIBE reveals the structure of tables
    • Elmers ready to store data
    • Create the Add Email script
    • The other side of Elmers application
    • The nuts and bolts of the Send Email script
    • First things first, grab the data
    • mysqli_fetch_array() fetches query results
    • Looping for a WHILE
    • Looping through data with while
    • Youve got mail...from Elmer!
    • Sometimes people want out
    • Removing data with DELETE
    • Use WHERE to DELETE specific data
    • Minimize the risk of accidental deletions
    • MakeMeElvis.com is a web application
    • Your PHP & MySQL Toolbox
  • 4. Realistic and Practical Applications: Your Application on the Web
    • Elmer has some irritated customers
    • Protecting Elmer from... Elmer
    • Demand good form data
    • The logic behind Send Email validation
    • Your code can make decisions with IF
    • Testing for truth
    • IF checks for more than just equality
    • The logic behind Send Email validation
    • PHP functions for verifying variables
    • Test multiple conditions with AND and OR
    • Form users need feedback
    • Ease in and out of PHP as needed
    • Use a flag to avoid duplicate code
    • Code the HTML form only once
    • A form that references itself
    • Point the form action at the script
    • Check to see if the form has been submitted
    • Some users are still disgruntled
    • Table rows should be uniquely identifiable
      • What Elmers table contains now:
      • What Elmers table should contain:
    • Primary keys enforce uniqueness
    • The five rules of primary keys:
    • From checkboxes to customer IDs
    • Loop through an array with foreach
    • Your PHP & MySQL Toolbox
  • 5. Working with Data Stored in Files: When a database just isnt enough
    • Virtual guitarists like to compete
      • Text cant be trusted
    • The proof is in the rockin picture
    • The application needs to store images
    • Planning for image file uploads in Guitar Wars
    • The high score database must be ALTERed
    • How do we get an image from the user?
    • Insert the image filename into the database
    • Find out the name of the uploaded file
    • Where did the uploaded file go?
    • Create a home for uploaded image files
    • Shared data has to be shared
    • Shared script data is required
    • Think of require_once as insert
    • Timing Order is everything with high scores
    • Honoring the top Guitar Warrior
    • Format the top score with HTML and CSS
    • Only small images allowed
    • File validation makes the app more robust
    • Plan for an Admin page
      • These pages are for users:
      • This page is only for the administrator:
    • Generate score removal links on the Admin page
    • Scripts can communicate with each other
    • Of GETs and POSTs
    • GET, POST, and high score removal
    • Isolate the high score for deletion
    • Control how much you delete with LIMIT
    • Your PHP & MySQL Toolbox
  • 6. Securing your Application: Assume theyre all out to get you
    • The day the music died
    • Where did the high scores go?
    • Securing the teeming hordes
    • Protecting the Guitar Wars Admin page
    • HTTP authentication requires headers
    • Take control of headers with PHP
    • Authenticating with headers
      • OK, so maybe Guitar Wars is NOT secure
    • Create an Authorize script
    • Guitar Wars Episode II : Attack of the High Score Clones
    • Subtraction by addition
    • Security requires humans
    • Plan for moderation in Guitar Wars
    • Make room for approvals with ALTER
    • Unapproved scores arent worthy
    • The million-point hack
    • Everything in moderation... ?
    • How exactly did she do it?
    • Tricking MySQL with comments
    • The Add Score form was SQL injected
    • Protect your data from SQL injections
    • A safer INSERT (with parameters)
    • Form validation can never be too smart
    • Cease fire!
    • Your PHP & MySQL Toolbox
  • 7. building personalized web apps: Remember me?
    • They say opposites attract
    • Mismatch is all about personal data
    • Mismatch needs user log-ins
      • Username
      • Password
    • Come up with a user log-in gameplan
    • Prepping the database for log-ins
    • Constructing a log-in user interface
    • Encrypt passwords with SHA()
    • Decrypting Comparing passwords
      • Making room for the encrypted password
    • Authorizing users with HTTP
    • Logging In Users with HTTP Authentication
    • A form for signing up new users
    • Give users a chance to sign up
    • Sometimes you just need a cookie
    • Whats in a cookie?
    • Bake Use cookies with PHP
    • Rethinking the flow of log-ins
    • A cookie-powered log-in
    • Navigating the Mismatch application
    • Logging out means deleting cookies
    • Sessions arent dependent on the client
    • The life and times of sessions
    • Keeping up with session data
    • Renovate Mismatch with sessions
    • Log out with sessions
    • Complete the session transformation
    • Users arent feeling welcome
    • Sessions are short-lived...
    • ... but cookies can last forever!
    • Sessions + Cookies = Superior log-in persistence
  • 8. Eliminate Duplicate Code: Sharing is caring
    • Mismatch is in pieces
    • Rebuilding Mismatch from a template
    • Rebuild Mismatch with templates
    • Mismatch is whole again... and much better organized
  • 9. Control your Data, Control your World: Harvesting data
    • Making the perfect mismatch
    • Mismatching is all about the data
    • Break down the Mismatch data
      • Categories
      • Topics
      • Responses
    • Model a database with a schema
    • Wire together multiple tables
    • Foreign keys in action
    • Tables can match row for row
    • One row leads to many
    • Matching rows many-to-many
    • Build a Mismatch questionnaire
    • Get responses into the database
    • We can drive a form with data
    • Speaking of efficiency...
    • Generate the Mismatch questionnaire form
    • The data is now driving the form
    • Strive for a bit of normalcy
    • When normalizing, think in atoms
    • Why be normal, really?
    • Three steps to a normal database
    • Altering the Mismatch database
    • So is Mismatch really normal?
    • A query within a query within a query...
    • Lets all join hands tables
    • Connect the with dots
    • Surely we can do more with inner joins
    • Simplifying ON with USING
    • Nicknames for tables and columns
    • Joins to the rescue
    • Love is a numbers game
    • Five steps to a successful mismatch
    • Prepare for the mismatch search
    • Compare users for mismatchiness
    • All we need is a FOR loop
    • Finishing the mismatching
    • Your PHP & MySQL Toolbox
  • 10. String and Custom Functions: Better living through functions
    • A good risky job is hard to find
    • The search leaves no margin for error
    • SQL queries can be flexible with LIKE
    • Explode a string into individual words
    • implode() builds a string from substrings
    • Preprocess the search string
    • Replace unwanted search characters
    • The query needs legit search terms
    • Copy non-empty elements to a new array
    • Sometimes you just need part of a string
    • Extract substrings from either end
    • Multiple queries can sort our results
    • Functions let you reuse code
    • Build a query with a custom function
    • SWITCH makes far more decisions than IF
    • Give build_query() the ability to sort
    • We can paginate our results
    • Get only the rows you need with LIMIT
    • Control page links with LIMIT
    • Keep track of the pagination data
    • Set up the pagination variables
    • Revise the query for paginated results
    • Generate the page navigation links
    • Putting together the complete Search script
    • The complete Search script, continued...
    • Your PHP & MySQL Toolbox
  • 11. Regular Expressions: Rules for replacement
    • Risky Jobs lets users submit resumes
    • Decide what your data should look like
    • Formulate a pattern for phone numbers
    • Match patterns with regular expressions
    • Build patterns using metacharacters
    • Fine-tune patterns with character classes
    • Check for patterns with preg_match()
    • Standardize the phone number data
    • Get rid of the unwanted characters
    • Matching email addresses can be tricky
    • Domain suffixes are everywhere
    • Use PHP to check the domain
    • Email validation: putting it all together
    • Your PHP & MySQL Toolbox
  • 12. Visualizing your Data... and More!: Drawing dynamic graphics
    • Guitar Wars Reloaded: Rise of the Machines
    • No input form is safe
    • We need to separate man from machine
    • We can defeat automation with automation
    • Generate the CAPTCHA pass-phrase text
    • Visualizing the CAPTCHA image
    • Inside the GD graphics functions
    • The GD graphics functions continued...
    • Drawing text with a font
    • Generate a random CAPTCHA image
    • Returning sanity to Guitar Wars
    • Add CAPTCHA to the Add Score script
    • Five degrees of opposability
    • Charting mismatchiness
    • Storing bar graph data
    • From one array to another
    • Build an array of mismatched topics
    • Formulating a bar graphing plan
    • Crunching categories
    • Doing the category math
    • Bar graphing basics
    • Draw and display the bar graph image
    • Individual bar graph images for all
    • Mismatch users are digging the bar graphs
    • Your PHP & MySQL Toolbox
  • 13. Syndication and Web Services: Interfacing to the world
    • Owen needs to get the word out about Fang
    • Push alien abduction data to the people
    • RSS pushes web content to the people
    • RSS is really XML
    • From database to newsreader
    • Visualizing XML RSS
    • Dynamically generate an RSS feed
    • Link to the RSS feed
    • A picture video is worth a thousand million words
    • Pulling web content from others
    • Syndicating YouTube videos
    • Make a YouTube video request
    • Owen is ready to build a REST request
    • YouTube speaks XML
    • Deconstruct a YouTube XML response
    • Visualize the XML video data
    • Access XML data with objects
    • From XML elements to PHP objects
    • Drill into XML data with objects
    • Not without a namespace!
    • Fang sightings are on the rise
    • Lay out videos for viewing
    • Format video data for display
    • Your PHP & MySQL Toolbox
  • A. Leftovers: The Top Ten Topics (we didnt cover)
    • #1. Retrofit this book for PHP4 and mysql functions
    • #2. User permissions in MySQL
    • #3. Error reporting for MySQL
    • #4. Exception handling PHP errors
    • #4. Exception handling PHP errors (cont.)
    • #5. Object-oriented PHP
    • #5. Object-oriented PHP (cont.)
      • So two big advantages of using Object Oriented PHP are:
    • #6. Securing your PHP application
    • #6. Securing your PHP application (cont.)
    • #7. Protect your app from cross-site scripting
    • #7. Protect your app from cross-site scripting (cont.)
      • Validate everything
      • Built-in PHP functions can help
      • Data is guilty until proven innocent
    • #8. Operator precedence
    • #9. Whats the difference between PHP 5 and PHP 6
      • More Unicode support
    • #9. Whats the difference between PHP 5 and PHP 6 (cont.)
      • OO refinements, XML support, and other changes
    • #10. Reusing other peoples PHP
      • Drupal
      • phpBB
      • Coppermine Gallery
      • WordPress
  • B. Set up a Development Environment: A place to play
    • Create a PHP development environment
    • Find out what you have
    • Do you have a web server?
    • Do you have PHP? Which version?
    • Do you have MySQL? Which version?
    • Start with the Web Server
    • Apache installation... concluded
    • PHP installation
    • PHP installation steps
    • PHP installation steps... concluded
    • Installing MySQL
      • Instructions and Troubleshooting
    • Steps to Install MySQL on Windows
      • Download your installer
      • Pick a destination folder
      • Click Install and youre done!
    • Enabling PHP on Mac OS X
    • Steps to Install MySQL on Mac OS X
    • Moving from production to a live site
    • Dump your data (and your tables)
    • Prepare to use your dumped data
    • Move dumped data to the live server
    • Connect to the live server
  • C. Extend your PHP: Get even more
    • Extending your PHP
      • If youre using Windows, youre in luck
    • And on the Mac...
  • Index
  • About the Authors
  • Copyright

Dodaj do koszyka Head First PHP & MySQL. A Brain-Friendly Guide

Code, Publish & WebDesing by CATALIST.com.pl



(c) 2005-2024 CATALIST agencja interaktywna, znaki firmowe należą do wydawnictwa Helion S.A.