Cargando…
Practical PHP 7, MySQL 8, and MariaDB website databases : a simplified approach to developing database-driven websites /
Build interactive, database-driven websites with PHP 7, MySQL 8, and MariaDB. The focus of this book is on getting you up and running as quickly as possible with real-world applications. In the first two chapters you will set up your development and testing environment, and then build your first PHP...
| Clasificación: | Libro Electrónico |
|---|---|
| Autores principales: | , |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
Apress,
[2018]
|
| Edición: | Second edition. |
| Colección: | ITpro collection
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Intro; Contents; About the Authors; Acknowledgments; Introduction; Chapter 1: Create and Test a Database and Table; Defining Developer, Administrator, and User; Defining Interactive Websites; Using MariaDB or MySQL Only for Interactive Database Tables; Methods for Developing and Maintaining Databases; A Brief Look Inside Web Server Communication; A Free Development Platform for Testing; Using XAMPP on Your Own Computer; Will I Be Able to Transfer the Database from XAMPP or EasyPHP to a Remote Host?; Downloading and Installing XAMPP; Starting XAMPP; Closing XAMPP; Where Is MariaDB and MySQL 8?
- Using EasyPHP on Your Own ComputerDownload and Install EasyPHP; Starting EasyPHP; Closing EasyPHP; phpMyAdmin Security; Accessing phpMyAdmin Directly; The Familiar Bits; Planning a Database: The Essential First Step; Creating a Database Using phpMyAdmin; Create a Table Using phpMyAdmin; The SQL Alternative; Deleting Databases and Tables; Summary; Chapter 2: Create Web Pages That Interact with Users; Creating the Folder for Holding the Database Pages; Creating the Temporary Template; Introducing the PHP include() Function; The Included Header File; The Included Menu File.
- The Included Information ColumnThe Included Footer File; How Does the Server Process the Page?; The Interactive Version of the Template; Connecting to the Database; Explanation of the Code; The Registration Page; Explanation of the Code; Explanation of the Code; The PHP Keyword echo; The "Thank You" Page; Displaying Error Messages That Are Collected in an Array; Hashing the Password; Viewing Members' Records; The View Users Page; Explanation of the Code; The Change Password Page; Explanation of the Code; Explanation of the Code; Confirming a Successful Password Change.
- Testing the Tutorial's PagesMore About Arrays; Summary; Chapter 3: Create Login/Logout Functionality for Members and an Administrator; Creating the logindb Database and users Table; Removing or Replacing Redundant Menu Buttons in the Headers; Adding a Login Button to the Home Page Header; Removing Redundant Buttons from the Registration and New Password Headers; The Revised Registration Page; The New Header for the New Password Page; A New Header Menu for the Members page; Amend the Header for the "Thank You" Page; The Registration Page and Undesirable Characters; Explanation of the Code.
- Registering Some MembersDifferentiating Between Two Types of Membership; Creating User Levels to Limit Access to Private Pages; Log In; The Header for the Login Page; The Login Page; Explanation of the Code; Explanation of the Code; Sessions; A Members-Only Page; Explanation of the Code; Planning the Administrator's Role; A New Header for the Administration Page; The Administrator's Page; Explanation of the Code; The Logout Page; Explanation of the Code; Testing the Login/Logout Function; Amending and Deleting Individual Records; Summary; Chapter 4: Create an Administration Interface.