Hi, This is Thomas Rutter from SitePoint.com here. I just wanted to follow-up with you to make sure you were able to download your sample chapters of Kevin Yank's new book:
"Build Your Own Database Driven Website Using PHP & MySQL" ( http://www.sitepoint.com/books/Kevs-php-mysql.pdf ) Please let me know what you thought of it? If you weren't able to download the sample chapters, let me know as well. Also, I wanted to give you some insight into what the rest of the book looks like. The following are chapter summaries which Kevin Yank (the author) wrote for the 8 remaining chapters of his book. After you take a look at the following you'll see why this book has been so popular... ----------------------------------------------------------------------- Chapter 5: Relational Database Design Although we'll have worked with a very simple sample database in the previous chapters, most database-driven Web sites require the storage of more complex forms of data than we'll have dealt with so far. Far too many database-driven Web site designs are abandoned midstream, or are forced to start again from the beginning, because of mistakes made early on, during the design of the database structure. In this critical chapter, I'll teach the essential principles of good database design, emphasizing the importance of data normalization. If you don't know what that means, then this is definitely an important chapter for you to read! Chapter 6: A Content Management System In many ways the climax of the book, this chapter is the big payoff for all you frustrated site builders who are tired of updating hundreds of pages whenever you need to make a change to a site's design. I'll walk you through the code for a basic Content Management System that allows you to manage a database of jokes, their categories, and their authors. A system like this can be used to manage simple content on your Website, and with a few modifications you should be able to build a Web administration system that will have your content providers submitting content for publications on your site in no time – all without having to know a shred of HTML! Chapter 7: Content Formatting and Submission Just because you're implementing a nice, easy tool to allow site administrators to add content to your site without their knowing HTML, doesn't mean you have to restrict that content to plain, unformatted text. In this chapter, I'll show you some neat tweaks you can make to the page that displays the contents of your database – tweaks that allow it to incorporate simple formatting such as bold or italicized text, among other things. I'll also show you a simple way to safely make a content submission form directly available to your content providers, so that they can submit new content directly into your system for publication, pending an administrator's approval. Chapter 8: MySQL Administration While MySQL is a good, simple database solution for those who don't need many frills, it does have some complexities of its own that you'll need to understand if you're going to rely on a MySQL database to store your content. In this section, I'll teach you how to perform backups of, and manage access to, your MySQL database. In addition to a couple of inside tricks (like what to do if you forget your MySQL password), I'll explain how to repair a MySQL database that has become damaged in a server crash. Chapter 9: Advanced SQL In chapter 5 we saw what was involved in modeling complex relationships between pieces of information in a relational database like MySQL. Although you learn a few more tricks of Structured Query Language. In this chapter, I'll cover some of the more advanced features of this language to get you efficiently juggling complex data like a pro. Chapter 10: Advanced PHP PHP let's you do a lot more than just retrieve, display, insert, and update information stored in a MySQL database. In this chapter, I'll give you a peek at some other interesting things you can do with PHP, such as sever-side includes, handling file uploads, and sending email. Of course, as we'll see, these features are really useful for improving the performance and security of your database-driven site, as well as sending feedback to your visitors. Chapter 11: Storing Binary Data in MySQL Some of the most interesting applications of database driven Web design include some juggling of binary files. Online file storage services like the now defunct iDrive, are prime examples, but a system as simple as a personal photo gallery can benefit from storing binary files (e.g. pictures) in a database for retrieval and management on the fly. In this chapter, we develop a very simple online file storage and viewing system and learn the ins and outs of working with binary data in MySQL. Chapter 12: Cookies and Sessions in PHP What are sessions? How are they related to cookies, a long-suffering technology for preserving stored data on the Web? What makes persistent data so important in current ecommerce systems and other Web applications? This chapter answers all those questions by explaining how PHP supports both cookies and sessions, and exploring the link between the two. At the end of this chapter, we'll develop a simple shopping cart system to demonstrate their use. Code archive As you progress through the text, you'll note a number of references to the code archive. When you order the book you'll not only receive a downloadable archive of all the code presented within this text, but also errata, updates, and information about other SitePoint publications. ---------------------------------------------------------------------- Hope the above was helpful to you. Here's the link to get your copy: https://sitepoint.com/bookstore/go/1/7c9659 (The price is $34.95 USD plus shipping & handling) You can even order using your PayPal account. And remember this is not an eBook. You will receive a printed, hard-copy book delivered to you anywhere in the world in as little as three days. All the best, Thomas Rutter Customer Support Manager SitePoint.com P.S. To summarize, When you grab your copy of "Build Your Own Database Driven Website Using PHP & MySQL" you'll learn how to: *Build a working Content Management System. *Add, edit and delete Web content without using HTML. *Setup automatic backups of your database. *Increase your database security. *Optimize the loading time of your Website. *Build an ecommerce shopping cart. *Automatically send email on triggered events. *Handle file uploads using HTML forms. *Build a Web-based file repository or photo gallery. *Utilize sessions and cookies to track site visitors. *Master MySQL Database Administration. *And everything else you need to create rich, sophisticated database driven websites that both you and your clients will be happy with. So why not give Kevin's book a 30-day test drive? Here's the link to get your copy: https://sitepoint.com/bookstore/go/1/7c9659 for only $34.95 USD. ______________________________________________________________ Click here if you do not wish to hear from us about this product: http://sitepoint.com/u?dne=1&t=19d0f90d717854bc&s=1 Click here if you never wish to hear from SitePoint about any product: http://sitepoint.com/u?dne=1&t=19d0f90d717854bc ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/BCfwlB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/kumpulan/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
