PHP and MySQL Live Lessons (2011)
Author: Marc Wandschneider| Published: Oct 2, 2008 | .h264 | .aac | 765.45 MB
Type Video
For every developer who wants to build production-quality applications using PHP and MySQL. In this one-of-a-kind video package, top Web developer and Prentice Hall author Marc Wandschneider shows you exactly how to build reliable, secure, industrial-strength Web applications with PHP and MySQL. You’ll master both PHP and MySQL through 18 comprehensive video lessons, and you’ll have your first PHP/MySQL application running in less than an hour.Author: Marc Wandschneider| Published: Oct 2, 2008 | .h264 | .aac | 765.45 MB
Type Video
Lesson 1
PHP and MySQL LiveLessons: Installing PHP
In this lesson you learn to install Apache, MySQL, and PHP software, and make sure they are configured properly. Installation is covered on Windows and Mac OS X.
Duration: 00:35:31 File Size: 74MB
Lesson 2
PHP and MySQL LiveLessons: Your First Web Application
In this lesson you learn to build your first web application in PHP. Along the way, you learn techniques for entering your PHP scripts and some basics about data types and variables. You also begin building the calculator application that you will enhance in later lessons.
Duration: 00:30:25 File Size: 32MB
Lesson 3
PHP and MySQL LiveLessons: Language Basics
In this lesson you explore additional variables and data types, variable expansion used to generate HTML, arithmetic operators, and type conversions. You begin enhancing the simple calculator application.
Duration: 00:34:22 File Size: 39MB
Lesson 4
PHP and MySQL LiveLessons: More PHP Language Features
In this lesson you learn about script lifetime in PHP, how to use constants to enhance code readability, the logical and comparison operators, and the switch statement. You then learn to add these features to the calculator application.
Duration: 00:25:26 File Size: 32MB
Lesson 5
PHP and MySQL LiveLessons: Functions and Loops
In this lesson you learn to program PHP functions, use loops, pass parameters to functions, declare variables within functions, and finally how to add functions to the calculator application.
Duration: 00:27:10 File Size: 29MB
Lesson 6
PHP and MySQL LiveLessons: Text and Strings
In this lesson you learn about strings in PHP. You learn about string operators and built in functions for manipulating strings. You then learn to write your own string manipulation functions to enhance the calculator application.
Duration: 00:28:56 File Size: 38MB
Lesson 7
PHP and MySQL LiveLessons: Arrays
In this lesson you explore techniques for iterating over array elements, functions for manipulating arrays, ways to optimize the organization of your PHP code, and how to apply these techniques to a photo sharing application which you will enhance in later lessons.
Duration: 00:31:28 File Size: 40MB
Lesson 8
PHP and MySQL LiveLessons: Object Oriented Programming I
In this lesson you learn about using Object Oriented Programming (OOP) techniques to create new classes with variables and functions. You then learn to add constructors to classes to make them easier to use, and ways to control access to class variables and functions. You use these techniques to update the photo sharing application.
Duration: 00:25:50 File Size: 34MB
Lesson 9
PHP and MySQL LiveLessons: Object Oriented Programming II
In this lesson you learn more advanced OOP techniques. You learn about inheritance and class hierarchies, overriding classes and functions, and how to apply these techniques to improve the photo sharing application.
Duration: 00:20:07 File Size: 29MB
Lesson 10
PHP and MySQL LiveLessons: Object Oriented Programming III
In this lesson you learn to make classes flexible and reusable. You learn how to add constants and static methods to a class, ways to improve error handling with exception handling, and finally how to apply these techniques to make the photo sharing application more robust.
Duration: 00:28:41 File Size: 39MB
Lesson 11
PHP and MySQL LiveLessons: Learning More About the Web Server
In this lesson you learn more about the element used in HTML pages, new elements to put on forms and how to process them on the server, information that PHP and the web server provide to your scripts, and how to apply these to improve the forms and processing in the photo sharing application.
[/b]Duration: 00:25:52 File Size: 37MB[/b]
Lesson 12
PHP and MySQL LiveLessons: Designing and Creating your
In this lesson you learn to create a MySQL database, You lean about MySQL data types and how to insert data into a database, including how this is done form within a PHP script. You then modify the create new user page in the photo sharing application so that new users are added to a database.
Duration: 00:27:56 File Size: 40MB
Lesson 13
PHP and MySQL LiveLessons: Fetching Data from the Database
In this lesson you learn to use SQL to retrieve data from tables. You begin with the SELECT statement and the WHERE clause to retrieve, filter and refine returned data. You then learn how to sort and limit returned data, and then how to load users from the photo sharing application database.
Duration: 00:30:07 File Size: 48MB
Lesson 14
PHP and MySQL LiveLessons: Modifying Data in the Database
In this lesson you learn to update and delete rows from tables. You then learn to use a FULLTEXT index, how to spread data over multiple tables and use the JOIN statement to retrieve data, and finally how to use SQL transactions to update multiple tables. You use these features to add a user bio feature to the photo sharing application.
Duration: 00:29:21 File Size: 49MB
Lesson 15
PHP and MySQL LiveLessons: Remembering Things: Cookies and Sessions
In this lesson you learn to modify your PHP application to use HTTP cookies. You also learn about sessions, and more about the MySQL FULLTEXT search index. These features allow you to add a search capability to the photo sharing application.
Duration: 00:30:08 File Size: 42MB
Lesson 16
PHP and MySQL LiveLessons: Files and File Uploads
In this lesson you learn to modify the photo sharing web application to enable users to upload files. You then look at the functions in PHP that enable you to work with files and directories.
Duration: 00:31:53 File Size: 46MB
Lesson 17
PHP and MySQL LiveLessons: Formatted Output, Output Buffering and Security
In this lesson you learn about functions that allow you to output numbers, dates, and currencies. Then you explore output buffering and security, and learn to do a security audit of the photo sharing application.
Duration: 00:30:40 File Size: 39MB
Lesson 18
PHP and MySQL LiveLessons: When Things Go Wrong
In this lesson you learn about error handling, including ways to report errors that wont confuse end users. You learn to replace PHPs default error handling mechanism, and also how to use the Xdebug tool to monitor your web applications.
Duration: 00:26:56 File Size: 41MB
http://www.wupload.com/file/82593234
http://www.wupload.com/file/82593122
http://www.wupload.com/file/82593285
http://www.wupload.com/file/82593180
