File Explorer
/
www
/
www
/
New File
Upload
Home
Directory could not be deleted because it is not empty.
Edit File: create_years_table.php
<?php // 创建年份表并插入初始数据 // 定义必要的常量 define('ROOTDIR', dirname(__FILE__) . '/'); define('COREDIR', ROOTDIR . 'core/'); define('LIBDIR', COREDIR . 'libs/'); define('MODELDIR', COREDIR . 'models/'); include 'conf/config.php'; include 'core/libs/db.class.php'; // 连接数据库 $database = new db($db_config); // 创建年份表 $sql = "CREATE TABLE IF NOT EXISTS `el_years` ( `id` INT AUTO_INCREMENT PRIMARY KEY, `year` INT NOT NULL UNIQUE, `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ) ENGINE=MyISAM DEFAULT CHARSET=utf8;"; $database->setSql($sql); $result = $database->query(); if ($result) { echo "表 el_years 创建成功或已存在\n"; // 插入初始年份数据 $initial_years = array(2023, 2024, 2025); foreach ($initial_years as $year) { // 检查年份是否已存在 $database->setSql("SELECT COUNT(*) as count FROM `el_years` WHERE `year` = $year"); $result = $database->getRow(); if ($result['count'] == 0) { // 插入年份 $database->setSql("INSERT INTO `el_years` (`year`) VALUES ($year)"); $insert_result = $database->query(); if ($insert_result) { echo "年份 $year 插入成功\n"; } else { echo "年份 $year 插入失败\n"; } } else { echo "年份 $year 已存在\n"; } } } else { echo "表 el_years 创建失败\n"; } ?>
Save Changes
Cancel