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
• 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; 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
• 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.