/**
* setNewPost
* @param string $headline
* @param string $body
* @param int $categoryId
* @param int $online
* @return int
*/
public static function setNewPost(Post $post)
{
$pdoMysql = new PdoMysql();
$pdoMysql->conn();
$sql = "INSERT INTO post_data (`headline`\n , `body`\n , `category_id`\n , `online`\n , `post_date`)\n VAlUES (:headline\n , :body\n , :category_id\n , :online\n , {$post->bindings['post_date']->value})";
unset($post->bindings['post_date']);
unset($post->bindings['id']);
$rv = $pdoMysql->query($sql, $post->bindings);
if (is_a($rv, 'ErrorObject')) {
$rv->caller = $_SERVER['SCRIPT_FILENAME'];
return $rv;
}
return $pdoMysql->getLastInsertId();
}
public static function setNewReply(Comments $comment, $parentId)
{
$commentId = self::setNewComment($comment);
if (is_a($commentId, 'ErrorObject')) {
$commentId->caller = $_SERVER['SCRIPT_FILENAME'];
return $commentId;
}
$pdoMysql = new PdoMysql();
$pdoMysql->conn();
$sql = "INSERT INTO replies ( comment_id, parent_id)\n VALUES ( :commentId, :parentId)";
$bindValues = array('commentId' => $commentId, 'parentId' => $parentId);
$rv = $pdoMysql->query($sql, $bindValues);
if (is_a($rv, 'ErrorObject')) {
$rv->caller = $_SERVER['SCRIPT_FILENAME'];
return $rv;
}
self::alertComment($comment);
return $pdoMysql->getLastInsertId();
}
public static function setNewCategory($newCategory)
{
$pdoMysql = new PdoMysql();
$pdoMysql->conn();
$sql = "INSERT INTO categories (`category`) VALUES ( :newCategory )";
$bindValues = array('newCategory' => $newCategory);
$rv = $pdoMysql->query($sql, $bindValues);
if (is_a($rv, 'ErrorObject')) {
$rv->caller = $_SERVER['SCRIPT_FILENAME'];
return $rv;
}
return $pdoMysql->getLastInsertId();
}
public static function setNewUser(Users $newUser)
{
$pdoMysql = new PdoMysql();
$pdoMysql->conn();
$sql = "INSERT INTO users (`user_name`\n , `user_type`\n , `email`\n , `user_pw`\n , `date_joined`)\n VALUES (:user_name\n , :user_type\n , :email\n , :user_pw\n , :date_joined)";
unset($newUser->bindings['id']);
$rv = $pdoMysql->query($sql, $newUser->bindings);
if (is_a($rv, 'ErrorObject')) {
$rv->caller = $_SERVER['SCRIPT_FILENAME'];
return $rv;
}
return $pdoMysql->getLastInsertId();
}