include_once "1-connection.php";
$userdata = [
    'fullname' => 'ali',
    'email' => 'ali@gmail.com',
    'username' => 'ali245',
    'password' => 'ali2345678',
    'age' => 19
];
// $sql = "INSERT INTO users (fullname,email,username,password,age) VALUES (?,?,?,?,?)";
// $stmt = $db->prepare($sql);
// $stmt->bindParam(1, $userdata['fullname'], PDO::PARAM_STR);
// $stmt->bindParam(2, $userdata['email'], PDO::PARAM_STR);
// $stmt->bindParam(3, $userdata['username'], PDO::PARAM_STR);
// $stmt->bindParam(4, $userdata['password'], PDO::PARAM_STR);
// $stmt->bindParam(5, $userdata['age'], PDO::PARAM_INT);
// $stmt->execute();
//----------------------------------------------------------------
$userdata1 = [
    'ali',
    'ali@gmail.com',
    'ali245',
    'ali2345678',
    19
];
// $sql = "INSERT INTO users (fullname,email,username,password,age) VALUES (?,?,?,?,?)";
// $stmt = $db->prepare($sql);
// $stmt->execute($userdata1);
//-----------------------------------------------------------------
// $userdata2 = [
//     'fullname' => 'mahdi',
//     'email' => 'mahdi@gmail.com',
//     'username' => 'mahdi245',
//     'password' => 'mkkg2345678',
//     'age' => 25
// ];
// $sql = "INSERT INTO users (fullname,email,username,password,age) VALUES (:fullname,:email,:username,:password,:age)";
// $stmt = $db->prepare($sql);
// $stmt->execute($userdata2);
// transaction in php
$sql = "INSERT INTO users (fullname,email,username,password,age) VALUES (?,?,?,?,?)";
$stmt = $db->prepare($sql);
$users = [
    ["sara", "sara@gmail.com", "sara154", "1237567", 18],
    ["changiz", "changiz@gmail.com", "changiz445", "1237567", 56],
    ["sara", "mohsen@gmail.com", "mohsendev", "1237567", 29]
];
$db->beginTransaction();
foreach ($users as $user) {
    $stmt->execute($user);
    if ($user[0] == "changiz") {
        exit();die;
    }
}
$db->commit();

متاسفانه کار نمیکنه سرچ هم کردم اکی نشد