ผมจะสร้างหน้า create table ไม่รู้จะใช้คำสั่ง create table ยังไงเพราะข้อมูลที่ได้มาจะต้องลูปออกมา

$tables = array(
	'table1' => array(
		'cols' => array(
			'col1' => array(
				'type' => 'int',
				'null' => FALSE,
				'length' => 11,
				'optional' => array(
					'primary' => TRUE,
					'unique' => FALSE,
					'autoincrement' => TRUE,
					'key' => FALSE,
				),
			),
			'col2' => array(
				'type' => 'varchar',
				'null' => TRUE,
				'length' => 200,
				'optional' => array(
					'primary' => TRUE,
					'unique' => TRUE,
					'autoincrement' => FALSE,
					'key' => TRUE,
				),
			),
		),
	),
);

foreach ($tables as $name => $table)
{
	$table_name = $name;
	$sql = "CREATE TABLE '{$table_name}' (";
	
	$primary_keys = array();
	$unique_keys = array();

	// concate cols
	foreach ($table['cols'] as $name => $col)
	{
		$col_name = $name;
		$col_type = $col['type'];
		$col_null = $col['null'] ? 'default null' : 'not null';
		$col_length = $col['length'];
		$col_autoincrement = '';
		
		if ($col['optional']['primary'] === TRUE)
		{
			$primary_keys[] = $col_name;
			
			if ($col['optional']['autoincrement'] === TRUE)
			{
				$col_autoincrement = 'auto_increment';
			}
		}

		if ($col['optional']['unique'] === TRUE)
		{
			$unique_keys[] = $col_name;
		}

		$sql .= "'{$col_name}' {$col_type}({$col_length}) {$col_null} {$col_autoincrement}, ";
	}
	
	foreach ($primary_keys as $pri)
	{
		$sql .= "PRIMARY KEY ('{$pri}'), ";
	}

	foreach ($unique_keys as $unique)
	{
		$sql .= "UNIQUE KEY '{$unique}' ('{$unique}'), ";
	}

	// ขอจบก่อนละกัน ยังมีอย่างอื่นอีก ทำเองนะคับ
	$sql .= ')';

	echo $sql, '<br><br>';

	// query create table here
}