Build Your Own Database Driven Website Using PHP & MySQL - Softcover

Yank, Kevin

Softcover

ISBN 10: 0957921802 ISBN 13: 9780957921801

Publisher: SitePoint Pty Ltd, 2001

Synopsis

Together, PHP & MySQL form the most widely used open source database and scripting technologies on the Web today. As a budding Web Developer, you need to learn and master PHP & MySQL.

Build Your Own Database Driven Website Using PHP & MySQL is a 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 or Linux, through to building a live Web-based content management system.

It also covers more advanced topics such as the storage of binary data in MySQL, and cookies and sessions in PHP, and comes complete with a set of PHP and MySQL reference tables that include PHP and MySQL syntax, functions, column types and more.

This book not only provides easy access to all the code samples demonstrated, but, more importantly, it leaves you with the confidence and know-how to adapt the principles and techniques to your own Web design projects.

This book will show you how to:

- Build a working Content Management System Add, edit & delete Web content without using HTML

- Setup automatic backups of your database

- Increase your database security (Chapter 8)

- Optimize the loading time of your Website (Chapter 9)

- Build an ecommerce shopping cart (Chapter 12)

- Automatically send email on triggered events (Chapter 10)

- Handle file uploads using HTML forms (Chapter 10)

- Build a Web-based file repository or photo gallery

- Utilize sessions and cookies to track site visitors

- Master MySQL Database Administration. (Chapter 8)

- And a whole lot more…

Build Your Own Database Driven Website Using PHP & MySQL is an essential resource for budding Web Developers. If you want to go beyond the limitations of a static site and learn to build dynamic, database-driven Websites, this book will show you how.

About this title

About the Author

Kevin Yank is the Technical Content Director for SitePoint.com, author of many well received tutorials and articles, and editor of the SitePoint Tech Times, an extremely popular technically-oriented email newsletter for Web Developers.

Before graduating from McGill University in Montreal with a Bachelor of Computer Engineering, Kevin was not only a budding Web Developer himself, but also an active advisor for the Sausage Software Web Development Forums and writer of several practical guides on advanced HTML and JavaScript.

Excerpt. © Reprinted by permission. All rights reserved.

On the Web today, content is king. Once you've mastered HTML and learned a few neat tricks in JavaScript and Dynamic HTML, you can probably build a pretty impressive-looking Web site design. But then comes the time to fill that fancy page layout with some real information. Any site that successfully attracts repeat visitors has to have fresh and constantly-updated content. In the world of traditional site building, that means HTML files -- and lots of 'em.

The problem is that, more often than not, the people who provide the content for a site are not the same people who handle its design. Oftentimes, the content provider doesn't even know HTML. How, then, is the content to get from the provider onto the Web site? Not every company can afford to staff a full-time Webmaster, and most Webmasters have better things to do than copying Word files into HTML templates anyway.

Maintenance of a content-driven site can be a real pain, too. Many sites (perhaps yours?) feel locked into a dry, outdated design because rewriting those hundreds of HTML files to reflect a new design would take forever. Server-side includes (SSI's) can help alleviate the burden a little, but you still end up with hundreds of files that need to be maintained should you wish to make a fundamental change to your site.

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!

Edition details

• Publisher: SitePoint Pty Ltd
• Publication date: 2001
• Language: English
• ISBN 10: 0957921802
• ISBN 13: 9780957921801
• Binding: Paperback
• Edition number: 1
• Number of pages: 242