Formularz mysql Opcje

[UszaTek]

Witam.
Mam kilka problemów z formularzem.
* Odświeżanie strony powoduje dodanie wpisu do bazy.
* Dodawanie wartości do bazy działa tylko dla opcji " temperatura"

* Czy jest możliwość zrobienia aby ' input typ number' miał widoczne strzalki góra/dół caly czas a nie tylko jak najedziemy kursorem?

Ss'y

(IMG:https://i.ibb.co/Sx9sZzf/do-wgladu.png)

Kod

   <?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);
?>

Kod

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

Ten post edytował UszaTek 12.12.2021, 22:07:04

[aras785]

Pokaż więcej tego html, a bo w formularzu nie widzę więc pól (IMG:style_emoticons/default/smile.gif)

[UszaTek]

Pokaż więcej tego html, a bo w formularzu nie widzę więc pól (IMG:style_emoticons/default/smile.gif)

Tutaj cały plik: https://pastebin.com/UrfTVA7u


Nie mogłem edytować.
Cały czas walczę z tym kodem.

Kod

<?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);
?>

Zapytanie do bazy jakie wykonałem:

Kod

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
)

W formularzu działa, że tylko temperature wysyła do bazy a temarature wody,ph,wilgotnośc juz nie.