Practical PHP and MySQL Website Databases: A Simplified Approach

( 1 )

Overview

Practical PHP and MySQL Website Databases is a project-oriented book that demystifies building interactive, database-driven websites. The focus is on getting you up and running as quickly as possible. In the first two chapters you will set up your development and testing environment, and then build your first PHP and MySQL database-driven website. You will then increase its sophistication, security, and functionality throughout the course of the book. The PHP required is taught in context within each project so ...

See more details below
Paperback
$39.99
BN.com price
(Save 20%)$49.99 List Price
Other sellers (Paperback)
  • All (10) from $39.72   
  • New (8) from $39.72   
  • Used (2) from $66.28   
Practical PHP and MySQL Website Databases: A Simplified Approach

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

Practical PHP and MySQL Website Databases is a project-oriented book that demystifies building interactive, database-driven websites. The focus is on getting you up and running as quickly as possible. In the first two chapters you will set up your development and testing environment, and then build your first PHP and MySQL database-driven website. You will then increase its sophistication, security, and functionality throughout the course of the book. The PHP required is taught in context within each project so you can quickly learn how PHP integrates with MySQL to create powerful database-driven websites.


Each project is fully illustrated, so you will see clearly what you are building as you create your own database-driven website. You will build a form for registering users, and then build an interface so that an administrator can view and administer the user database. You will create a message board for users and a method for emailing them. You will also learn the best practices for ensuring that your website databases are secure. Later chapters describe how to create a blog, a product catalog, and a simple e-commerce site. You will also discover how to migrate a database to a remote host. Because you are building the interactive pages yourself, you will know exactly how the MySQL and PHP work, and you will be able to add database interactivity to your own websites with ease.

What you’ll learn


  • Download and use a free development and test platform.
  • Create interactive database-driven websites.
  • Learn how to make website databases secure.
  • Create sophisticated projects, such as blogs and e-commerce sites.
  • Create user friendly and secure interfaces.
  • Migrate a site to a remote host.

Who this book is for

Practical PHP and MySQL Website Databases is for web developers who wish to begin designing database-driven websites. The book is an excellent choice for people who have HTML and CSS skills but would also like to learn MySQL and PHP. For readers who have little or no knowledge of PHP, the book will teach enough PHP to complete all the projects in the book. Web developers who are ready to move beyond the basics or who have not kept up-to-date with their MySQL and PHP knowledge will also benefit from Practical PHP and MySQL Website Databases. College and university I.T. teachers will find that Practical PHP and MySQL Website Databases is an excellent set text, the projects would form a basis for students to adapt for their course work.

Table of Contents


  1. Create and Test a MySQL Database and Table
  2. Create Web Pages that Interact with Users
  3. Setting Up Logins for Your Website Users
  4. Creating an Administration Interface
  5. Expanding and Enriching your Website
  6. Security and Validation
  7. Migrating to a Host and Backing Up Your Website Database
  8. Creating a Product Catalog
  9. Adding Multiple Tables and Other Enhancements
  10. Creating a Message Board
  11. E-commerce: A Brief Introduction
  12. Troubleshooting Your Database-Driven Website
  13. Appendix A: Resources
Read More Show Less

Product Details

  • ISBN-13: 9781430260769
  • Publisher: Apress
  • Publication date: 12/11/2013
  • Edition number: 1
  • Pages: 448
  • Sales rank: 1,312,297
  • Product dimensions: 7.50 (w) x 9.25 (h) x 0.91 (d)

Meet the Author

Adrian West resigned as a chartered engineer and has been teaching in one form or another since 1982. He introduced computers into his work place in 1989 and taught the staff how to use them. For 13 years he has designed and produced websites for businesses and charities in his present location Colyton, Devon, UK. He served as a computer technician to about 100 locals. He stopped visiting and teaching people five years ago so that he could concentrate on his favourite occupation, designing websites. To avoid disappointing his former customers, he launched his free computer help website www.colycomputerhelp.co.uk. He also writes monthly computer help articles in two local magazines. Adrian is the author of Practical HTML5 Projects; Apress May 2012; ISBN-13: 978-1-4302-4275-8.

Frustrated by over complicated MySQL manuals that assumed the reader would fill in the many gaps in the instructions, he researched, tested and developed a fully explained and simplified method to eliminate the difficulties he experienced; this book is the result.

Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted August 1, 2014

    Title says it all

    This is a very practical introduction to PHP and MySQL programming. The author's approach -- designing and building a member's only website -- makes it much easier to connect to the material. And his focus on security issues related to PHP, MySQL and data privacy is appreciated.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)