Advertisement
Guest User

Untitled

a guest
Aug 22nd, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. <?php
  2. $host = "localhost";
  3. $dbuser = "home_user";
  4. $dbpass = "AZ*******l9";
  5. $db = "data";
  6. $charset = 'utf8';
  7.  
  8. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  9. $opt = [
  10. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  11. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  12. PDO::ATTR_EMULATE_PREPARES => false,
  13. ];
  14. $pdo = new PDO($dsn, $dbuser, $dbpass, $opt);
  15.  
  16. $id = $_GET["id"];
  17. $data = $_GET["data"];
  18. $sql = "INSERT INTO `data_table` (`id`, `data`) VALUES ('".$id."', '".$data."');";
  19. $send = $pdo->prepare($sql);
  20. $send->execute();
  21. echo("ok");
  22. ?>
  23.  
  24. print($send->errorInfo());
  25.  
  26. try{...} catch (PDOException $e)
  27. {
  28. print($e);
  29. }
  30.  
  31. <?php
  32. ini_set('error_reporting', E_ALL);
  33. ini_set('display_errors', 1);
  34. ini_set('display_startup_errors', 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement