AWT

Slip1

1)Write a PHP program to create a simple calculator that can accept two numbers and perform operations like add, subtract, multiplication and divide (using Self Processing form)

                                                                                                                                               

2)Write class declarations and member function definitions for following

 employee(code, name, designation). Design derived classes as

 emp_account(account_no, joining_date) from employee and

 emp_sal(basic_pay, earnings, deduction) from emp_account.

Write a PHP Script to create 5 objects (pass detailsusing parameterized constructor)    andDisplay details of Employees who having Maximum and Minimum Salary.

Slip2

1)A college has given roll number to each student, The roll number is six digit number where first two digits are faculty(B.Sc., BCA, BA) third digit is year (Ist(1), IInd(2) and IIIrd(3)) and last three digit are actual number. Write PHP script to accept a number and print faculty, year and roll number of student.(e.g Rollno=BC1004,faculty=BCA, year=1^st,rollno=004)

2)Define aninterface which has methods area(), volume(). Define constant PI. Create aclass cylinder which implements this interface and calculate area and volume.(Use define())

 Slip3

1)Write a PHP script to demonstrate the introspection for examining class(use function get_declared_classes() ,get_class_methods() and get_class_vars()).

                                                                                                                                               

2) Derive aclass square from class Rectangle. Create one more class circle. Create aninterface with only one method called area (). Implement this interface in allthe classes. Include appropriate data members and constructors in all classes.Write a program to accept details of a square, circle and rectangle and displaythe area.

Slip4

1)Write a Calculator class that can accept two values, then add them, subtract them, multiply them together, or divide them on request. For example:

$calc = new Calculator( 3, 4 );

echo $calc- >add(); // Displays “7”

echo $calc- >multiply(); // Displays “12”                                                                   

2)Create a login form with a username and password. Once the user logs in, thesecond form should be displayed to accept user details (name, city, phoneno).If the user doesn’t enter information within a specified time limit, expire hissession and give a warning otherwise Display Details($_SESSION).     

Slip5

1) Write an PHP script to search customer name from customer.dat file(Use AJAX concept)

2)Define a class Employee having privatemembers – id, name, department, salary. Define parameterized constructors.Create a subclass called “Manager” with private member bonus. Create 6 objectsof the Manager class and display the details of the manager having the maximumtotal salary (salary + bonus).   

Slip6

1)Write a PHP Script create login form and validate it (Use database and Sticky form concept)                                                                                                                                                    

2) Write a PHP Script to create a super class Vehicle having members Company and price. Derive 2 different classes LightMotorVehicle (members – mileage) and HeavyMotorVehicle (members – capacity-in-tons). Define 5 Object of each subclass and display details in table format      

Slip7

1) Create a form to accept employee details like name, address and mobile number. Once  the employee information is accepted, then accept LIC information like policy_no, name, premium. Display employee details and LIC details on next form.(use COOKIE)                         

2) Create employee table as follows

Bus(bno, bname, source, designation ).

 Write Ajaxprogram to select the bus name and print the selected bus details.

Slip8

1 )Write a script to keep track of number of times the web page has been accessed

(use $_COOKIE).

2)Write Ajax program to carry out validation for ausername entered in textbox. If the textbox is blank, print ‘Enter username’.If the number of characters is less than three, print’ Username is too short’.If value entered is appropriate the print ‘Valid username’.    

Slip9

1)Create an abstract class Shape with methods calc_area( )  and calc_volume( ). Derive three classes Sphere(radius) , Cone(radius, height) and Cylinder(radius, height), Calculate area and volume of all. (Use Method overriding).                    

2) Write an Ajax program to print the content of themyfile.dat. This code asks the user to click a button, fetches data from theserver using Ajax techniques and displays that data in the same web page as thebutton without refreshing the page                 

Slip10

1) Write a PHP script to accept username and password. If in the first three chances, username and password entered is correct, then display second form, otherwise display error message.

(Use Session)                                                                                                                                     

2)Create a form to accept student information (name,class, address). Once the student information is accepted, accept marks in nextform (Java, PHP, ST, IT, pract1, and project). Display the mark sheet for thestudent in the next form containing name, class, marks of the subject, totaland percentage(Use $_COOKIE).  

Slip11

1)Write PHP script to create a CD catalog using XML file. 

2)Write a program to create a shopping mall. Usermust be allowed to do purchase from three pages. Each page should have a pagetotal. The fourth page should display a bill, which consists of a page total ofwhatever the purchase has been done and print the total. (Use $_SESSION).

Slip12

1). Write a PHP script for the following: Design a form to accept a number from the user. Perform the operations and  show the results.

1)      Factorial of a number using Recursion.

2)      Add the digits of that number to reduce it to single digit.

(use the concept of self processing page.)                                                                                                                                              

2) Create student  table as follows

Student(sno, sname, per).

 Write Ajaxprogram to select the student name and print the selected student’s details.                

Slip13

1)Write a PHP script using AJAX concept, to develop user-friendly and interactive search engine (like a google search engine)                                                                                    

2) Considerer the following entities and their relationships

Student (Stud_id,name,class)

Competition (c_no,c_name,type)

Relationship between student and competition is many-many with attribute rank and year.

 Create a RDB in3NF for the above and solve the following. Using above database write a scriptin PHP to accept a competition name from user and display information ofstudent who has secured 1st rank in that competition.     

Slip14

1) Create student registration form and display details in the next page. (Use sticky form concept).                                                                                                                                  

2)Write Ajax program to print Movie details by selecting an Actor’s name.

Create table MOVIE and ACTOR as follows with 1 : M cardinality

MOVIE(mno, mname, release_yr) and ACTOR(ano, aname)    

Slip15

1) Write a PHP Script to Upload the file and display its information.(use $_FILES).                                                                                                                                                                     

2)Write Ajax program to fetch suggestions when isuser is typing in a textbox. (eg like Google suggestions. Hint create array of suggestionsand matching string will be displayed)  

Slip16

1) Write a PHP Script to display Server information in table format (Use $_SERVER).                                                                                                                                                                

2)Write Ajaxprogram to get book details from XML file when user select a book name. CreateXML file for storing details of book(title, author, year, price).

                                                                                                                                               

Slip17

1) To create form that accept the user details. write php program to capitalize of first letter of each name and check user email address contain @ symbol.                                                                                                                                                                                                                       

2)Write a PHP program to accept username and password from the user. Validate it against the login table in the database. If there is a mismatch between username and password, then, display the error message as ―invalid user name and password; else display the message as ―Login successful‖ on the browser.        

Slip18

1) Create a XML file which gives details of books available in “ABC Bookstore” from following categories

1) Technical

                        2) Cooking

                        3) YOGA                                                                                                      

2)Write a PHP program to implement Create, Read,Update and Display operations on Teacher table with attributes(tid, tname,address, subject). (Use Radio Buttons)           

Slip19

1) Write a PHP script to accept a string and then display each word of string in reverse order.       (use concept of self processing form)                                                                          

2)Consider the following relational database:

Project (P_Group_No, Project_Title)

Student (Seat no, Name, Class, P_Group_No)

Write a PHPscript to accept project title and display list of students those who areworking in a particular project.

Slip20

1) Write PHP program to select list of subjects (use multivalued parameter) displays on next page.(Use listbox to select subject) 

                                                                                                                                               

2)Consider the following entities and their relationships

Emp (emp_no,emp_name,address,phone,salary)

Dept (dept_no,dept_name,location)

Emp-Dept are related with one-many relationship

Create a RDB in 3NF for the above and solve following

Using above database write a PHP script which will

a)      Insert employee records in table .

b)      Print a salary statement in the format given below, for a given department. (Accept department name from the user).

Maximum Salary	Minimum Salary	Sum Salary

 Slip21

1)Write a PHP program to accept two string from user and check whether entered strings are matching or not.(use sticky form concept)

                                                                                                                                               

2)Consider the following entities and their relationships

Doctor (doc_no, doc_name, address, city, area)

Hospital (hosp_no, hosp_name, hosp_city)

Doctor and Hospital are related with many-many relationship

Create a RDB in 3 NF for the above and solve following

     Using above database, write a PHP scriptwhich accepts hospital name and   printinformation about doctors visiting / working in that hospital in tabular format                                                                                                                                                             

 Slip22

1) Write a script to keep track of number of times the web page has been accessed.(Use $_SESSION[ ] )                                                                                                                                                                                                                                                                                    

2)Consider the following entities and their relationships

     Movie (movie_no, movie_name, release_year)

     Actor (actor_no, name)

Relationship between movie and actor is many – many with attribute rate in Rs. Create a RDB in 3 NF for the above and solve following Using above database, write PHP scripts for the following:

(Hint: Create HTML form having two radio buttons)

aa)  Accept actor name and display the names of the movies in which he has acted.

bb)Insert new movie information

Slip23

1). Write a PHP script to generate an XML in the following format

<?xml version = “1.0” ?>

<BookStore>

            <Books>

                        <PHP>

                                    <title>Programming PHP</title>

                                    <publication>O’RELLY</publication>

                        </PHP>

                        <PHP>

                                    <title>Beginners PHP</title>

                                    <publication>WROX</publication>

                        </PHP>

            </Books>

</BookStore>                                                                                                                                                                                                                                                                                

2) Consider the following entities and their relationships

BillMaster(billno, custname, billdate )

BillDetails(itemname, qty, rate, discount)

BillMaster and BillDetails are related with one-to-many relationship.

 Create a RDB in 3 NF for the above and solve following

Write PHP script to print the bill in following format Accept the Bill number from user.

        BillNo :                                                               BillDate :

        Customer Name :

Sr. No.	Particular	Quantity	Rate	Discount	Total

Slip24

1) Write a simple PHP program which implements Ajax for addition of two numbers.                        

 2) Create  an application that reads “Book.xml” fileinto simple XML object. Display attributes and elements(Hint: usesimple_xml_load_file() function)

Slip25

1)Write PHP script to demonstrate the concept of introspection for examining object.                                                                                                                                                                   

2)Create a XML file which gives details of books available in “ABC Bookstore” from following categories.

1) Technical

                        2) Cooking

                        3) Yoga

and elements in each category are in  the following  format

<Book>

                   <Book_PubYear>            --------------</Book_PubYear>

                   <Book_Title>       --------------</Book_Title>

                   <Book_Author>   ---------------</Book_Author>

</Book>

Save the file as “Book.xml”

Create an application that reads “Book.xml” file into simple XML object. Display attributes and elements.

(Hint: Use simple_xml_load_file() function)             

Slip26

1). Write a PHP script to accept student details(rno, name, class) and store them in student table (Max 10) , print them  in sorted order of name on the browser in table format .                                                                                                                                                                                

2) Write a script to solve following questions (Use “Book.xml” file)

a) Create a DOM Document object and load this XML file.

b) Get the output of this Document to the browser

c) Save this [. XML] document in another format i.e. in [.doc]

           d) Write a XML program to print thenames of the books available in “Book.xml” file.      

Slip27

1) Write an Ajax program to display list of games stored in an array on clicking OK button.          

                                                                                                                                               

2) Write a script to create “cricket.xml” file with multiple elements as shown below:

 <CricketTeam>

           <Team country=”India”>

                       <player>____</player>

                       <runs>______</runs>

                       <wicket>____</wicket>

                 </Team>

             </CricketTeam>

 Write a script to add multiple elements in“cricket.xml” file of category, country=”Australia”.

Slip28

1) Change the preferences of your web page like font style, font size, font color, background color using cookie. Display selected settings on next web page and actual implementation (with new settings) on third web page. 

                                                                                                                                               

2) Write a PHP script to accept an .XML file which should comprise the following:

<cricket>

<player>abc</player>

<runs>1000</runs>

<wickets>50</wickets>

<noofnotout>10</noofnotout>

</cricket>

For at least 5 players.

Display thedetails of players who have scored more than 1000 runs and at least 50 wickets.

Slip29

1)Write a script to create XML file named “Course.xml”

<Course>

<Computer Science>

<Student name>.......</Student name>

<Class name>......</Class name>

<percentage>.....</percentage>

</Computer Science>

</Course>

Store the details of 5 students who are in TYBCA.  

2)Write a PHPscript using AJAX concept, to check user name and password are valid or Invalid(use database to store user name and password).

Slip30

1)Write a PHP Script to display response header information for any text file using $_http_response_header.

                                               

2)Write a script to create “vehicle.xml” file with multiple elements as given below

<Vehicle>

<Type = Two Wheeler>

<Vehicler Name >-------- </Vehicle Name >

<Company >--------- </Company>

<Color>--------</Color>

<Average>------</Average>

</Type>

</Vehicle>

Also add Type = “Four Wheeler” and its elements