Goals
- Control exceptions and link the database with PDO
Program
Errors in PHP: Description of an error, levels
Error logging (log)
Customize the error handler
Exceptions: definition, common exceptions
Capturing and handling an exception
Throwing an exception
Define the particular cases to be managed via exceptions, set up the treatments
Structure of PDO classes
Connection to the data server, drivers and dsn
Perform simple queries
Retrieve data in a loop
Define the format of the result (table, column, object, class)
Retrieve the identifier of an insertion
Prepare queries and use them with parameters
Avoid SQL injections
Bind the parameter or directly the data
The cases of the LIKE and IN clauses
Transaction
management Error management
Set up multiple read and write processes in the database
Passing of the certification (if foreseen in the financing).
Duration
2 days
Price
£ 783
Audience
PHP Developer or Modern Language Developer (Java, C #) with a good knowledge of PHP syntax
Prerequisites
Good knowledge of PHP
Reference
PHP1086-F
Sessions
Contact us for more informations about session date