# Course 4: Working with TiDB from PHP [TiDB v6.x] (Code#: 201.4_v6_PHP) 

## Prerequisites
+ Experience with PHP programming and SQL

## Description
+ This course guides you through a series of concepts and hands-on best practices to implement read and write operations via PHP. Two APIs are introduced: mysqli and PDO_MySQL.

## Audience
+ SQL and PHP developers 

## Level
+ Intermediate

## Duration
+ 3 hours

## Summary
+ Using Database Connector
  + Explain what a database connector is
  + Describe `TiDB` Connector
  + Access `TiDB` via `PHP`
  + Describe the benefits of connection pooling
  + Handle `NULL` values in the result set
+ Using Prepared Statements
  + Describe the reasons for using prepared statement and its limitations
  + Use `MySQL Client` to execute **`PREPARE`**, **`EXECUTE`**, and **`DEALLOCATE`** on prepared statement
  + Describe the execution plan cache
  + Use prepared statement in your program
+ Exception Handling
  + Set `SQL` mode to modify the behavior of error output
  + Use **`SHOW WARNINGS`** and **`SHOW ERRORS`**
  + Interpret error messages
  + Handle exceptions in `PHP`