Advertisement
Krissz

MySQL DB Install

Jun 3rd, 2018
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.48 KB | None | 0 0
  1. <?php
  2.     //Config
  3.         $servername = "localhost";
  4.         $username = "root";
  5.         $password = "";
  6.     //End config
  7.    
  8.     if (isset ($_POST['ok'])) {
  9.         // Create connection
  10.         $conn = new mysqli($servername, $username, $password);
  11.        
  12.         // Check connection
  13.         if ($conn->connect_error) {
  14.             die("Connection failed: " . $conn->connect_error);
  15.         }
  16.  
  17.         // Create database
  18.         $sql =
  19.         "
  20.             CREATE DATABASE IF NOT EXISTS sitedb CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
  21.        
  22.             CREATE TABLE users (
  23.                 `id` int(11) NOT NULL,
  24.                 `user` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
  25.                 `pass` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
  26.                 `email` varchar(50) COLLATE utf8_hungarian_ci NOT NULL,
  27.                 `rights` int(11) DEFAULT NULL
  28.             ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci;
  29.         ";
  30.         if ($conn->query($sql) === TRUE) {
  31.             echo "Database created successfully!";
  32.         } else {
  33.             echo "Error creating database: " . $conn->error;
  34.         }
  35.  
  36.     $conn->close();
  37.     }
  38. ?>
  39.  
  40. <!DOCTYPE html>
  41. <html>
  42.     <head>
  43.         <meta charset="UTF-8">
  44.         <title>Setup</title>
  45.     </head>
  46.  
  47.     <body>
  48.         <p>
  49.         <?php
  50.             echo "<b>Current connection settings: </b><br>";
  51.             echo "<b>host:</b> ";
  52.             echo $servername;
  53.             echo "<br>";
  54.            
  55.             echo "<b>username:</b> ";
  56.             echo $username;
  57.             echo "<br>";
  58.            
  59.             echo "<b>password:</b> ";
  60.             echo $password;
  61.             echo "<br>";
  62.         ?>
  63.         </p>
  64.         <form method="POST" action="setup.php">
  65.             <input type="submit" name="ok" value="Install" >
  66.         </form>
  67.     </body>
  68.  
  69. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement