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