Advertisement
Guest User

Untitled

a guest
Jun 21st, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. <pre>
  2. Database Name: <?php
  3. print_r($_POST['dbname']);
  4. ?>
  5. </pre>
  6. <pre>
  7. Username: <?php
  8. print_r($_POST['username']);
  9. ?>
  10. </pre>
  11. <pre>
  12. Password: <?php
  13. print_r($_POST['password']);
  14. ?>
  15. </pre>
  16. <?php if($_POST['dbname']){
  17. echo "<h2 style=\"color:green\">Database has been created</h2>";
  18. } else{
  19. echo "<h2 style=\"color:red\">Sorry you did not enter any Database name";
  20. }
  21. ?>
  22.  
  23. <?php
  24.  
  25. $host="localhost"; // host name
  26.  
  27. $root="root"; // phpmyadmin username default is root
  28. $root_password=""; // if password is exist
  29.  
  30. $user= $_POST['username'];
  31. $pass= $_POST['password'];
  32. $db= $_POST['dbname'];
  33.  
  34. try {
  35. $dbh = new PDO("mysql:host=$host", $root, $root_password);
  36.  
  37. $dbh->exec("CREATE DATABASE `$db`;
  38. CREATE USER '$user'@'localhost' IDENTIFIED BY '$pass';
  39. GRANT ALL ON `$db`.* TO '$user'@'localhost';
  40. FLUSH PRIVILEGES;")
  41. or die(print_r($dbh->errorInfo(), true));
  42.  
  43. } catch (PDOException $e) {
  44. die("DB ERROR: ". $e->getMessage());
  45. }
  46.  
  47. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement