-
Notifications
You must be signed in to change notification settings - Fork 0
/
databases.php
76 lines (53 loc) · 1.87 KB
/
databases.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<?php
echo <<<'TAG'
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>The HTML5 Herald</title>
<meta name="description" content="The HTML5 Herald">
<meta name="author" content="SitePoint">
<link rel="stylesheet" href="css/styles.css?v=1.0">
<script type="text/javascript" src="js/scripts.js"></script>
<!--[if lt IE 9]>
<script src="https://cdnjs.cloudflare.com/ajax/libs/html5shiv/3.7.3/html5shiv.js"></script>
<![endif]-->
</head>
<body>
<div class="hot-container">
<img src="https://camo.githubusercontent.com/afc284462330fff4cf7c03c5bd4a5120431eb84f/687474703a2f2f616f6c61622e6769746875622e696f2f49313832302f6c6f676f2f6c6f676f2d6d642e706e67" alt="i1820" style="width:504px;height:428px;">
TAG;
$servername = "127.0.0.1";
$DBusername = "root";
$password = "";
$dbname = "smarthouse";
$conn = new mysqli($servername, $DBusername, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SHOW TABLES FROM $dbname";
$result = $conn->query($sql);
while ($table = $result->fetch_assoc()) {
foreach ($table as $key => $value) {
echo $value;
$query = "select * from " . $value;
echo "<table class=\"responstable\">";
//
$result2 = $conn->query($query);
$row = $result2->fetch_assoc();
echo "<tr>";
foreach ($row as $key2 => $value2) {
echo "<th>" . $key2 . "</th>";
}
echo "</tr>";
$result2 = $conn->query($query);
while ($row = $result2->fetch_assoc()) {
echo "<tr>";
foreach ($row as $key2 => $value2) {
echo "<td>" . $value2 . "</td>";
}
echo "</tr>";
}
echo "</table>";
}
}