Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.60 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.  
  5. </head>
  6.  
  7. <body>
  8. <?php
  9. if(isset($_GET['create1']))
  10. {
  11. $servername = "shahrulnizam.com";
  12. $username = "sh4hruln_mysql";
  13. $password = "8~^E}$_q)x&i";
  14. $dbname = "sh4hruln_mysql";
  15.  
  16. $conn = new mysqli($servername, $username, $password, $dbname);
  17.  
  18. if ($conn->connect_error)
  19. {
  20. die("Connection failed: " . $conn->connect_error);
  21. }
  22. else
  23. {
  24. $sql = "CREATE TABLE Table1(PersonName varchar(255),City varchar(255),Phone varchar(255));";
  25. if ($conn->query($sql) === TRUE)
  26. {
  27. echo "Table1 is created";
  28. }
  29. else
  30. {
  31. echo "Error: " . $sql . "<br>" . $conn->error;
  32. }
  33.  
  34. $conn->close();
  35. }
  36. }
  37. else if(isset($_GET['create2']))
  38. {
  39. $servername = "mysql9.000webhost.com";
  40. $username = "a7161864_finger";
  41. $password = "finger012";
  42. $dbname = "a7161864_finger";
  43.  
  44. $conn = new mysqli($servername, $username, $password, $dbname);
  45.  
  46. if ($conn->connect_error)
  47. {
  48. die("Connection failed: " . $conn->connect_error);
  49. }
  50. else
  51. {
  52. $sql = "CREATE TABLE Table1(PersonName varchar(255),City varchar(255),Phone varchar(255));";
  53. if ($conn->query($sql) === TRUE)
  54. {
  55. echo "Table1 is created";
  56. }
  57. else
  58. {
  59. echo "Error: " . $sql . "<br>" . $conn->error;
  60. }
  61.  
  62. $conn->close();
  63. }
  64. }
  65. else if(isset($_GET['drop1']))
  66. {
  67. $servername = "shahrulnizam.com";
  68. $username = "sh4hruln_mysql";
  69. $password = "8~^E}$_q)x&i";
  70. $dbname = "sh4hruln_mysql";
  71.  
  72. $conn = new mysqli($servername, $username, $password, $dbname);
  73.  
  74. if ($conn->connect_error)
  75. {
  76. die("Connection failed: " . $conn->connect_error);
  77. }
  78. else
  79. {
  80. $sql = "DROP TABLE Table1;";
  81. if ($conn->query($sql) === TRUE)
  82. {
  83. echo "Table1 is deleted";
  84. }
  85. else
  86. {
  87. echo "Error: " . $sql . "<br>" . $conn->error;
  88. }
  89.  
  90. $conn->close();
  91. }
  92. }
  93. else if(isset($_GET['drop2']))
  94. {
  95. $servername = "mysql9.000webhost.com";
  96. $username = "a7161864_finger";
  97. $password = "finger012";
  98. $dbname = "a7161864_finger";
  99.  
  100. $conn = new mysqli($servername, $username, $password, $dbname);
  101.  
  102. if ($conn->connect_error)
  103. {
  104. die("Connection failed: " . $conn->connect_error);
  105. }
  106. else
  107. {
  108. $sql = "DROP TABLE Table1;";
  109. if ($conn->query($sql) === TRUE)
  110. {
  111. echo "Table1 is deleted";
  112. }
  113. else
  114. {
  115. echo "Error: " . $sql . "<br>" . $conn->error;
  116. }
  117.  
  118. $conn->close();
  119. }
  120. }
  121. else
  122. {
  123. echo "No data";
  124. }
  125. ?>
  126. </body>
  127. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement