Spring 2020: PHP Programming Lab

• Instructions
  1. Please be on time to avoid the attendance penalty.
  2. Turn off(shutdown) your assigned computer after finishing your work (or before you leave the lab).
  3. Please arrange the chairs in proper place while leaving the lab.
  4. Please put your phone in silent mode.

Lab 1: Getting Started ( week of 6th/7th January 2020 )

• Brief introduction to PHP [Download]

Q. NO.	Program	Lab Exercise No.	Remarks
1	WAP to print first n even numbers	Practice Set No. 13
2	WAP to find sum of first n odd numbers	Practice Set No. 14
3	WAP to check whether the given number is prime or not	Practice Set No. 12
4	WAP to print the following pattern using nested for loop: * * * * * * * * * *	Practice Set No. 17
5	WAP to sort an array using built in PHP function	Lab Exercise No. 2

Lab 2: ( week of 13th/14th January 2020 )

• Arrays, Strings and Functions in PHP [Download]

Q. NO.	Program	Lab Exercise No.	Remarks
1	Create a PHP page using functions for comparing three integers and print the largest number (function with arguments, function without arguments, function returning value)	Practice Set No. 10
2	Write a function to calculate the factorial of a number(non-negative integer). The function accepts the number as an argument	Practice Set No. 11
3	Write a PHP script that checks whether a passed string is palindrome of not? (A Palindrome is word, phrase, or sequence that reads the same backward as forward. For example: mom, dad, madam, Step on no pets, nurses run	Practice Set No. 15
4	$color = array("white","green","red") Write a PHP script which will display the colors in the following way: Output: white, green, red, green red white	Lab Exercise No. 5
5	Write a PHP script which will perform string manipulations using in-built functions.	Practice Set L2

Lab 3: ( week of 20th/21st January 2020 )

• Introduction to PHP Form Handling [Download]

Q. NO.	Program	Lab Exercise No.	Remarks
1	Create a form which collects data like Name, Roll Number, Course, Address. Using a submit button send it for processing to a PHP file named "mydata.php". Use HTTP POST method to send the form-data and finally display the submitted data.	Practice Set No. L3
2	Create the same form as Q.NO. 1, and submit using HTTP GET method.	Practice Set No. L3 (2)
3	Create a PHP page which accepts string from user. After submission that page displays the reverse of provided string.	Lab Exercise No. 1
4	Write a PHP program to print Fibonacci series using recursion.	Practice Set No. 16

Lab 4: ( week of 27th/28th January 2020 )

• To get select data [Download]
• To get radio data [Download]
• To get checkbox data [Download]
• Sample Form for Q. NO. 1 [Form][Code]

Q. NO.	Program	Lab Exercise No.	Remarks
1	Create a form with elements/controls like text, textarea, select, radio button, checkbox, etc. Read the form data, submit it on the same page and display the submitted data.	Practice Set No. L4
2	Create the same form as Q.NO. 1, read the form data in another form named formProcess.php using GET/POST method.	Practice Set No. L4 (2)
3	Using switch case and dropdown list display a “Hello” message depending on the language selected in drop down list.	Lab Exercise No. 6
4	Create a simple "birthday countdown" script, the script will count the number of days between current day and birth day.	Lab Exercise No. 4

Lab 5: ( week of 03rd/04th February 2020 )

• Read PHP Date and Time from w3schools
• Read PHP Regular Expressions geeksforgeeks

Q. NO.	Program	Lab Exercise No.	Remarks
1	Use date function to perform following: Display date in the different formats(mm-dd-yyyy, mm.dd.yyyy, mm:dd:yyyy, yyyy/mm/dd, etc) Display time in the different format (12-hour, 24-hour) Display your birthday using mktime() function Create a Date from a String With strtotime() Display dates for the next 10 PHP Lab	Practice Set No. L5
2	Create a simple "birthday countdown" script, the script will count the number of days between current day and birth day using PHP date and time functions.	Lab Exercise No. 4
3	Write a menu driven PHP script that: a. Removes the whitespaces from a string. Sample string: ‘The quick ” ” brown fox’ Expected Output: Thequick'”‘brownfox [ Hint: str_replace(find,replace,string,count) ] b. Checks if a string contains another string. (using built in php functions) c. Checks if a string is all lower case. (using regex) d. Replace the first 'the' of the following string with 'That'. Sample: 'the quick brown fox jumps over the lazy dog.' Expected Result: That quick brown fox jumps over the lazy dog.	Lab Exercise No. 3	Regular Expressions Cheatsheet [1][2]

Lab 6: ( week of 10th/11th February 2020 )

• Complete all the previous assignments(1-5)
• Revisit MySQL concepts from NTU Tutorial

Lab 7: ( week of 17th/18th February 2020 )

Q. NO.	Program	Lab Exercise No.	Remarks
1	Create a MySQL Database named myDB Using MySQLi/PDO	Practice Set No. L7	Creating a Database [3]
2	Create a MySQL Table name myUsers Using MySQLi/PDO in myDB database with following attributes: username password use appropriate data types, size, and constraints	Practice Set No. L7(2)	Creating a table [4]
3	Insert five records in myUsers table Using MySQLi/PDO (duplicate atleast 1 username in the record)	Practice Set No. L7(3)	Adding data into a table [5]
4	Create a login page having user name and password. On clicking submit, a welcome message should be displayed if the user is already registered (i.e. name is present in the database) otherwise error message should be displayed.	Lab Exercise No. 7	Select data from a table [6]

Lab 8: ( week of 24th/25th February 2020 )

Q. NO.	Program	Lab Exercise No.	Remarks
1	Write a PHP program to check that the entered email id of the form username@domainname is valid and the domain name is present in the database table.	Lab Exercise No. 8	use regular expression to test for valid email id

Lab 9/Lab10: ( week of 02nd/03rd March)

• Complete all the previous assignments(1-8)

Final Lab

Q. NO.	Program	Lab Exercise No.	Remarks
1	Create a database table containing the marks of students in three subjects along with their roll number and name. Create a PHP page to display the mark sheet of the student along with the grade obtained.	Lab Exercise No. 9	Select data from database and put result in HTML table [7]