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

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

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

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 address must be valid email addressc. Username must be start with string and followed by number.d. Password length must be more than 8 characters.

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

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.

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

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 and of three student Anshis, Jayanti, Niraj. Then display the average marks of each student.

What is difference between WordPress theme and template? Write the steps to add and edit pages in WordPress.

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 form into database using database connection and appropriate query.

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'.

What is Widgets? Explain different Features of CMS.

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

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, Mobile, doctor name, gender, dob: Required• Mobile: 10 digit start with 98,97 or 96• DOB: YYYY-MM-DD format

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