public create_table ( $table, $data, $primary, $comment = "", $engine = "MyISAM" ) |
function create_table($table, $data, $primary, $comment = "", $engine = "MyISAM")
{
$sql = "CREATE TABLE IF NOT EXISTS `" . $table . "` (";
$values = array();
foreach ($data as $key => $value) {
$values[] = "`" . $key . "` " . $value;
}
$sql .= implode(",", $values);
$sql .= ", PRIMARY KEY (`" . $primary . "`)) ENGINE=" . $engine . " DEFAULT CHARSET=" . $this->db_charset . " COMMENT='" . $comment . "' AUTO_INCREMENT=1";
$this->db_rs = $this->query($sql);
return $this->db_rs;
}