Web fased Application development with PHP Course Code: 22619 Program Name : Computer Engineering Program Group Program Code : CO/CMAF/CW Semester ixth Course Title : Web Based Application development with PHP Course Code + 22619 1. RATIONALE PHP is a general purpose, server-side scripting language run a web sever that's designed to make dynamic pages and applications. PHP as a web development op secure, fast and reliable, In the growing field of Web technology it is essential for every Diploma pass outs to Jean PHP Language to help them build interactive web applications. This course is designed to inculcate web based applications development skills in students using server side scripting with PHP. 2. COMPETENCY The aim of this course is to help the student to attain the following industry identified competency through various teaching learning experiences: «Develop simple web-based application using PHP language. 3. COURSE OUTCOMES (COs) The theory, practical experiences and relevant soft skills associated with this course are to be taught and implemented, so that the student demonstrates the following industry oriented COs associated with the above mentioned competency: a) Develop program using control statement. b) Perform operations based on arrays and graphics. c) Develop programs by applying various object oriented concepts. d) Use form controls with validation to collect user’s input. ¢) Perform database operations in PHP. 4. TEACHING AND EXAMINATION SCHEME, Teaching Pr Ts Fast Lip [*T paper [ESE PA Total ESE PA | Total Hrs, |Max_|Min | Max [Min | Max |Min| Max | Min | Max | Min | Max | Min s{-[2 [ss | % | 28 [30° | 00 [100 | 40] asf 10 | 25 | wo | so | 20 (*): Under the theory PA, Out of 30 marks, 10 marks are for micro-project assessment to ‘facilitate integration of COs and the remaining 20 marks is the average of 2 tests to be taken ‘during the semester for the assessment of the UOs required for the attainment of the COs. Legends: L-Lecture; T ~ Tutorial/Teacher Guided Theory Practice; P - Practical; C— Credit, ESE - End Semester Examination; PA - Progressive Assessment 5. COURSE MAP (with sample COs, PrOs, UOs, ADOs and topics) This course map illustrates an overview of the flow and linkages of the topics at various levels of outcomes (details in subsequent sections) to be attained by the student by the end of the course, in all domains of learning in terms of the industry/employer identified competency depicted at the centre of this map. » MSBTE ~ Final Copy Dt. 24.09.2019 Page 1 of 7Wich Based Application development with PHP. - Couse Code: 22619 pi pet 9S 7 1 Ba Figure 1 - Course Map 6. SUGGESTED PRACTICALS/ EXERCISES ‘The practicals in this section are PrOs (i.e. sub-components of the COs) to be developed and assessed in the student for the attainment of the competency. | Approx. S Practical Outcomes (PrOs) Unit | Hrs, 0. No. Required ‘a, Install and configure PHP, web server, MYSQL 1 |b: Write a program to print “Welcome to PHP”. 1 Pa ¢. Write a simple PHP program using expressions and operators. 2 Write a PHP program to demonstrate the use of Decision making control structures using- a. If-statement 1 02" b. Ifelse statement c._ Switch statement - 3 | Write a PHP program to demonstrate the use of Looping structures using- a. While statement, b. Do-while statement c.For statement 4. Foreach statement MSBTE — Final Copy Dt. 24.09.2019 Page 2 0f7‘ich Based Applisation development wih PHP Course Code: 22619 | Approx. Pd Practical Outcomes (PrOs) Sait Hrs. . | Required 4 | Write a PHP program for ereating and manipul : a. Indexed array i 0 b. Associative array c. Multidimensional arra 5 | a. Write a PHP program to— Caleulate length of string. ii, Count the number of words in string -without using | jy | gps string functions. b. Write a simple PHP program to demonstrate use of various built-in string funetions. 6 | Write a simple PHP program to demonstrate use of Simple |, oo function and Parameterized function. 7 | Write a simple PHP program to create PDF document by using | 1, o graphics concepts 3 | Write a PHP program to- a. Inherit members of super class in subclass. m | oo b. Create constructor to initialize object of class ~by using object oriented concepts 9 [Write a simple PHP program on Introspection and |, | gy Serialization. TO | Design a web page using following form controls: wl oo a. Text box, b. Radio button, c, Check box, d. Buttons TT [Design a web page using following form controls: wl om a, List box, b, Combo box, ¢. Hidden field box 12 [Develop web page with data validation. W_|_0* | 13. | Write simple PHP program to - a, Set cookies and read it. wv | 02* b, Demonstrate session Management. 14 [Write a simple PHP program for sending and receiving plain | yy | ype text message (e-mail). 15 | Develop a simple application to- a. Enter data into database v 02* b. Retrieve and present data from database. T6 | Develop a simple application to Update, Delete table data from | yy ge database. Total 32 Not i. A suggestive list of PrOs is given in the above table. More such PrOs can be added to attain the COs and competency. All the above listed practical need to be performed compulsorily, so that the student reaches the ‘Applying Level’ of Bloom's ‘Cognitive Domain Taxonomy’ as generally required by the industry, ii. The ‘Process’ and ‘Product’ related skills associated with each PrO are to be assessed according to a suggested sample given below. Ss. No. Performance Indicators Weightage in a. Write appropriate code to generate desired output in Web application f' MSBTE — Final Copy Dt. 24.09.2019 Page 3 of 7Web Based Application development with PHP Course Code: 22619 S. Performance Indicators Weightage in No. —% 2 | Debug, Test and Execute the programs = | 30 3__| Presentation of Output 20 |__| Able to Answer to oral questions 10 5 Submission of report in time { 10 Total _ 100 The above PrOs also comprise of the following social skills/attitudes which are Affective Domain Outcomes (ADOs) that are best developed through the laboratory/field based experiences: a) Work collaboratively in team. b) Follow ethical practices. ‘The ADOs are not specific to any one PrO, but are embedded in many PrOs. Hence, the acquisition of the ADOs takes place gradually in the student when s/he undertakes a series of practical experiences over a period of time. Moreover, the level of achievement of the ADOs according to Krathwohl’s ‘Affective Domain Taxonomy’ should gradually increase as planned below: © ‘Valuing Level’ in 1" year * ‘Organization Level’ in 2™ year. * ‘Characterization Level’ in 3" year. 7. MAJOR EQUIPMENT/ INSTRUMENTS REQUIRED The major equipment with broad specification mentioned here will usher in uniformity in conduct of practicals, as well as aid to procure equipment by authorities concerned. *., Equipment Name with Broad Specifications 1 | Hardware = Computer system |__| (Any computer system, preferably i3 - iS with basic configuration) All 2 | Operating system : Windows / Linux || 3__| Any database too! such as MySQL, MariaDB or any equivalent tool — | 15.16 8. _ UNDERPINNING THEORY COMPONENTS: The following topics/subtopics should be taught and assessed in order to develop UOs in cognitive domain for achieving the COs to attain the identified competency. More UOs could be added . Unit Unit Outcomes (UOs) ‘Topies and Sub-topies (in cognitive domain) Unit—1 | 1a Write simple PHP program | 1.1 History and Advantages of PHP, , Expression] to solve the given Syntax of PHP. sand expression 1.2. Variables, Data types, Expressions control | 1b Use relevant decision and operators, constants statements | making control statement to | 1.3. Decision making Control statements - in PHP solve the given problem if, if-else, nested if, switeh, break and le Solve the given iterative continue statement, = problem using relevant loop | 1.4 Loop control structures-while doz | statement. while , for an MSBTE — Final Copy Dt. 24.09.2019 Page 4 of 7Web Based Applicaton development ih PHP. Course Code: 22619 Unit “Gneogntive doma °° ‘Topies and Sub-topics Unit-I [2a Manipulate the given type | 2.1 Creating and Manipulating Array, Arrays, of arrays to get the desired Types of Arrays- Indexed , Funetions result. ‘Associative and Multi-dimensional and 2b Apply implode, explode arrays Graphies functions on the given array. | 2.2 Extracting data from arrays, implode, 2c Apply the given string explode, and array flip. functions on the character | 2.3 Traversing Arrays array. 2.4 Function and its types —User defined 2d_ Scale the given image using function, Variable function and graphics concepts! Anonymous function, function 2.5. Operations on String and String fanctions:str_word_count()strlen(),str rev(),strpos(),str_replace(), uewords(),strtoupper(), strtolower(),stremp(). 2.6 Basic Graphics Concepts, Creating Images, Images with text, Scaling Images, Creation of PDF document. Unit-T1 3a_ Write constructor and 3.1 Creating Classes and Objects Apply destructor functions for the | 3.2. Constructor and Destructor Object given problem in PHP. 3.3. Inheritance, Overloading and Oriented | 3b Implement inheritance to Overriding, Cloning Object. Concepts extend the given base class. | 3.4 Introspection, Serializati inPHP — |3c_ Use overloading / overriding to solve the given problem. 3d_Clone the given object. 7 Unit-IV [4a Use the relevant form 4.1 Creating a webpage using GUI Creating controls to get user’s input Components, Browser Role-GET and and 4b Design web pages using POST methods, Server Role validating | multiple Forms for the given | 4.2 Form controls: text box, text area, forms problem. radio button, check box, list, buttons 4c Apply the given validation | 4.3 Working with multiple forms : rules on form. - A web page having many forms 4d_ Set/ modify/ delete cookies ~ A form having multiple submit using cookies attributes. buttons. 4e Manage the given session | 4.4 Web page validation. using session variables. 4.5. Cookies - Use of cookies, Attributes of cookies, create cookies, modify cookies value, and delete cookies. 4.6 Session - Use of session, Start session, get session variables, destroy session. | 4.7 Sending E-mail. - Unit-V_[5a Create database for the | 5.1 Introduction to MySQL ~ Create a Database given problem using PHP database. Operation script. 5.2 Connecting to a MySQlL.-database : s 5b_ Insert data in the given MySQL database sever from PHP database using PHP script. | 5.3 Database operaffons: Insertdata,” Se Apply the specified update Retrieving the Query result\\ operation in database record_| 5.4 Update and delete operations on table MSBTE — Final Copy Dt. 24.09.2019 Page 5 of7 ws aWel Bascd Application development with PHP. Couree Code: 22619 Unit Outcomes (UOs) cognitive domain) using PHP script. data 5d_ Delete the given record from the database using __PHP script. ‘Topics and Sub-topies Note: To attain the COs and competency, above listed UOs need to be undertaken to achieve the ‘Application Level’ of Bloom’s ‘Cognitive Domain Taxonomy’ 9. SUGGESTED SPECIFICATION TABLE FOR QUESTION PAPER DESIGN is «|_Distribution of Theory Marks = Unit Title Teaching "RT ou [A ‘| Total 7 * | Levet_| Levet | Level | Marks i Expressions and control statements in 7 o | os 2 T_| Arrays, Functions and Graphics 10 @ 04 | 10 16 7 Apply Object Oriented Concepts in a 7 ‘ou | io i’ TV_| Creating and validating forms 12 @ [06 | 12 V_| Database operations 08 o | 04 | 08 14 [ Total 48. 10 1s | 42 | 70 Legends: R=Remember, U=Understand, A~Apply and above (Bloom's Revised taxonomy) Note: This specification table provides general guidelines to assist student for their learning and to teachers to teach and assess students with respect to attainment of UOs. The actual distribution of marks at different taxonomy levels (of R, U and A) in the question paper may vary from above table. 10, SUGGESTED STUDENT ACTIVITIES Other than the classroom and laboratory learning, following are the suggested student-related co-curricular activities which can be undertaken to accelerate the attainment of the various outcomes in this course: Students should conduct following activities in group and prepare reports of about 5 pages for each activity, also collect/record physical evidences for their (student’s) portfolio which will be useful for their placement interviews: a) Prepare journal of practicals. b) Undertake micro-projects. i. SUGGESTED SPECIAL INSTRUCTIONAL STRATEGIES (if any) ‘These are sample strategies, which the teacher can use to accelerate the attainment of the various learning outcomes in this course: a) Massive open online courses (MOOCs) may be used to teach various topies/sub topics b) ‘L’ im item No. 4 does not mean only the traditional lecture method, but different types of teaching methods and media that are to be employed to develop the outcomes. ©) About 15-20% of the topics/sub-topies which is relatively simpler or descriptive in nature is to be given to the students for self-directed learning and assess the development of the COs through classroom presentations (see_impeyaen guideline for details). d) With respect to item No.10, teachers need to ensure 10 create opportnn provisions for co-curricular activities. MSBTE - Final Copy Dt. 24.09.2019 Page 6 of 7 1Wb Based Applicaton development with PHP Course Code: 22619 e) Guide student(s) in undertaking micro-projects. 1) Demonstrate students thoroughly before they start doing the practice. 2) Encourage students to refer different websites to have deeper understanding of the subject. h) Observe continuously and monitor the performance of students in Lab. 12. SUGGESTED MICRO-PROJECTS, Only one micro-project is planned to be undertaken by a student that needs to be him/her in the beginning of the semester. In the first four semesters, the micro-proje: group-based. However, in the fifth and sixth semesters, it should be preferably be individually undertaken to build up the skill and confidence in every student to become problem solver so that s/he contributes to the projects of the industry. In special situations where groups have to be formed for micro-projects, the number of students in the group should not exceed three. The micro-project could be industry application based, internet-based, workshop- based, laboratory-based or field-based. Each micro-project should encompass two or more COs which are in fact, an integration of PrOs, UOs and ADOs. Each student will have to maintain dated work diary consisting of individual contribution in the project work and give a seminar presentation of it before submission. The total duration of the micro-project should not be less than 16 (sixteen) student engagement hours during the course. The student ought to submit micro-project by the end of the semester to develop the industry-oriented COs. ‘A suggestive list of micro-projects is given here. Similar micro-projects could be added by the concerned faculty a) Develop web application for- Sending plain text email, Sending HTML message, Sending e-mails with attachment b) Develop web application for Library Management system. ~ Add book , Display list of book , Search book ©) Develop web application for Student Feedback System. 4) Develop web application for Employee Pay Management System. (Any other micro-projects suggested by subject faculty on similar line.) 13,__ SUGGESTED LEARNING RESOURCES. No, | Title of Book Author Publication 1 | Programming PHP | Rasmus Lerdork, | O'Reilly, USA, ISBN -078-1-449- Kevin.T and Peter M. | 39277-2, 2013 2 | The Complete Holzner, Steven [McGraw hill, New Delhi, Reference PHP (Third ISBN 9780070223622, 2008 Edition covers PHP) _ 3 | PHP and MySQL MeGrath, Mike MoGraw Hill, New Delhi, ISBN- - __|13:978-1259029431 7 [Advance Web Di. Rajedta Kawle | Devraj Publication , ISBN 978-93- Technolog ft 86492-01-2 14, SORTWARE/LEARNING WEBSITES a) _https://www.w3schools.com/php/default.asp b) _hitps://www.guru99,com/what-is-php-first-php-program.html ©) _hitps://www.tutorialspoint.com/php/ 4d) _https://tutorialehtml.com/en/php-tutorial-introduction/ ©) wwwatizag.com/phpT/ 1) _hitps://books.goalkicker.com/PHPBook/ c.com/watch/php-ba: ~ Final Copy Dt. 24.09.2019 Page 7 of 7