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

Which PHP function is used to redirect the user to another page?

A). redirect()

B). header()

C). forward()

D). location()

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()

What function is used to check if a file upload operation was successful in PHP?

A). file_exists()

B). is_uploaded_file()

C). move_uploaded_file()

D). file_upload_successful()

What type of attribute is used in an HTML form to specify where to send the form data?

A). method

B). action

C). type

D). name

How can you access the value of a form field named 'username' submitted via the POST method in PHP?

A). $_GET['username']

B). $_POST['username']

C). $_REQUEST['username']

D). $_SERVER['username']

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 superglobal array is used to retrieve form data sent with the POST method?

A). $_POST

B). $_GET

C). $_REQUEST

D). $_SERVER

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

A). To remove whitespace from the beginning and end of a string.

B). To truncate a string to a specified length.

C). To convert a string to lowercase.

D). To convert a string to uppercase.

What type of attribute is used in an HTML form to specify where to send the form data?

A). method

B). action

C). type

D). name

What function is used to validate email addresses in PHP?

A). validate_email()

B). filter_var()

C). check_email()

D). email_validate()