Guest User

Untitled

a guest
Mar 21st, 2017
26
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "username";
  4. $password = "password";
  5.  
  6. // Create connection
  7. $conn = new mysqli($servername, $username, $password);
  8. // Check connection
  9. if ($conn->connect_error) {
  10. die("Connection failed: " . $conn->connect_error);
  11. }
  12.  
  13. // Create database
  14. $sql = "CREATE DATABASE myDB";
  15. if ($conn->query($sql) === TRUE) {
  16. echo "Database created successfully";
  17. } else {
  18. echo "Error creating database: " . $conn->error;
  19. }
  20.  
  21. $conn->close();
  22. ?>
  23.  
  24. Note: When you create a new database, you must only specify the first three arguments to the mysqli object (servername, username and password).
  25.  
  26. Tip: If you have to use a specific port, add an empty string for the database-name argument, like this: new mysqli("localhost", "username", "password", "", port)
  27.  
  28. Example (MySQLi Procedural)
  29. <?php
  30. $servername = "63.223.86.80";
  31. $username = "root";
  32. $password = "password";
  33.  
  34. // Create connection
  35. $conn = mysqli_connect($servername, $username, $password);
  36. // Check connection
  37. if (!$conn) {
  38. die("Connection failed: " . mysqli_connect_error());
  39. }
  40.  
  41. // Create database
  42. $sql = "CREATE DATABASE TEST";
  43. if (mysqli_query($conn, $sql)) {
  44. echo "Database created successfully";
  45. } else {
  46. echo "Error creating database: " . mysqli_error($conn);
  47. }
  48.  
  49. mysqli_close($conn);
  50. ?>
Add Comment
Please, Sign In to add comment