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

Full description

Bibliographic Details
Main Authors: West, Adrian W., Prettyman, Steve (Author)
Format: eBook
Language:English
Published: New York Apress 2018
Edition:Second edition
Series:ITpro collection
Subjects:
Online Access:
Collection: O'Reilly - Collection details see MPG.ReNa
LEADER 06968nmm a2200613 u 4500
001 EB001939879
003 EBX01000000000000001102781
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9781484238448 
020 |a 9781484238431 
020 |a 1484238435 
050 4 |a TK5105.888 
100 1 |a West, Adrian W. 
245 0 0 |a Practical PHP 7, MySQL 8, and MariaDB website databases  |b a simplified approach to developing database-driven websites  |c Adrian W. West, Steve Prettyman 
250 |a Second edition 
260 |a New York  |b Apress  |c 2018 
300 |a 1 online resource 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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 
505 0 |a 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? 
505 0 |a Includes bibliographical references 
653 |a MariaDB / fast 
653 |a PHP (Computer program language) / fast 
653 |a MySQL (Electronic resource) / http://id.loc.gov/authorities/names/n2004021601 
653 |a Programming & scripting languages: general / bicssc 
653 |a PHP (Computer program language) / http://id.loc.gov/authorities/subjects/sh99002710 
653 |a COMPUTERS / Programming Languages / PHP. / bisacsh 
653 |a MySQL (Electronic resource) / fast 
653 |a MariaDB. / http://id.loc.gov/authorities/names/n2011046345 
653 |a Web site development / http://id.loc.gov/authorities/subjects/sh98004795 
653 |a Sites Web / Développement 
653 |a Web programming / bicssc 
653 |a PHP (Langage de programmation) 
653 |a Algorithms & data structures / bicssc 
653 |a COMPUTERS / Programming Languages / SQL. / bisacsh 
653 |a Web site development / fast 
700 1 |a Prettyman, Steve  |e author 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
490 0 |a ITpro collection 
028 5 0 |a 10.1007/978-1-4842-3843-1 
015 |a GBB8I7706 
776 |z 9781484238448 
776 |z 1484238435 
776 |z 1484238427 
776 |z 9781484238431 
776 |z 9781484238424 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781484238431/?ar  |x Verlag  |3 Volltext 
082 0 |a 005.7565 
520 |a 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 and MariaDB or 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 MariaDB/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 product catalog, and a simple e-commerce site. You will also discover how to migrate a database to a remote host. The final chapter will demonstrate the advantages of migrating to Oracle's MySQL 8. You will be shown step by step migration directions along with a demonstration of the tools available in SQL Workbench. Because you are building the interactive pages yourself, you will know exactly how MySQL, MariaDB, and PHP all work together, and you will be able to add database interactivity to your own websites with ease. You will: Build a secure database-driven website using PHP 7, MySQL 8, and MariaDB Create a product catalog Write a message board Move towards e-commerce Employ security and validation measures Migrate to Oracle's MySQL 8 Server platform