How can PHP arrays be utilized to handle multiple form inputs for database insertion?

When handling multiple form inputs for database insertion, PHP arrays can be utilized to efficiently manage and process the data. By using arrays, you can loop through the form inputs and dynamically insert the values into the database without the need to write separate insert statements for each input field. 

// Assuming form inputs are submitted via POST method
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Connect to the database
    $conn = new mysqli("localhost", "username", "password", "database");

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    // Define an array to store form input values
    $form_data = array();

    // Loop through the form inputs and store the values in the array
    foreach ($_POST as $key => $value) {
        $form_data[$key] = $conn->real_escape_string($value);
    }

    // Prepare the insert query using the array keys and values
    $keys = implode(", ", array_keys($form_data));
    $values = "'".implode("', '", array_values($form_data))."'";
    $sql = "INSERT INTO table_name ($keys) VALUES ($values)";

    // Execute the insert query
    if ($conn->query($sql) === TRUE) {
        echo "New record inserted successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }

    // Close the database connection
    $conn->close();
}

Keywords

PHP arrays form inputs database insertion handling utilization

Related Questions