Advertisement
Guest User

Untitled

a guest
Nov 29th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. <?php
  2.  
  3. /*
  4. * A MySQL DROP example using Java
  5. * @author mysqlcommands.com
  6. */
  7.  
  8. /*
  9. * A MySQL UPDATE example using Java
  10. * @author mysqlcommands.com
  11. */
  12.  
  13. //connect to mysql
  14. $dbhost = 'localhost:3036';
  15. $dbuser = 'root';
  16. $dbpass = 'rootpassword';
  17. $conn = mysql_connect($dbhost, $dbuser, $dbpass);
  18. if (!$conn) {
  19. die('Could not connect: ' . mysql_error());
  20. }
  21. echo 'Connected successfully<br />';
  22. //set query for variable
  23. $sql = 'DROP DATABASE demo_databas';
  24. //set query for variable
  25. //run drop query
  26. $retval = mysql_query($sql, $conn);
  27. if (!$retval) {
  28. die('Could not delete database: ' . mysql_error());
  29. }
  30. echo "Database demo_databas deleted successfully\n";
  31. mysql_close($conn);
  32. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement