Inserting, updating, and deleting records in database tables using PHP Mocktest

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

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 UPDATE statement in SQL is used to modify existing records in a database table. It changes the values of specified columns in existing rows based on specified conditions.

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 DELETE operation in SQL is used to delete specific records (rows) from a database table based on specified conditions. It removes rows that match the specified criteria from the table.

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

The mysqli_query() function in PHP MySQLi extension is used to execute an SQL query. 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 PDO::exec() method in PHP PDO extension is primarily used for executing an SQL query that does not return a result set, such as INSERT, UPDATE, DELETE, or CREATE statements.

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

The mysqli_affected_rows() function in PHP MySQLi extension is used to get the number of rows affected by an SQL query such as INSERT, UPDATE, DELETE, or REPLACE. It returns the number of affected rows or -1 if the last query did not affect any rows.