insert array into sql in php

main.php
// Assuming you have an array of data
$data = array('John Doe', 25, 'john@example.com');

// Connect to the database
$dsn = 'mysql:host=localhost;dbname=mydatabase';
$username = 'username';
$password = 'password';

try {
    $dbh = new PDO($dsn, $username, $password);
} catch(PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

// Prepare the insert statement
$stmt = $dbh->prepare("INSERT INTO users (name, age, email) VALUES (?, ?, ?)");

// Bind the array values to the statement placeholders
$stmt->bindParam(1, $data[0]);
$stmt->bindParam(2, $data[1]);
$stmt->bindParam(3, $data[2]);

// Execute the statement
$stmt->execute();
655 chars
25 lines