Advertisement
Guest User

Untitled

a guest
Jul 8th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. <?php
  2.  
  3. /*
  4. * SETTINGS!
  5. */
  6. $databaseName = 'oo_battle';
  7. $databaseUser = 'root';
  8. $databasePassword = '';
  9.  
  10. /*
  11. * CREATE THE DATABASE
  12. */
  13. $pdoDatabase = new PDO('mysql:host=localhost', $databaseUser, $databasePassword);
  14. $pdoDatabase->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  15. $pdoDatabase->exec('CREATE DATABASE IF NOT EXISTS oo_battle');
  16.  
  17. /*
  18. * CREATE THE TABLE
  19. */
  20. $pdo = new PDO('mysql:host=localhost;dbname='.$databaseName, $databaseUser, $databasePassword);
  21. $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  22.  
  23. // initialize the table
  24. $pdo->exec('DROP TABLE IF EXISTS ship;');
  25.  
  26. $pdo->exec('CREATE TABLE `ship` (
  27. `id` int(11) NOT NULL AUTO_INCREMENT,
  28. `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  29. `weapon_power` int(4) NOT NULL,
  30. `jedi_factor` int(4) NOT NULL,
  31. `strength` int(4) NOT NULL,
  32. `is_under_repair` tinyint(1) NOT NULL,
  33. PRIMARY KEY (`id`)
  34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci');
  35.  
  36. /*
  37. * INSERT SOME DATA!
  38. */
  39. $pdo->exec('INSERT INTO ship
  40. (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
  41. ("Jedi Starfighter", 5, 15, 30, 0)'
  42. );
  43. $pdo->exec('INSERT INTO ship
  44. (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
  45. ("CloakShape Fighter", 2, 2, 70, 0)'
  46. );
  47. $pdo->exec('INSERT INTO ship
  48. (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
  49. ("Super Star Destroyer", 70, 0, 500, 0)'
  50. );
  51. $pdo->exec('INSERT INTO ship
  52. (name, weapon_power, jedi_factor, strength, is_under_repair) VALUES
  53. ("RZ-1 A-wing interceptor", 4, 4, 50, 0)'
  54. );
  55.  
  56. echo 'Ding!';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement