To merge two or more arrays into a single array, you would use the ________ function in PHP.
- mergeArrays()
- array_combine()
- array_merge()
- combineArrays()
In PHP, the array_merge() function is used to merge two or more arrays into a single array. This is a common operation when working with arrays in PHP, allowing you to combine data efficiently.
What is the primary advantage of using prepared statements in PHP?
- Improved code readability
- Enhanced code reuse
- Better performance
- Protection against SQL injection
The primary advantage of using prepared statements in PHP is protection against SQL injection. They separate SQL code from user data, preventing malicious attacks.
You have a long string containing multiple words and you need to extract each word as an individual item in an array. Which PHP function would be most suitable for this task?
- explode()
- implode()
- split()
- preg_split()
The explode() function in PHP is used to split a string into an array based on a specified delimiter. This is ideal for separating words in a long string into individual array items.
In PDO, the placeholders used in prepared statements can be either named or ________.
- Indexed
- Positional
- Indexed or Positional
- Named
In PDO, placeholders in prepared statements can be either named (e.g., :name) or positional (e.g., ?). Both are valid ways to bind values.
Which PHP function is used to set a cookie?
- setCookie()
- createCookie()
- sendCookie()
- cookie()
The correct function is setCookie(). It is used in PHP to set cookies on the client's browser. Cookies are often used for tracking user preferences or maintaining session data.
The PHP function that merges the elements of one or more arrays together so that the values of one are appended to the end of the previous one is ________.
- array_merge
- array_combine
- array_push
- array_merge_recursive
The correct function is 'array_merge.' This function takes multiple arrays and combines them, appending the values of one array to the end of the previous one.
What is the main difference between the strcmp() and strcasecmp() functions in PHP?
- strcmp() compares case
- strcmp() is for binary
- strcmp() returns 0 on
- strcmp() is for
The main difference is that strcmp() is case-sensitive and returns 0 when two strings are equal, while strcasecmp() is case-insensitive and still returns 0 on equality.
Why is it recommended to use prepared statements in PHP when interacting with a database?
- To improve code readability.
- To prevent SQL injection attacks.
- To reduce the need for database indexes.
- To enhance database schema design.
Prepared statements prevent SQL injection attacks by separating SQL code from user input, making it safer to execute database queries.
When an error is not caught in PHP, it results in a ________ error.
- Fatal
- Syntax
- Logical
- Run-time
When an error is not caught in PHP, it results in a 'Fatal' error, which typically terminates script execution. Fatal errors often include issues like calling an undefined function or division by zero.
Which of the following is NOT a recommended approach to prevent SQL injection attacks in PHP?
- Using Prepared Statements
- Validating and Sanitizing User Input
- Escaping User Input with mysqli_real_escape_string()
- Disabling Error Reporting
Validating and sanitizing user input is an essential step in preventing SQL injection attacks. Therefore, it is not recommended to avoid this step. Other options, like using prepared statements and escaping user input, are recommended practices to prevent SQL injection in PHP. Disabling error reporting, while helpful, is not the primary method for prevention.