PHP & MySQL are the most widely used open source database and scripting technologies on the Web today. As a Web developer you can demand a lot more $$$ for your time if you can master PHP & MySQL.
Build Your Own Database Driven Website Using PHP & MySQL is a practical hands-on guide to learning all the tools, principles and techniques needed to build a fully functional database driven Website using PHP & MySQL.
This book covers everything from installing PHP & MySQL under Windows, Linux, and Mac through to building a live Web-based content management system. While this is essentially a beginners book, it also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set of handy reference guides for PHP & MySQL which include:
Build Your Own Database Driven Website Using PHP & MySQL also includes download access to all the code samples used throughout the book so you can adapt them to your own custom Web solutions.
- MySQL Syntax
- MySQL Functions
- MySQL Column Types, and
- PHP Functions for working with MySQL, and more.
The solution to these headaches is database-driven site design. By achieving complete separation between your site's design and the content you want to present, you can work with each without disturbing the other. Instead of writing an HTML file for every page of your site, you only need to write a page for each kind of information you want to be able to present. Instead of endlessly pasting new content into your tired page layouts, create a simple content management system that allows the writers to post new content themselves without a lick of HTML!
In this book, I'll provide you with a hands-on look at what's involved in building a database-driven Website. We'll use two tools for this, both of which may be new to you: the PHP scripting language and the MySQL relational database management system. If your Web host provides PHP and MySQL support, you're in great shape. If not, we'll be looking at the setup procedures under Linux, Windows, and Mac OS X, so don't sweat it.
About the Author
Kevin Yank is the Technical Business Director for SitePoint, author of numerous well received tutorials and articles, and editor of the SitePoint Tech Times, an extremely popular technically-oriented newsletter for Web developers.
Kevin Yank started developing Websites in 1995, long before graduating from McGill University with a Bachelor of Computer Engineering. Today, Kevin is the Technical Business Director for SitePoint, editor of the SitePoint Tech Times and a highly respected author.