Web Database Applications with PHP & MySQL, 2nd Edition by Hugh E. Williams, David Lane
There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templatesto give your dynamic web pages a standard look.But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include: Installation and configuration of Apache, MySQL, and PHP on Unix®, Windows®, and Mac OS® X systems Introductions to PHP, SQL, and MySQL administration Session management, including the use of a custom database for improved efficiency User input validation, security, and authentication The PEAR repository, plus details on the use of PEAR DB and Template classes Production of PDF reports Editorial Reviews About the Author Hugh E. Williams is a software design engineer at Microsoft's Windows Live Search in Redmond, WA. Previously, he was the Associate Professor in Information Retrieval at RMIT University in Melbourne, Australia. He's published over 70 research papers and holds around 10 patents, mostly in the search engine area. When not at work Hugh likes to hang out with his family, exercise, watch Richmond play footy, and learn about baseball. Hugh has a PhD from RMIT University. His home page is http://hughwilliams.com. Since the mid 1990s David Lane has worked as a software engineer and IT manager with the Multimedia Database Systems group at RMIT University in Melbourne, Australia. In that group he has helped to develop and commercialize the Structured Information Manager, a large-scale SGML/XML document repository and a high performance Web server. David has also worked with Australia's largest telecommunications company, Telstra, in areas as diverse as Satellite Communications, Human Factors Research, and Electronic Document Interchange (EDI). David has a Bachelor's degree in Applied Science (majoring in mathematics and computer science) from Swinburne University.
Publication Details
Title:
Author(s):
Illustrator:
Binding: Paperback
Published by: O'Reilly Media: , 2004
Edition:
ISBN: 9780596005436 | 0596005431
680 pages.
Book Condition: Very Good
Pickup currently unavailable at Book Express Warehouse
Product information
New Zealand Delivery
Shipping Options
Shipping options are shown at checkout and will vary depending on the delivery address and weight of the books.
We endeavour to ship the following day after your order is made and to have pick up orders available the same day. We ship Monday-Friday. Any orders made on a Friday afternoon will be sent the following Monday. We are unable to deliver on Saturday and Sunday.
Pick Up is Available in NZ:
Warehouse Pick Up Hours
- Monday - Friday: 9am-5pm
- 35 Nathan Terrace, Shannon NZ
Please make sure we have confirmed your order is ready for pickup and bring your confirmation email with you.
Rates
-
New Zealand Standard Shipping - $6.00
- New Zealand Standard Rural Shipping - $10.00
- Free Nationwide Standard Shipping on all Orders $75+
Please allow up to 5 working days for your order to arrive within New Zealand before contacting us about a late delivery. We use NZ Post and the tracking details will be emailed to you as soon as they become available. Due to Covid-19 there have been some courier delays that are out of our control.
International Delivery
We currently ship to Australia and a range of international locations including: Belgium, Canada, China, Switzerland, Czechia, Germany, Denmark, Spain, Finland, France, United Kingdom, United States, Hong Kong SAR, Thailand, Philippines, Ireland, Israel, Italy, Japan, South Korea, Malaysia, Netherlands, Norway, Poland, Portugal, Sweden & Singapore. If your country is not listed, we may not be able to ship to you, or may only offer a quoting shipping option, please contact us if you are unsure.
International orders normally arrive within 2-4 weeks of shipping. Please note that these orders need to pass through the customs office in your country before it will be released for final delivery, which can occasionally cause additional delays. Once an order leaves our warehouse, carrier shipping delays may occur due to factors outside our control. We, unfortunately, can’t control how quickly an order arrives once it has left our warehouse. Contacting the carrier is the best way to get more insight into your package’s location and estimated delivery date.
- Global Standard 1 Book Rate: $37 + $10 for every extra book up to 20kg
- Australia Standard 1 Book Rate: $14 + $4 for every extra book
Any parcels with a combined weight of over 20kg will not process automatically on the website and you will need to contact us for a quote.
Payment Options
On checkout you can either opt to pay by credit card (Visa, Mastercard or American Express), Google Pay, Apple Pay, Shop Pay & Union Pay. Paypal, Afterpay and Bank Deposit.
Transactions are processed immediately and in most cases your order will be shipped the next working day. We do not deliver weekends sorry.
If you do need to contact us about an order please do so here.
You can also check your order by logging in.
Contact Details
- Trade Name: Book Express Ltd
- Phone Number: (+64) 22 852 6879
- Email: sales@bookexpress.co.nz
- Address: 35 Nathan Terrace, Shannon, 4821, New Zealand.
- GST Number: 103320957 - We are registered for GST in New Zealand
- NZBN: 9429031911290
We have a 30-day return policy, which means you have 30 days after receiving your item to request a return.
To be eligible for a return, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase.
To start a return, you can contact us at sales@bookexpress.co.nz. Please note that returns will need to be sent to the following address: 62 Kaiwharawhara Road, Wellington, NZ once we have confirmed your return.
If your return is accepted, we’ll send you a return shipping label, as well as instructions on how and where to send your package. Items sent back to us without first requesting a return will not be accepted.
You can always contact us for any return question at sales@bookexpress.co.nz.
Damages and issues
Please inspect your order upon reception and contact us immediately if the item is defective, damaged or if you receive the wrong item, so that we can evaluate the issue and make it right.
Exceptions / non-returnable items
Certain types of items cannot be returned, like perishable goods (such as food, flowers, or plants), custom products (such as special orders or personalized items), and personal care goods (such as beauty products). We also do not accept returns for hazardous materials, flammable liquids, or gases. Please get in touch if you have questions or concerns about your specific item.
Unfortunately, we cannot accept returns on sale items or gift cards.
Exchanges
The fastest way to ensure you get what you want is to return the item you have, and once the return is accepted, make a separate purchase for the new item.
European Union 14 day cooling off period
Notwithstanding the above, if the merchandise is being shipped into the European Union, you have the right to cancel or return your order within 14 days, for any reason and without a justification. As above, your item must be in the same condition that you received it, unworn or unused, with tags, and in its original packaging. You’ll also need the receipt or proof of purchase.
Refunds
We will notify you once we’ve received and inspected your return, and let you know if the refund was approved or not. If approved, you’ll be automatically refunded on your original payment method within 10 business days. Please remember it can take some time for your bank or credit card company to process and post the refund too.
If more than 15 business days have passed since we’ve approved your return, please contact us at sales@bookexpress.co.nz.