field_edit.inc.php

来自「Phpcms2008 是一款基于 PHP+Mysql 架构的网站内容管理系统」· PHP 代码 · 共 17 行

<?php 
if($dateformat == 'date')
{
	$sql = "ALTER TABLE `$tablename` CHANGE `$field` `$field` DATE NOT NULL DEFAULT '0000-00-00'";
}
elseif($dateformat == 'datetime')
{
	$sql = "ALTER TABLE `$tablename` CHANGE `$field` `$field` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'";
}
elseif($dateformat == 'int')
{
	if($format)
	$sql = "ALTER TABLE `$tablename` CHANGE `$field` `$field` INT UNSIGNED NOT NULL DEFAULT '0'";
}

$db->query($sql);
?>