API tools faq
paste
Advertisement
Guest User

Database connection, selects and displaying data via PHP 1.0

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