Example #1
0
            return FALSE;
        }
        return TRUE;
    }
    public function ParseArrayToDatabase($content)
    {
        if ($this->CheckConnection()) {
            $columns = array_keys($content);
            $this->CreateTable($this->tableName, $columns);
            $this->InsertContent($this->tableName, $content);
        }
        return 'Uwierzytelnianie do systemu bazy danych nie powiodło się.';
    }
    public function CreateTable($name, $columns)
    {
        $query = " CREATE TABLE {$name} ( " . $this->SplitHeaders($columns) . "  ) ENGINE = InnoDB; ";
        echo $query;
    }
    public function SplitHeaders($columns)
    {
        $query = '';
        foreach ($columns as $column) {
            $query = $query . " {$column}" . ' VARCHAR(45) NOT NULL,';
        }
        $result = substr($query, 0, -1);
        return $result;
    }
}
$test = new Database('test');
$test->ParseArrayToDatabase(array('raz' => 1, 'dwa' => 2));