Website Development through PHP & MYSQL
Introduction: 'It is a short term course of six months. The syllabus is very much parallel with the requirements of modern job demands.
Eligibility:
(1) KNOWLEDGE OF ANY PROGRAMMING LANGUAGE (C/C++/ VB/JAVA etc.)
(2) KNOWLEDGE OF HTML and JavaScript, BASIC KNOWLEDGE OF DBMS.
PREREQUISITES:
1. Concept of HTML, HTML tags, HTML Components, Designing Form with different HTML components.
2. Basic concepts of JavaScript.
3. Basic concept of CSS.
4. Introduction to HTML5, CSS3 and JQuery.
5. Basic concept of BootStrap to make mobile friendly responsive website.
INTRODUCTION:
1. Introduction to Website and Domain Name
2. Categories of Websites
3. Static and Dynamic website definition, concepts and differences
4. Concept of Client and Server side Scripting
5. Concept of Web Server. Example of different web servers.
6. HTTP Request/ Response.
7. Introduction to PHP – Definition
8. Explanation of the terms- Open Source, Recursive Acronym, Server Side vs. Client Side Language, Cross Platform Technology, Scripting vs. Compiled Language.
9. Introduction to MySQL.
10. How PHP Works – Explanation with diagram.
11. History of PHP
12. PHP Versions – PHP 5 vs. PHP 7
13. PHP Environment Setup – Web server + Database + PHP Parser
14. Examples of Open Source Web Servers – WAMP/ XAMP/ LAMP/SAMP/ FAMP
15. Installation of WAMP Server (Apache, PHP Parser, MySQL), Sublime Text Editor.
16. Run a hello.php script in http://localhost/hello.php or http://127.0.0.1/hello.php
PHP LANGUAGE:
1. PHP Script Tags
2. PHP Comments
3. Sending Data to Web Browser using echo language construct.
4. PHP Variables – Rules, Usage with echo.
5. PHP $ and $$ Variables
6. PHP Datatypes
7. PHP var_dump() function with example
8. Type Casting in PHP
9. Different examples of echo
10. PHP Escape Characters
11. Defining Constants using PHP – define() and constant() function
12. PHP operators
13. PHP Decision Making – if…else, elseif, switch...case with examples.
14. PHP Loop Structures – while loop, do…while loop, for loop, foreach loop with examples.
15. break and continue statements
16. Array in PHP – Numeric array, Associative array, Two Dimensional array
17. Array handling library functions in PHP.
18. PHP String Handling – Concatenation, Interpolation, String handling functions in PHP
19. User Defined Functions in PHP
20. Scope and Lifetime of variables.
21. PHP Global Variables – Superglobals.
22. Designing Form in HTML with HTML components - PHP Form handling
23. GET vs. POST method – When to use GET and when to use POST
24. PHP file inclusion – include() and require() function - difference
25. Session Handling in PHP – session_start(), $_SESSION variable, destroying a session
26. File Uploading and Downloading in PHP – unlink() function to delete a file.
27. Date Handling in PHP – Different date functions.
28. ASSIGNMENT – 1: Enrollment Form Design using Form Submit + Photo Upload + Session handling.
DATABASE HANDLING IN PHP:
1. Introduction to DBMS.
2. Introduction to MySQL.
3. Introduction to PHPMyAdmin: Creating Database, Creating Tables, Browsing Records, Export and Importing database/ tables, writing SQL etc.
4. PHP Script to Connect to MySQL Database, Insert Record, Update/ Delete Record and Search Record on a database.
5. Different ways to Connect PHP and MySQL – i) Non Procedural ii) Procedural iii) Object Oriented iv) PDO
6. ASSIGNMENT 2: Create Student a) Registration Form and b) Login Form using PHP, MySQL and Session Handling.
OBJECT ORIENTED PROGRAMMING USING PHP:
1. Introduction to OOP in PHP.
2. Difference between Procedural and OOP.
3. Introduction to class, object, constructor, destructor, inheritance, method overloading, method overriding, public, private and protected access specifiers in PHP
4. Object Oriented Database handling using PHP.
5. Concept of PDO – database handling using PHP
6. Introduction to AJAX – sample coding
7. Introduction to JSON – JSON parsing, encoding and decoding.
CONTENT MANAGEMENT SYSTEM (CMS) :
1. Introduction to CMS, Examples of popular CMS softwares.
2. Introduction to WordPress – Installation and Configure to WordPress, Use of Plugins, Widgets and Templates in WordPress.
3. ASSIGNMENT 3: Create a Business website using WordPress, Plugins, and Templates.
4. Introduction to E-Commerce website – Introduction to WooCommerce Plugin of WordPress.
5. ASSIGNMENT 4: Create an e-commerce website using WordPress.
MVC ARCHITECTURE IN PHP :
1. Introduction to MVC architecture - Explain
2. Introduction to CodeIgniter – Installation, Configuration.
3. Directory and File structure of CodeIgniter.
4. Passing values from Controller, Model and Views.
5. Session handling in CodeIgniter.
6. Database programming using CodeIgniter.
7. Installing external CSS template in CodeIgniter framework.
8. URL Routing –Regular Expression in PHP
9. Assignment 5: Create Registration and Login Form using Codeigniter.
PDF FILE CREATION USING PHP :
1. Creating PDF file using FPDF library – Sample program.
SENDING MAIL USING PHP :
1. Sending mail from PHP script.
MAJOR PROJECT :
Project should be done using Custom PHP (Procedural / OOP) or CodeIgniter
1. Choose Project Topic.
2. Make Requirement Analysis/ Identify functionalities of the project.
3. Identify Static and Dynamic sections of the Website.
4. System Designing – Design both i) Front end ii) Admin Panel/ Dashboard of the project.
5. Design Database using MySQL.
6. Create/ Choose/ Modify Template for both i) Website and ii) Admin Panel.
7. Create a dynamic website using PHP and MySQL.
Certficate: All the students will have to submit Major Project at the end of the course to get the institute's certificates.