Executing SQL queries and retrieving data from databases Mocktest

PDO (PHP Data Objects) is a PHP extension commonly used for executing SQL queries and interacting with databases. It provides a consistent interface for accessing various database systems.

The mysqli_query() function in PHP is primarily used for executing SQL queries. It sends an SQL query to the MySQL database and returns a result object for SELECT queries or a boolean value for other types of queries.

The INSERT operation in SQL is used to insert new data into a database table. It adds one or more records (rows) to a table with the specified column values.

The mysqli_fetch_assoc() function in PHP is used to fetch a row from a result set returned by a SELECT query. It returns an associative array containing the fetched row's column values, where the keys are the column names.

The SQL DELETE operation is used to remove specific records (rows) from a table based on specified conditions. It deletes rows that match the specified criteria from the table.

One of the primary advantages of using prepared statements in PHP for executing SQL queries is improved security against SQL injection attacks. Prepared statements separate SQL logic from user input, preventing malicious SQL code injection.

MySQLi (MySQL Improved) extension in PHP provides both procedural and object-oriented approaches for executing SQL queries and interacting with MySQL databases. It offers features such as prepared statements and transaction support.

The PDO::query() method in PHP PDO extension is primarily used for executing an SQL query. It sends an SQL query to the database and returns a PDOStatement object representing the result set (if applicable).

The pdo_query() function in PHP PDO extension is used to execute an SQL query. It sends an SQL query to the database and returns a PDOStatement object representing the result set (if applicable).

The mysqli_fetch_array() function in PHP is primarily used for fetching a row from a result set returned by a SELECT query. It returns an array containing the fetched row's column values, with both numeric and associative indices.