Lynda - PHP With MySQL - Essential Training

1. 00. Introduction/01 Welcome.mp45.92MB
2. 00. Introduction/02 Using the exercise files.mp44.3MB
3. 01. PHP Overview/01 What is PHP.mp44.63MB
4. 01. PHP Overview/02 The history of PHP.mp43.52MB
5. 01. PHP Overview/03 Why choose PHP.mp48.69MB
6. 01. PHP Overview/04 Installation overview.mp45MB
7. 02. Mac Installation/010 Text editor.mp48.29MB
8. 02. Mac Installation/01 Overview.mp43.12MB
9. 02. Mac Installation/02 Working with Apache Web Server.mp49.9MB
10. 02. Mac Installation/03 Changing the document root.mp410.68MB
11. 02. Mac Installation/04 Installing to Yosemite.mp422.73MB
12. 02. Mac Installation/05 Enabling PHP.mp49.9MB
13. 02. Mac Installation/06 Upgrading PHP.mp49.49MB
14. 02. Mac Installation/07 Configuring PHP.mp424.88MB
15. 02. Mac Installation/08 Installing MySQL.mp411.81MB
16. 02. Mac Installation/09 Configuring MySQL.mp410.7MB
17. 03. Windows Installation/01 Overview.mp44.32MB
18. 03. Windows Installation/02 Installing WampServer.mp412.52MB
19. 03. Windows Installation/03 Finding the document root.mp44.3MB
20. 03. Windows Installation/04 Configuring PHP.mp418.32MB
21. 03. Windows Installation/05 Configuring MySQL.mp49.64MB
22. 03. Windows Installation/06 Text editor.mp49.53MB
23. 04. First Steps/01 Embedding PHP code on a page.mp48.38MB
24. 04. First Steps/02 Outputting dynamic text.mp49.47MB
25. 04. First Steps/03 The operational trail.mp43.1MB
26. 04. First Steps/04 Inserting code comments.mp46.78MB
27. 05. Exploring Data Types/010 NULL and empty.mp48.82MB
28. 05. Exploring Data Types/011 Type juggling and casting.mp413.76MB
29. 05. Exploring Data Types/012 Constants.mp47.48MB
30. 05. Exploring Data Types/01 Variables.mp411.42MB
31. 05. Exploring Data Types/02 Strings.mp47.54MB
32. 05. Exploring Data Types/03 String functions.mp415.15MB
33. 05. Exploring Data Types/04 Numbers part one - Integers.mp412.02MB
34. 05. Exploring Data Types/05 Numbers part two - Floating points.mp48.76MB
35. 05. Exploring Data Types/06 Arrays.mp416.45MB
36. 05. Exploring Data Types/07 Associative arrays.mp410.7MB
37. 05. Exploring Data Types/08 Array functions.mp414.28MB
38. 05. Exploring Data Types/09 Booleans.mp46.36MB
39. 06. Control Stuctures - Logical Expressions/01 If statements.mp49.61MB
40. 06. Control Stuctures - Logical Expressions/02 Else and elseif statements.mp46.12MB
41. 06. Control Stuctures - Logical Expressions/03 Logical operators.mp411.41MB
42. 06. Control Stuctures - Logical Expressions/04 Switch statements.mp416.79MB
43. 07. Control Structures - Loops/01 While loops.mp412.39MB
44. 07. Control Structures - Loops/02 For loops.mp49.05MB
45. 07. Control Structures - Loops/03 Foreach loops.mp411.82MB
46. 07. Control Structures - Loops/04 Continue.mp412.86MB
47. 07. Control Structures - Loops/05 Break.mp46.43MB
48. 07. Control Structures - Loops/06 Understanding array pointers.mp411.49MB
49. 08. User-Defined Functions/01 Defining functions.mp412.98MB
50. 08. User-Defined Functions/02 Function arguments.mp48.97MB
51. 08. User-Defined Functions/03 Returning values from a function.mp413.08MB
52. 08. User-Defined Functions/04 Multiple return values.mp48.28MB
53. 08. User-Defined Functions/05 Scope and global variables.mp49.49MB
54. 08. User-Defined Functions/06 Setting default argument values.mp48.83MB
55. 09. Debugging/01 Common problems.mp44.67MB
56. 09. Debugging/02 Warnings and errors.mp413.43MB
57. 09. Debugging/03 Debugging and troubleshooting.mp412.27MB
58. 10. Building Web Pages with PHP/01 Links and URLs.mp49.43MB
59. 10. Building Web Pages with PHP/02 Using GET values.mp48.79MB
60. 10. Building Web Pages with PHP/03 Encoding GET values.mp414.72MB
61. 10. Building Web Pages with PHP/04 Encoding for HTML.mp415.72MB
62. 10. Building Web Pages with PHP/05 Including and requiring files.mp412MB
63. 10. Building Web Pages with PHP/06 Modifying headers.mp411.06MB
64. 10. Building Web Pages with PHP/07 Page redirection.mp410.58MB
65. 10. Building Web Pages with PHP/08 Output buffering.mp412.81MB
66. 11. Working with Forms and Data/01 Building forms.mp412.43MB
67. 11. Working with Forms and Data/02 Detecting form submissions.mp412.6MB
68. 11. Working with Forms and Data/03 Single-page form processing.mp416.78MB
69. 11. Working with Forms and Data/04 Validating form values.mp418.4MB
70. 11. Working with Forms and Data/05 Problems with validation logic.mp417.09MB
71. 11. Working with Forms and Data/06 Displaying validation errors.mp413.87MB
72. 11. Working with Forms and Data/07 Custom validation functions.mp413.73MB
73. 11. Working with Forms and Data/08 Single-page form with validations.mp417.6MB
74. 12. Working with Cookies and Sessions/01 Working with cookies.mp43.64MB
75. 12. Working with Cookies and Sessions/02 Setting cookie values.mp49.32MB
76. 12. Working with Cookies and Sessions/03 Reading cookie values.mp410.41MB
77. 12. Working with Cookies and Sessions/04 Unsetting cookie values.mp48.67MB
78. 12. Working with Cookies and Sessions/05 Working with sessions.mp412.07MB
79. 13. MySQL Basics/01 MySQL introduction.mp49.42MB
80. 13. MySQL Basics/02 Creating a database.mp410.96MB
81. 13. MySQL Basics/03 Creating a database table.mp410.2MB
82. 13. MySQL Basics/04 CRUD in MySQL.mp46.99MB
83. 13. MySQL Basics/05 Populating a MySQL database.mp412.17MB
84. 13. MySQL Basics/06 Relational database tables.mp49.04MB
85. 13. MySQL Basics/07 Populating the relational table.mp412.51MB
86. 14. Using PHP to Access MySQL/01 Database APIs in PHP.mp46.87MB
87. 14. Using PHP to Access MySQL/02 Connecting to MySQL with PHP.mp412.52MB
88. 14. Using PHP to Access MySQL/03 Retrieving data from MySQL.mp416.18MB
89. 14. Using PHP to Access MySQL/04 Working with retrieved data.mp410.42MB
90. 14. Using PHP to Access MySQL/05 Creating records with PHP.mp413.2MB
91. 14. Using PHP to Access MySQL/06 Updating and deleting records with PHP.mp418.71MB
92. 14. Using PHP to Access MySQL/07 SQL injection.mp43.93MB
93. 14. Using PHP to Access MySQL/08 Escaping strings for MySQL.mp410.4MB
94. 14. Using PHP to Access MySQL/09 Introducing prepared statements.mp43.5MB
95. 15. Building a Content Management System (CMS)/01 Blueprinting the application.mp410.17MB
96. 15. Building a Content Management System (CMS)/02 Building the CMS database.mp47.82MB
97. 15. Building a Content Management System (CMS)/03 Establishing your work area.mp46.79MB
98. 15. Building a Content Management System (CMS)/04 Creating and styling the first page.mp49.5MB
99. 15. Building a Content Management System (CMS)/05 Making page assets reusable.mp413.06MB
100. 15. Building a Content Management System (CMS)/06 Connecting the application to the database.mp420.85MB
101. 16. Using Site Navigation to Choose Content/01 Adding pages to the navigation subjects.mp412.32MB
102. 16. Using Site Navigation to Choose Content/02 Refactoring the navigation.mp414.21MB
103. 16. Using Site Navigation to Choose Content/03 Selecting pages from the navigation.mp413.44MB
104. 16. Using Site Navigation to Choose Content/04 Highlighting the current page.mp410.95MB
105. 16. Using Site Navigation to Choose Content/05 Moving the navigation to a function.mp422.76MB
106. 17. Application CRUD/01 Finding a subject in the database.mp420.51MB
107. 17. Application CRUD/02 Refactoring the page selection.mp428.16MB
108. 17. Application CRUD/03 Creating a new subject form.mp414.26MB
109. 17. Application CRUD/04 Processing form values and adding subjects.mp427.5MB
110. 17. Application CRUD/05 Passing data in the session.mp417.74MB
111. 17. Application CRUD/06 Validating form values.mp425.61MB
112. 17. Application CRUD/07 Creating an edit subject form.mp419.62MB
113. 17. Application CRUD/08 Using single-page submission.mp425.41MB
114. 17. Application CRUD/09 Deleting a subject.mp424.45MB
115. 17. Application CRUD/10 Cleaning up.mp429.67MB
116. 17. Application CRUD/11 Assignment - Pages CRUD.mp46.48MB
117. 17. Application CRUD/12 Assignment results - Pages CRUD.mp419.36MB
118. 18. Building the Public Area/01 The public appearance.mp423.12MB
119. 18. Building the Public Area/02 Using a context for conditional code.mp426.8MB
120. 18. Building the Public Area/03 Adding a default subject behavior.mp415.26MB
121. 18. Building the Public Area/04 The public content area.mp49.43MB
122. 18. Building the Public Area/05 Protecting page visibility.mp417.49MB
123. 19. Regulating Page Access/01 User authentication overview.mp45.43MB
124. 19. Regulating Page Access/02 Admin CRUD.mp421.26MB
125. 19. Regulating Page Access/03 Encrypting passwords.mp49.86MB
126. 19. Regulating Page Access/04 Salting passwords.mp48MB
127. 19. Regulating Page Access/05 Adding password encryption to CMS.mp425.14MB
128. 19. Regulating Page Access/06 New PHP password functions.mp44.15MB
129. 19. Regulating Page Access/07 Creating a login system.mp426.02MB
130. 19. Regulating Page Access/08 Checking for authorization.mp411.51MB
131. 19. Regulating Page Access/09 Creating a logout page.mp410.29MB
132. Conclusion/01 Next steps.mp43.86MB