Q
Which PHP function is used to sanitize user input to prevent SQL injection attacks?

Answer & Solution

Answer: Option C
Solution:
The mysql_real_escape_string() function is used to escape special characters in a string for use in an SQL statement. This helps prevent SQL injection attacks by escaping characters that could be used to manipulate the SQL query.
Related Questions on Average

What is the purpose of the explode() function in PHP?

A). To split a string into an array based on a specified delimiter.

B). To join array elements into a string using a specified delimiter.

C). To sort an array in ascending order.

D). To merge two or more arrays.

What is the purpose of the htmlspecialchars() function in PHP?

A). To convert HTML entities to their corresponding characters.

B). To remove HTML tags from a string.

C). To encode special characters in HTML format.

D). To decode special characters in HTML format.

Which PHP superglobal array is used to retrieve form data sent with the POST method?

A). $_POST

B). $_GET

C). $_REQUEST

D). $_SERVER

Which PHP function is used to handle file uploads?

A). upload_file()

B). process_upload()

C). handle_upload()

D). move_uploaded_file()

What is the purpose of the isset() function in PHP when handling form submissions?

A). To check if a variable is empty

B). To check if a variable is set and is not NULL

C). To check if a variable is numeric

D). To convert a variable to a string

How can you check if a checkbox is checked in PHP when submitted via a form?

A). isset($_POST['checkbox'])

B). $_POST['checkbox'] == 'checked'

C). $_POST['checkbox'] === 'checked'

D). empty($_POST['checkbox'])

What is the purpose of the isset() function in PHP when handling form submissions?

A). To check if a variable is empty

B). To check if a variable is set and is not NULL

C). To check if a variable is numeric

D). To convert a variable to a string

Which attribute of the HTML <form> element specifies the HTTP method to be used when submitting the form data?

A). method

B). action

C). type

D). enctype

Which PHP superglobal array is used to retrieve form data sent with the POST method?

A). $_POST

B). $_GET

C). $_REQUEST

D). $_SERVER

Which function is used to check if a variable is an array in PHP?

A). is_array()

B). check_array()

C). array_check()

D). isArray()