What is a common use case for the $_GET superglobal in PHP?

  • Retrieving data sent via an HTML form using the GET method.
  • Storing data in cookies.
  • Accessing data from the URL's query string.
  • Processing user input from an HTML form using the POST method.
A common use case for the $_GET superglobal in PHP is to access data from the URL's query string. This can include parameters or values passed through the URL, such as search queries, page identifiers, or filter criteria. By retrieving data from the query string using $_GET, you can dynamically generate content, perform searches, or filter data based on user input. However, it is not used for retrieving form data using the GET method or processing user input using the POST method. Learn more: https://www.php.net/manual/en/reserved.variables.get.php

What are some common practices in PHP when working with MySQL databases?

  • Using prepared statements or parameterized queries
  • Sanitizing and validating user input
  • Handling database errors and exceptions
  • All of the above
When working with MySQL databases in PHP, it is good practice to use prepared statements or parameterized queries to prevent SQL injection vulnerabilities. Sanitizing and validating user input is crucial to ensure the security and integrity of the data stored in the database. Additionally, handling database errors and exceptions appropriately helps in detecting and resolving issues during database operations. Following these practices helps in writing secure, reliable, and efficient PHP code when interacting with MySQL databases.

To access an element of a multidimensional array in PHP, you use the name of the array followed by the ______ of the element in square brackets.

  • Index
  • Key
  • Value
  • Position
To access an element of a multidimensional array in PHP, you use the name of the array followed by the index or key of the element in square brackets ([]). The index or key corresponds to the position or identifier of the element within the array hierarchy. By specifying the appropriate index or key for each dimension of the multidimensional array, you can access the desired element. This allows for targeted retrieval and manipulation of specific elements within the multidimensional array. Learn more: https://www.php.net/manual/en/language.types.array.php#language.types.array.syntax

PHP uses the global keyword to make a local variable have global scope.

  • TRUE
  • FALSE
The statement is false. In PHP, the global keyword is used to access and modify variables with global scope from within a function. It allows you to work with global variables within the local scope of a function. By using the global keyword followed by the variable name, you can indicate that the variable being used is the global variable and not a local one. However, it does not change the scope of the variable to global. Learn more: https://www.php.net/manual/en/language.variables.scope.php#language.variables.scope.global

The elements of a PHP multidimensional array can be accessed using multiple indices.

  • TRUE
  • FALSE
True. In PHP, you can access elements of a multidimensional array by specifying multiple indices. Each index represents a dimension of the multidimensional array, allowing you to navigate through the nested arrays and access the desired element. By providing the appropriate indices for each dimension, you can access specific elements within the multidimensional array structure. This flexibility in accessing elements enables efficient manipulation and retrieval of data in complex data structures. Learn more: https://www.php.net/manual/en/language.types.array.php#language.types.array.syntax

You need to understand the purpose and usage of traits in PHP OOP. What would be your conclusion?

  • Traits provide a way to reuse code across multiple classes in PHP, allowing for better code organization and reducing code duplication. They are useful for incorporating shared functionality and resolving multiple inheritance limitations.
  • Traits are similar to classes but have some key differences, such as not being able to be instantiated on their own and not having their own properties.
  • When using traits, it's important to follow best practices, such as using them for common functionality, avoiding excessive use, and choosing meaningful names.
  • All of the above
After understanding the purpose and usage of traits in PHP OOP, one would conclude that traits provide a powerful mechanism to reuse code across multiple classes, promoting better code organization, reducing code duplication, and enhancing code modularity. Traits are valuable for incorporating shared functionality, overcoming the limitations of multiple inheritance, and improving code maintainability. Following best practices, such as using traits for common functionality, avoiding excessive use, and selecting meaningful names, helps ensure effective usage of traits.

Which of the following are common uses of the $_REQUEST superglobal in PHP?

  • Retrieving form data submitted through both GET and POST methods.
  • Accessing session variables.
  • Retrieving server environment variables.
  • Executing SQL queries on the database.
The $_REQUEST superglobal is commonly used for retrieving form data submitted through both GET and POST methods. It provides a simple way to access user input without having to differentiate between the two methods. However, it is not used for accessing session variables, server environment variables, or executing SQL queries on the database. Learn more: https://www.php.net/manual/en/reserved.variables.request.php

Which of the following are true about arrays in PHP?

  • Arrays can only store values of the same data type.
  • Arrays can have both numeric and string keys.
  • Arrays cannot be nested within each other.
  • Arrays cannot be modified once they are created.
In PHP, arrays can have both numeric and string keys. This allows for flexibility in accessing and organizing data within the array. Arrays can store values of different data types, including strings, integers, floats, booleans, and even other arrays. Additionally, arrays can be modified by adding, updating, or removing elements. Nesting arrays within each other is also possible, leading to multidimensional arrays. Learn more: https://www.php.net/manual/en/language.types.array.php

Which of the following are common uses of PHP?

  • Creating static HTML pages.
  • Advanced machine learning.
  • Web scraping.
  • High-performance game development.
While PHP can be used for a variety of tasks, one of its most common uses is web scraping, where PHP scripts can be written to automatically gather data from web pages. Learn more: https://www.php.net/manual/en/book.dom.php

You are writing a PHP script and you need to create a MySQL table. How would you do this?

  • Connect to the MySQL server, select the database, execute a CREATE TABLE query using mysqli_query
  • Connect to the MySQL server, execute an INSERT INTO query using mysqli_query
  • Connect to the MySQL server, execute a SELECT query using mysqli_query
  • Connect to the MySQL server, execute a DELETE query using mysqli_query
To create a MySQL table in a PHP script, you would follow these steps: 1. Connect to the MySQL server using the appropriate credentials. 2. Select the database where you want to create the table. 3. Execute a CREATE TABLE query using the mysqli_query function. You would pass the connection object and the CREATE TABLE query as parameters to the mysqli_query function. This executes the query against the MySQL server. Make sure to handle any errors that may occur during the query execution.