Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2016
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.91 KB | None | 0 0
  1. <?php
  2.  
  3. session_start();
  4. include('db.php');
  5.  
  6. ?>
  7.  
  8. <!DOCTYPE html>
  9.  
  10. <head>
  11.  
  12. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  13. <meta name="viewport" content="width=device-width,initial-scale=1" />
  14. <link rel="stylesheet" type="text/css" href="style.css"/>
  15.  
  16. </head>
  17.  
  18. <body>
  19.  
  20.  
  21. <?php
  22.  
  23. if(isset($_POST['login']) && $_POST['login'] == 'Login') {
  24. $loginEmail = $_POST['loginEmail'];
  25. $loginPassword = $_POST['loginPassword'];
  26.  
  27. $query = $db->prepare("INSERT INTO dbname(password,email) VALUES ('?','?');");
  28. $query->bind_param("ss",$loginEmail,$loginPassword);
  29. $query->execute();
  30.  
  31. }
  32. ?>
  33.  
  34. <div id="login">
  35. <strong>Login</strong>
  36.  
  37. <br/><br/>
  38.  
  39. <form action = "<?php echo $_SERVER['PHP_SELF'];?>" method="POST">
  40. <table style="width:500px">
  41. <tr>
  42. <td><input type="text" name="loginEmail" placeholder = "Email" required/><br/></td>
  43. </tr>
  44. <tr>
  45. <td><input type="password" name="loginPassword" placeholder = "Password" required/><br/></td>
  46.  
  47. </tr>
  48. </table>
  49.  
  50. <input style="font-weight: bold; width: 70px; height: 25px; border-radius: 5px;" type="submit" name="login" value="Login"/>
  51. </form>
  52. </div>
  53. </body>
  54. </html>
  55.  
  56. <?php
  57.  
  58. $host = 'host';
  59. $user = 'user';
  60. $password = 'password';
  61. $database = 'dbname';
  62.  
  63. $db = new mysqli($host, $user, $password, $database);
  64.  
  65. if($db->connect_errno > 0){
  66. die('Unable to connect to database ['.$db->connect_errno.']');
  67. }
  68. ?>
  69.  
  70. $db->prepare("INSERT INTO users(password,email) VALUES (?, ?);");
  71.  
  72. $db->prepare("INSERT INTO users(password,email) VALUES ('?','?');");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement