PHP & MYSQL

PHP/MySQL Training

Eligibility & Course Duration :

Must know at least one programming language.

Basic PHP:

    •  What is PHP
    •  Why PHP.
    •  Basic PHP syntax.
    •  Variables, comments, variable naming rules.
    •  Strings in PHP.
    •  Conditional Statements and Loops in PHP.
    •  Class and functions in PHP:
        • Class, Object, Methods.
        • Passing Parameters into Methods, Extending Classes.
    •  PHP form handling.
    •  Form validation, GET, POST methods, $_REQEST variable.

PHP with MySQL:

    •  What is MySQL.
    •  What is SQL, Types of SQL?
    •  Connecting with Database.
    •  Executing queries.
    •  Joining of Data Tables.
    •  Data manipulation: add, edit, delete.
    •  Data orientation.

Advanced PHP:

    •  Working with Date, Time-Stamp.
    •  Include and Require Once.
    •  File Operations:
        • Opening file, creating file.
        • Reading files in different ways.
        • Writing in a file.
        • Parsing a file.
        • Uploading files.
        • Restrictions for uploading.

 Session:

    • Register session variable
    • Storing data in session variable
    • Aaccessing and destroying session variable.

 Cookie:

    • Creating a cookie.
    • Retrieving data from cookie.
    • Browser dependency of cookie, life of cookie, deleting a cookie.

 Email Handling:

    • Header, Subject, To, CC, From, Message, send email.
    • PHP Secure emails.
    • PHP Stopping email injections.

 PHP Error handling:

    • Handling Errors
    • Type of errors.
    • Using die function.
    • Create and Set a custom error handler.
    • Trigger an error.
    • Send an error message by email.

 PHP Exception handling:

    • What is exception?
    • Basic use of exceptions.
    • Try, Through and Catch.
    • Create a custom exception class.
    • Multiple exceptions.

Ajax PHP:

    •  Ajax Introduction.
    •  Creating and Implementing an XML HTTP request.
    •  PHP Ajax with XML.
    •  PHP Ajax with MySQL database.
    •  Ajax response in XML.
    •  Ajax RSS reader.

Project:

    •  Analysis.
    •  Design.
    •  Coding.
    •  Testing and Finalizing.