Guest User

Untitled

a guest
Jul 5th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. <html>
  2. <head>
  3. <title>Creating MySQL Tables</title>
  4. </head>
  5. <body>
  6. <?php
  7. $dbhost = '109.236.84.80:3306';
  8. $dbuser = 'sitxxxxxxxe';
  9. $dbpass = 'f3cz40jEDxxxxx1';
  10. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  11. if(! $conn )
  12. {
  13. die('Could not connect: ' . mysql_error());
  14. }
  15. echo 'Connected successfully<br />';
  16. $sql = "DROP TABLE accounts";
  17. DELETE FROM `accounts` WHERE `loggedin` = 0;
  18. mysql_select_db( 'odin_sea' );
  19. $retval = mysql_query( $sql, $conn );
  20. if(! $retval )
  21. {
  22. die('Could not delete table: ' . mysql_error());
  23. }
  24. echo "Table deleted successfully\n";
  25. mysql_close($conn);
  26. ?>
  27. </body>
  28. </html>
Add Comment
Please, Sign In to add comment