· 7 years ago · Oct 04, 2018, 07:02 AM
1public function CreateTable(?string $TableName, ?array $Tables = ['type' => 'name']){
2 $tabel = null;
3
4 foreach($Tables as $type => $name){
5 end($Tables);
6 ($type !== key($Tables)) ? $tabel .= $name.' '.strtoupper($type).','.' ' : $tabel .= $name.' '.strtoupper($type);
7 }
8
9 $query = $this->DB->query(
10 '
11 CREATE TABLE IF NOT EXISTS '.$TableName.' (
12 '.$tabel.'
13 );
14 '
15 );
16 $this->QueryResult = $query;
17 return $this->QueryResult;
18 }