Guest User

Untitled

a guest
Feb 17th, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. <?php
  2. ini_set('display_errors', 1);
  3. ini_set('display_startup_errors', 1);
  4. error_reporting(E_ALL);
  5.  
  6. $host = 'localhost';
  7. $db = 'PDO';
  8. $user = 'root';
  9. $pass = '';
  10. $charset = 'utf8';
  11.  
  12. $name = (isset($_POST['name']) && !empty($_POST['name']))?$_POST['name']:'';
  13. $dates = (isset($_POST['dates']) && !empty($_POST['dates']))?$_POST['dates']:date('d.m.Y');
  14. $rd = (isset($_POST['rd']) && !empty($_POST['rd']))?$_POST['rd']:'';
  15. $section = (isset($_POST['section']) && !empty($_POST['section']))?$_POST['section']:'';
  16. $content = (isset($_POST['content']) && !empty($_POST['content']))?$_POST['content']:'';
  17. $author = (isset($_POST['author']) && !empty($_POST['author']))?$_POST['author']:'';
  18. var_dump($name);
  19. var_dump($content);
  20. var_dump($rd);
  21. var_dump($section);
  22. var_dump($content);
  23. var_dump($author);
  24.  
  25. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  26.  
  27. $opt = [
  28. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  29. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  30. PDO::ATTR_EMULATE_PREPARES => false,
  31. ];
  32.  
  33. $pdo = new PDO($dsn, $user, $pass, $opt);
  34.  
  35. if(!empty($name) && !empty($content)){
  36. $sql = "INSERT INTO news (name, publication_date, status, section, content, author) VALUES ('$name', '$dates', '$rd', '$section', '$content', '$author')";
  37.  
  38. $rows = $pdo->query($sql);
  39.  
  40. echo "Данные успешно добавлены";
  41.  
  42. } else {
  43. echo '"Название новости" и ' . '"Текст новости"' . " обязательны для заполнения";
  44. }
  45.  
  46. ?>
Add Comment
Please, Sign In to add comment