Practical PHP and MySQL Building Eight Dynamic Web Applications

by
Edition: 1st
Format: Paperback
Pub. Date: 2006-11-14
Publisher(s): Prentice Hall
List Price: $49.99

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

"Practical PHP and MySQL reflects Jono's commitment to the spirit of making open source subjects accessible to everyone. The book carefully walks you through the code for eight useful, dynamic Web applications. Projects are presented in a playful way, like the forum project that touts horror movies that make you 'hide behind the couch.'" -From the Foreword by Christopher Negus, Series Editor, Negus Live Linux Series Build Dynamic Web Sites Fast, with PHP and MySQL... Learn from Eight Ready-to-Run Applications! Suddenly, itrs"seasyto build commercial-quality Web applications using free and open source software. With this book, yours"ll learn from eight ready-to-run, real-world applications--all backed by clear diagrams and screenshots, well-documented code, and simple, practical explanations. Leading open source author Jono Bacon teaches the core skills yours"ll need to build virtually any application. Yours"ll discover how to connect with databases, upload content, perform cascading deletes, edit records, validate registrations, specify user security, create reusable components, use PEAR extensions, and even build Ajax applications. Working from complete examples on the CD-ROM, yours"ll create Generic dynamic Web sites Blogs Discussion forums Shopping carts Auction sites Calendars FAQ systems Reusable components Content management systems News sites JONO BACONis Ubuntu community manager for Canonical, Ubunturs"s sponsor. He is an established speaker, author, and contributor to the open source community. Bacon co-authoredLinux Desktop HacksandThe Official Ubuntu Book; has served as a columnist forLinux Format,Linux User & Developer, andPC Plus; and is an Ors"Reilly Networkweblog author. He is a lead developer onthe Jokosher (www.jokosher.org) project,and co-founder of LUGRadio-a podcastwith more than 15,000 listeners, andan annual event that attracts visitorsfrom around the world. CD-ROM Includes XAMPP for Linux: easy-to-install, preconfigured Apache distributions containing MySQL, PHP, Perl, and more Source code for all eight fully-working applications discussed in the book A remastered Ubuntu live CD, set to run all eight applications live System Requirements CPU: Pentium III, 650 MHz. RAM: 256MB (recommended 512MB). Hard disk: No space required to run live CD; 250MB of space needed to put XAMPP server and projects on installed system.

Author Biography

Jono Bacon works for Canonical as the Ubuntu community manager and is an established speaker, author, and regular contributor to the Open Source community. As an author, Bacon co-authored Linux Desktop Hacks and the Official Ubuntu Book, and has written more than 400 published articles in more than 14 publications. Bacon has also contributed as a columnist for Linux Format, Linux User & Developer, and PC Plus, and is an O’Reilly Network weblog author.

 

In addition, Bacon is a regular contributor to Open Source in a range of projects, a lead developer on the Jokosher (www.jokosher.org) project, and one of the co-founders of the popular LUGRadio (www.lugradio.org) podcast–a show with more than 15,000 listeners and an annual event that pulls visitors from around the world.

Table of Contents

Foreword xi
About the Author xii
Acknowledgments xiii
Introduction 1(1)
A Different Approach
1(2)
What You Need to Use This Book
3(1)
Conventions
4(1)
Onward
4(1)
A New Approach
5(10)
The Technology
6(2)
How the Dynamic Web Works
8(4)
Summary
12(3)
Getting Started with PHP and MySQL
15(38)
Setting Up PHP and MySQL
16(1)
Getting Started with PHP
17(18)
Rolling in MySQL
35(10)
Connecting to MySQL in PHP
45(6)
Summary
51(2)
Running the Projects
53(10)
About the Disc
53(3)
Running the Applications
56(1)
Using XAMPP
57(3)
Summary
60(3)
Building a Weblog
63(48)
Project Overview: Blogtastic Use Case
64(1)
Building the Database
65(3)
Starting to Code
68(14)
Viewing Specific Entries
82(10)
Building the Category Browser
92(3)
Don't Just Let Anyone Log In
95(7)
Rolling Your Own Categories
102(1)
Creating New Blog Entries
103(3)
Update a Blog Entry
106(4)
Summary
110(1)
Discussion Forums
111(58)
Under the Hood
111(3)
Building Your Own Forums
114(1)
Before You Begin
114(1)
Creating the Database
115(7)
Creating the Site Design
122(2)
Displaying the Forums
124(9)
Managing User Logins
133(17)
Posts and Replies
150(8)
Creating Administrator-Specific Pages
158(9)
Summary
167(2)
Creating a Shopping Cart
169(50)
Project Overview
170(1)
Building the Database
171(4)
Starting to Code
175(5)
Managing User Logins
180(4)
Displaying and Selecting Products
184(12)
Checking It Out
196(12)
Administrator Pages
208(8)
Summary
216(3)
Building an Online Auction Site
219(46)
Project Overview
219(1)
Building the Database
220(3)
Starting to Code
223(3)
Displaying Auction Items
226(14)
Dealing with Users
240(3)
Adding an Item
243(16)
Processing Auctions
259(3)
Scheduling the Page to Be Run
262(1)
Summary
263(2)
Creating a Web-Based Calendar
265(38)
Project Overview
265(1)
Building the Database
266(1)
Starting to Code
267(10)
Viewing Events
277(25)
Summary
302(1)
FAQ Content Management System
303(76)
Project Overview
304(1)
Building the Database
305(5)
Starting to Code
310(11)
Displaying Questions
321(9)
Dealing with Logins
330(11)
Adding and Moderating Questions
341(15)
Managing Subjects
356(4)
Managing Topics
360(4)
Subject Ownership
364(12)
Summary
376(3)
Building a Re-Usable Project
379(46)
Project Overview
380(1)
Building the Database
381(4)
Using Directories Intelligently
385(1)
Starting to Code: Building the Backbone
386(7)
Downloading Releases
393(3)
Viewing Screenshots
396(1)
Available Projects Viewer
397(1)
Administering Projects
398(8)
Changing General Settings
406(1)
Managing Downloads
407(7)
Deleting Releases
414(1)
Managing Screenshots
415(4)
Deleting Images
419(1)
Adding a New Project
420(1)
Deploying the Application
421(3)
Summary
424(1)
Building a News Web Site
425(44)
Project Overview
425(1)
Installing PEAR Packages
426(2)
Building the Database
428(3)
Starting to Code
431(9)
Handling User Logins
440(5)
Viewing and Rating Stories
445(6)
Managing Stories
451(6)
Managing Categories
457(4)
Creating Your Search Engine
461(6)
Summary
467(2)
APPENDIX A Web Site Design
469(30)
Project Overview
469(2)
Laying Out the Site
471(3)
Starting to Code
474(5)
Start Building the Stylesheet
479(2)
Formatting the Main <div> Items
481(6)
Creating an About Page
487(2)
Creating a Frequently Asked Questions Page
489(3)
Formatting Tables
492(3)
Summary
495(4)
Index 499

Excerpts

Foreword Foreword Listen to podcasts by Jono Bacon and friends at LUG Radio ( http://www.lugradio.org ) and you get a sense of both the spirit and thoughtfulness Jono brings to the open source community. At one moment they speak seriously about hurdles in contributing code to free software projects, while the next they offer a Monty Python-like discussion on which Linux distribution each of them most resembles. Practical PHP and MySQLreflects Jono's commitment to the spirit of making open source subjects accessible to everyone. The book carefully walks you through the code for eight useful, dynamic Web applications. Projects are presented in a playful way, like the forum project that touts horror movies that make you "hide behind the couch." And everything in the book can be run live, modified, saved, and reused from the included live CD. Although the tools you need to create Web content are readily available from the open source community, having a skillful guide like Jono Bacon to help you create dynamic Web applications from those tools is a real treat. The results form a foundation for developing your own blogs, forums, shopping carts, and other Web destinations that should significantly cut your startup time. I am thrilled to have Jono Bacon'sPractical PHP and MySQLas one of the first books in the Negus Live Linux Series. Its content perfectly suits the goals of the series to put quality free and open source software covering various topics into peoples' hands so they can quickly get high-quality results. I hope you enjoy learning from this book as much as I have. --Christopher Negus Series Editor, Negus Live Linux Series Copyright Pearson Education. All rights reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.