Advertisement
Guest User

Untitled

a guest
Jul 11th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. define("dbserver", "localhost");
  2. define("dbuser", "user");
  3. define("dbpass", "");
  4. define("dbname", "user");
  5.  
  6.  
  7. $db = new PDO(
  8. "mysql:host=" .dbserver. ";dbname=" .dbname,dbuser,
  9. array(
  10. PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
  11. PDO::MYSQL_ATTR_INIT_COMMAND => "SET CHARACTER SET utf8"
  12. ) );
  13.  
  14. session_start();
  15. include "DBjoin.php";
  16. if(isset($_POST["email"])) {
  17. $_SESSION['email'] = $_POST["email"];
  18. }
  19. if(isset($_POST["nick"])) {
  20. $_SESSION['nick'] = $_POST["nick"];
  21. }
  22. if(isset($_POST["pass"])) {
  23. $_SESSION['pass'] = $_POST["pass"];
  24. $_SESSION['pass'] = base64_encode($_SESSION['pass']);
  25. }
  26. $sthandler = $db->prepare("SELECT Email FROM Registrace WHERE Email = :email");
  27. $sthandler->bindParam(':email', $_SESSION['email']);
  28. $sthandler->execute();
  29. if(filter_var($_SESSION['email'], FILTER_VALIDATE_EMAIL)) {
  30. if($sthandler->rowCount() > 0){
  31. echo "Email is used";}
  32.  
  33. $db = new PDO(
  34. "mysql:host=" .dbserver. ";dbname=" .dbname,dbuser,dbpass,
  35. array(
  36. PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
  37. PDO::MYSQL_ATTR_INIT_COMMAND => "SET CHARACTER SET utf8"
  38. ) );
  39.  
  40. $servername = "localhost";
  41. $dbname = "user";
  42.  
  43. define("dbuser", "user");
  44. define("dbpass", "");
  45.  
  46. $dsn = "mysql:host=$servername;dbname=$dbname";
  47.  
  48. $username = dbuser; // variable equals constant
  49. $password = dbpass; // variable equals constant
  50.  
  51. $options = array(
  52. PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8",
  53. PDO::MYSQL_ATTR_INIT_COMMAND => "SET CHARACTER SET utf8"
  54. );
  55.  
  56. $db = new PDO($dsn, $username, $password, $options);
  57.  
  58. <?php
  59. error_reporting(E_ALL);
  60. ini_set('display_errors', 1);
  61.  
  62. // rest of your code
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement