Lab Manual

Sub Code: 14654

Lab Exercise:

1. Install Linux Server in Linux Environment
2. Set up a Local Area Network in Linux Environment
3. a Connect Internet in Linux Environment
   b Setting up a Print Server in Linux Environment
4. Setting up a Web server in Linux Environment
5. Generate a PHP script will display the multiples of the numbers 1 to 5 upto 5 times. The output should column format
6. a Display the week date of the current date of the machine serving PHP pages
   b Generate a list of possibility for two digit numbers consisting of numbers 0 to 5 using nested for loop
7. Generate a PHP script that will display the grade on the basis of marks as follows :
   * Distinction – 80 and above
   * First Class – From 60 to below 80
   * Second Class – From 45 to below 60
   * Pass Class – From 35 to below 45
   * Fail – Below 35
   
   Test the above program using the following set of values stored in an array : 67, 82, 23, 37, 57, and 97
8. a.Create a function to calculate 33% tax on the given salary Rs. 65,500.
   b. Generate Fibonacci series for the numbers 1 to 70.
9. Create a form to capture book details.
   * The HTML form should perform the following:
   * Capture the data such as the Book name, Author name, Publisher name,
   * Category and the Synopsis
   * Clears the form fields when reset button is clicked
   * Submit the captured data when submit button is clicked
10. Create a PHP code, which will retrieve the data captured by the HTML form, display the name of the form and also display the message Data Entered Successfully on the HTML form page after performing the following validations:
    * That the book name form field is not left blank
    * That the author name form field is not left blank
    * That the publisher name form field is not left blank
    * That the synopsis form field is not left blank
11. Develop a form to capture Personnel Information The HTML based form should perform the following:
    * Captures data such as name, date of birth, address, city, state and Email
    * Clear the form fields when the Clear button is clicked
    * Submit captured information, when Save button is clicked
12. Create a PHP file that will validate data captured by the form. This program uses regular expressions to validate and format data.
13. Create a table that will store valid book information.The structure of the MySQL table will be as follows.
    (i) Table Definition
    (ii) Column Definition (iii) Table Description
14. Create a Book Master form, which will allow
    (i) Inserting records in BookMaster
    (ii) Updating records that already exists in the BookMaster.
    (iii) Viewing records available in BookMaster.
    (iv) Deleting Records from BookMaster.
15. Using MySql , Create a table “Customer” with the following fields.
    i) Id
    ii) Company Name
    iii) Last Name
    iv) First Name
    v) Address
    vi) City
    vii) State
    viii) Pin Code
    
    Perform the following Operations
    i) Change the pin code of any customer
    ii) Insert a new record into the table
    iii) Update the field’s First name and LastName into name.
    iv) Find the customer who does not have a last name
16. Install a Apache Web server
17. Setting up and configuring PHP to work under Apache web server
18. Testing the PHP/Apache web server setup