LEADER 04901nam 22006255 450 001 9910300751703321 005 20200705123603.0 010 $a9781484238431 010 $a1484238435 024 7 $a10.1007/978-1-4842-3843-1 035 $a(CKB)4100000006995845 035 $a(MiAaPQ)EBC5528909 035 $a(DE-He213)978-1-4842-3843-1 035 $a(CaSebORM)9781484238431 035 $a(PPN)230542700 035 $a(OCoLC)1059521776 035 $a(OCoLC)on1059521776 035 $a(EXLCZ)994100000006995845 100 $a20180928d2018 u| 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aPractical PHP 7, MySQL 8, and MariaDB Website Databases $eA Simplified Approach to Developing Database-Driven Websites /$fby Adrian W. West, Steve Prettyman 205 $a2nd ed. 2018. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2018. 215 $a1 online resource (561 pages) 311 08$a9781484238424 311 08$a1484238427 320 $aIncludes bibliographical references. 327 $a1. Create and Test a Database and Table -- 2. Create Web Pages that Interact with Users -- 3. Login/Logout for Members and an Administrator -- 4. Creating an Administration Interface -- 5. Expanding and Enriching your Website -- 6. Finishing Touches: Security and Validation -- 7. Migrating to a Host and Backing Up Your Website Database -- 8. Creating a Product Catalog -- 9. Joining Multiple Tables and Other Enhancements -- 10. Creating a Message Board -- 11. E-commerce: A Brief Introduction -- 12. A Brief Look at Oracle MySQL 8 -- Appendix A. Troubleshooting -- Appendix B. Resources. 330 $aBuild 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. 517 3 $aPractical Personal Home Page seven, MySQL eight, and MariaDB website databases 606 $aComputer programming 606 $aData structures (Computer science) 606 $aProgramming languages (Electronic computers) 606 $aWeb Development$3https://scigraph.springernature.com/ontologies/product-market-codes/I29050 606 $aData Structures and Information Theory$3https://scigraph.springernature.com/ontologies/product-market-codes/I15009 606 $aProgramming Languages, Compilers, Interpreters$3https://scigraph.springernature.com/ontologies/product-market-codes/I14037 615 0$aComputer programming. 615 0$aData structures (Computer science). 615 0$aProgramming languages (Electronic computers). 615 14$aWeb Development. 615 24$aData Structures and Information Theory. 615 24$aProgramming Languages, Compilers, Interpreters. 676 $a005.133 700 $aWest$b Adrian W$4aut$4http://id.loc.gov/vocabulary/relators/aut$0872335 702 $aPrettyman$b Steve$4aut$4http://id.loc.gov/vocabulary/relators/aut 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300751703321 996 $aPractical PHP 7, MySQL 8, and MariaDB Website Databases$92528348 997 $aUNINA