File manager - Edit - /home/webapp69.cm.in.th/u69319090015/Portfolio/db.php
Back
<?php // Portfolio - Database Connection Configuration (PHP PDO) $host = 'localhost'; $db = 'mura_shop'; $user = 'root'; $pass = ''; $charset = 'utf8mb4'; $dsn = "mysql:host=$host;dbname=$db;charset=$charset"; $options = [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, PDO::ATTR_EMULATE_PREPARES => false, ]; try { $pdo = new PDO($dsn, $user, $pass, $options); // Create table if not exists $sql = "CREATE TABLE IF NOT EXISTS `portfolio_contacts` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `name` VARCHAR(100) NOT NULL, `email` VARCHAR(100) NOT NULL, `message` TEXT NOT NULL, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"; $pdo->exec($sql); } catch (\PDOException $e) { // If connection fails, we log it and fallback to local file logging in contact.php $pdo = null; } ?>
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.32 |
proxy
|
phpinfo
|
Settings