Duration: 3 Months [1.5 Hours/Day]
Eligibility: 10th Passed
PHP+MySQL & REST API Course Syllabus
Fill this information
- Introduction of PHP-:What is PHP, Why Choose PHP, Installation overview, Embedding PHP code on a page.
- Variable & Data Types-:variable, constant, operators in PHP.
- Control Structures & Array-:if, else, else-if, switch case in PHP, Loops in PHP, Array in PHP.
- Pre Defined Function-:String Function, Number Function & Date and Time Function in PHP.
- OOP Concepts-:Create a Class, User Defined Function in PHP, Parameters & Arguments in PHP.
- Superglobals Variables-:$_SERVER, $_GET, $_POST, $_REQUEST, $_FILES & Others.
- Cookies & Session-:What is Cookie, Using Cookies in PHP, What is Session, Difference between Session & Cookies
- Working with Form-:Building forms , Form data handlingDataLinks and URLs, Using GET values, Encoding GET values ,Encoding for HTML ,Including and requiring files ,Modifying headers, Page redirection.
- MySQL introduction-:DBMS Concepts, What is SQL, Create Database & Tables, Table Manipulation , Inset Select, Update & Delete records in a table, WHERE , LIKE, ORDER, Keyword in MySQL, Using Operators in queries, aggregate in SQL.
- Using PHP to Access MySQL Database-:Database APIs in PHP, Connecting to MySQL with PHP for Insert Data, Delete Data, Update data & Retrieved Data in Various Fields- TEXTBOX, DROPDOWN LIST, & TABLES.
- Building a Content Management System-:Design Blueprinting of an application- Webpages, Databases Structure and Connecting the application to the database,
- File Handling in PHP-:File validation (size, type, etc.), Uploading files to the server, Retrieving (displaying) files, Deleting files from the server.
- User Authentication System-:Registration Form with Validation, Password Hashing (e.g., password_hash(), password_verify()), Login System with Sessions, Logout Mechanism, Role-based login (Admin/User).
- RESTful API with PHP & MySQL-:What is REST API?. HTTP Methods: GET, POST, PUT, DELETE, JSON Encoding and Decoding, REST API Folder Structure
- Building a Simple REST API-:Fetch all records, Fetch single record, Insert a new record, Update record, Delete record.
- API Security & Advanced Features-:API Token Authentication (e.g., via custom headers), CORS Setup for APIs, JWT Authentication (optional, for advanced level), Postman for API Testing
- API Integrations-:Integrating frontend with HTML/JS/Bootstrap, Introduction to using PHP with AJAX.
- Projects & Assignments-:Online Exam Syatem, Library System, E-Commerce App, Inventory Management System.
