index.submit.php
<?php
// echo
// return;
$_POST['category'] = strtolower($_POST['category'] ?? '');
$_POST['status'] = 'published';
$_POST['author_id'] = 0;
$_POST['url'] = $this->cleanUrl('/'.$_POST['category'].'/'.$_POST['slug'].'/');
$_POST['slug'] = \ROF\Article::cleanSlug($_POST['slug']);
// var_dump($_POST['url']);
// var_dump($_POST);
// exit;
$pdo = $this->pdo;//get('db-pdo');
if (isset($_POST['id'])&&$_POST['id']!=NULL){
// var_dump('update request');
$update = $pdo->prepare("UPDATE rof_articles "
."SET title=:title, blurb=:blurb, body=:body, slug=:slug, category=:category, `status`=:stat, url=:url, author_id=:author_id, "
."updatedAt=:updatedAt "
."WHERE id=:id");
$update->execute(
array(
":title" => $_POST['title'],
":blurb" => $_POST['blurb'],
":body" => $_POST['article-body'],
":id" => $_POST['id'],
":slug" => $_POST['slug'],
":category" => $_POST['category'],
":stat" => $_POST['status'],
":url" => $_POST['url'],
":author_id" => $_POST['author_id'],
":updatedAt" => time(),
)
);
$id = $_POST['id'];
$url = $this->cleanUrl($_POST['url']);
} else {
$insert = $pdo->prepare("INSERT INTO rof_articles(title,blurb,body,slug,url,category,`status`,author_id,createdAt) "
."VALUES(:title,:blurb,:body,:slug,:url,:category,:stat,:author_id,:createdAt)");
$insert->execute(
array(
":title" => $_POST['title'],
":blurb" => $_POST['blurb'],
":body" => $_POST['article-body'],
":slug" => $_POST['slug'],
":category" => $_POST['category'],
":stat" => $_POST['status'],
":author_id" => $_POST['author_id'],
":url" => $_POST['url'],
":createdAt" => time(),
)
);
$id = $pdo->lastInsertId();
}
$this->showAtUrl($_POST['url'],'/');
?>