Lynda.com - PHP with MySQL Essential Training.zip

PHP with MySQL Essential Training with Kevin Skoglund (Size: 2.03 GB)

01- Introduction
01- Welcome.mp4 8.17 MB
02- Using the exercise files.mp4 5 MB

02- PHP Overview
03- What is PHP.mp4 4.39 MB
04- The history of PHP.mp4 3.49 MB
05- Why choose PHP.mp4 9.31 MB
06- Installation overview.mp4 4.51 MB

03- Mac Installation
007- Overview.mp4 2.96 MB
008- Working with Apache Web Server.mp4 10.98 MB
009- Changing the document root.mp4 13.24 MB
010- Enabling PHP.mp4 14.83 MB
011- Upgrading.mp4 14.61 MB
012- Configuring PHP.mp4 41.26 MB
013- Installing MySQL.mp4 15.76 MB
014- Configuring MySQL.mp4 13.87 MB
015- Text editor.mp4 9.35 MB

04- Windows Installation
016- Overview.mp4 4.49 MB
017- Installing WampServer.mp4 14.35 MB
018- Finding the document root.mp4 4.86 MB
019- Configuring PHP.mp4 26.29 MB
020- Configuring MySQL.mp4 11.35 MB
021- Text editor.mp4 10.39 MB

05- First Steps
022- Embedding PHP code on a page.mp4 7.95 MB
023- Outputting dynamic text.mp4 11.04 MB
024- The operational trail.mp4 3.48 MB
025- Inserting code comments.mp4 9.57 MB

06- Exploring Data Types
026- Variables.mp4 12.43 MB
027- Strings.mp4 9.84 MB
028- String functions.mp4 22.59 MB
029- Numbers part one Integers.mp4 17.11 MB
030- Numbers part two Floating points.mp4 11.76 MB
031- Arrays.mp4 21.25 MB
032- Associative arrays.mp4 13.65 MB
033- Array functions.mp4 20.13 MB
034- Booleans.mp4 7.98 MB
035- NULL and empty.mp4 11.97 MB
036- Type juggling and casting.mp4 18.7 MB
037- Constants.mp4 9.55 MB

07- Control Structures - Logical Expressions
038- If statements.mp4 11.5 MB
039- Else and elseif statements.mp4 7.23 MB
040- Logical operators.mp4 13.4 MB
041- Switch statements.mp4 21.77 MB

08- Control Structures - Loops
042- While loops.mp4 14.58 MB
043- For loops.mp4 11.14 MB
044- Foreach loops.mp4 13.93 MB
045- Continue.mp4 16.27 MB
046- Break.mp4 7.68 MB
047- Understanding array pointers.mp4 14.5 MB

09- User-Defined Functions
048- Defining functions.mp4 15.55 MB
049- Function arguments.mp4 11.17 MB
050- Returning values from a function.mp4 17.33 MB
051- Multiple return values.mp4 10.91 MB
052- Scope and global variables.mp4 12.07 MB
053- Setting default argument values.mp4 11.72 MB

10- Debugging
054- Common problems.mp4 4.75 MB
055- Warnings and errors.mp4 15.4 MB
056- Debugging and troubleshooting.mp4 14.05 MB

11- Building Web Pages with PHP
057- Links and URLs.mp4 11.1 MB
058- Using GET values.mp4 10.16 MB
059- Encoding GET values.mp4 17.9 MB
060- Encoding for HTML.mp4 19.54 MB
061- Including and requiring files.mp4 12.93 MB
062- Modifying headers.mp4 13.25 MB
063- Page redirection.mp4 12.73 MB
064- Output buffering.mp4 15.52 MB

12- Working with Forms and Form Data
065- Building forms.mp4 15.82 MB
066- Detecting form submissions.mp4 16.77 MB
067- Single-page form processing.mp4 22.05 MB
068- Validating form values.mp4 23.58 MB
069- Problems with validation logic.mp4 19.66 MB
070- Displaying validation errors.mp4 17.85 MB
071- Custom validation functions.mp4 17.6 MB
072- Single-page form with validations.mp4 24.01 MB

13- Working with Cookies and Sessions
073- Working with cookies.mp4 3.45 MB
074- Setting cookie values.mp4 11.86 MB
075- Reading cookie values.mp4 14.01 MB
076- Unsetting cookie values.mp4 10.49 MB
077- Working with sessions.mp4 14.37 MB

14- MySQL Basics
078- MySQL introduction.mp4 10.06 MB
079- Creating a database.mp4 12.61 MB
080- Creating a database table.mp4 10.97 MB
081- CRUD in MySQL.mp4 6.72 MB
082- Populating a MySQL database.mp4 16.31 MB
083- Relational database tables.mp4 10.39 MB
084- Populating the relational table.mp4 18.84 MB

15- Using PHP to Access MySQL
085- Database APIs in PHP.mp4 8.05 MB
086- Connecting to MySQL with PHP.mp4 16.47 MB
087- Retrieving data from MySQL.mp4 21.88 MB
088- Working with retrieved data.mp4 13.15 MB
089- Creating records with PHP.mp4 17.77 MB
090- Updating and deleting records with PHP.mp4 25.44 MB
091- SQL injection.mp4 3.95 MB
092- Escaping strings for MySQL.mp4 14.12 MB
093- Introducing prepared statements.mp4 3.92 MB

16- Building a Content Management System (CMS)
094- Blueprinting the application.mp4 11.05 MB
095- Building the CMS database.mp4 8.67 MB
096- Establishing your work area.mp4 7.31 MB
097- Creating and styling the first page.mp4 12.27 MB
098- Making page assets reusable.mp4 15.68 MB
099- Connecting the application to the database.mp4 26.49 MB

17- Using Site Navigation to Choose Content
100- Adding pages to the navigation subjects.mp4 17.36 MB
101- Refactoring the navigation.mp4 19.83 MB
102- Selecting pages from the navigation.mp4 17.87 MB
103- Highlighting the current page.mp4 15.45 MB
104- Moving the navigation to a function.mp4 34.39 MB

18- Application CRUD
105- Finding a subject in the database.mp4 31.61 MB
106- Refactoring the page selection.mp4 40.71 MB
107- Creating a new subject form.mp4 21.18 MB
108- Processing form values and adding subjects.mp4 38.31 MB
109- Passing data in the session.mp4 24.74 MB
110- Validating form values.mp4 35.42 MB
111- Creating an edit subject form.mp4 28.3 MB
112- Using single-page submission.mp4 33.32 MB
113- Deleting a subject.mp4 34.27 MB
114- Cleaning up.mp4 41.13 MB
115- Assignment Pages CRUD.mp4 7.03 MB
116- Assignment results Pages CRUD.mp4 29.42 MB

19- Building the Public Area
117- The public appearance.mp4 32.16 MB
118- Using a context for conditional code.mp4 35.49 MB
119- Adding a default subject behavior.mp4 21.16 MB
120- The public content area.mp4 11.47 MB
121- Protecting page visibility.mp4 24.26 MB

20- Regulating Page Access
122- User authentication overview.mp4 5.66 MB
123- Admin CRUD.mp4 27.58 MB
124- Encrypting passwords.mp4 11.56 MB
125- Salting passwords.mp4 8.49 MB
126- Adding password encryption to CMS.mp4 35.78 MB
127- New PHP password functions.mp4 4.15 MB
128- Creating a login system.mp4 36.98 MB
129- Checking for authorization.mp4 17.51 MB
130- Creating a logout page.mp4 12.7 MB

21- Conclusion
131- Next steps.mp4 5.25 MB