PHP & MySQL in easy steps, 2nd edition
eBook - ePub

PHP & MySQL in easy steps, 2nd edition

Updated to cover MySQL 8.0

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

PHP & MySQL in easy steps, 2nd edition

Updated to cover MySQL 8.0

About this book

PHP and MySQL in easy steps, 2nd edition teaches the user to write PHP server-side scripts and how to make MySQL database queries. It has an easy-to-follow style that will appeal to:

  • anyone who wants to begin producing data-driven web pages.
  • web developers wanting to add database interaction to their web sites.
  • the programmer who quickly wants to add PHP and MySQL to their skills set.
  • the hobbyist who wants to begin creating scripts for upload to their own ISP.
  • the student, and to those seeking a career in computing, who need a fundamental understanding of server-side programming with PHP and MySQL.

PHP and MySQL in easy steps, 2nd edition demonstrates by example how to produce data-driven web pages using the powerful PHP scripting language and the popular free MySQL database server. The book examples provide clear syntax-highlighted code showing how to selectively insert and extract data from databases for presentation on your web browser.

PHP and MySQL in easy steps, 2nd edition begins by explaining how to install a free web server, the PHP interpreter, and MySQL database server, to create an environment in which you can produce your very own data-driven server-side web pages. You will learn how to write PHP server-side scripts and how to make MySQL database queries. Examples illustrate how to store and retrieve Session Data, how to provide a Message Board, and how to create an E-Commerce Shopping Cart.

This book assumes you have no previous experience of any programming or scripting language so is ideal for the newcomer to PHP and MySQL technologies.

Covers MySQL 8.0.

Contents

  • Getting started
  • Performing operations
  • Controlling progress
  • Producing forms
  • Assembling tables
  • Handling data
  • Connecting databases
  • Registering users
  • Providing forums
  • Processing shops

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access PHP & MySQL in easy steps, 2nd edition by Mike McGrath in PDF and/or ePUB format, as well as other popular books in Computer Science & Programming in PHP. We have over one million books available in our catalogue for you to explore.
1
Getting started
Welcome to the exciting world of the data-driven web with PHP & MySQL. This chapter demonstrates how to create a dynamic development environment incorporating the Abyss Web Server, the PHP engine, and the MySQL database server.
Introducing PHP & MySQL
Understanding The Cloud
Installing Abyss Web Server
Installing the PHP engine
Configuring Abyss for PHP
Embedding PHP script
Installing the MySQL Server
Using the MySQL Client
Creating MySQL users
Connecting PHP & MySQL
Summary
Introducing PHP & MySQL
The most appealing modern websites provide a customized user experience by dynamically responding to some current conditions – user name, time of day, latest blog, shopping cart contents, etc. Many of these dynamic websites are created with PHP and MySQL.
image
What is PHP?
PHP is a widely-used general purpose scripting language that is especially suited for web development, and can be embedded into HTML. It was created by programmer Rasmus Lerdorf as a set of scripts to maintain his website that he released as “Personal Home Page Tools (PHP Tools) version 1.0” on June 8, 1995. These were extended in the version 2 release of 1997, and the name changed to become a recursive acronym “PHP: Hypertext Preprocessor” in version 3 the following year. Performance, reliability, and extensibility were improved in 2000 with the release of PHP4, which was powered by the new Zend engine – a virtual machine. The current version, PHP5, is powered by the Zend II engine and produced as free software by the PHP group. Today, PHP is installed on over 20 million websites and 1 million web servers.
image
What is MySQL?
MySQL is the world’s most popular database software. It is used to manage stored data and is described as DataBase Management Software (DBMS) or Relational DataBase Management Software (RDBMS). MySQL was created by Michael Wildenius and David Axmark back in 1995. Its name (“My-S-Q-L” officially, but often pronounced “My Sequel”) is a combination of Michael’s daughter’s name “My” and the term “SQL” (Structured Query Language). MySQL was originally produced by the company MySQL AB, founded by its creators, which was acquired by Sun Microsystems in 2008, and subsequently by Oracle in 2010. The current version, MySQL 8.0, is powered by the InnoDB storage engine, and the MySQL Community Server edition is available as free software. Today, MySQL is used on some of the most frequently visited websites, including Google, Wikipedia, Facebo...

Table of contents

  1. Cover
  2. Title
  3. Copyright
  4. Contents
  5. Preface
  6. 1 Getting started
  7. 2 Performing operations
  8. 3 Controlling progress
  9. 4 Producing forms
  10. 5 Assembling tables
  11. 6 Handling data
  12. 7 Connecting databases
  13. 8 Registering users
  14. 9 Providing forums
  15. 10 Processing shops
  16. Back Cover