Notes

Basics:
=======
1.Create a php file with plain text to print "Welcome to PHP".(File should be saved as plaintext.php)
2.Create a html file with html basic tags to print "Hi, Have a Nice Day!".(File should be saved as greeting.html)
3.Create a php file with html basic tags to print "Welcome to PHP".(File should be saved as htmlasphp.php)
4.Create a php file with PHP executable statement to print "Hello World". (File should be saved as welcomenote.php)
5.Create a php file with PHP executable statement to print "Hello World" in Heading size1. (File should be saved as formattedwelcome.php)
6.Create a php file with the combination of plain text,html tags and PHP executable statements.(File should be saved as mixed.php)


Form Methods:
=============
1.Create a HTML form to get the input values for name,gender and location of the user.[details.php]
2.Create a PHP file to show the details received from the form of the previous question.(Using GET method)[showdetails.php]
3.Create a HTML form to get the username,password from the user and write a PHP code to display the same.(Using POST method)[loginform.php & display.php]
4.Create a HTML form to get the feedback from the user and write a PHP script to display it.(Form should have name,email ID and comment)[feedbackform.php & feedback.php]
5.Create a registration form for students to join in a school sports club. Write up a PHP code to display the student's details given by the user through the previous form in the given format.[registrationform.php & showinfo.php]


Operators & Control Statements:
==============================
Create the webpages for the following tasks as needed.

1.Get the age from the user and check for their eligibility to vote.(A person is eligibile to vote if he/she is more than 18 yrs old )
2.Get a number from the user and check the given number is odd or even.
3.Generate an odd number series or even number series based on the given number.
4.Check for valid triangle by getting the angles from the user.(A triangle is valid if the sum of all angles are 180 degree)
5.Get the cost and selling price from the user and say the profit/loss amount as a result.
6.Get the number of power units from user and calculate the EB charge.
Units Consumed Charges per unit (in Rupees)
0-100 1.25
100-200 2.50
200-300 3.75
>300 4
7.Get a number from the user and provide the multiplication table for the same as follows.
5 x 1 = 5
5 x 2 =10 ...
8.Get a number from the user and provide the multiplication tables of all the numbers till the given number.
9.Get the no.of rows and the type of the triangle from the user and provide the same with ' * '.
(Type: Floyd's , Pascal)
Floyd's:(4)
*
* *
* * *
* * * *
Pascal:
*
* *
* * *
* * * *
10.Get a number from the user and give a greeting note if the given number is a numeric palindrome.
11.Find the greatest in three given numbers.
12.Find the second greatest in three given numbers.
13.Get a number from the user and print 1 to the given number in reverse order.
14.Get any number from 1 - 20 and print from 1 to 20 missing the choosen number.
15.Write a program to fetch the two values and perform the arithmetic action based on user selection (define arithmetic actions in combo/select box).
16.Write a program to accept the student name and three marks from the user and calculate the total, average and grade.

Arrays:
=======
1.Write a program to find out the sum of the array.
2.Write a program to find the greatest and the smallest element of the given array.
3.Write a program to swap two numeric arrays.
4.Write a program to check whether the given numeric array elements are in Arithmetic Progression or not.
5.Write a program to display only the keys of an associative array.
6.Write a program to check whether the given key is available in the associative array.



Strings:
========

Create a webpage to get the username and the password from the user.(login.php)

1.Welcome the user if the user name and the password are same in size.(valid1.php)
2.Welcome the user if the username and the password are same.(valid2.php)
3.Welcome the user if the password is the uppercase of the username.(valid3.php)
4.Welcome the user if password contains '@'.(valid4.php)
5.Welcome the user if password is the reverse of the username.(valid5.php)
6.Edit the form to get the department name from the user and welcome the user if the password is of the following format.(username@dept)(valid6.php)
Username:John
Dept:CT
Password:John@CT
7. Get the email address(email.php) from the user and tell them back their mail server's domain name .(domain.php)
Eg:[email protected] => gmail

Note:Generate a warning message for all the tasks if required.

MySQL - Queries:
================
I) Create a table EMPLOYEES with following fields

EMPNO ENAME JoB Hiredate MGR Sal Comm Deptno


II)
Insert the following in EMPLOYEES Table.

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO

---------- ---------- --------- ---------- --------- ---------- ---------- ------

7369 SMITH CLERK 7902 17-DEC-80 800 20

7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30

7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30

7566 JONES MANAGER 7839 02-APR-81 2975 20

7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30

7698 BLAKE MANAGER 7839 01-MAY-81 2850 30

7782 CLARK MANAGER 7839 09-JUN-81 2450 10

7788 ALLEN ANALYST 7566 19-APR-87 3000 20

7839 KING PRESIDENT 17-NOV-81 5000 10

7844 SCOTT SALESMAN 7698 08-SEP-81 1500 0 30

7876 ADAMS CLERK 7788 23-MAY-87 1100 20

7900 JAMES CLERK 7698 03-DEC-81 950 30

7902 FORD ANALYST 7566 03-DEC-81 3000 20

7934 MILLER CLERK 7782 23-JAN-82 1300 10




III)


1.Display the dept information from department table.
2.Display the details of all employees.
3.Display the name and job for all employees.
4.Display name and salary for all employees.
5.Display employee number and total salary for each employee.
6.Display employee name and annual salary for all employees.
7.Display the names of all employees who are working in department number 10.
8.Display the names of all employees working as clerks and drawing a salary more than 1500.
9.Display employee number and names for employees who earn commission.
10.Display names of employees who do not earn any commission.
11.Display the names of employees who are working as clerk , salesman or analyst and drawing a salary more than 3000.
12.Display the names of employees who are working in the company for the past 5 years.
13.Display the list of employees who have joined the company before 30th june 90 or after 31 st dec 90.
14.Display the names of all tables from the current user.
15.Display the names of employees working in department number 10 or 20 or 40 or employees working as clerks , salesman or analyst.
16.Display the names of employees whose name starts with alphabet S.
17.Display employee name from employees whose name ends with alphabet S.
18.Display the names of employees whose names have second alphabet A in their names.
19.Display the names of employees who are not working as managers.
20.Display the names of employees who are not working as SALESMAN or CLERK or ANALYST.
21.Display all rows from emp table.
22.Display the total number of employees working in the company.
23.Display the total salary and total commission to all employees.
24.Display the maximum salary from emp table.
25.Display the minimum salary from emp table.
26.Display the average salary from emp table.
27.Display the maximum salary being paid to CLERK.
28.Display the maximum salary being paid in dept no 20.
29.Display the minimum salary being paid to any SALESMAN.
30.Display the average salary drawn by managers.
31.Display the total salary drawn by analyst working in dept no 40.
36.Display the names of employees in order of salary i.e. the name of the employee earning.
37.Display the names of employees in descending order of salary lowest salary shoud appear first.
38.Display the details from emp table in order of emp name.
39.Display empnno,ename,deptno and sal. Sort the output first based on name and within name by deptno and witdhin deptno by sal.
40.Display the name of employees along with their annual salary(sal*12). The name of the employee earning highest annual salary should appear first





Redirection:
============
1.Accept the username and password from the user and send them to the welcome page if the user is already exists else send back to the login page.
2.Accept the user's age then direct the user to different pages based on their age of a movie gallery.