Web Designing Using PHP and MySQL Course code: 3361603

GUJARAT TECHNOLOGICAL UNIVERSITY, AHMEDABAD, GUJARAT

COURSE CURRICULUM
COURSE TITLE: WEB DESIGNING USING PHP AND MYSQL
(COURSE CODE: 3361603)
Diploma Program in which this course is offered Semester in which offered
Information Technology SIXTH

1. RATIONALE
PHP is a powerful tool for making dynamic and interactive database driven web pages.
PHP is the widely-used as efficient open source technology. The students of diploma in
Information Technology as web developers would be able to write dynamic interactive
web based applications such as for online banking, ticket/hotels booking sites, E-
Commerce using PHP and MYSQL database. After mastering this course they may
work as self employed web page developer.

2. COMPETENCY
The course content should be taught and implemented with the aim to develop required skills
in the students so that they are able to acquire following competency:

• Develop interactive web based application using PHP and MySQL

3. COURSE OUTCOMES:
The theory should be taught and practical should be carried out in such a manner that
students are able to acquire different learning out comes in cognitive, psychomotor
and affective domain to demonstrate following course outcomes.

i. Create small programs using basic PHP concepts.

ii. Apply In-Built and Create User defined functions in PHP programming.
iii. Design and develop a Web site using form controls for presenting web based
content.
iv. Debug the Programmes by applying concepts and error handling techniques of
PHP.
v. Create dynamic Website/ Web based Applications, using PHP, MySQL database

4. TEACHING AND EXAMINATION SCHEME

Teaching Scheme Total Credits Examination Scheme

(In Hours) (L+T+P) Theory Marks Practical Marks Total Marks
L T P C ESE PA ESE PA
200
3 0 4 7 70 30 40 60
Legends: L - Lecture; T - Tutorial/Teacher Guided Student Activity; P - Practical; C - Credit; ESE - End
Semester Examination; PA - Progressive Assessment

GTU/NITTTR/Bhopal/14-15 Gujarat State

1of6
Web Designing Using PHP and MySQL Course code: 3361603

5. COURSE DETAILS
Major Learning Outcomes Topics and Sub-topics
Unit
(in cognitive domain)
Unit – I 1a. Identify relationship between 1.1 Configuration of PHP, Apache Web
Apache, MySQL and PHP Server, MySQL and Open Source
Introduction 1b. State steps to Install & test 1.2 Relationship between Apache,
to PHP web server
MySQL and PHP(AMP Module)
1c. State Steps to Configure
Apache to use PHP 1.3 Installing PHP for (Windows, Wamp
server , XAMP server),
1d. Create simple PHP page using 1.4 PHP Structure and Syntax
PHP structure and Syntax. 1.5 Creating PHP pages
1e. List and state use of PHP 1.6 Rules of PHP syntax
variables, data types .
1.7 Integrating HTML with PHP
1f. Describe use of PHP Operators.
1g. Apply control structures in 1.8 Constants , Variables: Static and
programming Global Variable
1h. State the steps to use different 1.9 Conditional Structure and Looping,
types of array in given PHP operators
application 1.10 Arrays, constructs
1i. State the steps to create user 1.11 User Defined function, argument
defined functions
function, variable function, Return
function, default argument, variable
length argument

Unit – II 2a. Apply various InBuilt 2.1 Variable Function:

Working Variable, String, MATH, Date, (gettype, settype, isset, strval, floatval,
with In Built Array, File Functions in intval,print_r)
Functions programming
2.2 string function:
(Chr, ord, strtolower, strtoupeer,
strlen, ltrim, rtrim, trim, substr,
strcmp, strcasecmp, ctrops, strops,
stristr, str_replace, strrev, echo, print)
2.3 MATH functions:
(Abs, ceil, floor, round, fmod, min,
max, pow, sqrt, rand)
2.4 Date function:
(Date, getdate, setdate, checkdate,
time, mktime)
2.5 Array Function:
(Count, list, in_array, current, next,
previous, end, each, sort, array_merge,
array_reverse)
2.6 File function:

GTU/NITTTR/Bhopal/14-15 Gujarat State

2of6
Web Designing Using PHP and MySQL Course code: 3361603

Major Learning Outcomes Topics and Sub-topics

Unit
(in cognitive domain)
(Fopen, fread, fwrite, fclose)

Unit – III 3a. State the steps to Create an 3.1 Reading data using Form Controls
input form (Text Fields, Text Areas, CheckBoxes,
Working 3b.State the steps to use Using Radio Buttons, List Boxes, Password
with data PHP $_Get and $_Post,
Controls, Hidden Controls, Image Maps,
and forms $_Request method for a given
application File Uploads, Buttons)
3.2 Submitting form values, using $_Get
and $_Post Methods, $_REQUEST
3.3 Accessing form inputs with Get/Post
functions
3.4 Combining HTML and PHP codes
together on single page, Redirecting
the user

Unit - IV 4a. Use cookie to store and 4.1 Setting a cookie with PHP, Deleting a
Session, retrieve data cookie
Cookies and 4b. Use querystring to transfer 4.2 Creating session cookie
Error data
4.3 Working with the query string
Handling 4c. Create session variable and
handle session Creating query string
4d. Handle runtime errors through 4.4 Session
exception handling 4.5 Starting and Destroying session
4.6 Working with session variables ,
Passing session IDs
4.7 Error Types in PHP
4.8 Exception Handling in PHP

Unit - V 5a. Describe/ State MySQL 5.1 Concepts and Installation of MySQL
Database structure and Syntax 5.2 MySQL structure and syntax
Connectivity 5b. Discuss types of MySQL 5.3 Types of MySQL tables and Storage
using tables and storage engines
engines
MYSQL 5c. Apply/Use various MySQL
commands on database 5.4 MySQL commands
5d. State steps to connect with 5.5 Integration of PHP with MySQL
database using PHP and 5.6 Connection to the MySQL Database
MYSQL 5.7 Creating and DeletingMySQL
5e.Write MySQL commands to database usingPHP
Insert, Update, Delete records 5.8 Updating, Inserting, Deleting records
5f. Describe steps for hosing
in the MySQL database
a Website using ‘C’ panel
and Filezilla software 5.9 Hosting Website (Using ‘C’ panel,
Using Filezilla Software)

GTU/NITTTR/Bhopal/14-15 Gujarat State

3of6
 Web Designing Using PHP and MySQL Course code: 3361603

6. SUGGESTED SPECIFICATION TABLE WITH HOURS & MARKS (THEORY)

Unit Unit Title Teaching Distribution of Theory Marks
No. Hours R U A Total
Level Level Level Marks
I Introduction to PHP 6 4 4 2 10
II Working With Functions 6 4 6 4 14
III Working with DATA and Forms 9 2 6 6 14
IV Cookie, Session and Error 9 4 8 4 16
Handling
V Database Connectivity using 12 2 6 8 16
MYSQL
Total 42 16 30 24 70
Legends: R = Remembrance; U = Understanding; A = Application and above levels (Revised Bloom’s
taxonomy)

Note: This specification table shall be treated as a general guideline for students and teachers.
The actual distribution of marks in the question paper may vary slightly from above table.

7. SUGGESTED LIST OF EXERCISES/PRACTICAL

The practical/exercises should be properly designed and implemented with an attempt to

develop different types of skills (outcomes in psychomotor and affective domain) so that
students are able to acquire the competencies/programme outcomes. Following is the list of
practical exercises for guidance.

Note: Here only outcomes in psychomotor domain are listed as practical/exercises. However,
if these practical/exercises are completed appropriately, they would also lead to development
of certain outcomes in affective domain which would in turn lead to development of Course
Outcomes related to affective domain. Thus over all development of Programme Outcomes
(as given in a common list at the beginning of curriculum document for this programme)
would be assured.

S. No. Approx.
Unit Practical Exercises
Hours.
No. (Outcomes in Psychomotor Domain)
Required
1. Write a PHP script to display Welcome message. 2
2. Write a PHP script to demonstrate arithmetic operators, 2
comparison operator, and logical operator.
3. Write PHP Script to print Fibonacci series. 2
I
4. Write PHP Script to generate result and display grade. 2
5. Write PHP Script to find maximum number out of three given 2
numbers.
6. Write PHP Script for addition of two 2x2 matrices. 2
7. Write PHP script to demonstrate Variable function. 2
8. Write PHP script to obtain 5! Using function 2
9. Write PHP script to demonstrate string function. 2
II
10. Write PHP script to demonstrate Date functions. 2
11. Write PHP script to demonstrate Math functions. 2
12. Write PHP script to demonstrate Array functions. 2
GTU/NITTTR/Bhopal/14-15 Gujarat State
4of6
Web Designing Using PHP and MySQL Course code: 3361603

S. No. Approx.
Unit Practical Exercises
Hours.
No. (Outcomes in Psychomotor Domain)
Required
13. Write PHP script to demonstrate File functions. 2
14. Create student registration form using text box, check box, radio 2
button, select, submit button. And display user inserted value in
new PHP page.
III
15. Create Website Registration Form using text box, check box, 2
radio button, select, submit button. And display user inserted
value in new PHP page.
16. Write two different PHP script to demonstrate passing variables 2
through a URL.
17. Write two different PHP script to demonstrate passing variables 2
with sessions.
18. IV Write PHP script to demonstrate passing variables with 2
cookies.
19. Write a program to keep track of how many times a visitor has 2
loaded the page.
20. Write an example of Error-handling using exceptions. 2
21. Write a PHP script to connect MySQL server from your 2
website.
22. Write a program to read customer information like cust_no, 2
cust_name, Item_purchase, and mob_no, from customer table
and display all these information in table format on output
screen.
V
23. Write a program to edit name of customer to “Bob” with 2
cust_no =1, and to delete record with cust_no=3.
24. Write a program to read employee information like emp_no, 2
emp_name, designation and salary from EMP table and display
all this information using table format.
25. Create a dynamic web site using PHP and MySQL. 8
TOTAL 56

8. SUGGESTED LIST OF STUDENT ACTIVITIES

Following is the list of proposed student activities like:
i. Prepare power point presentation showing relation between PHP, APACHE and
MYSQL.
ii. Develop sample web based Application using PHP and MYSQL and present the
same.

9. SPECIAL INSTRUCTIONAL STRATEGIES (if any)

i. Concepts should be introduced in classroom input sessions and by giving
demonstration through projector.
ii. Arrange expert lectures by IT experts working professionally in the area of webpage
development.
iii. More focus should be given on practical work which will be carried out in laboratory
sessions. If possible some theory sessions may be conducted in labs so that theory and
practice can go hand in hand.

GTU/NITTTR/Bhopal/14-15 Gujarat State

5of6
Web Designing Using PHP and MySQL Course code: 3361603

iv. Faculty should allow students to use their creativity and let them struggle to learn
on their own during practical sessions. However, faculty should remain around the
students and should help them when they are stuck.
v. Arrange a webpage development competition by making groups of four students
each and award the winning group. Give publicity to this competition at
institute/city level.

10. SUGGESTED LEARNING RESOURCES

A) List of Books

S.
Title of Book Author Publication
No.
1 Beginning PHP and MySQL, 4th W. Jason Gilmore Apress, 2010
Edition
2 PHP: The Complete Reference Steven Holzner McGraw-Hill,
2008
3 Learning PHP, MySQL, Robin Nixon O'reilly Media ,
JavaScript, CSS & HTML5, 2014
Third Edition
4 Teach yourself PHP, MySQL and Julie C. Meloni, Pearson Education,
Apache All in One , 5th Edition 2012

B) List of Major Equipment/ Instrument with Broad Specifications

1. Computer System with latest configuration, Server with latest specification,
broadband or leased line connection
2. Multimedia Projector
C) List of Software/Learning Websites
Software: WAMP server / XAMPP server, ‘C’ Panel, Text Editor
i. http://www.codecademy.com/tracks/web ,
ii. http://www.codecademy.com/tracks/php
iii. http://www.w3schools.com/PHP
iv. http://www.tutorialpoint.com
v. .http://www.homeandlearn.co.uk

11. COURSE CURRICULUM DEVELOPMENT COMMITTEE

Faculty Members from Polytechnics

 Mrs. Rikita Dhaval Parekh, Lecturer ( IT ), Government Polytechnic For Girls,

Ahmedabad
 P.V.Garach, , Lecturer ( IT ), Government Polytechnic For Girls, Ahmedabad

Coordinator and Faculty Members from NITTTR Bhopal

 Dr. K. James Mathai, Associate Professor, Dept. of Computer Engineering and
Applications.
 Dr. Shailendra Singh, Professor and Head, Dept. of Computer Engineering and
Applications.

GTU/NITTTR/Bhopal/14-15 Gujarat State

6of6