KUK - LMS

Syllabus

MODULE NO / UNIT	COURSE SYLLABUS CONTENTS OF MODULE	NOTES
Course Code: BCA-502(II) Course Name: PHP AND MYSQL
1	Introduction to PHP: Advantages of PHP, HTML relationship, variable types and their scope, Types of Data, Type conversion, Type casting. Operators, unary operators, arithmetic operators, logical operators, conditional operators, conversion operators, Comparison operators, Ternary Operator, Scope resolution operator. Control statements – sequence, conditional statements, loops, jump statements.
2	Creating an array, Multidimensional arrays, Accessing array, Element Looping with Index based array, Looping with associative array using each () and foreach(), Array Library functions. Functions and Strings: Function prototypes, arguments, Recursive functions, Mathematical conversion functions. Strings: Basic operations on strings: Reading from part of a string, Replacing parts of a string, Finding a substring within a string, Trimming whitespace, Changing string case, Comparing strings.
3	OOPS Concept: Classes, Defining a class and Objects, Constructor & Destructor, Method Overloading, Basic inheritance, Overriding functions, Variables, 'this' variable, Access control modifiers-Public, Private, Protected, Final, Abstract, Iterating through object variables, Deleting objects, Abstract class and Interfaces. Forms Processing: Designing a form, GET and POST, Handling data-register, Handling form, Form Validation: Clientside validation, Server-side validation. File Uploading – File Downloading through Form. Working with directory.
4	PHP & MySQL: Introduction MySQL, PhpMyAdmin, PHP_MySQL-DB functions, Connecting to a MySQL database, Performing basic database operation(DML) (Insert, Delete, Update, Select), Setting query parameter, Executing query, Join (Cross joins, Inner joins, Outer Joins, Self joins.),Aggregate Functions(sum, avg, count). Introduction to Cookies and Sessions: Using cookies, Sessions: Starting a session, ending a session, checking session data.