BCA Semester 4 – Scripting Language – Unit 2: Server Side Scripting with Database Connectivity (15Hrs.)

Question 1

Explain the two HTTP functions to accept the user values from interface with suitable PHP program

Marks: 5

Year: 2020 Final TU FOHSS

1. Introduction: In PHP, user input from an HTML interface (form) is accepted using HTTP methods. The two main HTTP functions (methods) used are GET and POST. --- 2. HTTP GET Method Explanation -

Question 2

What is CMS, Write the steps to create submenu in WordPress or Joomla?

Marks: 5

Year: 2020 Final TU FOHSS

1. Definition of CMS: A Content Management System (CMS) is a software application that allows users to create, manage, and modify digital content on a website without needing to write code. Key Fe

Question 3

Design following forms in HTML and write corresponding PHP and MySQL code to store the user's values after satisfying following validation rules.a. Length of Full name up to 40 charactersb. Email addr

Marks: 10

Year: 2020 Final TU FOHSS

Validation Rules: a. Full name length ≤ 40 characters b. Valid email address c. Username must start with letters followed by numbers d. Password length > 8 characters --- 1. HTML Form html <

Question 4

Explain an array using suitable example and discuss how foreach loop accessing of elements is stored in an array using PHP.

Marks: 5

Year: 2021 Final TU FOHSS

1. Definition of Array An array in PHP is a special variable that can store multiple values under a single name. - Each value in an array is called an element. - Arrays can be indexed (numeric key

Question 5

Design following form in HTML and write corresponding PHP and SQL code for CRUD operations based on user's data.Assume your own database and database connectivity related constraints if necessary.

Marks: 10

Year: 2021 Final TU FOHSS

1. HTML Form for User Data html <!DOCTYPE html> <html> <head> <title>User Management Form</title> </head> <body> <h2>User Registration / Management Form</h2> <form method="post" action="crud.ph

Question 6

What do you mean by super global variable in PHP? How to read and write CSV file in PHP explain with suitable example.

Marks: 5

Year: 2023 Final TU FOHSS

1. Super Global Variable in PHP Definition Superglobals are built-in PHP variables that are available in all scopes throughout a script. - They can be accessed inside functions, classes, or any par

Question 7

What is an associative array? Write a PHP program to create a multidimensional array that holds the marks of five subject like Operating system, Scripting, Numerical method, DBMS, Software Engineering

Marks: 5

Year: 2023 Final TU FOHSS

1. Definition of Associative Array An associative array in PHP is an array where keys are named instead of numeric indices. - It allows storing data with meaningful keys. - Example: php $student =

Question 8

Design a HTML registration form containing text box for Name and Email, radio button for gender, selection list for education field. Write a PHP script to validate input and then store data from the f

Marks: 10

Year: 2023 Final TU FOHSS

1. HTML Registration Form html <!DOCTYPE html> <html> <head> <title>Registration Form</title> </head> <body> <h2>Registration Form</h2> <form action="register.php" method="post"> Name: <inpu

Question 9

Write PHP function that accepts username and password as arguments and check with student table, if credential match, redirect to dashboard page otherwise display 'Invalid username/password'.

Marks: 5

Year: 2024 Final TU FOHSS

PHP Program php <?php // Database connection $servername = "localhost"; $username = "root"; $password = ""; $dbname = "schooldb"; $conn = new mysqli($servername, $username, $password, $dbname); // Che

Question 10

Write rules to create variable in PHP. How to create, store, access and destroy session in PHP?

Marks: 5

Year: 2024 Final TU FOHSS

1. Rules to Create Variables in PHP 1. Start with $: All variable names start with the dollar sign $. 2. Followed by a letter or underscore: $name, $age 3. Case-sensitive: $Name and $name are differen

Question 11

Write server side script to create and validate form with following rule and store given data into 'patients' table with details (name, patientid, mobile, gender, address, dob, doctor name)• Name, Mob

Marks: 10

Year: 2024 Final TU FOHSS

1. HTML Form (patientsform.html) html <!DOCTYPE html> <html> <head> <title>Patient Registration</title> </head> <body> <h2>Patient Registration Form</h2> <form action="patientsregister.php" meth

Question 12

Write a Program to create Chess board in PHP using loop.

Marks: 5

Year: 2022 Final TU FOHSS

1. Definition / Concept A Chess board has 8 rows and 8 columns with alternating black and white squares. - PHP can generate this dynamically using nested loops. - HTML <table> is used for renderin