Advertisement
Guest User

php

a guest
Feb 17th, 2016
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "manuel";
  4. $password = "passwort";
  5. $dbname = "werist.online";
  6. $url = "test123";
  7. $status = "ONTHELINE";
  8. $privekey = "45edzuwQJUFHBSRDGHGVVGIOWEFV";
  9. $adminlvl = "0";
  10.  
  11. // Create connection
  12. $conn = mysql_connect($servername, $username, $password, $dbname);
  13. // Check connection
  14. if (!$conn) {
  15. die("Connection failed: " . mysqli_connect_error());
  16. }
  17. $result = mysql_query("SELECT PrivKey FROM users WHERE url = 'test123'");
  18. if(mysql_num_rows($result) === NULL) {
  19. // row not found, do stuff...
  20. echo "Kunde schon vorhanden!";
  21. } else {
  22. // do other stuff..
  23. echo "Kunde wurde geschrieben";
  24.  
  25. $sql = "INSERT INTO users (PrivKey, url, status, adminlvl)
  26. VALUES ('$privekey','$url','$status','$adminlvl')";
  27.  
  28. if (mysql_query($conn, $sql)) {
  29. echo "New record created successfully";
  30. } else {
  31. echo "Error: " . $sql . "<br>" . mysql_error($conn);
  32. }
  33. }
  34. mysql_close($conn);
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement