• Урок 1. 00:01:04
    Welcome
  • Урок 2. 00:02:08
    What you should know before watching this course
  • Урок 3. 00:04:56
    Using the exercise files
  • Урок 4. 00:01:11
    Setting SQLite permissions
  • Урок 5. 00:04:14
    A quick primer on using PHP objects
  • Урок 6. 00:04:05
    Overview of PHP database APIs
  • Урок 7. 00:04:24
    Using prepared statements
  • Урок 8. 00:01:43
    Using transactions
  • Урок 9. 00:02:04
    Creating a database source name
  • Урок 10. 00:07:27
    Connecting to a database with PDO
  • Урок 11. 00:03:49
    Looping directly over a SELECT query
  • Урок 12. 00:08:03
    Fetching a result set
  • Урок 13. 00:07:14
    Finding the number of results from a SELECT query
  • Урок 14. 00:03:32
    Checking if a SELECT query contains results
  • Урок 15. 00:06:03
    Executing simple non-SELECT queries
  • Урок 16. 00:07:17
    Getting error messages
  • Урок 17. 00:03:30
    Using the quote() method to sanitize user input
  • Урок 18. 00:02:36
    Binding input and output values
  • Урок 19. 00:09:51
    Using named parameters
  • Урок 20. 00:02:35
    Using question marks as anonymous placeholders
  • Урок 21. 00:05:20
    Passing an array of values to the execute() method
  • Урок 22. 00:07:53
    Binding results to variables
  • Урок 23. 00:06:54
    Executing a transaction
  • Урок 24. 00:04:42
    Closing the cursor before running another query
  • Урок 25. 00:02:44
    Generating an array from a pair of columns
  • Урок 26. 00:04:42
    Setting an existing object`s properties with a database result
  • Урок 27. 00:06:01
    Creating an instance of a specific class with a database result
  • Урок 28. 00:07:53
    Reusing a result set
  • Урок 29. 00:05:58
    Connecting to a database with MySQLi
  • Урок 30. 00:01:57
    Setting the character set
  • Урок 31. 00:04:04
    Submitting a SELECT query and getting the number of results
  • Урок 32. 00:07:35
    Fetching the result
  • Урок 33. 00:03:20
    Rewinding the result for reuse
  • Урок 34. 00:05:27
    Handling non-SELECT queries
  • Урок 35. 00:05:47
    Getting error messages
  • Урок 36. 00:04:07
    Sanitizing user input with real_escape_string()
  • Урок 37. 00:04:17
    Initializing and preparing a statement
  • Урок 38. 00:05:55
    Binding parameters and executing a prepared statement
  • Урок 39. 00:05:06
    Binding output variables
  • Урок 40. 00:07:05
    Executing a MySQLi transaction
  • Урок 41. 00:05:26
    Dealing with commands out of sync in prepared statements
  • Урок 42. 00:04:19
    Buffered and unbuffered queries
  • Урок 43. 00:06:01
    Using real_query()
  • Урок 44. 00:02:31
    Freeing resources that are no longer needed
  • Урок 45. 00:06:42
    Submitting multiple queries
  • Урок 46. 00:04:35
    Creating an instance of a class from a result set
  • Урок 47. 00:03:31
    PDO and MySQLi compared
Этот материал находится в платной подписке. Оформи премиум подписку и смотри PHP: Accessing Databases with PDO and MySQLi, а также все другие курсы, прямо сейчас!
Премиум