Beginning PHP and MySQL: From Novice to Professional, Fifth Edition

  • 10h 58m
  • Frank M. Kromann
  • Apress
  • 2018

Get started with PHP and MySQL programming: no experience necessary. This fifth edition of a classic best-seller includes detailed instructions for configuring the ultimate PHP 7 and MySQL development environment on all major platforms, complete coverage of the latest additions and improvements to the PHP language, and thorough introductions to MySQL’s most relied-upon features. You'll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but you'll also learn how to effectively integrate them in order to build robust data-driven applications. Author Frank M. Kromann draws upon more than 20 years of experience working with these technologies to pack this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide.

What You Will Learn

  • Install PHP, MySQL, and several popular web servers
  • Get started with PHP, including using its string-handling, networking, forms-processing, and object-oriented features
  • Gain skills in MySQL’s fundamental features, including supported data types, database management syntax, triggers, views, stored routine syntax, and import/export capabilities
  • Work with hundreds of examples demonstrating countless facets of PHP and MySQL integration

Who This Book Is For

Anyone who wants to get started using PHP to write dynamic web applications.

About the Author

Frank Kromann has spent more than 30 years solving business problems using software and technology. Since the introduction of the first web browser he has developed systems with web technology on Unix, Linux, Windows, and Mac platforms, with the primary focus on PHP, JavaScript, C/C++, and other languages. He has contributed several PHP extensions over the years and has been a member of the PHP development team since 1997. Previous publications included several articles in PHP Magazine and he was the coauthor of PHP and MySQL Recipes (Apress, 2016). Frank has held managing positions for more than 20 years, leading both smaller and larger teams in development and implementation of business systems and processes utilizing databases and programming. Currently he is an Engineering Manager at Panasonic Avionics and the CEO and cofounder of Web by Pixel, Inc. Kromann holds a Master of Science degree in Electrical Engineering from the Technical University of Denmark.

In this Book

  • Introducing PHP
  • Configuring Your Environment
  • PHP Basics
  • Functions
  • Arrays
  • Object-Oriented PHP
  • Advanced OOP Features
  • Error and Exception Handling
  • Strings and Regular Expressions
  • Working with the File and Operating System
  • Third-Party Libraries
  • Date and Time
  • Forms
  • Authenticating Your Users
  • Handling File Uploads
  • Networking
  • Session Handlers
  • Web Services
  • Secure PHP Programming
  • Integrating jQuery and PHP
  • MVC and Frameworks
  • Introducing MySQL
  • Installing and Configuring MySQL
  • The Many MySQL Clients
  • MySQL Storage Engines and Data Types
  • Securing MySQL
  • Using PHP with MySQL
  • Introducing PDO
  • Stored Routines
  • MySQL Triggers
  • MySQL Views
  • Practical Database Queries
  • Indexes and Searching
  • Transactions
  • Importing and Exporting Data
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book PHP 8 Basics: For Programming and Web Development
Book Job Ready SQL
Audiobook Learning SQL: Generate, Manipulate, and Retrieve Data, 3rd Edition