5. Using Databases | Learning PHP 7

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning PHP 7

By : Antonio L Zapata (GBP)

3.4 (10)

Learning PHP 7

3.4 (10)

By: Antonio L Zapata (GBP)

Overview of this book

PHP is a great language for building web applications. It is essentially a server-side scripting language that is also used for general purpose programming. PHP 7 is the latest version with a host of new features, and it provides major backwards-compatibility breaks. This book begins with the fundamentals of PHP programming by covering the basic concepts such as variables, functions, class, and objects. You will set up PHP server on your machine and learn to read and write procedural PHP code. After getting an understanding of OOP as a paradigm, you will execute MySQL queries on your database. Moving on, you will find out how to use MVC to create applications from scratch and add tests. Then, you will build REST APIs and perform behavioral tests on your applications. By the end of the book, you will have the skills required to read and write files, debug, test, and work with MySQL.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Setting Up the Environment

1. Setting Up the Environment

Setting up the environment with Vagrant

Setting up the environment on OS X

Setting up the environment on Windows

Setting up the environment on Ubuntu

Summary

2. Web Applications with PHP

2. Web Applications with PHP

The HTTP protocol

Web applications

Web servers

Summary

3. Understanding PHP Basics

3. Understanding PHP Basics

PHP files

Variables

Operators

Working with strings

Arrays

PHP in web applications

Control structures

Functions

The filesystem

Summary

4. Creating Clean Code with OOP

4. Creating Clean Code with OOP

Classes and objects

Properties and methods visibility

Static properties and methods

Namespaces

Autoloading classes

Inheritance

Interfaces

Traits

Handling exceptions

Design patterns

Anonymous functions

Summary

5. Using Databases

5. Using Databases

Introducing databases

Schemas and tables

Keys and constraints

Inserting data

Querying data

Using PDO

Joining tables

Grouping queries

Updating and deleting data

Working with transactions

Summary

6. Adapting to MVC

6. Adapting to MVC

The MVC pattern

Using Composer

Working with requests

M for model

V for view

C for controller

Dependency injection

Summary

7. Testing Web Applications

7. Testing Web Applications

The necessity for tests

Integrating PHPUnit

Writing unit tests

Testing with doubles

Database testing

Test-driven development

Summary

8. Using Existing PHP Frameworks

8. Using Existing PHP Frameworks

Reviewing frameworks

Other features of frameworks

Types of frameworks

An overview of famous frameworks

The Laravel framework

The Silex microframework

Silex versus Laravel

Summary

9. Building REST APIs

9. Building REST APIs

Introducing APIs

Introducing REST APIs

The foundations of REST APIs

Using third-party APIs

The toolkit of the REST API developer

Best practices with REST APIs

Creating a REST API with Laravel

Testing your REST APIs

Summary

10. Behavioral Testing

10. Behavioral Testing

Behavior-driven development

BDD with Behat

Testing with a browser using Mink

Summary

Index

Index

Querying data

It took quite a lot of time, but we are finally in the most exciting—and useful—section related to databases: querying data. Querying data refers to asking MySQL to return rows from the specified table and optionally filtering these results by a set of rules. You can also choose to get specific fields instead of the whole row. In order to query data, we will use the SELECT command, as follows:

mysql> SELECT firstname, surname, type FROM customer;
+-----------+---------+---------+
| firstname | surname | type    |
+-----------+---------+---------+
| Han       | Solo    | premium |
| James     | Kirk    | basic   |
+-----------+---------+---------+
2 rows in set (0.00 sec)

One of the simplest ways to query data is to specify the fields of interest after SELECT and specify the table with the FROM keyword. As we did not add any filters—mostly known as conditions—to the query, we got all the rows there. Sometimes, this is the desired behavior, but the most common thing to do...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning PHP 7

Search

Your notes and bookmarks