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

Yank, Kevin

  • 3.89 out of 5 stars
    128 ratings by Goodreads
 
9780975240212: Build Your Own Database Driven Website Using PHP & MySQL

Synopsis

Explains how to build database driven Web sites with the PHP scripting language and the MySQL database.

"synopsis" may belong to another edition of this title.

About the Author

Kevin Yank is a world-renowned leader in web development. When not writing best sellers, Kevin is the Technical Director of sitepoint.com and editor of the popular SitePoint Tech Times newsletter.



Kevin's Author credits include: Build Your Own Database Driven Website Using PHP & MySQL (SitePoint and Simply JavaScript (SitePoint).

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!

"About this title" may belong to another edition of this title.