Forum PHP.pl

   <?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)";
        
        $humidity =  $_REQUEST['humidity'];
            $sql = "INSERT INTO stat (humidity) VALUES ($humidity)";
        
        $temperature_water =  $_REQUEST['temperature_water'];
            $sql = "INSERT INTO stat (humidity) VALUES ($temperature_water)";
        
        $ph =  $_REQUEST['ph'];
            $sql = "INSERT INTO stat (humidity) VALUES ($ph)";

        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("\n$temperature");
        }
        else
        {
            echo "ERROR: Hush! Sorry $sql. "
                . mysqli_error($conn);
        }
          
        mysqli_close($conn);
?>

<form action="settings.php" method="post">
    <div class="tekst">Temperature</div>
    <input type="number" name="temperature" class="rectangle-settings" value=<? echo $temper;?>>
</form>

<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">pH</div>
    <input type="number" name="ph" class="rectangle-settings" value=<? echo $ph;?>>
</form>

<?php
    $conn = mysqli_connect("mysql1.ugu.pl", "db699487", "Mefedron12$", "db699487");
          
    if($conn === false)
    {
        die("ERROR: Could not connect. " .mysqli_connect_error());
    }
        
    $temperature =  $_REQUEST['temperature'];
        $sql = "INSERT INTO stat (temperature) VALUES ($temperature)";
    
    $humidity =  $_REQUEST['humidity'];
        $sql = "INSERT INTO stat (humidity) VALUES ($humidity)";
        
    $temperature-water-pot-1 =  $_REQUEST['temperature-water-pot-1'];
        $sql = "INSERT INTO stat (temperature-water-pot-3) VALUES ($temperature-water-pot-1)";
    $temperature-water-pot-2 =  $_REQUEST['temperature-water-pot-2'];
        $sql = "INSERT INTO stat (temperature-water-pot-3) VALUES ($temperature-water-pot-2)";
    $temperature-water-pot-3 =  $_REQUEST['temperature-water-pot-3'];
        $sql = "INSERT INTO stat (temperature-water-pot-3) VALUES ($temperature-water-pot-3)";
    $temperature-water-pot-4 =  $_REQUEST['temperature-water-pot-4'];
        $sql = "INSERT INTO stat (temperature-water-pot-4) VALUES ($temperature-water-pot-4)";
        
    $ph-pot-1 =  $_REQUEST['ph-pot-1'];
        $sql = "INSERT INTO stat (ph-pot-1) VALUES ($ph-pot-1)";
    $ph-pot-2 =  $_REQUEST['ph-pot-2'];
        $sql = "INSERT INTO stat (ph-pot-2) VALUES ($ph-pot-2)";
    $ph-pot-3 =  $_REQUEST['ph-pot-3'];
        $sql = "INSERT INTO stat (ph-pot-3) VALUES ($ph-pot-3)";
    $ph-pot-4 =  $_REQUEST['ph-pot-4'];
        $sql = "INSERT INTO stat (ph-pot-4) VALUES ($ph-pot-4)";
        
    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\n $humidity");
    }
    else
    {
        echo "ERROR: Hush! Sorry $sql. "
            . mysqli_error($conn);
    }
    
    mysqli_close($conn);
?>

CREATE TABLE IF NOT EXISTS `stat`
(
  `temperature` int(11) NOT NULL,
  `humidity` int(11) NOT NULL,
  `temperature-water-pot-1` int(11) NOT NULL,
  `temperatuxre-water-pot-2` int(11) NOT NULL,
  `temperature-water-pot-2` int(11) NOT NULL,
  `temperature-water-pot-3` int(11) NOT NULL,
  `ph-pot-1` int(11) NOT NULL,
  `ph-pot-2` int(11) NOT NULL,
  `ph-pot-3` int(11) NOT NULL,
  `ph-pot-4` int(11) NOT NULL
)

<?php
    $conn = mysqli_connect("xxu.pl", "db69948xxx7", "xxx$", "dx487"x);
          
    if($conn === false)
    {
        die("ERROR: Could not connect. " .mysqli_connect_error());
    }
        
    $temperature =  $_REQUEST['temperature'];
        $sql = "INSERT INTO stat (temperature) VALUES ($temperature)";
    
    $humidity =  $_REQUEST['humidity'];
        $sql = "INSERT INTO stat (humidity) VALUES ($humidity)";
        
    $TemperatureWaterPot1 =  $_REQUEST['TemperatureWaterPot1'];
        $sql = "INSERT INTO stat (TemperatureWaterPot1) VALUES ($TemperatureWaterPot1)";
        
    $TemperatureWaterPot2 =  $_REQUEST['TemperatureWaterPot2'];
        $sql = "INSERT INTO stat (TemperatureWaterPot2) VALUES ($TemperatureWaterPot2)";
        
    $TemperatureWaterPot3 =  $_REQUEST['TemperatureWaterPot3'];
        $sql = "INSERT INTO stat (TemperatureWaterPot3) VALUES ($TemperatureWaterPot3)";
        
    $TemperatureWaterPot4 =  $_REQUEST['TemperatureWaterPot4'];
        $sql = "INSERT INTO stat (TemperatureWaterPot4) VALUES ($TemperatureWaterPot4)";
        
    $pHPot1 =  $_REQUEST['pHPot1'];
        $sql = "INSERT INTO stat (pHPot1) VALUES ($pHPot1)";
        
    $pHPot2 =  $_REQUEST['pHPot2'];
        $sql = "INSERT INTO stat (pHPot2) VALUES ($pHPot2)";
        
    $pHPot3 =  $_REQUEST['pHPot3'];
        $sql = "INSERT INTO stat (pHPot3) VALUES ($pHPot3)";
        
    $pHPot4 =  $_REQUEST['pHPot4'];
        $sql = "INSERT INTO stat (pHPot4) VALUES ($pHPot4)";
        
    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\n $humidity");
    }
    else
    {
        echo "ERROR: Hush! Sorry $sql. "
            . mysqli_error($conn);
    }
    
    mysqli_close($conn);
?>

<?
    $username="dxxx9487";
    $password="Mxxxxx";
    $database="db6xxxx487";

    mysql_connect('myxxxgu.pl',$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");
        
        $TemperatureWaterPot1=mysql_result($result,$i,"TemperatureWaterPot1");
        $TemperatureWaterPot2=mysql_result($result,$i,"TemperatureWaterPot2");
        $TemperatureWaterPot3=mysql_result($result,$i,"TemperatureWaterPot3");
        $TemperatureWaterPot4=mysql_result($result,$i,"TemperatureWaterPot4");
        
        $pHPot1=mysql_result($result,$i,"pHPot1");
        $pHPot2=mysql_result($result,$i,"pHPot2");
        $pHPot3=mysql_result($result,$i,"pHPot3");
        $pHPot4=mysql_result($result,$i,"pHPot4");

        echo "";
        $i++;
    }
?>

<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-pot-1">Temperature water</div> <input type="number" name="TemperatureWaterPot1" class="rectangle-settings" value=<? echo $TemperatureWaterPot1;?>>
                </form>
                
                <form action="settings.php" method="post">
                    <div class="pHPot1">pH</div> <input type="number" name="pHPot1" class="rectangle-settings" value=<? echo $pHPot1;?>>
                </form>
            </td>
            
            
            <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-pot-2">Temperature water</div> <input type="number" name="TemperatureWaterPot2" class="rectangle-settings" value=<? echo $TemperatureWaterPot2;?>>
                </form>
                
                <form action="settings.php" method="post">
                    <div class="pHPot2">pH</div> <input type="number" name="pHPot2" class="rectangle-settings" value=<? echo $pHPot2;?>>
                </form>
            </td>
        </tr>
        
        <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-pot-3">Temperature water</div> <input type="number" name="TemperatureWaterPot3" class="rectangle-settings" value=<? echo $TemperatureWaterPot3;?>>
                </form>
                
                <form action="settings.php" method="post">
                    <div class="pHPot3">pH</div> <input type="number" name="pHPot3" class="rectangle-settings" value=<? echo $pHPot3;?>>
                </form>
            </td>
            
        <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-pot-4">Temperature water</div> <input type="number" name="TemperatureWaterPot4" class="rectangle-settings" value=<? echo $TemperatureWaterPot4;?>>
                </form>
                
                <form action="settings.php" method="post">
                    <div class="pHPot4">pH</div> <input type="number" name="pHPot4" class="rectangle-settings" value=<? echo $pHPot4;?>>
                </form>
            </td>
    </tr>
    </table>

www.programbox.ugu.pl/settings.php