Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: [PHP] poprawienie kodu
Forum PHP.pl > Forum > Przedszkole
damain1960
Mam kod php tylko że można zarejestrować się kilkakrotnie za pomocą loginu i adresu email

kod php:

  1. <?php session_start();
  2. $mysql_hostname ="local host";
  3. $mysql_user ="user";
  4. $mysql_password ="haslo";
  5. $mysql_database ="nazwa bazy";
  6. $bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Could not connect database");
  7. mysql_select_db($mysql_database, $bd) or die("Could not select database");
  8.  
  9. //Code for Registration
  10. if(isset($_POST['signup']))
  11. {
  12. $fname=$_POST['fname'];
  13. $lname=$_POST['lname'];
  14. $email=$_POST['email'];
  15. $password=$_POST['password'];
  16. $contact=$_POST['contact'];
  17. $enc_password=md5($password);
  18. $a=date('Y-m-d');
  19. $msg=mysql_query("insert into users(fname,lname,email,password,contactno,posting_date) values('$fname','$lname','$email','$enc_password','$contact','$a')");
  20. if($msg)
  21. {
  22. echo "<script>alert('Register successfully');</script>";
  23. }
  24. }
  25. // Code for login system
  26. if(isset($_POST['login']))
  27. {
  28. $password=$_POST['password'];
  29. $dec_password=md5($password);
  30. $ret= mysql_query("SELECT * FROM users WHERE email='".$_POST['uemail']."' and password='$dec_password'");
  31. $num=mysql_fetch_array($ret);
  32. if($num>0)
  33. {
  34. $extra="welcome.php";
  35. $_SESSION['login']=$_POST['uemail'];
  36. $_SESSION['id']=$num['id'];
  37. $_SESSION['name']=$num['fname'];
  38. $host=$_SERVER['HTTP_HOST'];
  39. $uri=rtrim(dirname($_SERVER['PHP_SELF']),'/\\');
  40. header("location:http://$host$uri/$extra");
  41. exit();
  42. }
  43. else
  44. {
  45. echo "<script>alert('Invalid username or password');</script>";
  46. $extra="index.php";
  47. $host = $_SERVER['HTTP_HOST'];
  48. $uri = rtrim(dirname($_SERVER['PHP_SELF']),'/\\');
  49. //header("location:http://$host$uri/$extra");
  50. exit();
  51. }
  52. }
  53.  
  54. //Code for Forgot Password
  55.  
  56. if(isset($_POST['send']))
  57. {
  58. $row1=mysql_query("select email,password from users where email='".$_POST['femail']."'");
  59. $row2=mysql_fetch_array($row1);
  60. if($row2>0)
  61. {
  62. $email = $row2['email'];
  63. $subject = "Information about your password";
  64. $password=$row2['password'];
  65. $message = "Your password is ".$password;
  66. mail($email, $subject, $message, "From: $email");
  67. echo "<script>alert('Your Password has been sent Successfully');</script>";
  68. }
  69. else
  70. {
  71. echo "<script>alert('Email not register with us');</script>";
  72. }
  73. }
  74.  
  75. ?>
  76. <!DOCTYPE html>
  77. <html>
  78. <head>
  79. <title>Login System</title>
  80. <link href="css/style.css" rel='stylesheet' type='text/css' />
  81. <meta name="viewport" content="width=device-width, initial-scale=1">
  82. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  83. <meta name="keywords" content="Elegent Tab Forms,Login Forms,Sign up Forms,Registration Forms,News latter Forms,Elements"./>
  84. <script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar, 0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
  85. </script>
  86. <script src="js/jquery.min.js"></script>
  87. <script src="js/easyResponsiveTabs.js" type="text/javascript"></script>
  88. <script type="text/javascript">
  89. $(document).ready(function () {
  90. $('#horizontalTab').easyResponsiveTabs({
  91. type: 'default',
  92. width: 'auto',
  93. fit: true
  94. });
  95. });
  96. </script>
  97. <link href='http://fonts.googleapis.com/css?family=Source+Sans+Pro:200,400,600,700,200italic,300italic,400italic,600italic|L
    ora:400,700,400italic,700italic|Raleway:400,500,300,600,700,200,100' rel='stylesheet' type='text/css'>
  98. </head>
  99. <body>
  100. <div class="main">
  101. <h1>Registration and Login System</h1>
  102. <div class="sap_tabs">
  103. <div id="horizontalTab" style="display: block; width: 100%; margin: 0px;">
  104. <ul class="resp-tabs-list">
  105. <li class="resp-tab-item" aria-controls="tab_item-0" role="tab"><div class="top-img"><img src="images/top-note.png" alt=""/></div><span>Register</span>
  106.  
  107. </li>
  108. <li class="resp-tab-item" aria-controls="tab_item-1" role="tab"><div class="top-img"><img src="images/top-lock.png" alt=""/></div><span>Login</span></li>
  109. <li class="resp-tab-item lost" aria-controls="tab_item-2" role="tab"><div class="top-img"><img src="images/top-key.png" alt=""/></div><span>Forgot Password</span></li>
  110. <div class="clear"></div>
  111. </ul>
  112.  
  113. <div class="resp-tabs-container">
  114. <div class="tab-1 resp-tab-content" aria-labelledby="tab_item-0">
  115. <div class="facts">
  116.  
  117. <div class="register">
  118. <form name="registration" method="post" action="" enctype="multipart/form-data">
  119. <p>First Name </p>
  120. <input type="text" class="text" value="" name="fname" required >
  121. <p>Last Name </p>
  122. <input type="text" class="text" value="" name="lname" required >
  123. <p>Email Address </p>
  124. <input type="text" class="text" value="" name="email" >
  125. <p>Password </p>
  126. <input type="password" value="" name="password" required>
  127. <p>Contact No. </p>
  128. <input type="text" value="" name="contact" required>
  129. <div class="sign-up">
  130. <input type="reset" value="Reset">
  131. <input type="submit" name="signup" value="Sign Up" >
  132. <div class="clear"> </div>
  133. </div>
  134. </form>
  135.  
  136. </div>
  137. </div>
  138. </div>
  139. <div class="tab-2 resp-tab-content" aria-labelledby="tab_item-1">
  140. <div class="facts">
  141. <div class="login">
  142. <div class="buttons">
  143.  
  144.  
  145. </div>
  146. <form name="login" action="" method="post">
  147. <input type="text" class="text" name="uemail" value="" placeholder="Enter your registered email" ><a href="#" class=" icon email"></a>
  148.  
  149. <input type="password" value="" name="password" placeholder="Enter valid password"><a href="#" class=" icon lock"></a>
  150.  
  151. <div class="p-container">
  152.  
  153. <div class="submit two">
  154. <input type="submit" name="login" value="LOG IN" >
  155. </div>
  156. <div class="clear"> </div>
  157. </div>
  158.  
  159. </form>
  160. </div>
  161. </div>
  162. </div>
  163. <div class="tab-2 resp-tab-content" aria-labelledby="tab_item-1">
  164. <div class="facts">
  165. <div class="login">
  166. <div class="buttons">
  167.  
  168.  
  169. </div>
  170. <form name="login" action="" method="post">
  171. <input type="text" class="text" name="femail" value="" placeholder="Enter your registered email" required ><a href="#" class=" icon email"></a>
  172.  
  173. <div class="submit three">
  174. <input type="submit" name="send" onClick="myFunction()" value="Send Email" >
  175. </div>
  176. </form>
  177. </div>
  178. </div>
  179. </div>
  180. </div>
  181. </div>
  182. </div>
  183. </div>
  184.  
  185. </body>
  186. </html>
MGie
sprawdzaj:
  1. if(isset($_SESSION['login']))
Kshyhoo
Proszę poprawić tytuł wątku na zgodny z zasadami działu.
damain1960
nie działa !

czy ktoś mógł by dodać do powyszego kodu linijkę:

  1. $existsLogin = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE login='$login' LIMIT 1"));
  2. $existsEmail = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM users WHERE email='$email' LIMIT 1"));
Star
  1. if(isset($_POST['signup']))
  2. {
  3. $fname=$_POST['fname'];
  4. $lname=$_POST['lname'];
  5. $email=$_POST['email'];
  6. $password=$_POST['password'];
  7. $contact=$_POST['contact'];
  8. $enc_password=md5($password);
  9. $a=date('Y-m-d');
  10.  
  11. $query = "SELECT * FROM users WHERE email = '$_POST[email]' OR fname = '$_POST[fname]'";
  12. $result = mysql_fetch_array(mysql_query($query));
  13. if($result) exit("Zapis odrzucony!Taka osoba już istnieje!");
  14.  
  15. $msg=mysql_query("insert into users(fname,lname,email,password,contactno,posting_date) values('$fname','$lname','$email','$enc_password','$contact','$a')");
  16. if($msg)
  17. {
  18. echo "<script>alert('Register successfully');</script>";
  19. }
  20. }

?
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.