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 = 'PDO';
- $user = 'root';
- $pass = '';
- $charset = 'utf8';
- $name = (isset($_POST['name']) && !empty($_POST['name']))?$_POST['name']:'';
- $dates = (isset($_POST['dates']) && !empty($_POST['dates']))?$_POST['dates']:date('d.m.Y');
- $rd = (isset($_POST['rd']) && !empty($_POST['rd']))?$_POST['rd']:'';
- $section = (isset($_POST['section']) && !empty($_POST['section']))?$_POST['section']:'';
- $content = (isset($_POST['content']) && !empty($_POST['content']))?$_POST['content']:'';
- $author = (isset($_POST['author']) && !empty($_POST['author']))?$_POST['author']:'';
- var_dump($name);
- var_dump($content);
- var_dump($rd);
- var_dump($section);
- var_dump($content);
- var_dump($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,
- ];
- $pdo = new PDO($dsn, $user, $pass, $opt);
- if(!empty($name) && !empty($content)){
- $sql = "INSERT INTO news (name, publication_date, status, section, content, author) VALUES ('$name', '$dates', '$rd', '$section', '$content', '$author')";
- $rows = $pdo->query($sql);
- echo "Данные успешно добавлены";
- } else {
- echo '"Название новости" и ' . '"Текст новости"' . " обязательны для заполнения";
- }
- ?>
Add Comment
Please, Sign In to add comment