Problem oko jednostavnog query bazeevo par dana me muči zašto nemogu da uradim query baze i jednostavno rezultat da ispišem u browseru.
Sve sam probao, različite php query, ništa ne pomaže.
Neću lagati noob sam za php, ali ništa bolji nisam bio ni za aurdino kojeg sam uspio programirati da preko wifi šalje ove podatke u phpmyadmin, i to funkcioniše, ali nemogu nikako te podatke da ispišem u browseru, uvijek neki error.
Ovo se vrti na XAMPP.
Hvala.
Code:
CREATE TABLE `logs` (
`ID` int(9) NOT NULL,
`sensor1` varchar(50) NOT NULL,
`sensor2` varchar(50) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `logs` (`ID`, `sensor1`, `sensor2`, `timestamp`) VALUES
(1, '25.56', '23', '2022-06-12 17:45:51'),
(2, '25.52', '34', '2022-06-20 18:34:35'),
(3, '25.56', '33', '2022-06-12 17:45:56'),
(4, '25.54', '44', '2022-06-20 18:34:25'),
(5, '25.56', '55', '2022-06-12 17:46:00');
CREATE TABLE `logs` (
`ID` int(9) NOT NULL,
`sensor1` varchar(50) NOT NULL,
`sensor2` varchar(50) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
INSERT INTO `logs` (`ID`, `sensor1`, `sensor2`, `timestamp`) VALUES
(1, '25.56', '23', '2022-06-12 17:45:51'),
(2, '25.52', '34', '2022-06-20 18:34:35'),
(3, '25.56', '33', '2022-06-12 17:45:56'),
(4, '25.54', '44', '2022-06-20 18:34:25'),
(5, '25.56', '55', '2022-06-12 17:46:00');
Code:
<!DOCTYPE html>
<html>
<head>
<title>Table with database</title>
<style>
table {
border-collapse: collapse;
width: 100%;
color: #588c7e;
font-family: monospace;
font-size: 25px;
text-align: left;
}
th {
background-color: #588c7e;
color: white;
}
tr:nth-child(even) {background-color: #f2f2f2}
</style>
</head>
<body>
<table>
<tr>
<th>Id</th>
<th>Username</th>
<th>Password</th>
</tr>
<?php
$dbname = 'sensor';
$dbuser = 'root';
$dbpass = '';
$dbhost = 'localhost';
$sql = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysqli_select_db($link, $dbname) or die("Could not open the db '$dbname'");
$sql = SELECT * FROM `logs` WHERE sensor1 = 25.56;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr><td>" . $row["id"]. "</td><td>" . $row["sensor1"] . "</td><td>" . $row["sensor2"]. "</td></tr>";
}
echo "</table>";
} else { echo "0 results"; }
$conn->close();
?>
</table>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<title>Table with database</title>
<style>
table {
border-collapse: collapse;
width: 100%;
color: #588c7e;
font-family: monospace;
font-size: 25px;
text-align: left;
}
th {
background-color: #588c7e;
color: white;
}
tr:nth-child(even) {background-color: #f2f2f2}
</style>
</head>
<body>
<table>
<tr>
<th>Id</th>
<th>Username</th>
<th>Password</th>
</tr>
<?php
$dbname = 'sensor';
$dbuser = 'root';
$dbpass = '';
$dbhost = 'localhost';
$sql = mysqli_connect($dbhost, $dbuser, $dbpass) or die("Unable to Connect to '$dbhost'");
mysqli_select_db($link, $dbname) or die("Could not open the db '$dbname'");
$sql = SELECT * FROM `logs` WHERE sensor1 = 25.56;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr><td>" . $row["id"]. "</td><td>" . $row["sensor1"] . "</td><td>" . $row["sensor2"]. "</td></tr>";
}
echo "</table>";
} else { echo "0 results"; }
$conn->close();
?>
</table>
</body>
</html>
