Trending

Monday, May 19, 2014

PHP with MySQL Essential Training 2013

Lynda – PHP with MySQL Essential Training 2013
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

Table of content

  • Introduction
    • Welcome
    • Using the exercise files
  • PHP Overview
    • What is PHP?
    • The history of PHP
    • Why choose PHP?
    • Installation overview
  •  Mac Installation
    • Overview
    • Working with Apache Web Server
    • Changing the document root
    • Enabling PHP
    • Upgrading PHP
    • Configuring PHP
    • Installing MySQL
    • Configuring MySQL
    • Text editor
  • Windows Installation
    • Overview
    • Installing WampServer
    • Finding the document root
    • Configuring PHP
    • Configuring MySQL
    • Text editor
  • First Steps
    • Embedding PHP code on a page
    • Outputting dynamic text
    • The operational trail
    • Inserting code comments
  • 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
  • Control Structures: Logical Expressions
    • If statements
    • Else and elseif statements
    • Logical operators
    • Switch statements
  • Control Structures: Loops
    • While loops
    • For loops
    • Foreach loops
    • Continue
    • Break
    • Understanding array pointers
  • User-Defined Functions
    • Defining functions
    • Function arguments
    • Returning values from a function
    • Multiple return values
    • Scope and global variables
    • Setting default argument values
  • Debugging
    • Common problems
    • Warnings and errors
    • Debugging and troubleshooting
  • 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
  • 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
  •  Working with Cookies and Sessions
    • Working with cookies
    • Setting cookie values
    • Reading cookie values
    • Unsetting cookie values
    • Working with sessions
  • 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
  • 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
  • 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
  • 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
  •  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
  • Building the Public Area
    • The public appearance
    • Using a context for conditional code
    • Adding a default subject behavior
    • The public content area
    • Protecting page visibility
  • Regulating Page Access
    • User authentication overview
    • Admin CRUD
    • Encrypting passwords
    • Salting passwords
    • Adding password encryption to CMS
    • New PHP password functions
    • Creating a login system
    • Checking for authorization
    • Creating a logout page
  • Conclusion
    • Next steps
Uploaded.net
  1. http://ul.to/0bno3lpg
  2. http://ul.to/n6v3xdjs
  3. http://ul.to/h73fkgzy
  4. http://ul.to/hlz0ihft
Rapidgator.net
  1. bit.ly/R1KdA3  
  2. bit.ly/1kjknmv  
  3. bit.ly/1p7t2Jt  
  4. bit.ly/1h1IRfy  
 Uploadable.ch
  1. bit.ly/TnzCkR  
  2. bit.ly/1h1J56x  
  3. bit.ly/1kjkMFE  
  4. bit.ly/R1L8Ar  
 K2s.cc
  1. bit.ly/1j3QBh3  
  2. bit.ly/1o8IipA  
  3. bit.ly/1tciFWY  
  4. bit.ly/1gIrUwi  
 Fileparadox.in
  1. bit.ly/1h1KcDk  
  2. Uploading.....
  3. Uploading.....
  4. bit.ly/1hYHmyR  
  

No comments:

Post a Comment

About

Contact Form

Name

Email *

Message *

Copyright © 2013 TOTdownload.com
Designed By Blogger Templates