GLS UNIVERSITY

Bachelor of Computer Applications (BCA)

(Core Course)
Semester-V
0301501 WEBSITE DEVELOPMENT USING PHP & MySQL
1. Course Objective:
 This course introduces students to the PHP programming language, the MySQL
relational database system commonly used to create dynamic websites.
 To construct Web applications that access simple databases from PHP using dynamically
generated SQL.
 To understand the general concepts of PHP scripting language for the development of
Internet websites.
 To understand the basic functions of MySQL database program.

2. Course Duration:
The course will have sessions which are divided into five modules. Each module consists of
nine sessions of 60 minutes each and carries a weightage of 20%.

3. Course Contents:
Module Modules/Sub-Modules No. of Marks
No. Sessions Weightage
I Introduction to PHP, Creating PHP Pages 09 20%
 Brief introduction to Apache, MySQL,
PHP and Open Source
o Brief History of Open Source
Initiatives
 Installing Apache, MySQL and PHP
 Overview of PHP structure and Syntax
o PHP and HTML
o Rules of PHP Syntax
o Importance of Coding Practices
 PHP Data Types
o String, integer, float, object, array,
NULL value
 Creating First Program
 Integrating HTML with PHP
 Using Constants and Variables
 Passing Variables between pages
o Passing Variables through a URL
 Using Includes for Efficient Code
 Alternate Syntax for PHP
o Alternates to the echo Command
o Alternates to Logical Operator
o Alternates to Double Quotes
o Alternates to Increment / Decrement
Values
II Conditional Statements, Looping, PHP 09 20%
Functions and Arrays
 Conditional Statements
o If-else statement
o If-else if statement
o Switch statement
 Loops
BCA Programme Syllabus
 o While loop
o Do..while loop
o For loop
o For-each loop
 Functions
o Create a function
o Function with one argument
o Function with two argument
o Function with default argument value
o Functions returns a value
 Arrays
o Introduction to Array
o Creating Arrays
o Storing values in an array
o Initializing Arrays
o Creating Associative Arrays
o Creating Multidimensional Arrays
o Array related Functions
III Strings, Date and Time, Working with Forms 09 20%
 Strings, Dates and Time
o Formatting Strings with PHP
o Using Date and Time Functions in
PHP
 Forms
o Creating Simple Input Form.
o Accessing Form Input with Use-
Defined Arrays
o GET & POST method
o Radio Input Element
o Multiple Submit Buttons
o PHP Form Validations
 Preg_Match
 Preg_Match_all
o PHP Required Field Validation
o PHP Email Validation
o Using CSS in Forms
o Using hidden fields to Save State
o Redirecting the User

IV Working with Sessions and Cookies, Images, 09 20%

Files
 Sessions and Cookies
o Introduction to Session
o Starting Session
o Modifying Session Variables
o UN-registering and deleting session
variable
 Introduction to Cookies
o Creating Cookies
o Deleting Cookies
 Allowing User to Upload Images
 Working with file and directories
o Understanding files and directory
o Opening and Closing file
o Coping, renaming and deleting file
o Working with directories

BCA Programme Syllabus

 o File uploading and downloading
V PHP and MySQL Programming 09 20%
 Using PHP and MySQL
o MySQL Structure
o MySQL Syntax and Commands
 PHP with MySQL
 Connecting to the MySQL Server
 Functions Accessing MySQL from PHP
o Mysqli_Connect()
o Mysqli_Select_db()
o Mysqli_Query()
o mysqli_fetch_array()
o Extract()
o mysqli_close()
o mysqli_numrows()
 Creating Table in PHP
 Getting Information from the User
 Inserting Records in the Table
 Retrieving all Records from the Table
 Searching Records from the Table
 Deleting Records from the Table
 Website Hosting
o Domain Name and Web Space
o Types of Hosting
 Free web hosting
 Shared hosting
 Dedicated server hosting
o Website Hosting Companies Name

4. Teaching Methods:
The following pedagogical tools will be used to teach this course:
1) Lectures and Discussions
2) Practical demos
3) Assignments and Presentations

5. Evaluation:
The students will be evaluated on a continuous basis and broadly follow the scheme given
below:
1. Assignments / Presentations 30% (Internal Assessment)
2. Internal Examination 20% (Internal Assessment)
3. External Examination (University Exam) 50% (External Assessment)

6. Basic Text Books:

Sr. Author/s Name of the Publisher Edition
No book
T1 W. Jason Gilmore Begining PHP APress Latest
and MySQL

7. Reference Books:
Sr. Author/s Name of the book Publisher Edition
No
BCA Programme Syllabus
R1 Steven Holzner The Complete Reference PHP McGraw Latest
Hill
R2 Richard Blum PHP, MySQL & JavaScript For Latest
Dummies

8. List of E-books and Video Lectures etc.:

Sr. No Link
1 E-book Beginning PHP and MySQL by W. Jason Gilmore (Apress)
2 http://www.nptelvideos.com/video.php?id=2143&c=27
3 http://www.nptelvideos.com/video.php?id=2138&c=27
4 http://www.nptelvideos.com/video.php?id=2131&c=27

9. Session Plan:
Session No. Topics / Chapters
1 Brief introduction to Apache, MySQL, PHP and Open Source
2-3 Installing Apache, MySQL and PHP, PHP structure and Syntax
4-5 PHP Data Types, Integrating HTML with PHP, Constants and Variables
6-7 Passing Variables between pages
8-9 Alternate Syntax for PHP
10-11 Conditional Statements
12-13 Looping
14-15 Functions
16-18 Arrays
19-22 Strings, Date and Time
23-27 Working with Forms
28-31 Working with Sessions
32-34 Working with Cookies
35-36 Working with files
37 PHP and MySQL
38-40 Functions Accessing MySQL from PHP
41-45 Database connectivity with all operations

10. Learning Outcome:

Upon the completion of this course, students will be able to

 Develop websites and web based projects.

 Develop interactive and dynamic website.
 Understand the basics of the PHP and examine how web pages are developed using
PHP.

BCA Programme Syllabus