File manager - Edit - /home/webapp69.cm.in.th/u69319090029/Project SME/scratch_db.php
Back
require 'db.php'; try { $pdo->exec("CREATE TABLE IF NOT EXISTS promotions ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, description TEXT, discount_code VARCHAR(50), is_active TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB;"); // Insert mock promotion if not exists $stmt = $pdo->prepare("SELECT COUNT(*) FROM promotions WHERE discount_code = 'CMTC Tech Solution10'"); $stmt->execute(); if ($stmt->fetchColumn() == 0) { $pdo->exec("INSERT INTO promotions (title, description, discount_code, is_active) VALUES ( 'ฉลองเปิดตัวระบบลด 10%', 'ส่วนลดพิเศษสำหรับร้านค้าใหม่ที่สมัครสมาชิกตั้งแต่วันนี้', 'CMTC Tech Solution10', 1 );"); } echo "Database migrated successfully!\n"; } catch (Exception $e) { echo "Migration failed: " . $e->getMessage() . "\n"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.39 |
proxy
|
phpinfo
|
Settings