Build Your Own Database-Driven Website Using PHP & MySQL

301 Pages·2003·3.184 MB·English

by  Kevin Yank

Build Your Own Database-Driven Website Using PHP &
MySQL
by Kevin Yank ISBN:0957921810
SitePoint © 2003 (275 pages)
This book is a hands-on guide to learning all the tools,
principles, and techniques needed to build a fully functional
database-driven Web site using PHP and MySQL from scratch.

Table of Contents
Build Your Own Database Driven Website Using PHP & MySQL
Introduction
Chapter 1 - Installation
Chapter 2 - Getting Started with MySQL
Chapter 3 - Getting Started with PHP
Chapter 4 - Publishing MySQL Data on the Web
Chapter 5 - Relational Database Design
Chapter 6 - A Content Management System
Chapter 7 - Content Formatting and Submission
Chapter 8 - MySQL Administration
Chapter 9 - Advanced SQL
Chapter 10 - Advanced PHP
Chapter 11 - Storing Binary Data in MySQL
Chapter 12 - Cookies and Sessions in PHP
Appendix A - MySQL Syntax
Appendix B - MySQL Functions
Appendix C - MySQL Column Types
Appendix D- PHP Functions for Working with MySQL
Index
List of Figures
List of Tables
List of Sidebars
Build Your Own Database-Driven Website Using PHP &
Back Cover MySQL
PHP & MySQL are thbey m Koesvti nw Yidaenlky used open source database and sIScBriNp:t0i9n5g7 9t2e1c8h1n0ologies on the Web today. As a
Web developer you can demand a lot more $$$ for your time if you can master PHP & MySQL.
SitePoint © 2003 (275 pages)
Build Your Own DataTbhaisse b Doorikv eisn aW heabnsditse- oUns ingugi dPeH Pto & l eMayrnSiQngL aisll ath per atocotilcsa,l hands-on guide to learning all the tools,
principles and technpiqruinecsi pnleese,d aendd t ote bcuhinldiq au efus llnye feudnecdt ioton ablu diladt aab fauslley dfurinvcetnio Wnaelbsite using PHP & MySQL.
database-driven Web site using PHP and MySQL from scratch.
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
Ttoapbicles souf cCho anst ethnet sstorage of binary data in MySQL, and cookies and sessions in PHP. It comes complete with a set
oBf uhialdn dYoy urre fOewrenn cDea tgaubidasees Dforri vPeHnP W &e MbsyiSteQ UL swinhgic PhH iPn c&lu Mdey:SQL
Introduction
MySQL Syntax
ChaptMery S1QL- FIunnstcatliloantison
ChaptMery S2QL- CGoeluttminng TSytapretse,d a wndith MySQL
PHP Functions for working with MySQL, and more.
Chapter 3 - Getting Started with PHP
BCuhiladp Yteoru r4 Ow-nP uDbaltisahbiansge MDyrSivQeLn DWaetbas oitne tUhsein Wg ePbHP & MySQL also includes download access to all the code samples
uCsheadp ttherro 5ugh-oRuet ltahteio nbaolo Dk astoa byaosue c Danes aigdnapt them to your own custom Web solutions.
Chapter 6 - A Content Management System
About the Author
Chapter 7 - Content Formatting and Submission
KCehvainp tYear n8k s-taMrtyeSdQ dLe vAedlmopininisgt rWateiobnsites in 1995, long before graduating from McGill University with a Bachelor of
CCohmapputetre r9 En-giAndevearinncge.d T SoQdaLy, Kevin is the Technical Business Director for SitePoint, editor of the SitePoint Tech
Times and a highly respected author.
Chapter 10 - Advanced PHP
Chapter 11 - Storing Binary Data in MySQL
Chapter 12 - Cookies and Sessions in PHP
Appendix A - MySQL Syntax
Appendix B - MySQL Functions
Appendix C - MySQL Column Types
Appendix D- PHP Functions for Working with MySQL
Index
List of Figures
List of Tables
List of Sidebars
Build YoBuurild O Yowur Onw nD Daatatbaasbe-aDrsiveen DWerbisvitee Unsin gW PHeP b&site Using PHP
MySQL
& MySQLby Kevin Yank ISBN:0957921810
SitePoint © 2003 (275 pages)
Kevin Yank
This book is a hands-on guide to learning all the tools,
principles, and techniques needed to build a fully functional
database-driven Web site using PHP and MySQL from scratch.
About SitePoint

TaSbiltee Poof iCnto snpteecnitaslizes in publishing fun, practical and easy-to-understand content for Web Professionals.
BVuiilsdit Y hottupr: /O/wwwnw D.saitteabpaosinet .Dcroivme/n t oW aecbscietes sU osiunrg b PoHoPk s&, MneywSQslLetters, articles and community forums.
InGtreoodrugcintiaon Laidlaw
Chapter 1 - Installation
CJhauptleira 2n -CGaetrtirnog lSltarted with MySQL
Chapter 3 - Getting Started with PHP
Chapter 4 - Publishing MySQL Data on the Web
Copyright © 2003 SitePoint Pty. Ltd.
Chapter 5 - Relational Database Design
CShaitpetPeor i6nt P-tyA. CLotdn.tent Management System
CShaupittee r6 ,7 50- RCeongteenntt SFtorremeta,tting and Submission
CRhaicphtemr o8nd- , VMICySA QuLs tAradlmiai 3n1is2tr1a.t .ion
C0h-a9p5te7r9 9218--1A-d0vanced SQL
Chapter 10 - Advanced PHP
First Edition: August 2001
Chapter 11 - Storing Binary Data in MySQL
CShaepctoenr d1 2Ed-itCioono:k Fieesb arnuda rSye 2s0si0o3n,s Jinu nPeH P2003
Appendix A - MySQL Syntax
AApplle rnigdhixt sB re-sMeyrSveQdL. FNuon cptaiornt sof this book may be reproduced, stored in a retrieval system or transmitted in
Aapnpeyn fdoirxm C o-r MbyyS aQnLy Cmoeluamnns , Twyiptheosut the prior written permission of the publisher, except in the case of brief
quotations embodied in critical articles or reviews.
Appendix D- PHP Functions for Working with MySQL
Index
The author and publisher have made every effort to ensure the accuracy of the information herein.
List of Figures
However, the information contained in this book is sold without warranty, either express or implied. Neither
List of Tables
the authors and SitePoint Pty. Ltd., nor its dealers or distributors will be held liable for any damages to be
Licsat uosf eSdid eeibtharesr directly or indirectly by the instructions contained in this book, or by the software or hardware
products described herein.
Rather than indicating every occurrence of a trademarked name as such, this book uses the names only
in an editorial fashion and to the benefit of the trademark owner with no intention of infringement of the
trademark.
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.
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.
These days, when he's not discovering new technologies, writing books, or catching up on sleep, Kevin
can be found helping other up-and-coming Web developers in the SitePoint Forums.
Second
Dedication
To my parents, Cheryl and Richard, for making all this possible.
Build Your Own Database-Driven Website Using PHP &
MySQL
by Kevin Yank ISBN:0957921810
SitePoint © 2003 (275 pages)
This book is a hands-on guide to learning all the tools,
principles, and techniques needed to build a fully functional
database-driven Web site using PHP and MySQL from scratch.

Table of Contents
Build Your Own Database Driven Website Using PHP & MySQL
Introduction
Chapter 1 - Installation
Chapter 2 - Getting Started with MySQL
Chapter 3 - Getting Started with PHP
Chapter 4 - Publishing MySQL Data on the Web
Chapter 5 - Relational Database Design
Chapter 6 - A Content Management System
Chapter 7 - Content Formatting and Submission
Chapter 8 - MySQL Administration
Chapter 9 - Advanced SQL
Chapter 10 - Advanced PHP
Chapter 11 - Storing Binary Data in MySQL
Chapter 12 - Cookies and Sessions in PHP
Appendix A - MySQL Syntax
Appendix B - MySQL Functions
Appendix C - MySQL Column Types
Appendix D- PHP Functions for Working with MySQL
Index
List of Figures
List of Tables
List of Sidebars
IntroductBiuoildn Your Own Database-Driven Website Using PHP &
MySQL
by Kevin Yank ISBN:0957921810
“Content is king.” Cliché, yes; but it has never been more true. Once you've mastered HTML and learned a
SitePoint © 2003 (275 pages)
few neat tricks in JavaScript and Dynamic HTML, you can probably design a pretty impressive-looking
This book is a hands-on guide to learning all the tools,
Website. But your next task must be to fill that fancy page layout with some real information. Any site that
principles, and techniques needed to build a fully functional
successfully attracts repeat visitors has to have fresh and constantly updated content. In the world of
database-driven Web site using PHP and MySQL from scratch.
traditional site building, that means HTML files—and lots of 'em.

TaTbhlee opfr oCbolenmte nist sthat, more often than not, the people who provide the content for a site are not the same
people who handle its design. Frequently, the content provider doesn't even know HTML. How, then, is the
Build Your Own Database Driven Website Using PHP & MySQL
content to get from the provider onto the Website? Not every company can afford to staff a full-time
Introduction
Webmaster, and most Webmasters have better things to do than copying Word files into HTML templates
Chapter 1 - Installation
anyway.
Chapter 2 - Getting Started with MySQL
CMhaapinteter n3an-ceG eotft ian gc oSntatertnetd-d wriivthe nP HsiPte can be a real pain, too. Many sites (perhaps yours?) feel locked into a
Cdhrayp,t oeru t4dat-ePdu dbelisshiginng b MecySauQsLe D raetwa roitnin tgh eth Woseeb hundreds of HTML files to reflect a new look would take
Cfhoarpetveerr 5. Se-rRveerla-stiiodnea iln Dcalutadbeass e(S DSeIssi)g cnan help alleviate the burden a little, but you still end up with hundreds
Cohfa pfitleers 6tha-t nAe Ceodn ttoe nbte M manaaingteamineendt sShyostuelmd you wish to make a fundamental change to your site.
Chapter 7 - Content Formatting and Submission
The solution to these headaches is database-driven site design. By achieving complete separation
Chapter 8 - MySQL Administration
between your site's design and the content you want to present, you can work with each without disturbing
Chapter 9 - Advanced SQL
the other. Instead of writing an HTML file for every page of your site, you only need to write a page for
Chapter 10 - Advanced PHP
each kind of information you want to be able to present. Instead of endlessly pasting new content into your
Chapter 11 - Storing Binary Data in MySQL
tired page layouts, create a simple content management system that allows the writers to post new
Chapter 12 - Cookies and Sessions in PHP
content themselves without a lick of HTML!
Appendix A - MySQL Syntax
AIpnp ethnidsi xb oBo-k,M I'yllS pQrLo vFiudnec ytiooun swith a hands-on look at what's involved in building a database-driven Website.
AWppee'nlld uixs eC t-wMo ytSoQolLs Cfoorlu tmhins, Tbyoptehs of which may be new to you: the PHP scripting language and the MySQL
Arpepleantidoinxa Dl d-aPtHabP aFsuen cmtiaonnsa gfoerm Weonrtk sinygs twemith. IMf yyoSuQrL Web host provides PHP and MySQL support, you're in
Ingdreexat shape. If not, we'll be looking at the setup procedures under Linux, Windows, and Mac OS X, so
Lidsot no'ft Fsiwgueraets it.
List of Tables
Who Should Read This Book
List of Sidebars
This book is aimed at intermediate or advanced Web designers looking to make the leap into server-side
programming. You'll be expected to be comfortable with simple HTML, as I'll make use of it without much
in the way of explanation. No knowledge of JavaScript is assumed or required, but if you do know
JavaScript, you'll find it will make learning PHP a breeze.
By the end of this book, you can expect to have a grasp of what's involved in setting up and building a
database-driven Website. If you follow the examples, you'll also learn the basics of PHP (a server-side
scripting language that gives you easy access to a database, and a lot more) and Structured Query
Language (SQL — the standard language for interacting with relational databases) as supported by
MySQL, one of the most popular free database engines available today. Most importantly, you'll come
away with everything you need to get started on your very own database-driven site in no time!
What's In This Book
Build Your Own Database-Driven Website Using PHP &
MySQL
This book compribsye sK ethvein fYoallnokw ing 12 chapters. Read them in oISrBdNe:r0 9f5ro79m21 8b1e0ginning to end to gain a
complete understSaitnedPionign to ©f t2h0e03 s (2u7b5j epacgte, so)r skip around if you need a refresher on a particular topic.
This book is a hands-on guide to learning all the tools,
principles, and techniques needed to build a fully functional
"Installation" database-driven Web site using PHP and MySQL from scratch.
Before you can start building your database-driven Web presence, you must first ensure
that you have the right tools for the job. In this first chapter, I'll tell you where to obtain the
Table of Contentstwo essential components you'll need: the PHP scripting language and the MySQL
Build Your Own Dadtaabtaasbea sDeri vmeann Waegbesmitee nUts sinygs tPeHmP. &I'l lM syteSpQ Lyou through the setup procedures on Windows,
Introduction Linux, and Mac OS X, and show you how to test that PHP is operational on your Web
server.
Chapter 1 - Installation

Chapter 2 - Getting Started with MySQL
"Getting
CShataprtteerd 3 wit-hGettinAglt hSotaurgtehd I 'wmit hs uPrHeP you'll be anxious to get started building dynamic Web pages, I'll begin
CMhaypStQerL 4" - Publiswhiitnhg a Mny iSntQroL dDuacttaio onn toth dea Wtaebbases in general, and the MySQL relational database
Chapter 5 - Relatimonaanl aDgaetmabeanset sDyessteigmn in particular. If you've never worked with a relational database
Chapter 6 - A Conbteefnotr Me,a tnhaisg esmhoeuntld S dyestfeinmitely be an enlightening chapter that will whet your appetite for
Chapter 7 - Contetnhtin Fgosr mtoa cttoinmge a!n Idn Sthueb mpriosscieonss, we'll build up a simple database to be used in later
Chapter 8 - MySQcLh Aapdmteirnsi.stration

Chapter 9 - Advanced SQL
"Getting
CShataprtteerd 1 w0it-hAdvanHceerde P'sH wPhere the fun really starts. In this chapter, I'll introduce you to the PHP scripting
CPhaHpPte"r 11 - Storinlagn Bgiunaargye D, wathai cinh McaynS QbLe easily used to build dynamic Web pages that present up-to-the-
Chapter 12 - Cookimeso amnedn St einsfsoiornmsa itnio PnH tPo your visitors. Readers with previous programming experience will
Appendix A - MySQpLr oSbyanbtalyx be able to get away with a quick skim of this chapter, as I explain the essentials
Appendix B - MySQoLf Fthuen cltainongsuage from the ground up. This is a must-read chapter for beginners, however,
Appendix C - MySQaLs C tholeu mrens tT oyfp ethsis book relies heavily on the basic concepts presented here.
Appendix D- PHP Functions for Working with MySQL
"Publishing
InMdyeSxQL Data In this chapter we bring together PHP and MySQL, which you'll have seen separately in
Liosnt othf eF igWuerebs" the previous two chapters, to create some of your first database-driven Web pages. We'll
List of Tables explore the basic techniques of using PHP to retrieve information from a database and
List of Sidebars display it on the Web in real time. I'll also show you how to use PHP to create Web-based
forms for adding new entries to, and modifying existing information in, a MySQL database
on-the-fly.

"Relational
Database Although we'll have worked with a very simple sample database in the previous chapters,
Design" most database-driven Websites require the storage of more complex forms of data than
we'll have dealt with so far. Far too many database-driven Website 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!

"A Content
Management In many ways the climax of the book, this chapter is the big payoff for all you frustrated
System" 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 publication on your site in no time - all without
having to know a shred of HTML!
"Content Build Your Own Database-Driven Website Using PHP &
Formatting JMuysSt QbeLcause you're implementing a nice, easy tool to allow site administrators to add
and cboyn Kteenvitn t oY aynoku r site without their knowing HTMISLB, Nd:o09e5s7n92't1 m81e0an you have to restrict that
Submission" cSoitnetPeonint tto © p2l0a0i3n (,2 u75n pfoagrems)atted text. In this chapter, I'll show you some neat tweaks you can
mThaisk eb otoo kth ise ap ahganed tsh-aotn d gisupidlaey tso t lheea rcnoinngte anllt st hoef tyoooulsr ,database—tweaks that allow it to
ipnrcinocrpipoleras,t ea nsdim tpecleh nfoiqrumeas ttnineegd seudc tho absu ibldo lad f oulrl yit afulinciczteiodn atelxt, among other things. I'll also
sdhaotawb aysoeu- dar isviemnp Wlee wb asiyt eto u ssainfge lPyH mP aakned aM cySonQtLe nfrto smu bscmraistschio.n 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.
Table of Contents

B"uMildy SYQouLr Own Database Driven Website Using PHP & MySQL
InAtrdomduincitsitornation" While MySQL is a good, simple database solution for those who don't need many frills, it
Chapter 1 - Instaldlaoteiosn have some complexities of its own that you'll need to understand if you're going to
Chapter 2 - Gettinreg lyS toanrt ead M wyiSthQ MLy dSaQtLabase 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
Chapter 3 - Getting Started with PHP
couple of inside tricks (like what to do if you forget your MySQL password), I'll explain how
Chapter 4 - Publishing MySQL Data on the Web
to repair a MySQL database that has become damaged in a server crash.
Chapter 5 - Relational Database Design

Chapter 6 - A Content Management System
"Advanced
CShaQpLte"r 7 - ConteInnt " RFeorlamtiaotntianlg D aantda bSausbem Disseisoingn" we saw what was involved in modelling complex
Chapter 8 - MySQrLe lAadtimoninsihstiprast iboentween pieces of information in a relational database like MySQL. Although
Chapter 9 - Advanthcee dt hSeQoLry was quite sound, putting these concepts into practice requires that you learn a
Chapter 10 - Advanfecwed m PHorPe tricks of Structured Query Language. In this chapter, I'll cover some of the more
advanced features of this language to get you juggling complex data like a pro.
Chapter 11 - Storing Binary Data in MySQL

Chapter 12 - Cookies and Sessions in PHP
"Advanced
APppHePnd"ix A - MySQPLH SPy nletatsx you do a lot more than just retrieve, display, insert, and update information
Appendix B - MySQsLt oFruendc tinio ans MySQL database. In this chapter, I'll give you a peek at some other interesting
Appendix C - MySQtLh inCgolsu myonu T cyapne sdo with PHP, such as server-side includes, handling file uploads, and
Appendix D- PHP Fsuenncdtiionngs e fmora Wil.o Arksi nwge w'lli tshe Me,y tShQeLse features are really useful for improving the
Index performance and security of your database-driven site, as well as sending feedback to
List of Figures your visitors.

List of Tables
"Storing Binary
LiDsta otaf Sinidebars Some of the most interesting applications of database-driven Web design include some
MySQL" 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 simple online file storage and viewing system and learn the ins and
outs of working with binary data in MySQL.

"Cookies and
Sessions in One of the most hyped new features in PHP 4.0 was built-in support for sessions. But
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.
The Book's Web Site
Build Your Own Database-Driven Website Using PHP &
MySQL
Located at http://wbyw Kwe.sviitne pYoaninkt .com/books/, the Website suppoISrtBinNg:0 9t5h7is9 2b1o81o0k will give you access to the
following facilitiesS:itePoint © 2003 (275 pages)
This book is a hands-on guide to learning all the tools,
The Code Aprricnchipilevse, and techniques needed to build a fully functional
database-driven Web site using PHP and MySQL from scratch.
As you progress through the text, you'll note a number of references to the code archive. This is a
Tadbolew nolfo Caodnabtelen tZsIP archive that contains complete code for all the examples presented in the book.
Build Your Own Database Driven Website Using PHP & MySQL
InUtropdducatitones and Errata
Chapter 1 - Installation
CNhaop bteoro 2k is- pGeertfteincgt, Satnadrt eedve wni tthh oMuygShQ tLhis is a second edition, I expect that watchful readers will be able to
Cshpaoptt eart 3lea-stG oenttein ogr Stwtaort emdi swtaitkhe PsH bPefore the end of this one. Also, PHP and MySQL (and even the Web in
general) are moving targets, constantly undergoing changes with each new release. The Errata page on
Chapter 4 - Publishing MySQL Data on the Web
the book's Website will always have the latest information about known typographical and code errors, and
Chapter 5 - Relational Database Design
necessary updates for changes to PHP and MySQL.
Chapter 6 - A Content Management System
Chapter 7 - Content Formatting and Submission
Chapter 8 - MySQL Administration
Chapter 9 - Advanced SQL
Chapter 10 - Advanced PHP
Chapter 11 - Storing Binary Data in MySQL
Chapter 12 - Cookies and Sessions in PHP
Appendix A - MySQL Syntax
Appendix B - MySQL Functions
Appendix C - MySQL Column Types
Appendix D- PHP Functions for Working with MySQL
Index
List of Figures
List of Tables
List of Sidebars
The SitePoint Forums
Build Your Own Database-Driven Website Using PHP &
MySQL
While I've made ebvye Krye vaintt eYmanpkt to anticipate any questions you ImSBaNy:0 h95a7v9e2 1a8n10d answer them in this book,
there is no way thSaitt eaPnoyin bt o©o 2k0 0c3o (2u7ld5 pcaogevse)r everything there is to know about PHP and MySQL. If you have
a question about Tahnisy thboinogk iins tah ihsa bnodos-ko nth gaut indeee tdos l eaanrsnwinegr ianllg t, hthe et oboelss,t place to go for a quick answer is
http://www.sitepopinrtifnocriuplmess,. caonmd t/.e Nchonti qounelys wneilel dyoedu tfoin dbu ail dv iab rfaunllty afunndc ktinoonwalledgeable PHP community there,
but you'll occasiodnaatlalyb aesvee-nd rfiivnedn mWee,b t hseite a uusthinogr ,P tHhPe raen idn MmyyS sQpLa frreo mho sucrrsa.tch.

Table of Contents
Build Your Own Database Driven Website Using PHP & MySQL
Introduction
Chapter 1 - Installation
Chapter 2 - Getting Started with MySQL
Chapter 3 - Getting Started with PHP
Chapter 4 - Publishing MySQL Data on the Web
Chapter 5 - Relational Database Design
Chapter 6 - A Content Management System
Chapter 7 - Content Formatting and Submission
Chapter 8 - MySQL Administration
Chapter 9 - Advanced SQL
Chapter 10 - Advanced PHP
Chapter 11 - Storing Binary Data in MySQL
Chapter 12 - Cookies and Sessions in PHP
Appendix A - MySQL Syntax
Appendix B - MySQL Functions
Appendix C - MySQL Column Types
Appendix D- PHP Functions for Working with MySQL
Index
List of Figures
List of Tables
List of Sidebars
The SitePoint Tech Times
Build Your Own Database-Driven Website Using PHP &
MySQL
In addition to boobkys Klikeevi nth Yisa nokn e, I write a free, biweekly (that'sI SeBvNe:r0y9 5tw79o21 w81e0eks) email newsletter called
The SitePoint TecShit eTPimoinets ©. I2n0 0it3, (I2 w75r ipteag easb)out the latest news, product releases, trends, tips, and techniques
for all technical aTshpies cbtso ookf iWs ae bh adnedvse-loonp gmueidnet. tIof nleoatrhniningg eallsl eth, ey otuoo'llls g,et useful PHP articles and tips, but if
you're interested pinr inlecaiprlneisn,g a ontdh teerc lhannigquueasg ense,e dyoedu 'tllo f ibnudil dit ea sfpuellyc ifaullnyc utisoneafull. Sign up to the Tech Times
(and other SitePodinatt anbeawses-ledrttiveersn) Wate hbt tspit:e// wuswinwg. sPitHePp oainndt. cMoymSQ/nLe fwrosmle tstecrra/.tch.

Table of Contents
Build Your Own Database Driven Website Using PHP & MySQL
Introduction
Chapter 1 - Installation
Chapter 2 - Getting Started with MySQL
Chapter 3 - Getting Started with PHP
Chapter 4 - Publishing MySQL Data on the Web
Chapter 5 - Relational Database Design
Chapter 6 - A Content Management System
Chapter 7 - Content Formatting and Submission
Chapter 8 - MySQL Administration
Chapter 9 - Advanced SQL
Chapter 10 - Advanced PHP
Chapter 11 - Storing Binary Data in MySQL
Chapter 12 - Cookies and Sessions in PHP
Appendix A - MySQL Syntax
Appendix B - MySQL Functions
Appendix C - MySQL Column Types
Appendix D- PHP Functions for Working with MySQL
Index
List of Figures
List of Tables
List of Sidebars