Web Database Applications with PHP & MySQL - Bookswagon UAE
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Computer programming / software engineering > Database programming > Web Database Applications with PHP & MySQL
Web Database Applications with PHP & MySQL

Web Database Applications with PHP & MySQL


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

What do eBay, Amazon.com and CNN.com have in common? They're all applications that integrate large databases with the Web. The popularity of these applications stems from their accessibility and usability: thousands of users can access the same data at the same time without the need to install any additional software on their computers. This book offers Web developers a mixture of theoretical and practical information on creating Web database applications. Using PHP, and MySQL, two open-source technologies that are often combined to develop Web applications, the book offers detailed information on designing relational databases and on Web application architecture, both of which will be useful to readers who have never dealt with these issues before. The book also introduces Hugh and Dave's Online Wines, a complete (but fictional) online retail site that allows users to browse, search a dAtabase, add items to a shopping cart, manage their membership, and purchase wines. Using this site as an example, the book shows you how to implement searching and browsing. If you want to build small to medium-scale Web database applications that can run on modest hardware and process more than a million hits a day from users, this book will show you how.

Table of Contents:
Preface 1. Database Applications and the Web Three-Tier Architectures The Client Tier The Middle Tier The Database Tier Our Case Study 2. PHP Introducing PHP Conditions and Branches Loops A Worked Example Arrays Strings Regular Expressions Date and Time Functions Integer and Float Functions User-Defined Functions Objects Common Mistakes 3. MySQL and SQL Database Basics Quick Start Guide MySQL Command Interpreter Managing Databases, Tables, and Indexes Inserting, Updating, and Deleting Data Querying with SQL SELECT Join Queries Modifying the Database Functions More on SQL and MySQL 4. Querying Web Databases Connecting to a MySQL Database Formatting Results Case Study: The Front-Page Panel Interacting with Other DBMSs Using PHP 5. User-Driven Querying User Input Querying with User Input Case Study: Previous and Next Browsing Case Study: Producing a select List 6. Writing to Web Databases Database Inserts, Updates, and Deletes Issues in Writing Data to Databases 7. Validation on the Server and Client Validation and Error Reporting for Web Database Applications Server-Side Validation Client-Side Validation with JavaScript 8. Sessions Building Applications That Keep State Session Management Over the Web PHP Session Management Case Study: Adding Sessions to the Winestore When to Use Sessions 9. Authentication and Security HTTP Authentication HTTP Authentication with PHP Authentication Using a Database Web Database Applications and Authentication Protecting Data on the Web 10. Winestore Customer Management Overview of the Winestore Application Customer Management Authenticating Users The Winestore Include Files 11. The Winestore Shopping Cart The Winestore Home Page The Shopping Cart Architecture Managing Redirection 12. Ordering and Shipping at the Winestore Finalizing Orders HTML and Email Receipts 13. Related Topics Automated Housekeeping Templates Searching and Browsing A. Installation Guide B. Internet and Web Protocols C. Modeling and Designing Relational Databases D. Managing Sessions in the Database Tier E. Resources Index

About the Author :
Hugh Williams is a senior lecturer in the School of Computer Science and IT at RMIT University in Melbourne, Australia, where he has taught for seven years. He currently teaches in two areas: database technology and web technology, and is the coordinator of a Masters program that focuses on the Internet and the Web. His research interests include building better search engines, bioinformatics, and designing faster data structures. When not at work Hugh likes to go running, watch Richmond play footy, and follow the cricket. Hugh has a PhD from RMIT University. 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.

Review :
"As symbolized by the duck-billed platypus on the cover it is a book that will help you to survive in a rapidly changing world. Submerge yourself in proven technology and emerge unscathed once the dots have fallen out by the wayside. Recommended for its excellent examples which will save you thousands in case you need to develop a similar application." Information Security Bulletin, July 2002 "The book manages to deliver on two levels at once - the concepts, planning and design process as well as implementation. It's also surprisingly well written, and manages not to be too smug or patronizing." - Nick Veitch, LinuxFormat, October 2002


Best Sellers


Product Details
  • ISBN-13: 9780596000417
  • Publisher: O'Reilly Media
  • Publisher Imprint: O'Reilly Media
  • Height: 232 mm
  • Returnable: N
  • Width: 179 mm
  • ISBN-10: 0596000413
  • Publisher Date: 23 Apr 2002
  • Binding: Paperback
  • Language: English
  • Weight: 822 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Web Database Applications with PHP & MySQL
O'Reilly Media -
Web Database Applications with PHP & MySQL
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Web Database Applications with PHP & MySQL

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!