Lynda com PHP with MySQL Collection courses | 17E4ADBA8658BF635DC6F14BCB81BF618728E147

Lynda com PHP with MySQL Collection courses

Name	Lynda.com - PHP with MySQL Collection (5 courses)	DOWNLOAD Copy Link
Total Size	3.2 GB
Total Files	376
Hash	17E4ADBA8658BF635DC6F14BCB81BF618728E147

/0 - Introduction/
0-1 Welcome.mp4	17.0 MB
0-2 What you should know before watching this course.mp4	4.2 MB
0-4 Understanding the differences between Dreamweaver CS5.5 and CS6.mp4	4.1 MB
0-3 Using the exercise file.mp4	4.1 MB
/.../1 - Understanding Browsers, Servers and Databases/
1-3 Introducing Apache, MySQL and PHP.mp4	10.8 MB
1-2 Selecting application and database servers.mp4	9.0 MB
1-1 Understanding static vs. dynamic web pages.mp4	7.4 MB
1-4 Installing Apache, MySQL, and PHP.mp4	7.0 MB
/.../2 - Getting Started with Dreamweaver and PHP/
2-3 Creating and testing a PHP-based web page.mp4	27.9 MB
2-7 Using server-side includes.mp4	25.2 MB
2-2 Configuring a PHP testing server.mp4	24.5 MB
2-5 Setting and outputting simple variables.mp4	10.4 MB
2-1 Defining a Dreamweaver site.mp4	10.3 MB
2-8 Navigating included pages with the Code Navigator.mp4	8.7 MB
2-4 Adding PHP commands with the Insert panel.mp4	8.4 MB
2-6 Testing pages with Live view and Live Code view.mp4	5.8 MB
/.../3 - Managing PHP Code/
3-6 Using Zend Framework classes with code hints.mp4	19.4 MB
3-2 Understanding PHP custom classes.mp4	17.9 MB
3-3 Adding Zend Framework to PHP on Windows.mp4	16.0 MB
3-1 Using code hinting with PHP variable.mp4	14.2 MB
3-4 Adding Zend Framework to PHP on Mac.mp4	10.9 MB
3-7 Managing reusable code with the Snippets panel.mp4	10.6 MB
3-5 Using the Site-Specific Code Hints feature.mp4	9.1 MB
/4 - Creating a Database/
4-4 Importing a completed database from a script.mp4	13.6 MB
4-2 Creating a MySQL database in phpMyAdmin.mp4	9.1 MB
4-1 Understanding relational databases.mp4	7.9 MB
4-3 Adding data in phpMyAdmin.mp4	5.9 MB
/.../5 - Using Bindings and Server Behaviors/
5-4 Displaying data with repeating regions.mp4	21.6 MB
5-8 Limiting records with paging controls.mp4	14.7 MB
5-1 Defining a Dreamweaver database connection.mp4	14.7 MB
5-6 Formatting dynamic data.mp4	14.7 MB
5-5 Displaying data in a dynamic table.mp4	14.5 MB
5-3 Building an advanced recordset.mp4	14.5 MB
5-2 Building a simple recordset.mp4	12.0 MB
5-9 Creating conditional regions.mp4	10.2 MB
5-7 Displaying the total number of records.mp4	6.7 MB
/.../6 - Building Data Entry Forms/
6-6 Working with multiple checkbox controls.mp4	22.5 MB
6-7 Sending email with Zend_Mail.mp4	21.7 MB
6-4 Validating form controls with Spry.mp4	19.5 MB
6-5 Populating a list control with dynamic data.mp4	14.0 MB
6-2 Handling form submissions with PHP.mp4	13.5 MB
6-1 Building a simple data entry form.mp4	12.9 MB
6-3 Creating a customer email form.mp4	9.8 MB
/.../7 - Managing Server-Side Data/
7-8 Creating list page links to edit and update data.mp4	22.4 MB
7-6 Preparing an update form.mp4	19.1 MB
7-9 Using the Delete Record server behavior.mp4	16.5 MB
7-1 Using data wizards.mp4	16.4 MB
7-7 Using the Update Form behavior.mp4	15.9 MB
7-5 Using the Insert Record server behavior.mp4	14.8 MB
7-2 Formatting dates for SQL.mp4	14.5 MB
7-3 Creating a custom data entry form.mp4	11.7 MB
7-4 Preparing a database table for server behaviors.mp4	8.3 MB
/.../8 - Authenticating Users with PHP/
8-1 Creating a login form with a PHP server behavior.mp4	15.5 MB
8-2 Protecting page access with PHP server behaviors.mp4	12.0 MB
8-3 Logging out with a PHP server behavior.mp4	11.5 MB
/.../9 - Deploying a Dynamic Site to a Remote Server/
9-5 Configuring the site for the remote database.mp4	17.2 MB
9-2 Synchronizing site assets with the remote server.mp4	14.7 MB
9-1 Configuring a remote server with FTP credentials.mp4	10.8 MB
9-3 Exporting the MySQL database to a script.mp4	7.2 MB
9-4 Importing the MySQL database on a remote server.mp4	6.1 MB
/Conclusion/
Final thoughts.mp4	2.0 MB
/Dreamweaver with PHP and MySQL/
Exercises.rar	307.0 MB
/MySQL Essentials/1 - Introducing MySQL/
1-1 Welcome.mov	16.2 MB
1-3 Important Terminology.mov	3.3 MB
1-4 Using the exercise files.mov	2.0 MB
1-2 What is MySQL.mov	611.0 KB
/.../2 - Installing the Test Environment/
2-2 Installing XAMPP on Windows.mov	8.3 MB
2-3 Installing XAMPP on a Mac.mov	7.6 MB
2-1 Installation overview.mov	6.5 MB
/MySQL Essentials/3 - Configuring MySQL/
3-5 Importing databases on Windows.mov	7.3 MB
3-4 Setting up regular users.mov	6.9 MB
3-6 Importing databases on a Mac.mov	5.6 MB
3-1 Using the MySQL Command Line Interface on Windows.mov	5.5 MB
3-3 Setting up the root server.mov	3.8 MB
3-2 Using the MySQL Command Line Interface on a Mac.mov	915.2 KB
/.../4 - Using the SQL Interactive Demonstrator (SID)/
4-2 Installing SID on Windows.mov	4.5 MB
4-3 Installing SID on a Mac.mov	3.6 MB
4-1 Using SID.mov	991.3 KB
/MySQL Essentials/5 - Creating a Database/
5-2 Creating a table.mov	2.8 MB
5-1 Creating a database.mov	1.1 MB
/.../6 - MySQL Data Types/
6-8 Enumeratino types.mov	5.7 MB
6-2 Numeric types.mov	3.9 MB
6-6 Bit type.mov	2.6 MB
6-5 date and time types.mov	2.0 MB
6-3 String types.mov	1.3 MB
6-7 Boolean values.mov	961.8 KB
6-4 Large storage types.mov	861.2 KB
6-1 What are data types.mov	657.5 KB
/MySQL Essentials/7 - MySQL Functions/
7-2 String functions.mov	9.6 MB
7-3 Numeric functions.mov	8.8 MB
7-7 Installing time zone support in MySQL on a Mac.mov	8.5 MB
7-6 Installing time zone support in MySQL in Windows.mov	7.6 MB
7-9 Full-text speech.mov	7.0 MB
7-8 Aggregate functions.mov	5.0 MB
7-5 Time zones in MySQL.mov	4.4 MB
7-4 date and time functions.mov	2.9 MB
7-1 MySQL functions.mov	1.2 MB
/.../8 - PHP's MySQLi Interface/
8-3 Connecting to the database.mov	7.1 MB
8-2 Introducing CRUD.mov	5.7 MB
8-4 Prepared statements.mov	3.8 MB
8-5 Fetching results.mov	3.8 MB
8-6 Auto-increment IDs.mov	1.5 MB
8-1 PHP programming interfaces.mov	761.3 KB
/.../9 - PHP's PDO Interface with MySQL/
9-4 Fetching results.mov	4.1 MB
9-2 Connecting to the database.mov	3.7 MB
9-5 Auto-increment IDs.mov	1.7 MB
9-3 Prepared statements.mov	1.6 MB
9-1 PDO is multi-platform.mov	1.5 MB
/MySQL Essentials/Conclusion/
Goodbye.mov	1.4 MB
/MySQL Essentials/Exercise Files/CRUD/assets/
main.php	1.5 KB
bw.ico	1.1 KB
header.php	0.5 KB
index.html	0.3 KB
footer.php	0.2 KB
plain.php	0.2 KB
/MySQL Essentials/Exercise Files/CRUD/css/
main.css	3.3 KB
index.html	0.3 KB
/MySQL Essentials/Exercise Files/CRUD/
crud.php	24.2 KB
crud-mysqli.php	23.8 KB
/MySQL Essentials/Exercise Files/SID/assets/
bw.ico	1.1 KB
main.php	0.7 KB
header.php	0.5 KB
index.html	0.3 KB
footer.php	0.2 KB
/MySQL Essentials/Exercise Files/SID/css/
main.css	2.9 KB
index.html	0.3 KB
/MySQL Essentials/Exercise Files/SID/
sid.php	8.2 KB
/MySQL Essentials/Exercise Files/SQL/
world-mysql.sql	395.3 KB
album-mysql.sql	9.8 KB
test-mysql.sql	2.5 KB
/0 - Introduction/
0-1 Welcome.mp4	4.9 MB
0-2 Using the exercise files.mp4	3.5 MB
0-3 Understanding what you should know.mp4	991.1 KB
/.../1 - Introduction to Object-Oriented Programming/
1-3 Why should you use object-oriented programming.mp4	3.0 MB
1-2 What is a class.mp4	1.8 MB
1-1 What is an object.mp4	1.8 MB
1-4 The history of object-oriented PHP.mp4	1.5 MB
/.../2 - Creating Your First Object/
2-5 Specifying the visibility scope.mp4	8.5 MB
2-3 Creating a method and exploring object context with $this.mp4	7.5 MB
2-2 Defining class properties.mp4	7.4 MB
2-4 Instantiating an object and accessing its contents.mp4	7.3 MB
2-1 Defining a class.mp4	4.9 MB
/.../3 - Overloading with Magic Methods/
3-2 Overloading property access.mp4	18.8 MB
3-3 Customizing object construction.mp4	13.5 MB
3-4 Standardizing object rendering as a string.mp4	5.1 MB
3-1 What is a magic method, and do I need one.mp4	3.0 MB
/.../4 - Accessing Classes without Instantiation/
4-5 Creating a database class.mp4	24.1 MB
4-4 Avoiding static method pitfalls.mp4	19.4 MB
4-1 Using the static keyword.mp4	6.2 MB
4-3 Setting constant values.mp4	5.2 MB
4-2 Leveraging scope resolution operators.mp4	2.1 MB
/.../5 - Class Relationships and Interactions/
5-2 Abstracting classes.mp4	15.3 MB
5-1 Extending your class.mp4	13.0 MB
5-3 Sharing interfaces using polymorphism.mp4	10.8 MB
5-4 Overriding methods, properties, and constants.mp4	9.2 MB
5-6 Referencing objects.mp4	9.0 MB
5-5 Cloning and comparing objects.mp4	9.0 MB
/.../6 - Built-In PHP Objects/
6-2 Retrieving objects from the database.mp4	19.9 MB
6-4 Customizing PHP exceptions.mp4	14.3 MB
6-1 Leveraging standard class objects.mp4	5.9 MB
6-3 Error handling with exceptions.mp4	4.3 MB
/7 - Design Patterns/
7-3 Implementing a strategy pattern.mp4	14.2 MB
7-2 Using the factory method pattern.mp4	7.3 MB
7-1 Identifying the singleton pattern.mp4	4.0 MB
/8 - Conclusion/
8-3 Goodbye.mp4	2.4 MB
8-2 Next steps.mp4	1.8 MB
8-1 Looking forward to namespaces.mp4	1.0 MB
/Object-Oriented Programming with PHP/
Exercise Files.rar	226.8 KB
/0 - Introduction/
0-1 Welcome.mov	18.0 MB
0-2 Using the exercise files.mov	2.5 MB
/.../1 - Installation and Project Setup/
1-2 Project setup.mov	3.6 MB
1-1 PHP and MySQL installation.mov	1.3 MB
/.../10 - The Photograph Class/
10-7 Deleting photographs.mov	11.6 MB
10-6 Storing messages in the Session class.mov	9.1 MB
10-3 Saving photographs.mov	9.0 MB
10-1 Starting the Photograph class.mov	8.7 MB
10-2 Coding the Photograph class.mov	8.7 MB
10-5 Listing photographs.mov	8.6 MB
10-4 Uploading photographs.mov	8.4 MB
10-8 Displaying photographs in the public area.mov	6.3 MB
/.../11 - The Comment Class/
11-3 Listing comments.mov	12.7 MB
11-2 Building the comment form.mov	10.0 MB
11-4 Reviewing comments in the staff area.mov	9.7 MB
11-1 Creating the Comment class.mov	9.7 MB
/12 - Pagination/
12-3 Finding the pagination variables.mov	9.2 MB
12-6 Using pagination links.mov	7.0 MB
12-4 Using the Pagination class.mov	5.2 MB
12-5 Paginating photographs.mov	4.4 MB
12-1 Understanding the concepts behind pagination.mov	2.8 MB
12-2 Using LIMIT, OFFSET, and COUNT.mov	2.2 MB
/.../13 - Sending Emails/
13-5 Using PHPMailer.mov	13.0 MB
13-6 Building notification for new comments.mov	12.2 MB
13-3 Using headers.mov	7.6 MB
13-2 Sending email with mail.mov	6.0 MB
13-1 Configuring PHP for email.mov	5.4 MB
13-4 Reviewing SMTP.mov	2.5 MB
/.../14 - Templating and Code Organization/
14-2 Simple templating.mov	11.0 MB
14-1 Using MVC architecture.mov	6.2 MB
14-3 Using the Smarty PHP templating engine.mov	3.2 MB
14-4 Building PHP libraries and frameworks.mov	2.1 MB
/15 - Conclusion/
15-1 Goodbye.mov	1.3 MB
/.../16 - Appendix - PHP Installation and Configuration Assistance/
16-1 Installing on Mac 10.4 (Tiger).mov	14.2 MB
16-9 MySQL basics phpMyAdmin.mov	12.0 MB
16-3 Configuring a Mac.mov	10.5 MB
16-2 Installing on Mac 10.5 (Leopard).mov	10.2 MB
16-7 Configuring on Windows.mov	8.0 MB
16-6 Installing on Windows.mov	6.4 MB
16-8 The text editor on Windows.mov	5.0 MB
16-4 The text editor on Mac.mov	3.8 MB
16-5 phpMyAdmin installation on Mac.mov	2.3 MB
/.../2 - Intermediate PHP Techniques/
2-4 Formatting dates and times - Strings and SQL.mov	9.4 MB
2-3 Building dates and times - Epoch Unix.mov	7.2 MB
2-9 Using references as function return values.mov	5.9 MB
2-2 Applying more array functions.mov	5.6 MB
2-6 Establishing global and static variable scope.mov	5.3 MB
2-5 Setting server and request variables.mov	5.2 MB
2-1 Using variable variables.mov	4.9 MB
2-8 Using references as function arguments.mov	3.7 MB
2-7 Making a reference assignment.mov	2.8 MB
/.../3 - Introduction to Object-Oriented Programming (OOP)/
3-6 Defining class properties.mov	7.9 MB
3-4 Instantiating a class.mov	5.0 MB
3-1 Introducing the concept and basics of OOP.mov	4.4 MB
3-2 Defining classes.mov	3.9 MB
3-5 Referencing an instance.mov	3.7 MB
3-3 Defining class methods.mov	3.5 MB
/.../4 - OOP in Practice/
4-2 Setting access modifiers.mov	7.5 MB
4-4 Working with the static modifier.mov	7.3 MB
4-1 Understanding class inheritance.mov	5.9 MB
4-6 Referencing the Parent class.mov	5.8 MB
4-7 Using constructors and destructors.mov	5.1 MB
4-9 Comparing objects.mov	4.3 MB
4-3 Using setters and getters.mov	3.5 MB
4-8 Cloning objects.mov	3.2 MB
4-5 Reviewing the scope resolution operator.mov	2.5 MB
/.../5 - Photo Gallery Project Setup/
5-2 Creating project and asset directories.mov	5.7 MB
5-3 Creating a MySQL database.mov	4.7 MB
5-1 Overview of the project.mov	2.1 MB
/.../6 - Foundations of an OOP Project/
6-13 Late static binding.mov	16.0 MB
6-10 Logging in using the Session class.mov	13.1 MB
6-6 Instantiating user objects.mov	11.1 MB
6-11 Initializing files and path constants.mov	8.4 MB
6-5 Creating a User class.mov	7.7 MB
6-4 How OOP is an improvement.mov	7.2 MB
6-1 Creating the MySQL Database class.mov	7.1 MB
6-9 Creating the Session class.mov	6.8 MB
6-3 Using the database object.mov	6.7 MB
6-12 Using path content for layout.mov	6.2 MB
6-8 Autoload - The undeclared object safety net.mov	4.8 MB
6-7 Revising find methods to instantiate.mov	4.5 MB
6-2 Adding queries to the MySQL Database class.mov	4.2 MB
/.../7 - Working with Files and Directories/
7-4 PHP permissions.mov	11.6 MB
7-5 Accessing files.mov	8.2 MB
7-11 Working with directories.mov	7.8 MB
7-10 Examining file details.mov	7.5 MB
7-9 Reading files.mov	7.5 MB
7-14 Creating a log file Solution.mov	7.4 MB
7-2 Understanding file permissions.mov	6.7 MB
7-12 Viewing directory content.mov	6.6 MB
7-3 Setting file permissions.mov	5.5 MB
7-1 File system basics.mov	5.4 MB
7-6 Writing to files.mov	5.4 MB
7-13 Creating a log file Assignment.mov	4.2 MB
7-8 Moving the file pointer.mov	3.5 MB
7-7 Deleting files.mov	1.8 MB
/8 - Uploading Files/
8-5 Moving uploaded files.mov	6.0 MB
8-2 Sending files as form data.mov	5.7 MB
8-1 Configuring PHP for file uploads.mov	5.0 MB
8-4 Uploading errors.mov	3.8 MB
8-3 Inspecting uploaded files.mov	3.5 MB
/.../9 - Completing the User Class/
9-6 Abstracting the attributes.mov	9.5 MB
9-3 Updating users.mov	7.9 MB
9-5 Abstracting the database table name.mov	7.6 MB
9-2 Creating users.mov	6.0 MB
9-4 Deleting users.mov	4.8 MB
9-7 Finding the database attributes.mov	3.9 MB
9-1 Remaining user CRUD.mov	2.1 MB
/PHP with MySQL - Beyond the Basics/
Exercise Files.rar	32.3 MB
/0 - Introduction/
0-2 Using the exercise files.mov	4.2 MB
0-1 Introduction.mov	1.9 MB
/1 - PHP Overview/
1-3 Why choose PHP.mov	7.4 MB
1-4 Installation overview.mov	3.3 MB
1-2 History.mov	2.9 MB
1-1 What is PHP.mov	2.1 MB
/.../10 - Building Web Pages/
10-8 Headers and page redirection.mov	13.6 MB
10-6 Setting cookies.mov	12.3 MB
10-4 Encoding for HTMLs.mov	10.6 MB
10-7 Establishing session.mov	9.3 MB
10-9 Including and requiring page.mov	8.4 MB
10-3 Encoding GET values.mov	7.6 MB
10-5 Building forms.mov	7.6 MB
10-2 Using GET values.mov	6.2 MB
10-1 Links and URLs.mov	4.9 MB
/.../11 - MySQL Basics/
11-4 phpMyAdmin.mov	16.8 MB
11-3 Populating a MySQL database.mov	8.7 MB
11-6 Accessing data in MySQL with PHP.mov	8.4 MB
11-5 Connecting to MySQL with PHP.mov	6.8 MB
11-2 Creating a database in MySQL.mov	5.7 MB
11-1 MySQL introduction.mov	3.4 MB
/.../12 - Building a Content Management System/
12-9 Refactoring the navigation.mov	16.8 MB
12-7 Connecting your site to a database.mov	16.1 MB
12-8 Building dynamic navigation.mov	14.1 MB
12-6 Making page assets reusable.mov	14.1 MB
12-5 Creating your first page.mov	13.2 MB
12-2 Building the CMS database.mov	11.0 MB
12-1 Blueprinting your application.mov	7.8 MB
12-10 Adding links to your navigation.mov	7.1 MB
12-11 Determining which page is selected.mov	7.0 MB
12-12 Displaying HTML based on the selection.mov	6.4 MB
12-4 Establishing your work area.mov	6.3 MB
12-3 Understanding relational databases.mov	6.2 MB
/.../13 - Application CRUD/
13-3 Creating a page for a new subject.mov	25.0 MB
13-15 CRUD assignment results.mov	18.4 MB
13-1 Finding a subject in the database.mov	17.3 MB
13-13 Deleting a subject.mov	16.0 MB
13-6 Escaping values for MySQL.mov	14.5 MB
13-11 Updating a subject in the database.mov	13.0 MB
13-5 Adding subjects.mov	11.5 MB
13-12 Sending form results as messages.mov	10.4 MB
13-10 Using single-page submission.mov	10.1 MB
13-7 Form validation.mov	10.0 MB
13-14 CRUD review and assignment.mov	9.2 MB
13-4 Creating a subject entry form.mov	9.2 MB
13-9 Editing a subject.mov	8.6 MB
13-2 Finding a page in the database.mov	8.1 MB
13-8 Additional form validation.mov	4.1 MB
/.../14 - Building the Public Area/
14-2 Navigation in the public context.mov	11.5 MB
14-3 Functions in the public context.mov	10.3 MB
14-4 Creating a default subject behavior.mov	10.3 MB
14-5 Text encoding and transforming.mov	9.3 MB
14-1 The public appearance.mov	3.8 MB
/.../15 - Regulating Page Access/
15-6 Creating a logout page.mov	12.2 MB
15-2 Encryption.mov	12.0 MB
15-4 Checking authorization.mov	10.5 MB
15-5 Using sessions to maintain login status.mov	8.7 MB
15-3 Creating a login system.mov	7.2 MB
15-1 User access overview.mov	2.1 MB
/2 - Mac Installation/
02_01_macinstall.mov	21.1 MB
02_02_macconfig.mov	18.6 MB
02_03_mactexteditor.mov	5.8 MB
02_04_phpmyadmin.mov	4.1 MB
/3 - Windows Installation/
3-2 Configuring.mov	13.2 MB
3-1 Installing.mov	8.1 MB
3-3 The text editor.mov	6.6 MB
/4 - First Steps/
4-1 Viewing PHP configuration information.mov	11.0 MB
4-2 Embedding PHP.mov	6.1 MB
4-3 Hello World.mov	5.2 MB
4-5 Inserting comments.mov	4.2 MB
4-4 The operational trail.mov	1.3 MB
/.../5 - Exploring Data Types/
5-6 Arrays.mov	11.9 MB
5-8 Booleans and NULL.mov	10.1 MB
5-1 Variables.mov	9.4 MB
5-3 String fluctuations.mov	8.1 MB
5-9 Type switching and casting.mov	8.1 MB
5-7 Array functions.mov	6.3 MB
5-2 Strings.mov	6.0 MB
5-4 Numbers Part 1 - Integers.mov	5.8 MB
5-5 Numbers Part 2 - Floating Points.mov	4.8 MB
5-10 Constants.mov	4.1 MB
/.../6 - Control Structures Pt. 1 Logical Expressions/
6-3 Logical operators.mov	7.0 MB
6-1 If statements.mov	5.5 MB
6-4 Switch statements.mov	4.3 MB
6-2 Else and elseif statements.mov	2.5 MB
/.../7 - Control Structures Pt. 2 Loops/
7-1 While loops.mov	7.1 MB
7-3 Foreach loops.mov	7.1 MB
7-6 Understanding array pointers.mov	6.3 MB
7-2 For loops.mov	4.3 MB
7-4 Continue.mov	4.0 MB
7-5 Break.mov	3.3 MB
/.../8 - User-Defined Functions/
8-1 Defining functions.mov	11.0 MB
8-3 Returning values from a function.mov	9.2 MB
8-2 Using functions.mov	8.3 MB
8-5 Setting default variables.mov	8.1 MB
8-4 Setting global variables.mov	7.8 MB
/9 - Debugging/
9-1 Debugging and troubleshooting.mov	6.2 MB
/Conclusion/
Goodbye.mov	2.3 MB
/PHP with MySQL - Essential Training/
Exercise Files.rar	784.5 KB
Total files 376