Forum PHP.pl

<?php
    $conn = mysqli_connect("xxxxl", "mxxxxst", "Mxxx2$", "mxxxst");
    
    if($conn === false)
    {
        die("ERROR: Could not connect. " .mysqli_connect_error());
    }

    $query="SELECT * FROM stat";
    $result=mysqli_query($conn, $query);
          
    function validation_sql($c, $sql)
    {
        if(mysqli_query($c, $sql))
    {
        echo "<h3>data stored in a database successfully. "
            . " Please browse your localhost php my admin"
            . " to view the updated data</h3>";

        echo nl2br("$TemperaturePot1\n $TemperaturePot2\n $TemperaturePot3\n $TemperaturePot4\n $HumidityPot1\n $HumidityPot2\n $HumidityPot3\n $HumidityPot4\n $TemperatureWaterPot1\n $TemperatureWaterPot2\n $TemperatureWaterPot3\n $TemperatureWaterPot4\n $pHPot1\n $pHPot2\n $pHPot3\n $pHPot4");
            return 'true';
    }
    else
    {
        echo "ERROR: Hush! Sorry $sql. "
            .mysqli_error($c);
                return 'false';
        }
    }

    $sql = "INSERT INTO `stat` (TemperaturePot1,  TemperaturePot2, TemperaturePot3, TemperaturePot4, HumidityPot1, HumidityPot2, HumidityPot3, HumidityPot4, TemperatureWaterPot1, TemperatureWaterPot2, TemperatureWaterPot3, TemperatureWaterPot4, pHPot1, pHPot2, pHPot3, pHPot4) VALUES (11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26)";
        if(isset($_POST['passed_exam']))
        {
            echo validation_sql($conn, $sql);
        }
        
    while ($row = mysqli_fetch_row($result))
    {
        printf("%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s", $row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8], $row[9], $row[10], $row[11], $row[12], $row[13], $row[14], $row[15]);
    }

    $TemperaturePot1 = (int) filter_input(INPUT_POST, 'TemperaturePot1', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperaturePot1 = " . $TemperaturePot1 . " where id=1;";
        echo validation_sql($conn, $sql);
    
    $TemperaturePot2 = (int) filter_input(INPUT_POST, 'TemperaturePot2', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperaturePot2 = " . $TemperaturePot2 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $TemperaturePot3 = (int) filter_input(INPUT_POST, 'TemperaturePot3', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperaturePot3 = " . $TemperaturePot3 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $TemperaturePot4 = (int) filter_input(INPUT_POST, 'TemperaturePot4', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperaturePot4 = " . $TemperaturePot4 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $HumidityPot1 = (int) filter_input(INPUT_POST, 'HumidityPot1', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set HumidityPot1 = " . $HumidityPot1 . " where id=1;";
        echo validation_sql($conn, $sql);
    
    $HumidityPot2 = (int) filter_input(INPUT_POST, 'HumidityPot2', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set HumidityPot2 = " . $HumidityPot2 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $HumidityPot3 = (int) filter_input(INPUT_POST, 'HumidityPot3', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set HumidityPot3 = " . $HumidityPot3 . " where id=1;";
        echo validation_sql($conn, $sql);
    
    $HumidityPot4 = (int) filter_input(INPUT_POST, 'HumidityPot4', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set HumidityPot4 = " . $HumidityPot4 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $TemperatureWaterPot1 = (int) filter_input(INPUT_POST, 'TemperatureWaterPot1', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperatureWaterPot1 = " . $TemperatureWaterPot1 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $TemperatureWaterPot2 = (int) filter_input(INPUT_POST, 'TemperatureWaterPot2', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperatureWaterPot2 = " . $TemperatureWaterPot2 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $TemperatureWaterPot3 = (int) filter_input(INPUT_POST, 'TemperatureWaterPot3', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperatureWaterPot3 = " . $TemperatureWaterPot3 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $TemperatureWaterPot4 = (int) filter_input(INPUT_POST, 'TemperatureWaterPot4', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set TemperatureWaterPot3 = " . $TemperatureWaterPot3 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $pHPot1 = (int) filter_input(INPUT_POST, 'pHPot1', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set pHPot1 = " . $pHPot1 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $pHPot2 = (int) filter_input(INPUT_POST, 'pHPot2', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set pHPot2 = " . $pHPot2 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $pHPot3 = (int) filter_input(INPUT_POST, 'pHPot3', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set pHPot3 = " . $pHPot3 . " where id=1;";
        echo validation_sql($conn, $sql);
        
    $pHPot4 = (int) filter_input(INPUT_POST, 'pHPot4', FILTER_SANITIZE_NUMBER_INT);
    $sql="update stat set pHPot4 = " . $pHPot4 . " where id=1;";
        echo validation_sql($conn, $sql);

    $sql = <<< 'SQL' SELECT `TemperaturePot1`, `TemperaturePot2`, `TemperaturePot3`, `TemperaturePot4`, `HumidityPot1`, `HumidityPot2`, `HumidityPot3`, `HumidityPot4`, `TemperatureWaterPot1`, `TemperatureWaterPot2`, `TemperatureWaterPot3`, `TemperatureWaterPot4`, `pHPot1`, `pHPot2`, `pHPot3`, `pHPot4` FROM `stat` SQL;
    $sql = <<< 'SQL' UPDATE `stat` SET `TemperaturePot1` = ?, `TemperaturePot2` = ?, `TemperaturePot3` = ?, `TemperaturePot4` = ?, `HumidityPot1` = ? , `HumidityPot2` = ?, `HumidityPot3` = ?, `HumidityPot4` = ?, `TemperatureWaterPot1` = ?, `TemperatureWaterPot2` = ?, `TemperatureWaterPot3` = ?, `TemperatureWaterPot4` = ?, `pHPot1` = ?, `pHPot2` = ?, `pHPot3` = ?, `pHPot4` = ? LIMIT 1; SQL;

    $stmt = mysqli_prepare($conn, $sql);
    mysqli_stmt_bind_param
    (
        $stmt, 'iiiiiiiiiiiiiiii', $TemperaturePot1, $TemperaturePot2, $TemperaturePot3, $TemperaturePot4, $HumidityPot1, $HumidityPot2, $HumidityPot3, $HumidityPot4, $TemperatureWaterPot1, $TemperatureWaterPot2, $TemperatureWaterPot3, $TemperatureWaterPot4, $pHPot1, $pHPot2, $pHPot3, $pHPot4
    );
    mysqli_stmt_execute($stmt);
    
    $res = mysqli_query($conn, $sql);

    while($foo = mysqli_fetch_row($res))
    {
        echo $foo[0];
    }

    $rows = mysqli_fetch_all($result, MYSQLI_NUM);    
?>

Parse error: syntax error, unexpected '<' in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/settings.php on line 106

$sql = <<< 'SQL' SELECT `TemperaturePot1`, `TemperaturePot2`, `TemperaturePot3`, `TemperaturePot4`, `HumidityPot1`, `HumidityPot2`, `HumidityPot3`, `HumidityPot4`, `TemperatureWaterPot1`, `TemperatureWaterPot2`, `TemperatureWaterPot3`, `TemperatureWaterPot4`, `pHPot1`, `pHPot2`, `pHPot3`, `pHPot4` FROM `stat` SQL;

$sql = <<< 'SQL' SELECT
    `TemperaturePot1`,
    `TemperaturePot2`,
    `TemperaturePot3`,
    `TemperaturePot4`,
    `HumidityPot1`,
    `HumidityPot2`,
    `HumidityPot3`,
    `HumidityPot4`,
    `TemperatureWaterPot1`,
    `TemperatureWaterPot2`,
    `TemperatureWaterPot3`,
    `TemperatureWaterPot4`,
    `pHPot1`,
    `pHPot2`,
    `pHPot3`,
    `pHPot4`
    FROM `stat` SQL;
    >>>;
    
    $sql = <<< 'SQL' UPDATE `stat` SET
    `TemperaturePot1` = ?,
    `TemperaturePot2` = ?,
    `TemperaturePot3` = ?,
    `TemperaturePot4` = ?,
    `HumidityPot1` = ? ,
    `HumidityPot2` = ?,
    `HumidityPot3` = ?,
    `HumidityPot4` = ?,
    `TemperatureWaterPot1` = ?,
    `TemperatureWaterPot2` = ?,
    `TemperatureWaterPot3` = ?,
    `TemperatureWaterPot4` = ?,
    `pHPot1` = ?,
    `pHPot2` = ?,
    `pHPot3` = ?,
    `pHPot4` = ?
    LIMIT 1; SQL;
    >>>;

Parse error: syntax error, unexpected '<<' (T_SL) in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/settings.php on line 106

$sql = <<<
    'SQL' SELECT
    `TemperaturePot1`,
    `TemperaturePot2`,
    `TemperaturePot3`,
    `TemperaturePot4`,
    `HumidityPot1`,
    `HumidityPot2`,
    `HumidityPot3`,
    `HumidityPot4`,
    `TemperatureWaterPot1`,
    `TemperatureWaterPot2`,
    `TemperatureWaterPot3`,
    `TemperatureWaterPot4`,
    `pHPot1`,
    `pHPot2`,
    `pHPot3`,
    `pHPot4`
    FROM `stat` SQL;
    >>>;

[PHP] pobierz, plaintext 
$sql = <<<SQL
    SELECT
    `TemperaturePot1`,
    `TemperaturePot2`,
    `TemperaturePot3`,
    `TemperaturePot4`,
    `HumidityPot1`,
    `HumidityPot2`,
    `HumidityPot3`,
    `HumidityPot4`,
    `TemperatureWaterPot1`,
    `TemperatureWaterPot2`,
    `TemperatureWaterPot3`,
    `TemperatureWaterPot4`,
    `pHPot1`,
    `pHPot2`,
    `pHPot3`,
    `pHPot4`
    FROM `stat` 
SQL;
[PHP] pobierz, plaintext 

Parse error: Invalid indentation - tabs and spaces cannot be mixed in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/settings.php on line 107

SELECT

Parse error: syntax error, unexpected '>>' (T_SR),

Parse error: Invalid body indentation level (expecting an indentation level of at least 2) in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/settings.php on line 107

Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, bool given in /usr/home/UszaTek/domains/uszatek.ct8.pl/public_html/settings.php on line 157

while($foo = mysqli_fetch_row($res))

<form action="settings.php" method="post">
                    <label for="s1">Temperature: </label>
                        <div class="ui-spinner">
                            <input type="text" id="s1" name="TemperaturePot1" class="ui-spinner-box" autocomplete="off" value=<? echo '<p>'.$rows[1].'</p>'; ?>>
                            <button class="ui-spinner-up" type="button">▲</button>
                            <button class="ui-spinner-down" type="button">▼</button>
                        </div>
                </form>

value=<? echo $rows[1] ?>>