JNTU B.Tech IV Year PHP PROGRAMMING Previous Question Paper (June - 2024 - R16)

Define PHP.

Explain the purpose of PHP tags in a web page.

State the purpose of the rand() function in PHP.

Explain the difference between local and global scope in PHP variables.

State two examples of HTML form elements.

Explain the role of the action attribute in an HTML form. How does it affect form submission?

List and briefly explain three types of errors in PHP.

Define what exceptions are in PHP. How are they different from regular errors?

State two commonly used MySQL commands.

Explain the syntax of a basic MySQL query. What are the components of a SELECT statement?

Create a PHP script that calculates the sum of two numbers entered by the user.

Implement a PHP script that reads data from a MySQL database and displays it in a formatted table.

Develop a PHP program that checks if a given number is prime or not.

Write a PHP function that counts the number of occurrences of a specific word in a given string.

Create a user-defined PHP function that calculates the factorial of a given number. Demonstrate its usage with an example.

Design a PHP script that checks if a given username already exists in a MySQL database. If not, insert the username into the database.

Analyze the importance of data validation in form processing. How does it contribute to the security and integrity of web applications?

Evaluate the impact of file handling errors on the reliability of web applications. How can such errors be minimized through error handling techniques in PHP?

Explain how to create and delete folder with an example.

Describe about the validating the user input.

Create a PHP script that generates an image table dynamically based on user input.

Examine the significance of proper syntax in PHP scripts to avoid parse errors. How can developers ensure syntactic correctness?

Describe how emails can be sent using PHP. What functions are commonly used for this purpose?

Develop a PHP script that sets a cookie with user preferences and retrieves it on subsequent visits.

Create a MySQL query that retrieves all records from a table named “users”. Provide a brief explanation of each component of the query.

Create a MySQL query that deletes records from a table based on specified conditions, such as a certain value in a particular column. Provide an example scenario.

Design a MySQL query that joins two tables, “orders” and “customers”, based on a common field such as customer ID. Provide an explanation of the join type used.

Design a MySQL query that alters the structure of a table by adding a new column. Include the necessary syntax for the alteration.