Page 14 - Computer Software Application TP - Volume 1

Ex. No. Table of Contents Page No.

33 Creating Cursors in MYSQL 107
34 Using Cursors in MySQL 110
35 Implementing MySQL Security 113

36 Simple application on database using SP, Triggers, Cursors & Indexing 115
Module 3: Introduction to Java Script

37 Using the JAVA Script Syntax 118
38 Using Variables, Operators and Writing Expressions 120
39 Programming with Control Flow statements 130

40 Creating and using Objects in JavaScript 141
41 Creating and using Functions 146
42 Using Java Script with Forms 151
43 Creating Cookies with JavaScript 155
44 Creating CSS 159

45 Error Handling in JavaScript 169
46 Implementing an AJAX application 173

Module 4: PHP (Hyper text pre processor)

47 Demonstrate on- Paginators, popovers, progress, spinner 175
48 Demonstrateon Table, toasts, tooltips 189

49 Demonstrate on Bootstrap Styling essentials like Breakpoints for
components, layouts and grid systems. Practice on typography, floats, flex,
alignment, borders, position of elements, shadow and visibility 198
50 Perform Installation of Apache Web Server Practice simple PHP
programs. Practicing on programming to test events 213
51 Demonstrate on if statement Using the else clause with if statement, switch
statement Using the? operator, while statement, do while statement, for
statement, Breaking out of loops, Nesting loops 226
52 Demonstrate on Function and returning value from function, user defined
functions, dynamic functions, variable scope, accessing variable with the
global statement, Function calls with the static statement, setting default
values for arguments, Passing arguments to a function by value,
Passing arguments to a function by reference, Testing for function existence 235
53 Demonstratethe Writing to the browser, Getting input from forms, Output
buffering, Session handling, Regular expression, Common math,
Random numbers, File upload, File download, Environment variables 244
54 Demonstrate on E-mail in PHP, anatomy of a cookie, setting a cookie
with PHP, deleting a cookie, creating session cookie, working with the
query string, creating query string, starting a session, Working with
session, variables, Destroying session, passing session IDs, Encoding and
decoding session variables 255

xi