Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors', 1);
- ini_set('display_startup_errors', 1);
- error_reporting(E_ALL);
- $host = 'localhost';
- $db = 'addnews';
- $user = 'root';
- $pass = '';
- $charset = 'utf8';
- // $text = (isset($_POST['title']) && !empty($_POST['title']))?'%'.$_POST['title'].'%':'';
- $title = $_POST['title'];
- $date = $_POST['date'];
- $status = $_POST['publish_in_index'];
- $category = $_POST['category'];
- $content = $_POST['content'];
- $author = $_POST['author'];
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $opt = [
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
- PDO::ATTR_EMULATE_PREPARES => false,
- ];
- echo $title.'<br>';
- echo $date.'<br>';
- echo $status.'<br>';
- echo $category.'<br>';
- echo $content.'<br>';
- echo $author.'<br>';
- $pdo = new PDO($dsn, $user, $pass, $opt);
- if(!empty($title) && !empty($content) && !empty($author)){
- $sql = "INSERT INTO `news` (`title`, `publish_date`, `status`, `category`, `content`, `author`)
- VALUES (:title, :publish_date, :status, :category, :content, :author)";
- $rows = $pdo->prepare($sql);
- $rows->execute([
- 'title'=>$title,
- 'publish_date'=>$date,
- 'status'=>$status,
- 'category'=>$category,
- 'content'=>$content,
- 'author'=>$author
- ]);
- echo "Запись добавлена";
- }else{
- echo "Запись не добавлена";
- }
- ?>
Add Comment
Please, Sign In to add comment