Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Creating MySQL Tables</title>
- </head>
- <body>
- <?php
- $dbhost = '109.236.84.80:3306';
- $dbuser = 'sitxxxxxxxe';
- $dbpass = 'f3cz40jEDxxxxx1';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass);
- if(! $conn )
- {
- die('Could not connect: ' . mysql_error());
- }
- echo 'Connected successfully<br />';
- $sql = "DROP TABLE accounts";
- DELETE FROM `accounts` WHERE `loggedin` = 0;
- mysql_select_db( 'odin_sea' );
- $retval = mysql_query( $sql, $conn );
- if(! $retval )
- {
- die('Could not delete table: ' . mysql_error());
- }
- echo "Table deleted successfully\n";
- mysql_close($conn);
- ?>
- </body>
- </html>
Add Comment
Please, Sign In to add comment