Advertisement
noam76

store_data.php

May 15th, 2023
899
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.73 KB | None | 0 0
  1.    <?php
  2.    function store_data($data) {
  3.        $dsn = 'mysql:host=localhost;dbname=mydatabase';
  4.        $username = 'myusername';
  5.        $password = 'mypassword';
  6.        $options = array(
  7.            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  8.        );
  9.        try {
  10.            $pdo = new PDO($dsn, $username, $password, $options);
  11.            $pdo->beginTransaction();
  12.            $stmt = $pdo->prepare('INSERT INTO data_storage (value) VALUES (:value)');
  13.            foreach ($data as $value) {
  14.                $stmt->bindParam(':value', $value);
  15.                $stmt->execute();
  16.            }
  17.            $pdo->commit();
  18.        } catch (PDOException $e) {
  19.            $pdo->rollBack();
  20.            throw $e;
  21.        }
  22.    }
  23.    ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement