File manager - Edit - /home/webapp69.cm.in.th/u69319090041/Shop41/scratch_run_cart_migration.php
Back
<?php require_once __DIR__ . '/config/database.php'; $db = getDBConnection(); $sql = "CREATE TABLE IF NOT EXISTS `cart_items` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `user_id` INT DEFAULT NULL COMMENT 'FK -> users.id (NULL = Guest)', `session_id` VARCHAR(128) DEFAULT NULL COMMENT 'เก็บ PHP session_id() กรณีที่ยังไม่ล็อกอิน', `product_id` INT NOT NULL, `size` VARCHAR(50) DEFAULT NULL, `color` VARCHAR(50) DEFAULT NULL, `quantity` INT NOT NULL DEFAULT 1, `created_at` DATETIME DEFAULT CURRENT_TIMESTAMP, `updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX (`user_id`), INDEX (`session_id`), UNIQUE KEY `uq_cart_item` (`user_id`, `session_id`, `product_id`, `size`, `color`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;"; try { $db->exec($sql); echo "MIGRATION CART ITEMS SUCCESSFUL!\n"; } catch (PDOException $e) { echo "Error: " . $e->getMessage() . "\n"; }
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.22 |
proxy
|
phpinfo
|
Settings