Q
Which PHP function is commonly used to sanitize input data from a form to prevent SQL injection?

Answer & Solution

Answer: Option A
Solution:
The mysqli_real_escape_string() function in PHP escapes special characters in a string to prevent SQL injection attacks when inserting data into a MySQL database.
Related Questions on Average

What is the purpose of using HTTPS (HTTP Secure) in web applications?

A). Encrypting Data

B). Authenticating Users

C). Preventing XSS Attacks

D). Optimizing Page Load Speed

What does XSS stand for in the context of web security?

A). Cross-Site Scripting

B). XML Secure Socket

C). External Server Session

D). Cross-Site Sanitization

What is the purpose of session management in web applications?

A). Maintaining User State

B). Encrypting Data

C). Preventing SQL Injection

D). Validating Form Data

Which of the following HTTP methods is considered safe and idempotent, making it suitable for form submissions?

A). POST

B). GET

C). PUT

D). DELETE

What security mechanism prevents Cross-Site Request Forgery (CSRF) attacks by generating and validating unique tokens for each form submission?

A). CSRF Token

B). Session Management

C). Secure Cookies

D). HTTPS

Which PHP function is commonly used to check if a form field is empty?

A). empty()

B). isset()

C). is_empty()

D). is_null()

Which HTTP header instructs web browsers to limit the scope of cookies to a specific domain?

A). SameSite

B). Cache-Control

C). Access-Control-Allow-Origin

D). Content-Security-Policy

Which PHP function is commonly used to sanitize input data from a form to prevent XSS attacks?

A). htmlspecialchars()

B). htmlentities()

C). strip_tags()

D). filter_var()

What security measure helps prevent form spamming by distinguishing between human users and bots?

A). CAPTCHA

B). HTTPS

C). CSRF Token

D). Two-Factor Authentication

What is the primary purpose of form data validation in web applications?

A). Enhancing user experience

B). Preventing security vulnerabilities

C). Optimizing server performance

D). Improving search engine ranking