API tools faq
paste
Advertisement
Guest User

Database connection and selects example via PHP, XSJS

a guest
Feb 18th, 2019
133
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 6.01 KB | None | 0 0
raw download clone embed print report
  1. [XSJS]
  2. Database connection and selects example via PHP (Mysql DB)
  3. # home.html
  4. <!DOCTYPE html>
  5. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  6.  
  7. <!-- jQuery library -->
  8. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  9.  
  10. <!-- Latest compiled JavaScript -->
  11. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  12.  
  13. <head>
  14.     <meta charset="UTF-8">
  15.     <title>My Example</title>
  16.     <link rel="stylesheet" type="text/css" href="mystyle.css">
  17. </head>
  18. <html>
  19.     <nav class="navbar navbar-default">
  20.         <a class="navbar-brand">My Example</a>
  21.         <ul class="nav navbar-nav">
  22.             <li class="active"><a href="home.php">Databases</a></li>
  23.         </ul>
  24.     </nav>
  25.    
  26.     <?php
  27.      $strDbLocation = 'mysql:dbname=dbname;host=127.0.0.1';
  28.      $strDbUser = 'root';
  29.      $strDbPassword = 'root';
  30.      try
  31.      {
  32.          $objDb = new PDO($strDbLocation, $strDbUser, $strDbPassword);
  33.      }
  34.      catch(PDOException $e)
  35.      {
  36.          echo 'Datenbank-Fehler: '. $e -> getMessage();
  37.             exit("");
  38.         }
  39.         $sql = "SHOW DATABASES";
  40.         $data = $objDb->query($sql)->fetchAll();
  41.         echo "<div class='container'>";
  42.         echo "<div class='card'>";
  43.         echo "<ul class='list-group list-group-flush'>";
  44.         foreach($data as $row){
  45.             $value = $row["Database"];
  46.             echo "<li class='list-group-item db-card'>$value<a href='secondpage.php?db=$value' class='btn btn-success' style='float:right;'>Go</a></li>";
  47.         }
  48.         echo "</ul></div></div>";
  49.     ?>
  50. </html>
  51.  
  52. # secondepage.php
  53. <!DOCTYPE html>
  54. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  55.  
  56. <!-- jQuery library -->
  57. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  58.  
  59. <!-- Latest compiled JavaScript -->
  60. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  61.  
  62. <head>
  63.     <meta charset="UTF-8">
  64.     <title>My Example</title>
  65.     <link rel="stylesheet" type="text/css" href="mystyle.css">
  66. </head>
  67. <html>
  68.     <nav class="navbar navbar-default">
  69.         <a class="navbar-brand">My Example</a>
  70.         <ul class="nav navbar-nav">
  71.             <li><a href="home.php">Databases</a></li>
  72.         </ul>
  73.     </nav>
  74.    
  75.     <?php
  76.      $strDbLocation = 'mysql:dbname=dbname;host=127.0.0.1';
  77.      $strDbUser = 'root';
  78.      $strDbPassword = 'root';
  79.      $searchQuery = '';
  80.      try
  81.      {
  82.          $objDb = new PDO($strDbLocation, $strDbUser, $strDbPassword);
  83.      }
  84.      catch(PDOException $e)
  85.      {
  86.          echo 'Datenbank-Fehler: '. $e -> getMessage();
  87.             exit("");
  88.         }
  89.         $searchQuery = $_GET["db"];
  90.         $sql = "SHOW TABLES from $searchQuery";
  91.         $data = $objDb->query($sql)->fetchAll();
  92.         echo "<div class='container'>";
  93.         echo "<div class='card'>";
  94.         echo "<ul class='list-group list-group-flush'>";
  95.         foreach($data as $row){
  96.             $value = $row["Tables_in_$searchQuery"];
  97.             echo "<li class='list-group-item db-card'>$value<a href='result.php?db=$searchQuery&table=$value' class='btn btn-success' style='float:right;'>Go</a></li>";
  98.         }
  99.         echo "</ul></div></div>";
  100.     ?>
  101. </html>
  102.  
  103. # result.php
  104. <!DOCTYPE html>
  105. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  106.  
  107. <!-- jQuery library -->
  108. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  109.  
  110. <!-- Latest compiled JavaScript -->
  111. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  112.  
  113. <head>
  114.     <meta charset="UTF-8">
  115.     <title>My Example</title>
  116.     <link rel="stylesheet" type="text/css" href="mystyle.css">
  117. </head>
  118. <html>
  119.     <nav class="navbar navbar-default">
  120.         <a class="navbar-brand">Tankstelle</a>
  121.         <ul class="nav navbar-nav">
  122.             <li><a href="home.php">Databases</a></li>
  123.         </ul>
  124.     </nav>
  125.    
  126.     <?php
  127.      $strDbLocation = 'mysql:dbname=dbname;host=127.0.0.1';
  128.      $strDbUser = 'root';
  129.      $strDbPassword = 'root';
  130.      $table = '';
  131.      try
  132.      {
  133.          $objDb = new PDO($strDbLocation, $strDbUser, $strDbPassword);
  134.      }
  135.      catch(PDOException $e)
  136.      {
  137.          echo 'Datenbank-Fehler: '. $e -> getMessage();
  138.             exit("");
  139.         }
  140.         $table = $_GET["table"];
  141.         $db = $_GET["db"];
  142.         $sql = "DESCRIBE $db.$table";
  143.         $data = $objDb->query($sql)->fetchAll();
  144.         echo "<div class='container'>";
  145.         echo "<table class='table'><thead><tr>";
  146.         echo "<th scope='col'>Field</th>";
  147.         echo "<th scope='col'>Type</th>";
  148.         echo "<th scope='col'>Null</th>";
  149.         echo "<th scope='col'>Key</th>";
  150.         echo "<th scope='col'>Default</th>";
  151.         echo "<th scope='col'>Extra</th></thead><tbody>";
  152.         foreach($data as $row){
  153.             $field = $row["Field"];
  154.             $type = $row["Type"];
  155.             $isNull = $row["Null"];
  156.             $key = $row["Key"];
  157.             $default = $row["Default"];
  158.             $extra = $row["Extra"];
  159.             echo "<tr>
  160.                 <td>$field</td>
  161.                 <td>$type</td>
  162.                 <td>$isNull</td>
  163.                 <td>$key</td>
  164.                 <td>$default</td>
  165.                 <td>$extra</td>
  166.                 </tr>";
  167.         }
  168.         echo "</tbody></div>";
  169.     ?>
  170. </html>
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!