public function save_id()
{
$verbose = Config::$env == "dev" ? true : false;
$id = null;
if ($verbose) {
Log::log("<blue>Creating the category `" . $this->name . "`..");
}
$slug = Database::escape(strtolower(App::clean($this->name)));
$query = "INSERT INTO `" . Config::$db_name . "`.`" . Config::$wp_prefix . "terms`( `name`, `slug`, `term_group` ) VALUE( '" . Database::escape($this->name) . "', '" . $slug . "', 0 )";
$exec = Database::exec($query);
if ($exec === false) {
Log::log("<red>Cannot save the category:");
Log::log("<red>[" . Database::$conn->errno . "] " . Database::$conn->error);
Log::log("<red>" . $query);
exit;
} else {
$term_id = Database::$conn->insert_id;
if ($verbose) {
Log::log("<green>Created the category `" . $this->name . "` with the slug `" . $slug . "` and ID '" . $term_id . "'.");
}
}
$query = "INSERT INTO `" . Config::$db_name . "`.`" . Config::$wp_prefix . "term_taxonomy`( `term_id`, `taxonomy`, `description`, `parent`, `count`) VALUE( '" . $term_id . "', 'category', '', 0, 0 );";
$exec = Database::exec($query);
if ($exec === false) {
Log::log("<red>Cannot save the taxonomy:");
Log::log("<red>[" . Database::$conn->errno . "] " . Database::$conn->error);
Log::log("<red>" . $query);
exit;
} else {
if ($verbose) {
Log::log("<green>Taxonomy created.");
}
$tax_id = Database::$conn->insert_id;
}
return [$term_id, $tax_id];
}
public function get_query()
{
$query = "INSERT INTO `" . Config::$db_name . "`.`" . Config::$wp_prefix . "posts` (";
$attributes = [];
$values = [];
foreach ($this as $key => $value) {
if ($key != "category" && $key != "post_id") {
$attributes[] = "`" . $key . "`";
$values[] = "'" . Database::escape($value) . "'";
}
}
$query .= implode(",", $attributes);
$query .= ") VALUE (";
$query .= implode(",", $values);
$query .= ");";
return $query;
}
