Head First PHP & MySQL

Front Cover
"O'Reilly Media, Inc.", Dec 22, 2008 - Computers - 774 pages

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.
 

What people are saying - Write a review

User ratings

5 stars
8
4 stars
2
3 stars
2
2 stars
1
1 star
0

Head First: Php & Mysql, What a great book!

User Review  - BrandonH - Borders

I have been developing websites since the beginning of what we all know as the internet. Up until recently I have paid to have all of the coding done. Nothing that I ever read about Php or Mysql could ... Read full review

User Review - Flag as inappropriate

Great tutorial for PHP & MYSQL. Thanks for this

All 8 reviews »

Contents

1 add life to your static pages Its Alive
1
2 Connecting to MySQL How it fits together
59
3 create and populate a database Creating your own data
103
4 realistic and practical applications Your Application on the Web
159
5 working with data stored in files When a database just isnt enough
223
6 securing your application Assume theyre all out to get you
295
7 building personalized web apps Remember me?
345
7 12 eliminate duplicate code Sharing is caring
417
9 string and custom functions Better living through functions
501
10 regular expressions Rules for replacement
561
11 visualizing your data and more Drawing dynamic graphics
605
12 syndication and web services Interfacing to the world
657
appendix i leftovers The Top Ten Topics we didnt cover
713
appendix ii set up a development environment A place to play
731
appendix iii extend your php Get even more
749
Index
755

8 control your data control your world Harvesting data
427

Other editions - View all

Common terms and phrases

About the author (2008)

Lynn Beighley is a fiction writer stuck in a technical book writer's body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it. After going back to school to get a Masters in Computer Science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller. A victim of bad timing, she moved to Silicon Valley just before the great crash. She spent several years working for Yahoo! and writing other books and training courses. Finally giving in to her creative writing bent, she moved to the New York area to get an MFA in Creative Writing. Her Head First-style thesis was delivered to a packed room of professors and fellow students. It was extremely well received, and she finished her degree, finished Head First SQL, and can't wait to begin her next book.



Lynn loves traveling, cooking, and making up elaborate background stories about complete strangers. She's a little scared of clowns.

Michael Morrison is a writer, developer, toy inventor, and author of a variety of books covering topics such as Java, Web scripting, game development, and mobile devices. Some of Michael's notable writing projects include JavaScript Bible, 6th Edition (Wiley, 2006),Teach Yourself HTML and CSS in 24 Hours, 7th Edition (Sams Publishing, 2005), Beginning Mobile Phone Game Programming (Sams Publishing, 2004) and Java Unleashed (Sams Publishing, 1997). Michael is the intructor of several Web-based courses, including DigitalThink's Introduction to Java 2 series, JavaBeans for Programmers series, and Win32 Programming series (www.digitalthink.com).



In addition to his primary profession as a writer and technical consultant, Michael is the founder of Stalefish Labs (www.stalefishlabs.com), an entertainment company specializing in games, toys, and interactive media. When not glued to his computer, skateboarding, playing hockey, or watching movies with his wife, Masheed, Michael enjoys hanging out by his koi pond.