Practical PHP 7, MySQL 8, and MariaDB website databases : a simplified approach to developing database-driven websites /: a simplified approach to developing database-driven websites. ([2018])
- Record Type:
- Book
- Title:
- Practical PHP 7, MySQL 8, and MariaDB website databases : a simplified approach to developing database-driven websites /: a simplified approach to developing database-driven websites. ([2018])
- Main Title:
- Practical PHP 7, MySQL 8, and MariaDB website databases : a simplified approach to developing database-driven websites
- Further Information:
- Note: Adrian W. West, Steve Prettyman.
- Authors:
- West, Adrian W
Prettyman, Steve - Contents:
- 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; DisplayingIntro; 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 … (more)
- Publisher Details:
- New York : Apress
- Publication Date:
- 2018
- Extent:
- 1 online resource
- Subjects:
- 005.7565
Computer science
COMPUTERS -- Programming Languages -- SQL
COMPUTERS -- Programming Languages -- PHP
Web site development
PHP (Computer program language)
Computers -- Information Theory
Computers -- Programming Languages -- General
Algorithms & data structures
Programming & scripting languages: general
Computer programming
Data structures (Computer science)
Computers -- Web -- Web Programming
Web programming
Electronic books - Languages:
- English
- ISBNs:
- 9781484238431
1484238435 - Related ISBNs:
- 1484238427
9781484238424 - Notes:
- Note: Online resource; title from PDF title page (EBSCO, Oct. 5, 2018).
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.333859
- Ingest File:
- 01_279.xml