Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $conn = mysqli_connect("xxx", "xxx", "xxx", "xxx");
- if($conn === false)
- {
- die("ERROR: Could not connect. " .mysqli_connect_error());
- }
- $temperature = $_REQUEST['temperature'];
- $sql = "INSERT INTO stat (temperature) VALUES ($temperature)";
- if(mysqli_query($conn, $sql))
- {
- echo "<h3>data stored in a database successfully. "
- . " Please browse your localhost php my admin"
- . " to view the updated data</h3>";
- echo nl2br("$temperature");
- }
- else
- {
- echo "ERROR: Hush! Sorry $sql. "
- . mysqli_error($conn);
- }
- mysqli_close($conn);
- ?>
- <?
- $username="xxx";
- $password="xxx";
- $database="xxx";
- mysql_connect('xxx',$username,$password);
- @mysql_select_db($database) or die("Nie odnaleziono bazy danych");
- $query="SELECT * FROM stat";
- $result=mysql_query($query);
- $num=mysql_numrows($result);
- mysql_close();
- echo "";
- $i=0;
- while ($i < $num)
- {
- $temperature=mysql_result($result,$i,"temperature");
- $humidity=mysql_result($result,$i,"humidity");
- $temperature_water=mysql_result($result,$i,"temperature_water");
- $ph=mysql_result($result,$i,"ph");
- echo "";
- $i++;
- }
- ?>
- <script language= "JavaScript" type= "text/javascript">
- function wyswietlDane()
- {
- var data = new Date();
- var godziny = data.getHours();
- var minuty = data.getMinutes();
- var sekundy = data.getSeconds();
- var czas = godziny;
- czas += ((minuty < 10) ? ":0" : ":") + minuty;
- czas += ((sekundy < 10) ? ":0" : ":") + sekundy;
- var miesiac = data.getMonth() + 1;
- if (miesiac < 9){
- miesiac = "0" + miesiac;
- }
- var dzien = data.getDate();
- if (dzien < 9){
- dzien = "0" + dzien;
- }
- var rok = data.getYear();
- if (rok < 1000){
- rok = 2000 + rok - 100;
- }
- var dzisiaj = dzien + "." + miesiac + "." + rok;
- var dzienTygodnia = data.getDay();
- switch(dzienTygodnia)
- {
- case 0: dzienTygodnia = "niedziela"; break;
- case 1: dzienTygodnia = "poniedziałek"; break;
- case 2: dzienTygodnia = "wtorek"; break;
- case 3: dzienTygodnia = "środa"; break;
- case 4: dzienTygodnia = "czwartek"; break;
- case 5: dzienTygodnia = "piątek"; break;
- case 6: dzienTygodnia = "sobota"; break;
- }
- var tekst = czas;
- tekst += "<BR>";
- tekst += "Dziś jest " + dzienTygodnia + ", " + dzisiaj;
- document.getElementById("dataLayer").innerHTML = tekst;
- timerID = setTimeout("wyswietlDane()",1000);
- }
- </script>
- <html>
- <head>
- <meta charset="utf-8">
- <meta name="description" content="GrowBox">
- <link href="styles/program.css" rel="stylesheet" type="text/css">
- <title>GrowBox</title>
- </head>
- <body onLoad="wyswietlDane()">
- <table rules="none" border="1" bordercolor="white" cellpadding="5" align="right" style="width: 1095px; height: 40px; margin-top: 0px;">
- <td>
- <div class="tekst"><b>Settings</b></div>
- </td>
- </table>
- <table border="1" bordercolor="white" cellspacing="10" align="right" class="table">
- <tr>
- <td>
- <form action="settings.php" method="post">
- <div class="temperature">Temperature</div> <input type="number" name="temperature" class="rectangle-settings" value=<? echo $temperature;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="humidity">Humidity</div> <input type="number" name="humidity" class="rectangle-settings" value=<? echo $humidity;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="temperature_water">Temperature water</div> <input type="number" name="temperature_water" class="rectangle-settings" value=<? echo $temperature_water;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="ph">pH</div> <input type="number" name="ph" class="rectangle-settings" value=<? echo $ph;?>>
- </form>
- </td>
- <td>
- <form action="settings.php" method="post">
- <div class="tekst">Temperature</div> <input type="number" name="temperature" class="rectangle-settings" value=<? echo $temperature;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">Humidity</div> <input type="number" name="humidity" class="rectangle-settings" value=<? echo $humidity;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">Temperature water</div> <input type="number" name="temperature_water" class="rectangle-settings" value=<? echo $temperature_water;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">pH</div> <input type="number" name="ph" class="rectangle-settings" value=<? echo $ph;?>>
- </form>
- </td>
- </tr>
- <tr>
- <td>
- <form action="settings.php" method="post">
- <div class="tekst">Temperature</div> <input type="number" name="temperature" class="rectangle-settings" value=<? echo $temperature;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">Humidity</div> <input type="number" name="humidity" class="rectangle-settings" value=<? echo $humidity;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">Temperature water</div> <input type="number" name="temperature_water" class="rectangle-settings" value=<? echo $temperature_water;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">pH</div> <input type="number" name="ph" class="rectangle-settings" value=<? echo $ph;?>>
- </form>
- </td>
- <td>
- <form action="settings.php" method="post">
- <div class="tekst">Temperature</div> <input type="number" name="temperature" class="rectangle-settings" value=<? echo $temperature;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">Humidity</div> <input type="number" name="humidity" class="rectangle-settings" value=<? echo $humidity;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">Temperature water</div> <input type="number" name="temperature_water" class="rectangle-settings" value=<? echo $temperature_water;?>>
- </form>
- <form action="settings.php" method="post">
- <div class="tekst">pH</div> <input type="number" name="ph" class="rectangle-settings" value=<? echo $ph;?>>
- </form>
- </td>
- </tr>
- </table>
- <table rules="none" border="1" bordercolor="white" align="right" style="width: 1530px; height: 40px; margin-top: 0px;">
- <td>
- <div id="dataLayer"></div>
- <div class="stopka">
- Powered by UszaTek<br>
- GrowBox © 2021<br>
- </div>
- </td>
- </table>
- </body>
- </html>
- </html>
Add Comment
Please, Sign In to add comment