Advertisement
Guest User

Untitled

a guest
Apr 12th, 2018
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. <?php
  2.  
  3. $server_servername = "localhost";
  4. $server_username = "root";
  5. $server_password = "";
  6. $server_dbName = "quizwhizz";
  7.  
  8. $username = "test1";
  9. $password = "testpassword";
  10. $currency = 100;
  11.  
  12. $conn = new mysqli($server_servername, $server_username, $server_password, $server_dbName);
  13.  
  14. if(!$conn){
  15. die("Connection failed. ". mysqli_connect_error());
  16. }
  17.  
  18. $sql = "INSERT INTO student (username, password, currency)
  19. VALUES ('".$username."','".$password."','".$currency."')";
  20. $result = mysqli_query($conn, $sql);
  21.  
  22. if(!$result) echo "there was error";
  23. else echo "everything ok.";
  24.  
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement