Lynda PHP with MySQL Essential Training از جدید ترین دوره های آموزشی ویدیویی برنامه نویسی لیندا می باشد.در این دوره آموزشی ویدیویی پروژه محور مدرس به آموزش فوری کار با زبان PHP و پایگاه داده MySQL می پردازد. Lynda.com PHP with MySQL Beyond the Basics Introduction Welcome Using the exercise files Installation and Project Setup PHP and MySQL installation Project setup Intermedi. Lynda.com AJAX Essential Training.

PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces.

Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code. Lynda – PHP with MySQL Essential Training 2013 Lynda – PHP with MySQL Essential Training 2013 Size: 2.03 GB Lynda – PHP with MySQL Essential Training 2013 Author: Kevin Skoglund Subject: Developer, Servers, Programming Languages, Web Development Software: MySQL, PHP Level: Beginner Duration: 14h 24m Released date: Jun 04, 2013 Homepage: PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code. Topics include: What is PHP?

Installing and configuring PHP and MySQL Exploring data types Controlling code with logical expressions and loops Using PHP’s built-in functions Writing custom functions Building dynamic webpages Working with forms and form data Using cookies and sessions to store data Connecting to MySQL with PHP Creating and editing database records Building a content management system Adding user authentication Introduction Welcome Using the exercise files 1. PHP Overview What is PHP? The history of PHP Why choose PHP? Installation overview 2.

Mac Installation Overview Working with Apache Web Server Changing the document root Enabling PHP Upgrading PHP Configuring PHP Installing MySQL Configuring MySQL Text editor 3. Windows Installation Overview Installing WampServer Finding the document root Configuring PHP Configuring MySQL Text editor 4. First Steps Embedding PHP code on a page Outputting dynamic text The operational trail Inserting code comments 5. Exploring Data Types Variables Strings String functions Numbers part one: Integers Numbers part two: Floating points Arrays Associative arrays Array functions Booleans NULL and empty Type juggling and casting Constants 6. Control Structures: Logical Expressions If statements Else and elseif statements Logical operators Switch statements 7.

Control Structures: Loops While loops For loops Foreach loops Continue Break Understanding array pointers 8. Lemon tree fool's garden lyrics. User-Defined Functions Defining functions Function arguments Returning values from a function Multiple return values Scope and global variables Setting default argument values 9. Debugging Common problems Warnings and errors Debugging and troubleshooting 10. Building Web Pages with PHP Links and URLs Using GET values Encoding GET values Encoding for HTML Including and requiring files Modifying headers Page redirection Output buffering 11.

Working with Forms and Form Data Building forms Detecting form submissions Single-page form processing Validating form values Problems with validation logic Displaying validation errors Custom validation functions Single-page form with validations 12. Working with Cookies and Sessions Working with cookies Setting cookie values Reading cookie values Unsetting cookie values Working with sessions 13. MySQL Basics MySQL introduction Creating a database Creating a database table CRUD in MySQL Populating a MySQL database Relational database tables Populating the relational table 14. Using PHP to Access MySQL Database APIs in PHP Connecting to MySQL with PHP Retrieving data from MySQL Working with retrieved data Creating records with PHP Updating and deleting records with PHP SQL injection Escaping strings for MySQL Introducing prepared statements 15. Building a Content Management System (CMS) Blueprinting the application Building the CMS database Establishing your work area Creating and styling the first page Making page assets reusable Connecting the application to the database 16. Using Site Navigation to Choose Content Adding pages to the navigation subjects Refactoring the navigation Selecting pages from the navigation Highlighting the current page Moving the navigation to a function 17. Application CRUD Finding a subject in the database Refactoring the page selection Creating a new subject form Processing form values and adding subjects Passing data in the session Validating form values Creating an edit subject form Using single-page submission Deleting a subject Cleaning up Assignment: Pages CRUD Assignment results: Pages CRUD 18.