Advertisement
Guest User

Untitled

a guest
Feb 10th, 2017
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.46 KB | None | 0 0
  1. //index.php
  2. if(isset($_POST['btn-signup-preduzece'])) {
  3. $uname = trim($_POST['pr-username']); //there are inputs in my html
  4. $umail = trim($_POST['pr-email']);
  5. $upass = trim($_POST['pr-password']);
  6. $comp = trim($_POST['pr-naziv']);
  7. $maticni = trim($_POST['pr-maticni']);
  8. $pib = trim($_POST['pr-pib']);
  9. $sifra = trim($_POST['pr-sifra']);
  10. $racun = trim($_POST['pr-racun']);
  11. $adresa = trim($_POST['pr-adresa']);
  12.  
  13. if($uname=="") {
  14. $error[] = "provide username !";
  15. }
  16. else if($umail=="") {
  17. $error[] = "provide email id !";
  18. }
  19. else if(!filter_var($umail, FILTER_VALIDATE_EMAIL)) {
  20. $error[] = 'Please enter a valid email address !';
  21. }
  22. else if($upass=="") {
  23. $error[] = "provide password !";
  24. }
  25. else {
  26. try {
  27. $stmt = $DB_con->prepare("SELECT username,email FROM preduzeca WHERE username=:uname OR email=:umail");
  28. $stmt->execute(array(':uname'=>$uname, ':umail'=>$umail));
  29. $row=$stmt->fetch(PDO::FETCH_ASSOC);
  30.  
  31. if($row['username']==$uname) {
  32. $error[] = "sorry username already taken !";
  33. }
  34. else if($row['email']==$umail) {
  35. $error[] = "sorry email id already taken !";
  36. }
  37. else {
  38. //PROBLEM IS HERE IN THIS FUNTION BELLOW, when I put here some echo it writes me that, but if i put echo bellow this if statement it gives me nothing
  39. if($user->registerPreduzece($uname,$upass,$umail, $comp, $maticni, $pib, $sifra, $racun, $adresa)) {
  40. $user->redirect('ostalo/uspesno.php');
  41. }
  42. }
  43. }
  44. catch(PDOException $e) {
  45. echo $e->getMessage();
  46. }
  47. }
  48. }
  49.  
  50. public function registerPreduzece($uname,$upass,$umail, $comp, $maticni, $pib, $sifra, $racun, $adresa) {
  51. try
  52. {
  53. $new_password = password_hash($upass, PASSWORD_DEFAULT);
  54.  
  55. $stmt = $this->db->prepare("INSERT INTO preduzeca(naziv,maticniBroj,PIB,sifraDelatnosti,racun,adresa,username,password,email)
  56. VALUES(:comp, :maticni, :pib, :sifra, :racun, :adresa, :uname, :upass, :umail)");
  57. $stmt->bindparam(":naziv", $comp);
  58. $stmt->bindparam(":maticniBroj", $maticni);
  59. $stmt->bindparam(":PIB", $pib);
  60. $stmt->bindparam(":sifraDelatnosti", $sifra);
  61. $stmt->bindparam(":racun", $racun);
  62. $stmt->bindparam(":adresa", $adresa);
  63. $stmt->bindparam(":username", $uname);
  64. $stmt->bindparam(":password", $new_password);
  65. $stmt->bindparam(":email", $umail);
  66. $stmt->execute();
  67.  
  68. return $stmt;
  69. }
  70. catch(PDOException $e)
  71. {
  72. echo $e->getMessage();
  73. }
  74. }
  75.  
  76. CREATE TABLE `preduzeca` (
  77. `idPreduzeca` int(10) UNSIGNED NOT NULL,
  78. `naziv` varchar(45) NOT NULL,
  79. `maticniBroj` varchar(8) DEFAULT NULL,
  80. `PIB` varchar(11) DEFAULT NULL,
  81. `sifraDelatnosti` varchar(5) DEFAULT NULL,
  82. `racun` varchar(20) DEFAULT NULL,
  83. `adresa` int(11) DEFAULT NULL,
  84. `username` varchar(45) NOT NULL,
  85. `password` varchar(45) NOT NULL,
  86. `email` varchar(45) NOT NULL
  87. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  88.  
  89. ALTER TABLE `preduzeca`
  90. ADD PRIMARY KEY (`idPreduzeca`),
  91. ADD UNIQUE KEY `idfirme_UNIQUE` (`idPreduzeca`),
  92. ADD UNIQUE KEY `username_UNIQUE` (`username`),
  93. ADD UNIQUE KEY `maticniBroj_UNIQUE` (`maticniBroj`),
  94. ADD UNIQUE KEY `PIB_UNIQUE` (`PIB`),
  95. ADD UNIQUE KEY `racun_UNIQUE` (`racun`),
  96. ADD KEY `fk_preduzeca_adrese1_idx` (`adresa`);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement