Guest User

Untitled

a guest
Mar 23rd, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. #!/usr/bin/env php
  2. <?php
  3. if (defined('STDIN')) {
  4. $hostdb = $argv[1];
  5. $dbname = $argv[2];
  6. $userdb = $argv[3];
  7. $passdb = $argv[4];
  8. }
  9. $servername = $hostdb;
  10. $username = $userdb;
  11. $password = $passdb;
  12.  
  13. // Create connection
  14. $conn = new mysqli($servername, $username, $password);
  15. // Check connection
  16. if ($conn->connect_error) {
  17. die("Connection failed: " . $conn->connect_error);
  18. }
  19.  
  20. // Create database
  21. $sql = "CREATE DATABASE IF NOT EXISTS ".$dbname." CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
  22. if ($conn->query($sql) === TRUE) {
  23. echo "Database created successfully";
  24. } else {
  25. echo "Error creating database: " . $conn->error;
  26. }
  27.  
  28. $conn->close();
Add Comment
Please, Sign In to add comment