API tools faq
paste
Guest User

Database connection and selects example via PHP

a guest
Feb 18th, 2019
72
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 5.28 KB | None | 0 0
raw download clone embed print report
  1. # home.php
  2.  
  3. <!DOCTYPE html>
  4. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  5.  
  6. <!-- jQuery library -->
  7. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  8.  
  9. <!-- Latest compiled JavaScript -->
  10. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  11.  
  12. <head>
  13.     <meta charset="UTF-8">
  14.     <title>My Example</title>
  15.     <link rel="stylesheet" type="text/css" href="mystyle.css">
  16. </head>
  17. <html>
  18.     <nav class="navbar navbar-default">
  19.         <a class="navbar-brand">My Example</a>
  20.         <ul class="nav navbar-nav">
  21.             <li class="active"><a href="home.php">Databases</a></li>
  22.         </ul>
  23.     </nav>
  24.    
  25.     <?php
  26.         $strDbLocation = 'mysql:dbname=dbname;host=127.0.0.1';
  27.         $strDbUser = 'root';
  28.         $strDbPassword = 'root';
  29.         try
  30.         {
  31.             $objDb = new PDO($strDbLocation, $strDbUser, $strDbPassword);
  32.         }
  33.         catch(PDOException $e)
  34.         {
  35.             echo 'Datenbank-Fehler: '. $e -> getMessage();
  36.             exit("");
  37.         }
  38.         $sql = "SHOW DATABASES";
  39.         $data = $objDb->query($sql)->fetchAll();
  40.         echo "<div class='container'>";
  41.         echo "<div class='card'>";
  42.         echo "<ul class='list-group list-group-flush'>";
  43.         foreach($data as $row){
  44.             $value = $row["Database"];
  45.             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>";
  46.         }
  47.         echo "</ul></div></div>";
  48.     ?>
  49. </html>
  50.  
  51. # secondepage.php
  52.  
  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.  
  105. <!DOCTYPE html>
  106. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  107.  
  108. <!-- jQuery library -->
  109. <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  110.  
  111. <!-- Latest compiled JavaScript -->
  112. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  113.  
  114. <head>
  115.     <meta charset="UTF-8">
  116.     <title>My Example</title>
  117.     <link rel="stylesheet" type="text/css" href="mystyle.css">
  118. </head>
  119. <html>
  120.     <nav class="navbar navbar-default">
  121.         <a class="navbar-brand">Tankstelle</a>
  122.         <ul class="nav navbar-nav">
  123.             <li><a href="home.php">Databases</a></li>
  124.         </ul>
  125.     </nav>
  126.    
  127.     <?php
  128.         $strDbLocation = 'mysql:dbname=dbname;host=127.0.0.1';
  129.         $strDbUser = 'root';
  130.         $strDbPassword = 'root';
  131.         $table = '';
  132.         try
  133.         {
  134.             $objDb = new PDO($strDbLocation, $strDbUser, $strDbPassword);
  135.         }
  136.         catch(PDOException $e)
  137.         {
  138.             echo 'Datenbank-Fehler: '. $e -> getMessage();
  139.             exit("");
  140.         }
  141.         $table = $_GET["table"];
  142.         $db = $_GET["db"];
  143.         $sql = "DESCRIBE $db.$table";
  144.         $data = $objDb->query($sql)->fetchAll();
  145.         echo "<div class='container'>";
  146.         echo "<table class='table'><thead><tr>";
  147.         echo "<th scope='col'>Field</th>";
  148.         echo "<th scope='col'>Type</th>";
  149.         echo "<th scope='col'>Null</th>";
  150.         echo "<th scope='col'>Key</th>";
  151.         echo "<th scope='col'>Default</th>";
  152.         echo "<th scope='col'>Extra</th></thead><tbody>";
  153.         foreach($data as $row){
  154.             $field = $row["Field"];
  155.             $type = $row["Type"];
  156.             $isNull = $row["Null"];
  157.             $key = $row["Key"];
  158.             $default = $row["Default"];
  159.             $extra = $row["Extra"];
  160.             echo "<tr>
  161.                 <td>$field</td>
  162.                 <td>$type</td>
  163.                 <td>$isNull</td>
  164.                 <td>$key</td>
  165.                 <td>$default</td>
  166.                 <td>$extra</td>
  167.                 </tr>";
  168.         }
  169.         echo "</tbody></div>";
  170.     ?>
  171. </html>
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!