API tools faq
paste
Guest User

Untitled

a guest
May 7th, 2018
95
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.46 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. /*** mysql hostname ***/
  4. $hostname = '**********.com';
  5.  
  6. /*** mysql port ***/
  7. $port = '****';
  8.  
  9. /*** mysql username ***/
  10. $username = '*******';
  11.  
  12. /*** mysql password ***/
  13. $password = '*******';
  14.  
  15. /*** database name ***/
  16. $dbname = 'periodic_table';
  17.  
  18.  
  19. $data = array(
  20. array('atomicnumber' => 1, 'latin' => 'HYDROGENIUM', 'english' => 'Hydrogen', 'abbr' => 'H'),
  21. array('atomicnumber' => 2, 'latin' => 'HELIUM', 'english' => 'Helium', 'abbr' => 'He'),
  22. array('atomicnumber' => 3, 'latin' => 'LITHIUM', 'english' => 'Lithium', 'abbr' => 'Li'),
  23. array('atomicnumber' => 4, 'latin' => 'Beryllium', 'english' => 'Beryllium', 'abbr' => 'Be'),
  24. array('atomicnumber' => 5, 'latin' => 'Borum', 'english' => 'Boron', 'abbr' => 'B'),
  25. array('atomicnumber' => 6, 'latin' => 'Carboneum', 'english' => 'Carbon', 'abbr' => 'C'),
  26. array('atomicnumber' => 7, 'latin' => 'Nitrogenium', 'english' => 'Nitrogen', 'abbr' => 'N'),
  27. array('atomicnumber' => 8, 'latin' => 'Oxygenium', 'english' => 'Oxygen', 'abbr' => 'O'),
  28. array('atomicnumber' => 9, 'latin' => 'Fluorum', 'english' => 'Fluorine', 'abbr' => 'F'),
  29. array('atomicnumber' => 10, 'latin' => 'Neon', 'english' => 'Neon', 'abbr' => 'Ne'),
  30. array('atomicnumber' => 11, 'latin' => 'Natrium', 'english' => 'Sodium', 'abbr' => 'Na'),
  31. array('atomicnumber' => 12, 'latin' => 'Magnesium', 'english' => 'Magnesium', 'abbr' => 'Mg'),
  32. array('atomicnumber' => 13, 'latin' => 'aluminium', 'english' => 'Aluminum', 'abbr' => 'Al'),
  33. array('atomicnumber' => 14, 'latin' => 'Silicium', 'english' => 'Silicon', 'abbr' => 'Si'),
  34. array('atomicnumber' => 15, 'latin' => 'Phosphorus', 'english' => 'Phosphorus', 'abbr' => 'P'),
  35. array('atomicnumber' => 16, 'latin' => 'Sulphur', 'english' => 'Sulphur', 'abbr' => 'S'),
  36. array('atomicnumber' => 17, 'latin' => 'Chlorum', 'english' => 'Chlorine', 'abbr' => 'Cl'),
  37. array('atomicnumber' => 18, 'latin' => 'Argon', 'english' => 'argon', 'abbr' => 'Ar'),
  38. array('atomicnumber' => 19, 'latin' => 'Kalium', 'english' => 'Potassium', 'abbr' => 'K'),
  39. array('atomicnumber' => 20, 'latin' => 'Calcium', 'english' => 'Calcium', 'abbr' => 'Ca'),
  40. array('atomicnumber' => 21, 'latin' => 'Scandium', 'english' => 'Scandium', 'abbr' => 'Sc'),
  41. array('atomicnumber' => 22, 'latin' => 'Titanium', 'english' => 'Titanium', 'abbr' => 'Ti'),
  42. array('atomicnumber' => 23, 'latin' => 'Vanadium', 'english' => 'Vanadium', 'abbr' => 'V'),
  43. array('atomicnumber' => 24, 'latin' => 'Chromium', 'english' => 'Chromium', 'abbr' => 'Cr'),
  44. array('atomicnumber' => 25, 'latin' => 'Manganum', 'english' => 'Manganese', 'abbr' => 'Mn'),
  45. array('atomicnumber' => 26, 'latin' => 'Ferrum', 'english' => 'Iron', 'abbr' => 'Fe'),
  46. array('atomicnumber' => 27, 'latin' => 'Cobaltum', 'english' => 'Cobalt', 'abbr' => 'Co'),
  47. array('atomicnumber' => 28, 'latin' => 'Niccolum', 'english' => 'Nickel', 'abbr' => 'Ni'),
  48. array('atomicnumber' => 29, 'latin' => 'Cuprum', 'english' => 'Copper', 'abbr' => 'Cu'),
  49. array('atomicnumber' => 30, 'latin' => 'Zincum', 'english' => 'Zinc', 'abbr' => 'Zn'),
  50. array('atomicnumber' => 31, 'latin' => 'Gallium', 'english' => 'Gallium', 'abbr' => 'Ga'),
  51. array('atomicnumber' => 32, 'latin' => 'Germanium', 'english' => 'Germanium', 'abbr' => 'Ge'),
  52. array('atomicnumber' => 33, 'latin' => 'Arsenicum', 'english' => 'Arsenic', 'abbr' => 'As'),
  53. array('atomicnumber' => 34, 'latin' => 'Selenium', 'english' => 'Selenium', 'abbr' => 'Se'),
  54. array('atomicnumber' => 35, 'latin' => 'Bromum', 'english' => 'Bromine', 'abbr' => 'Br'),
  55. array('atomicnumber' => 36, 'latin' => 'Krypton', 'english' => 'Krypton', 'abbr' => 'Kr'),
  56. array('atomicnumber' => 37, 'latin' => 'Rubidium', 'english' => 'Rubidium', 'abbr' => 'Rb'),
  57. array('atomicnumber' => 38, 'latin' => 'Strontium', 'english' => 'Strontium', 'abbr' => 'Sr'),
  58. array('atomicnumber' => 39, 'latin' => 'Yttrium', 'english' => 'Yttrium', 'abbr' => 'Y'),
  59. array('atomicnumber' => 40, 'latin' => 'Zirkonium', 'english' => 'Zirkonium', 'abbr' => 'Zr'),
  60. array('atomicnumber' => 41, 'latin' => 'Niobium', 'english' => 'Niobium', 'abbr' => 'Nb'),
  61. array('atomicnumber' => 42, 'latin' => 'Molybdaenum', 'english' => 'Molybdaenum', 'abbr' => 'Mo'),
  62. array('atomicnumber' => 43, 'latin' => 'Technetium', 'english' => 'Technetium', 'abbr' => 'Tc'),
  63. array('atomicnumber' => 44, 'latin' => 'Ruthenium', 'english' => 'Ruthenium', 'abbr' => 'Ru'),
  64. array('atomicnumber' => 45, 'latin' => 'Rhodium', 'english' => 'Rhodium', 'abbr' => 'Rh'),
  65. array('atomicnumber' => 46, 'latin' => 'Palladium', 'english' => 'Palladium', 'abbr' => 'Pd'),
  66. array('atomicnumber' => 47, 'latin' => 'Argentum', 'english' => 'Silver', 'abbr' => 'Ag'),
  67. array('atomicnumber' => 48, 'latin' => 'Cadmium', 'english' => 'Cadmium', 'abbr' => 'Cd'),
  68. array('atomicnumber' => 49, 'latin' => 'Indium', 'english' => 'Indium', 'abbr' => 'In'),
  69. array('atomicnumber' => 50, 'latin' => 'Stannum', 'english' => 'Tin', 'abbr' => 'Sn'),
  70. array('atomicnumber' => 51, 'latin' => 'Stibium', 'english' => 'Antimony', 'abbr' => 'Sb'),
  71. array('atomicnumber' => 52, 'latin' => 'Tellurium', 'english' => 'Tellurium', 'abbr' => 'Te'),
  72. array('atomicnumber' => 53, 'latin' => 'Iodum', 'english' => 'Iodine', 'abbr' => 'I'),
  73. array('atomicnumber' => 54, 'latin' => 'Xenon', 'english' => 'Xenon', 'abbr' => 'Xe'),
  74. array('atomicnumber' => 55, 'latin' => 'Caesium', 'english' => 'Cesium', 'abbr' => 'Cs'),
  75. array('atomicnumber' => 56, 'latin' => 'Baryum', 'english' => 'Barium', 'abbr' => 'Ba'),
  76. array('atomicnumber' => 57, 'latin' => 'Lanthanum', 'english' => 'Lanthanum', 'abbr' => 'La'),
  77. array('atomicnumber' => 58, 'latin' => 'Cerium', 'english' => 'Cerium', 'abbr' => 'Ce'),
  78. array('atomicnumber' => 59, 'latin' => 'Praseodymium', 'english' => 'Praseodymium', 'abbr' => 'Pr'),
  79. array('atomicnumber' => 60, 'latin' => 'Neodymium', 'english' => 'Neodymium', 'abbr' => 'Nd'),
  80. array('atomicnumber' => 61, 'latin' => 'Promethium', 'english' => 'Promethium', 'abbr' => 'Pm'),
  81. array('atomicnumber' => 62, 'latin' => 'Samarium', 'english' => 'Samarium', 'abbr' => 'Sm'),
  82. array('atomicnumber' => 63, 'latin' => 'Europium', 'english' => 'Europium', 'abbr' => 'Eu'),
  83. array('atomicnumber' => 64, 'latin' => 'Gadolinium', 'english' => 'Gadolinium', 'abbr' => 'Gd'),
  84. array('atomicnumber' => 65, 'latin' => 'Terbium', 'english' => 'Terbium', 'abbr' => 'Tb'),
  85. array('atomicnumber' => 66, 'latin' => 'Dysprosium', 'english' => 'Dysprosium', 'abbr' => 'Dy'),
  86. array('atomicnumber' => 67, 'latin' => 'Holmium', 'english' => 'Holmium', 'abbr' => 'Ho'),
  87. array('atomicnumber' => 68, 'latin' => 'Erbium', 'english' => 'Erbium', 'abbr' => 'Er'),
  88. array('atomicnumber' => 69, 'latin' => 'Thulium', 'english' => 'Thulium', 'abbr' => 'Tm'),
  89. array('atomicnumber' => 70, 'latin' => 'Ytterbium', 'english' => 'Ytterbium', 'abbr' => 'Yb'),
  90. array('atomicnumber' => 71, 'latin' => 'Lutetium', 'english' => 'Lutetium', 'abbr' => 'Lu'),
  91. array('atomicnumber' => 72, 'latin' => 'Hafnium', 'english' => 'Hafnium', 'abbr' => 'Hf'),
  92. array('atomicnumber' => 73, 'latin' => 'Tantalum', 'english' => 'Tantalum', 'abbr' => 'Ta'),
  93. array('atomicnumber' => 74, 'latin' => 'Wolframium', 'english' => 'Tungsten', 'abbr' => 'W'),
  94. array('atomicnumber' => 75, 'latin' => 'Rhenium', 'english' => 'Rhenium', 'abbr' => 'Re'),
  95. array('atomicnumber' => 76, 'latin' => 'Osmium', 'english' => 'Osmium', 'abbr' => 'Os'),
  96. array('atomicnumber' => 77, 'latin' => 'Iridium', 'english' => 'Iridium', 'abbr' => 'Ir'),
  97. array('atomicnumber' => 78, 'latin' => 'Platinum', 'english' => 'Platinum', 'abbr' => 'Pt'),
  98. array('atomicnumber' => 79, 'latin' => 'Aurum', 'english' => 'Gold', 'abbr' => 'Au'),
  99. array('atomicnumber' => 80, 'latin' => 'Mercury', 'english' => 'Hydrargyrum', 'abbr' => 'Hg'),
  100. array('atomicnumber' => 81, 'latin' => 'Thallium', 'english' => 'Thallium', 'abbr' => 'Tl'),
  101. array('atomicnumber' => 82, 'latin' => 'Plumbum', 'english' => 'Lead', 'abbr' => 'Pb'),
  102. array('atomicnumber' => 83, 'latin' => 'Bismuthum', 'english' => 'Bismuth', 'abbr' => 'Bi'),
  103. array('atomicnumber' => 84, 'latin' => 'Polonium', 'english' => 'Polonium', 'abbr' => 'Po'),
  104. array('atomicnumber' => 85, 'latin' => 'Astatium', 'english' => 'Astatine', 'abbr' => 'At'),
  105. array('atomicnumber' => 86, 'latin' => 'Radon', 'english' => 'Radon', 'abbr' => 'Rn'),
  106. array('atomicnumber' => 87, 'latin' => 'Francium', 'english' => 'Francium', 'abbr' => 'Fr'),
  107. array('atomicnumber' => 88, 'latin' => 'Radium', 'english' => 'Radium', 'abbr' => 'Ra'),
  108. array('atomicnumber' => 89, 'latin' => 'Actinium', 'english' => 'Actinium', 'abbr' => 'Ac'),
  109. array('atomicnumber' => 90, 'latin' => 'Thorium', 'english' => 'Thorium', 'abbr' => 'Th'),
  110. array('atomicnumber' => 91, 'latin' => 'Protactinium', 'english' => 'Protactinium', 'abbr' => 'Pa'),
  111. array('atomicnumber' => 92, 'latin' => 'Uranium', 'english' => 'Uranium', 'abbr' => 'U'),
  112. array('atomicnumber' => 93, 'latin' => 'Neptunium', 'english' => 'Neptunium', 'abbr' => 'Np'),
  113. array('atomicnumber' => 94, 'latin' => 'Plutonium', 'english' => 'Plutonium', 'abbr' => 'Pu'),
  114. array('atomicnumber' => 95, 'latin' => 'Americium', 'english' => 'Americium', 'abbr' => 'Am'),
  115. array('atomicnumber' => 96, 'latin' => 'Curium', 'english' => 'Curium', 'abbr' => 'Cm'),
  116. array('atomicnumber' => 97, 'latin' => 'Berkelium', 'english' => 'Berkelium', 'abbr' => 'Bk'),
  117. array('atomicnumber' => 98, 'latin' => 'Californium', 'english' => 'Californium', 'abbr' => 'Cf'),
  118. array('atomicnumber' => 99, 'latin' => 'Einsteinium', 'english' => 'Einsteinium', 'abbr' => 'Es'),
  119. array('atomicnumber' => 100, 'latin' => 'Fermium', 'english' => 'Fermium', 'abbr' => 'Fm'),
  120. array('atomicnumber' => 101, 'latin' => 'Mendelevium', 'english' => 'Mendelevium', 'abbr' => 'Md'),
  121. array('atomicnumber' => 102, 'latin' => 'Nobelium', 'english' => 'Nobelium', 'abbr' => 'No'),
  122. array('atomicnumber' => 103, 'latin' => 'Lawrencium', 'english' => 'Lawrencium', 'abbr' => 'Lr'),
  123. array('atomicnumber' => 104, 'latin' => 'Rutherfordium', 'english' => 'Rutherfordium', 'abbr' => 'Rf'),
  124. array('atomicnumber' => 105, 'latin' => 'Dubnium', 'english' => 'Dubnium', 'abbr' => 'Db'),
  125. array('atomicnumber' => 106, 'latin' => 'Seaborgium', 'english' => 'Seaborgium', 'abbr' => 'Sg'),
  126. array('atomicnumber' => 107, 'latin' => 'Bohrium', 'english' => 'Bohrium', 'abbr' => 'Bh'),
  127. array('atomicnumber' => 108, 'latin' => 'Hassium', 'english' => 'Hassium', 'abbr' => 'Hs'),
  128. array('atomicnumber' => 109, 'latin' => 'Meitnerium', 'english' => 'Meitnerium', 'abbr' => 'Mt')
  129. );
  130.  
  131. try {
  132. $dbh = new PDO("mysql:host=$hostname;port=$port;dbname=$dbname", $username, $password);
  133. /*** echo a message saying we have connected ***/
  134. echo 'Connected to database<br />';
  135.  
  136. /*** set the PDO error mode to exception ***/
  137. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  138.  
  139. /*** prepare the sql ***/
  140. $stmt = $dbh->prepare("INSERT INTO elements (atomicnumber, latin, english, abbr)
  141. VALUES (:atomicnumber, :latin, :english, :abbr)");
  142.  
  143. $stmt->bindParam(':atomicnumber', $atomicnumber);
  144. $stmt->bindParam(':latin', $latin);
  145. $stmt->bindParam(':english', $english);
  146. $stmt->bindParam(':abbr', $abbr);
  147.  
  148. foreach($data as $e){
  149. extract($e, EXTR_OVERWRITE);
  150. $stmt->execute();
  151. }
  152.  
  153. /*** echo a message to say the database was created ***/
  154. echo 'Records entered successfully<br />';
  155. }
  156. catch(PDOException $e)
  157. {
  158. /*** echo the sql statement and error message ***/
  159. echo $sql . '<br />' . $e->getMessage();
  160. }
  161. ?>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!