/** * @param $id * @param $id_acc * @param $title * @param $post * @param int $category */ public static function edit($id, $id_acc, $title, $post, $category = 2) { $cleanPost = \Post::sensor($post, false); $sql = sprintf("UPDATE `iniforum`.`posts`\n SET `post` = :post, `title` = :title, `id_category` = :category, `modified_at`=now()\n WHERE `posts`.`id` = :id AND `posts`.`id_account` = :id_acc"); $bindArray = [':id' => $id, ':id_acc' => $id_acc, ':title' => $title, ':post' => $cleanPost, ':category' => $category]; self::query($sql, $bindArray); }
public static function create($from, $to, $subject, $msg) { $cleanMsg = \Post::sensor($msg, false); $sql = sprintf("INSERT INTO `iniforum`.`messages` \n (`id`, `from_account`, `to_account`, `subject`, `text`, `created_at`)\n VALUES (NULL, :from_member, :to_member, :subject, :msg, CURRENT_TIMESTAMP)"); $bindArray = [':from_member' => $from, ':to_member' => $to, ':subject' => $subject, ':msg' => $cleanMsg]; self::query($sql, $bindArray); }