Practical PHP and MySQL Website Databases: A Simplified Approach (Paperback)

Adrian W. West

  • 出版商: Apress
  • 出版日期: 2013-12-19
  • 售價: $2,190
  • 貴賓價: 9.5$2,081
  • 語言: 英文
  • 頁數: 448
  • 裝訂: Paperback
  • ISBN: 1430260769
  • ISBN-13: 9781430260769
  • 相關分類: MySQLPHPSQL資料庫
  • 無法訂購

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

《實用的 PHP 和 MySQL 網站資料庫》是一本以專案為導向的書籍,揭開了建立互動式、資料庫驅動的網站的神秘面紗。重點是讓您能夠盡快上手。在前兩章中,您將建立開發和測試環境,然後建立您的第一個 PHP 和 MySQL 資料庫驅動的網站。在整本書的過程中,您將提升網站的複雜性、安全性和功能。所需的 PHP 將在每個專案中以上下文方式教授,因此您可以快速學習 PHP 如何與 MySQL 整合,創建功能強大的資料庫驅動網站。

每個專案都有詳細的圖解,因此在創建自己的資料庫驅動網站時,您將清楚地看到正在建立的內容。您將建立一個用於註冊使用者的表單,然後建立一個介面,以便管理員可以查看和管理使用者資料庫。您還將創建一個用於使用者的留言板和發送電子郵件的方法。您還將學習確保網站資料庫安全的最佳實踐。後面的章節介紹了如何創建博客、產品目錄和簡單的電子商務網站。您還將了解如何將資料庫遷移到遠程主機。由於您自己建立了互動頁面,您將完全了解 MySQL 和 PHP 的工作原理,並能夠輕鬆地將資料庫互動性添加到自己的網站中。

《實用的 PHP 和 MySQL 網站資料庫》適合希望開始設計資料庫驅動網站的網頁開發人員。本書對於具備 HTML 和 CSS 技能但也想學習 MySQL 和 PHP 的讀者來說是一個很好的選擇。對於對 PHP 幾乎沒有或沒有知識的讀者,本書將教授足夠的 PHP 知識以完成書中的所有專案。已經掌握基礎知識或未能跟上 MySQL 和 PHP 知識的網頁開發人員也會從《實用的 PHP 和 MySQL 網站資料庫》中受益。大學和高等教育機構的資訊技術教師將發現《實用的 PHP 和 MySQL 網站資料庫》是一本優秀的教材,其中的專案可以成為學生課程作業的基礎。

目錄:
1. 創建並測試 MySQL 資料庫和表格
2. 創建與使用者互動的網頁
3. 為網站使用者設置登錄功能
4. 創建管理介面
5. 擴展和豐富您的網站
6. 安全性和驗證
7. 遷移到遠程主機並備份網站資料庫
8. 創建產品目錄
9. 添加多個表格和其他增強功能
10. 創建留言板
11. 電子商務:簡介
12. 故障排除資料庫驅動的網站
附錄 A:資源