74 lines
2.0 KiB
PHP
74 lines
2.0 KiB
PHP
<?php
|
|
|
|
function initializeTableArray($initTableName) {
|
|
$tableArray = array();
|
|
|
|
if (!isset($initTableName) || strlen($initTableName) == 0) return($tableArray);
|
|
|
|
$query = "SHOW columns FROM $initTableName";
|
|
$initResults = db_query($query);
|
|
|
|
if (db_num_rows($initResults)) {
|
|
|
|
while ($initRow = db_fetch_assoc($initResults)) {
|
|
$initField = $initRow['Field'];
|
|
$initType = $initRow['Type'];
|
|
$initDefault = $initRow['Default'];
|
|
|
|
$initType = preg_replace("/\(.*/","",$initType);
|
|
|
|
switch ($initType) {
|
|
case 'int':
|
|
case 'int unsigned':
|
|
case 'smallint':
|
|
case 'smallint unsigned':
|
|
case 'bigint':
|
|
case 'bigint unsigned':
|
|
if ($initDefault == 'NULL') $initDefault = '0';
|
|
if ($initField == 'school_num' && isset($school_num)) $initDefault = $school_num;
|
|
|
|
$tableArray[$initField] = $initDefault;
|
|
break;
|
|
|
|
case 'decimal(12,2)':
|
|
if ($initDefault == 'NULL') $initDefault = '0.0';
|
|
if ($initDefault == '') $initDefault = '0.0';
|
|
|
|
$tableArray[$initField] = $initDefault;
|
|
break;
|
|
|
|
case 'enum':
|
|
case 'varchar':
|
|
case 'char':
|
|
if ($initDefault == 'NULL') $initDefault = '';
|
|
|
|
$tableArray[$initField] = $initDefault;
|
|
break;
|
|
|
|
default:
|
|
if ($initDefault == 'NULL') $initDefault = '';
|
|
|
|
switch ($initField) {
|
|
case 'added_date':
|
|
$initDefault = date("Y-m-d", time());
|
|
break;
|
|
|
|
case 'added_time':
|
|
$initDefault = date("Y-m-d H:i:s",time());
|
|
break;
|
|
|
|
default:
|
|
break;
|
|
}
|
|
|
|
$tableArray[$initField] = $initDefault;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
return($tableArray);
|
|
}
|
|
|
|
?>
|