Insert Multiple Records Into MySQL from a multi line table PHP

// Connect to the database
$dbh = new PDO("mysql:host=localhost;dbname=mydatabase", $user, $pass);

// Check connection
if ($dbh === false) {
    die("Connection failed.");
}

// Get the multi-line table data
$data = "John,Doe,25\nJane,Smith,30\nBob,Johnson,40\n";

// Split the table data into an array of rows
$rows = explode("\n", $data);

// Prepare the INSERT statement
$stmt = $dbh->prepare("INSERT INTO mytable (firstname, lastname, age) VALUES (:firstname, :lastname, :age)");

// Iterate over the rows and insert each one into the database
foreach ($rows as $row) {
    // Split the row into an array of values
    $values = explode(",", $row);

    // Bind the values to the placeholders
    $stmt->bindParam(':firstname', $values[0]);
    $stmt->bindParam(':lastname', $values[1]);
    $stmt->bindParam(':age', $values[2]);

    // Execute the statement
    if (!$stmt->execute()) {
        echo "Error: " . $stmt->errorInfo()[2] . "<br>";
    }
}

// Close the database connection
$dbh = null;