How can multidimensional arrays be utilized in PHP to improve database insertion processes?

When inserting multiple rows into a database table, using multidimensional arrays in PHP can streamline the process by allowing you to insert multiple rows in a single query. Each sub-array within the multidimensional array represents a row of data to be inserted. 

// Sample multidimensional array containing data to be inserted into a database table
$data = array(
    array('John', 'Doe', 'john.doe@example.com'),
    array('Jane', 'Smith', 'jane.smith@example.com'),
    array('Mike', 'Johnson', 'mike.johnson@example.com')
);

// Prepare the SQL query
$query = "INSERT INTO users (first_name, last_name, email) VALUES ";
foreach ($data as $row) {
    $query .= "(" . implode(", ", array_map('mysql_real_escape_string', $row)) . "), ";
}
$query = rtrim($query, ', ');

// Execute the query
$result = mysqli_query($connection, $query);

if ($result) {
    echo "Data inserted successfully";
} else {
    echo "Error inserting data: " . mysqli_error($connection);
}

Keywords

multidimensional arrays PHP database insertion optimization data structure

Related Questions