21 lines
607 B
PHP
21 lines
607 B
PHP
<?php
|
|
//work1
|
|
include_once 'config/pdo_connect.php';
|
|
/** @var PDO $pdo */
|
|
|
|
if (isset($_POST['submit'])) {
|
|
try {
|
|
$pdoname = $_POST['pdo'];
|
|
$dbname = $_POST['dbname'];
|
|
$datetime = $_POST['datetime'];
|
|
$query = 'insert into tb_pdo_mysql(pdo, dbname, time) values (?,?,?)';
|
|
$pdo->beginTransaction();
|
|
$statement = $pdo->prepare($query);
|
|
$statement->execute([$pdoname, $dbname, $datetime]);
|
|
echo 'Insert success';
|
|
$pdo->commit();
|
|
} catch (PDOException $e) {
|
|
echo 'Error: ' . $e->getMessage();
|
|
$pdo->rollBack();
|
|
}
|
|
} |