Advertisement
Guest User

database

a guest
Jul 25th, 2018
305
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.21 KB | None | 0 0
  1. <?php
  2. if (isset($_POST[1]) && isset($_POST[2]) && isset($_POST[3]) && isset($_POST[4])) {
  3.  
  4. $servername = "localhost";
  5. $username = "root";
  6. $password = "";
  7. $dbname = "database";
  8.  
  9. $conn = new mysqli($servername, $username, $password, $dbname);
  10.  
  11. if ($conn->connect_error) {
  12.     die("Connection failed: " . $conn->connect_error);
  13. }
  14.  
  15. $sql = "SELECT eMail FROM dero";
  16. $result = $conn->query($sql);
  17.  
  18. if ($result->num_rows > 0) {
  19.     // output data of each row
  20.     while($row = $result->fetch_assoc()) {
  21.         //echo "id: " . $row["eMail"];
  22.         if ($row["eMail"] == $_POST[2]) {
  23.           echo '<script>
  24.          document.getElementById("r_passw_error").innerHTML="↻ un account con questa mail esiste gia";
  25.          $("#r_passw").blur (function (e){document.getElementById("r_passw_error").innerHTML=""});
  26.          </script>';
  27.          
  28.         } else {
  29.               $query = "INSERT INTO dero (user, eMail, Password) VALUES ('$_POST[1]','$_POST[2]','$_POST[3]')";
  30.               $result = mysqli_query($conn, $query);
  31.               if (!$result) {
  32.               die("errore nella qery $query:");}
  33.               echo '<p style ="color: red;">tutto funziona per il meglio</p>';
  34.  
  35.         }
  36.     }
  37. }
  38. }
  39. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement