Info Tech

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.

Baca selengkapnya: PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

* Essentially three books in one, provides thorough introductions to the PHP language, MySQL database, and shows you how these two technologies can be effectively integrated to build powerful websites.
* Provides over 500 code examples, including real-world tasks such as providing an auto-login feature, sending HTML-formatted email, testing password guessability, and uploading files via a Web interface.
* Updated for MySQL 5, includes new chapters introducing triggers, stored procedures, and views.

Interested in becoming a master of the PHP language and MySQL database but don't know where to begin? This bestselling book ranks among the most thorough and practical guides in print, covering all of the key concepts and features, and showing you how to effectively integrate PHP and MySQL to build powerful websites.

The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.

Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5-specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.
What You Will Learn from This Book

• Install and configure Apache, PHP and MySQL on both Windows and Linux
• Accept and process information submitted via HTML forms
• Authenticate users and track user preferences and data using PHP's session-handling capabilities
• Process Web-based file uploads using the HTTP_Upload PEAR package
• Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML
• Use both command-line and graphical MySQL clients to effectively manage your data
• Secure the MySQL server, creating roles and restricting access even at very granular levels
• Effectively integrate PHP and MySQL to create dynamic, data-driven web applications

Who This Book Is For

This book is for the budding web developer searching for a powerful and low-cost solution to building flexible, scalable websites.

Read More : Beginning PHP and MySQL: From Novice to Professional, Third Edition