1. Урок 1.00:01:04
    Welcome
  2. Урок 2.00:02:08
    What you should know before watching this course
  3. Урок 3.00:04:56
    Using the exercise files
  4. Урок 4.00:01:11
    Setting SQLite permissions
  5. Урок 5.00:04:14
    A quick primer on using PHP objects
  6. Урок 6.00:04:05
    Overview of PHP database APIs
  7. Урок 7.00:04:24
    Using prepared statements
  8. Урок 8.00:01:43
    Using transactions
  9. Урок 9.00:02:04
    Creating a database source name
  10. Урок 10.00:07:27
    Connecting to a database with PDO
  11. Урок 11.00:03:49
    Looping directly over a SELECT query
  12. Урок 12.00:08:03
    Fetching a result set
  13. Урок 13.00:07:14
    Finding the number of results from a SELECT query
  14. Урок 14.00:03:32
    Checking if a SELECT query contains results
  15. Урок 15.00:06:03
    Executing simple non-SELECT queries
  16. Урок 16.00:07:17
    Getting error messages
  17. Урок 17.00:03:30
    Using the quote() method to sanitize user input
  18. Урок 18.00:02:36
    Binding input and output values
  19. Урок 19.00:09:51
    Using named parameters
  20. Урок 20.00:02:35
    Using question marks as anonymous placeholders
  21. Урок 21.00:05:20
    Passing an array of values to the execute() method
  22. Урок 22.00:07:53
    Binding results to variables
  23. Урок 23.00:06:54
    Executing a transaction
  24. Урок 24.00:04:42
    Closing the cursor before running another query
  25. Урок 25.00:02:44
    Generating an array from a pair of columns
  26. Урок 26.00:04:42
    Setting an existing object`s properties with a database result
  27. Урок 27.00:06:01
    Creating an instance of a specific class with a database result
  28. Урок 28.00:07:53
    Reusing a result set
  29. Урок 29.00:05:58
    Connecting to a database with MySQLi
  30. Урок 30.00:01:57
    Setting the character set
  31. Урок 31.00:04:04
    Submitting a SELECT query and getting the number of results
  32. Урок 32.00:07:35
    Fetching the result
  33. Урок 33.00:03:20
    Rewinding the result for reuse
  34. Урок 34.00:05:27
    Handling non-SELECT queries
  35. Урок 35.00:05:47
    Getting error messages
  36. Урок 36.00:04:07
    Sanitizing user input with real_escape_string()
  37. Урок 37.00:04:17
    Initializing and preparing a statement
  38. Урок 38.00:05:55
    Binding parameters and executing a prepared statement
  39. Урок 39.00:05:06
    Binding output variables
  40. Урок 40.00:07:05
    Executing a MySQLi transaction
  41. Урок 41.00:05:26
    Dealing with commands out of sync in prepared statements
  42. Урок 42.00:04:19
    Buffered and unbuffered queries
  43. Урок 43.00:06:01
    Using real_query()
  44. Урок 44.00:02:31
    Freeing resources that are no longer needed
  45. Урок 45.00:06:42
    Submitting multiple queries
  46. Урок 46.00:04:35
    Creating an instance of a class from a result set
  47. Урок 47.00:03:31
    PDO and MySQLi compared