Guest User

Untitled

a guest
Nov 30th, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. function sql($query) {
  2.  
  3. // SQL Connection details
  4. include "sql.php";
  5.  
  6. // Initialize PDO connection
  7. $pdo = new PDO($sqldsn, $sqluser, $sqlpass, $sqlopt);
  8.  
  9. // Prepare and execute statement
  10. $stm = $pdo->prepare("$query");
  11. $stm->execute();
  12.  
  13. // Fetch results into array
  14. $result = $stm->fetchAll(PDO::FETCH_GROUP|PDO::FETCH_UNIQUE);
  15. return $result;
  16.  
  17. }
  18.  
  19. // Main
  20. $sqlhost = 'localhost';
  21. $sqldb = 'MyDB';
  22. $sqluser = 'mysqluser';
  23. $sqlpass = 'mypassword';
  24. $sqlport = "";
  25.  
  26.  
  27. // PDO Options
  28. $sqlchar = 'utf8';
  29. $sqldsn = "mysql:host=$sqlhost;dbname=$sqldb;charset=$sqlchar";
  30. $sqlopt = [
  31. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  32. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  33. PDO::ATTR_EMULATE_PREPARES => false,
  34. ];
  35.  
  36. // Statement
  37. $sql = "INSERT INTO `MyTable` (`UserName`, `Email`, `ExpiryDate`, `Notes`) VALUES ('$username', '$email', '$expirydate', '$notes');";
  38.  
  39. // Run query
  40. sql($sql);
  41.  
  42. $notes = addslashes($notes);
Add Comment
Please, Sign In to add comment