PHP and MySQL
Home > Computing and Information Technology > Computer programming / software engineering > Web programming > PHP and MySQL: Create - Modify - Reuse
PHP and MySQL: Create - Modify - Reuse

PHP and MySQL: Create - Modify - Reuse


     0     
5
4
3
2
1



Out of Stock


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

Learn everything about the dynamic power of PHP and MySQL in real-world applications with the practical information and step-by-step instructions in PHP and MySQL: Create - Modify – Reuse. The authors, experts in tune with common web development tasks, will guide you through several projects that are complete, tested, and ready to be implemented, so that you can understand by doing. Understand all aspects of design, such as portability, design flow, and integration, and become proficient at solving problems that developers face in everyday circumstances.

Table of Contents:
Introduction xi Chapter 1: User Registration 1 Plan the Directory Layout 1 Planning the Database 2 Writing Shared Code 3 User Class 5 CAPTCHA 9 Templates 11 Registering a New User 12 E-mailing a Validation Link 17 Logging In and Out 21 Changing Information 25 Forgotten Passwords 28 Summary 30 Chapter 2: Community Forum 31 Design of the Forum 31 Designing the Database 32 Working with Permissions and Bitwise Operators 33 Updating the User Class 35 Code and Code Explanation 40 Adding Forums 41 Adding Posts 43 Displaying Forums and Posts 47 Pagination 55 Avatars 56 BBCode 59 Summary 62 Chapter 3: Mailing List 63 Design of the Mailing List 63 Choosing POP3 64 Designing the Database 65 Code and Code Explanation 66 The POP3 Client 66 The Configuration File 73 Account Management 73 Processing Messages 79 Processing the Digest 83 Setting Up the Mailing List 83 Summary 86 Chapter 4: Search Engine 87 Designing the Search Engine 87 Problems with Full-Text Search 88 Designing the Database 89 Code and Code Explanation 91 Administrative Interface 91 Crawler/Indexer 98 Front End 104 Summary 110 Chapter 5: Personal Calendar 113 Designing the Application 113 Designing the Database 114 Code and Code Explanation 115 Creating a Month-View Calendar 115 Creating a Day-View Calendar 120 Adding and Showing Events 121 Sending Reminders 129 Exporting the Calendar 130 Summary 135 Chapter 6: Ajax File Manager 137 Design of the Ajax File Manager 137 JavaScript and Ajax 138 The XMLHttpRequest Object 139 Code and Code Explanation 142 Main Interface 143 Client-Side Functionality 147 Server-Side Functionality 160 Summary 175 Chapter 7: Online Photo Album 177 Design of the Online Photo Album 177 Code and Code Explanation 178 Views 178 Helper Files 188 QuickTime Thumbnails 190 Thumbnail Caching 192 Summary 193 Chapter 8: Shopping Cart 195 Designing the Shopping Cart 195 Designing the Database 196 Code and Code Explanation 197 The ShoppingCart Class 197 Working with the Shopping Cart 201 Building the Storefront 209 Adding Inventory 217 Summary 238 Chapter 9: Web Site Statistics 239 Determining What to Collect 239 Designing the Database 241 Obtaining Data 242 Code and Code Explanation 244 Pie Chart 244 Bar Chart 248 The Report 253 Summary 264 Chapter 10: News/Blog System 265 Tables 265 Adding Posts 267 Generating the RSS 278 Displaying Posts 282 Adding Comments 285 Summary 289 Chapter 11: Shell Scripts 291 Designing the Script 292 General Shell Scripting Advice 293 Code and Code Explanation 294 The CommandLine Class 294 startproject 303 The Skeleton 313 Summary 314 Chapter 12: Security and Logging 315 Cross-Site Scripting 315 Path Traversal 318 Injection 320 SQL Injection 320 Command Injection 324 Weak Authentication 325 Logging 327 Preventing Accidental Deletes 330 Summary 332 Index 333

About the Author :
Timothy Boronczyk is a native of Syracuse, NY, where he works as a freelance developer, programmer and technical editor. He has been involved in web design since 1998 and over the years has written several articles and tutorials on PHP programming. Timothy holds a degree in software application programming and recently started his first business venture, Salt City Tech ( www.saltcitytech.com ). In his spare time, he enjoys photography, hanging out with friends, and sleeping with his feet hanging off the end of his bed. He ’ s easily distracted by shiny objects. Martin E. Psinas is a recognized security expert and valued member of the open - source community. He has been contracted as a technical editor, code auditor, and is a published author with Pearson Education as well as the #1 PHP magazine, PHP|Architect . In his free time, he maintains his personal web site and is a volunteer administrator/contributor at codewalkers.com — a resource for PHP & MySQL developers. Martin interacts frequently with the leaders of the PHP project as well as PHP User ’ s Groups. Timothy Boronczyk is a native of Syracuse, NY, where he works as a freelance developer, programmer and technical editor. He has been involved in web design since 1998 and over the years has written several articles and tutorials on PHP programming. Timothy holds a degree in software application programming and recently started his first business venture, Salt City Tech ( www.saltcitytech.com ). In his spare time, he enjoys photography, hanging out with friends, and sleeping with his feet hanging off the end of his bed. He ’ s easily distracted by shiny objects. Martin E. Psinas is a recognized security expert and valued member of the open - source community. He has been contracted as a technical editor, code auditor, and is a published author with Pearson Education as well as the #1 PHP magazine, PHP|Architect . In his free time, he maintains his personal web site and is a volunteer administrator/contributor at codewalkers.com — a resource for PHP & MySQL developers. Martin interacts frequently with the leaders of the PHP project as well as PHP User ’ s Groups.


Best Sellers


Product Details
  • ISBN-13: 9780470382660
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Wrox Press
  • Language: English
  • Sub Title: Create - Modify - Reuse
  • ISBN-10: 047038266X
  • Publisher Date: 11 Jul 2008
  • Binding: Digital (delivered electronically)
  • No of Pages: 341


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
PHP and MySQL: Create - Modify - Reuse
John Wiley & Sons Inc -
PHP and MySQL: Create - Modify - Reuse
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.

PHP and MySQL: Create - Modify - Reuse

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

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!