PHP and MySQL

PHP and MySQL

HTML (Hypertext Markup Language)

  1. Introduction to HTML
  2. Basic structure of HTML
  3. Formatting tags in HTML
  4. Working with Table Tags

PHPSCRIPT

  1. Introduction to PHPScript
  2. Looping statement in PHPScript
  3. Working with Predefined functions
  4. Maintaining Validations in PHPScript
  5. Working with Different types of Mouse Events
  6. Miscellaneous

PHP

  1. PHP’s role in the WWW
  2. Language fundamentals
  3. PHP Basics
  4. Variable rules
  5. Storing & retrieving information in variables
  6. Decision making in PHP
  7. Comparison operators
  8. The if construct
  9. The while construct
  10. The for construct
  11. Working with arrays
  12. Functions
  13. Declaring functions
  14. Passing data by reference
  15. Variable scope in PHP
  16. Working with web forms
  17. PHP POST & GET form elements
  18. Embedding forms with PHP code
  19. Validating form data
  20. Guidelines for secure PHP
  21. Understanding magic quotes
  22. Setting default values in forms
  23. Processing uploaded files
  24. Retrieving uploaded files
  25. PHP session handling
  26. PHP cookie handling
  27. Handling date & time
  28. Working with files in PHP
  29. Reading & writing files with PHP
  30. Handling errors

MySQL

  1. A brief history of databases
  2. Relational database concepts
  3. Database tables
  4. MySQL Data types
  5. Introduction to P HPMyadmin
  6. Creating and Checking Tables
  7. Auto increment and Primary Keys
  8. Inserting Values into Tables

Mini Project with PHP and MySQL

  1. Creation of database and required tables using PHPMyadmin.
  2. Creation of required templates, pages and managing site using IDEDreamweaver.
  3. Keeping structure, style and behavior of created pages apart.
  4. Creating login and logout pages for maintaining sessions.
  5. Creating forms to insert data into address book-personal details, image etc.
  6. Creating page to view the data from address book.
  7. Adding PHPScript for form validation.
  8. Adding server side validation.
  9. Adding mouse events like mouseout and mouseover dynamically.
  10. Creating page to edit or delete the records in the address book.
  11. Creating page to enable searching the address book.

Introduction to Ajax

  1. What is ajax
  2. Connecting to server using PHPScript
  3. Downloading data behind scenes
  4. Modifying web pages on the fly
  5. Creating an XMLHttpRequest Object in different browsers
  6. Checking the XMLHttpRequest Object’s readyState property
  7. Checking the XMLHttpRequest Object’s status property
  8. Getting Your Data With the XMLHttpRequest Object
  9. Problems creating an XMLHttpRequest Object
  10. Fetching Text Data From the server
  11. Using the text data received through XMLHttpRequest