How can a loop or iteration be used in PHP to separate and insert individual array elements into separate rows in a database table?

To separate and insert individual array elements into separate rows in a database table using PHP, you can use a loop or iteration to iterate through each element in the array and insert them one by one into the database table. This can be achieved by using a foreach loop to loop through the array and execute an SQL INSERT query for each element. 

// Assuming $array contains the array of elements to be inserted into the database table

foreach($array as $element) {
    // Connect to the database
    $conn = new mysqli("localhost", "username", "password", "database");

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

    // Escape the element to prevent SQL injection
    $escaped_element = $conn->real_escape_string($element);

    // Execute the SQL INSERT query
    $sql = "INSERT INTO table_name (column_name) VALUES ('$escaped_element')";
    if ($conn->query($sql) === TRUE) {
        echo "Record inserted successfully";
    } else {
        echo "Error inserting record: " . $conn->error;
    }

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

Keywords

PHP loop iteration array database table

Related Questions