-
Notifications
You must be signed in to change notification settings - Fork 0
/
settingsRW.php
39 lines (34 loc) · 1.32 KB
/
settingsRW.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
<?php
// Connect to the HeatBatt database
$conn = mysqli_connect("localhost", "root", "raspberry", "HeatBatt");
// Check for a successful connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// SELECT query to retrieve the current settings
$query = "SELECT setting_id, setting_name, setting_value FROM settings";
$result = mysqli_query($conn, $query);
// Display the current settings in a table
echo "<table>";
echo "<tr><th>Setting ID</th><th>Setting Name</th><th>Setting Value</th></tr>";
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>" . $row["setting_id"] . "</td>";
echo "<td>" . $row["setting_name"] . "</td>";
echo "<td>" . $row["setting_value"] . "</td>";
echo "</tr>";
}
echo "</table>";
// Form to update the settings
echo "<form action='update.php' method='post'>";
echo "<label for='setting_id'>Setting ID:</label>";
echo "<input type='text' id='setting_id' name='setting_id'><br>";
echo "<label for='setting_name'>Setting Name:</label>";
echo "<input type='text' id='setting_name' name='setting_name'><br>";
echo "<label for='setting_value'>Setting Value:</label>";
echo "<input type='text' id='setting_value' name='setting_value'><br>";
echo "<input type='submit' value='Update'>";
echo "</form>";
// Close the database connection
mysqli_close($conn);
?>