This preview shows page 1-2-3-4-5-6-7-8-57-58-59-60-61-62-63-64-65-116-117-118-119-120-121-122-123 out of 123 pages.
Title PageTable of ContentsPrefaceWho Should Read This BookWhat’s In This BookThe Book’s WebsiteThe Code ArchiveUpdates and ErrataThe SitePoint ForumsThe SitePoint NewslettersYour Feedback1.InstallationWindows InstallationInstalling MySQLInstalling PHPLinux InstallationRemoving Packaged SoftwareInstalling MySQLInstalling PHPMac OS X InstallationInstalling MySQLInstalling PHPMac OS X and LinuxPost-Installation Setup TasksIf Your Web Host Provides PHP and MySQLYour First PHP ScriptSummary2.Getting Started with MySQLAn Introduction to DatabasesLogging On to MySQLSo, What’s SQL?Creating a DatabaseCreating a TableInserting Data into a TableViewing Stored DataModifying Stored DataDeleting Stored DataSummary3.Getting Started with PHPIntroducing PHPBasic Syntax and CommandsVariables and OperatorsArraysUser Interaction and FormsControl StructuresMultipurpose PagesSummary4.Publishing MySQL Data on the WebA Look Back at First PrinciplesConnecting to MySQL with PHPSending SQL Queries with PHPHandling SELECT Result SetsInserting Data into the DatabaseA ChallengeSummary“Homework” SolutionIndexBuild Your Own Database Driven Website Using PHP and MySQL, 3rd Edition (First 4 Chapters) Thank you for downloading the first four chapters of Kevin Yank’s Build Your Own Database Driven Website Using PHP and MySQL, 3rd Edition. This excerpt encapsulates the Summary of Contents, Information about the Author and SitePoint, Table of Contents, Introduction, and the first four chapters of the book. We hope you find this information useful in evaluating the book. For more information, visit sitepoint.comSummary of Contents of this Excerpt Preface ..........................................................................................ix 1. Installation ............................................................................... 1 2. Getting Started with MySQL ................................................ 29 3. Getting Started with PHP ..................................................... 43 4. Publishing MySQL Data on the Web ................................... 67 Index......................................................................................... 345 Summary of Additional Book Contents 5. Relational Database Design................................................... 85 6. A Content Management System ......................................... 101 7. Content Formatting and Submission .................................. 143 8. MySQL Administration....................................................... 165 9. Advanced SQL Queries........................................................ 183 10. Binary Data........................................................................ 199 11. Cookies and Sessions in PHP............................................ 221 12. Structured PHP Programming........................................... 235 A. MySQL Syntax .................................................................... 277 B. MySQL Functions ............................................................... 301 C. MySQL Column Types ....................................................... 321 D. PHP Functions for Working with MySQL ........................ 331Build Your Own DatabaseDriven Website Using PHP &MySQLby Kevin YankBuild Your Own Database Driven Website Using PHP &MySQLby Kevin YankCopyright © 2004 SitePoint Pty. Ltd.Index Editor: Bill JohncocksEditor: Georgina LaidlawCover Design: Julian CarrollManaging Editor: Simon MackiePrinting History:First Edition: August 2001Second Edition: February 2003Third Edition: October 2004Notice of RightsAll rights reserved. No part of this book may be reproduced, stored in a retrieval system or transmittedin any form or by any means, without the prior written permission of the publisher, except in thecase of brief quotations embodied in critical articles or reviews.Notice of LiabilityThe author and publisher have made every effort to ensure the accuracy of the information herein.However, the information contained in this book is sold without warranty, either express or implied.Neither the authors and SitePoint Pty. Ltd., nor its dealers or distributors will be held liable for anydamages to be caused either directly or indirectly by the instructions contained in this book, or bythe software or hardware products described herein.Trademark NoticeRather than indicating every occurrence of a trademarked name as such, this book uses the namesonly in an editorial fashion and to the benefit of the trademark owner with no intention of infringe-ment of the trademark.Published by SitePoint Pty. Ltd.424 Smith Street CollingwoodVIC Australia 3066.Web: www.sitepoint.comEmail: [email protected] 0–9752402–1–8Printed and bound in the United States of AmericaAbout the AuthorAs Technical Director for SitePoint, Kevin Yank oversees all of its technical publica-tions—books, articles, newsletters and blogs. He has written over 50 articles for SitePointon technologies including PHP, XML, ASP.NET, Java, JavaScript and CSS. He writes TheSitePoint Tech Times, SitePoint’s biweekly technical newsletter for Web developers, whichhas over 75,000 readers worldwide.When he’s not discovering new technologies, editing books, or catching up on sleep,Kevin can be found helping other up-and-coming Web developers in the SitePoint Forums.Kevin lives in Melbourne, Australia, with several potted plants. In his spare time he enjoysflying light aircraft and learning the fine art of improvised acting. Go you big red fire engine!About SitePointSitePoint specializes in publishing fun, practical, and easy-to-understand content for Webprofessionals. Visit http://www.sitepoint.com/ to access our books, newsletters, articlesand community forums.To my parents, Cheryl andRichard, for making all thispossible.iiTable of ContentsPreface ..................................................................................................... ixWho Should Read This Book ............................................................... xWhat’s In This Book ............................................................................ xThe Book’s Website .......................................................................... xiiiThe Code Archive ...................................................................... xiiiUpdates and Errata ................................................................... xiiiThe SitePoint Forums
View Full Document
Unlocking...