oldSupportSystem/Table.php at main · Damian10012/oldSupportSystem · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<?php
echo
"
<div class='part1'></div>
<div class='tabulka'>


<table border ='1' >

    <td> ID </td>
    <td> Zaměstnanec </td>
    <td> Datum </td>

    <td> Problém </td>
    <td> Řešení</td>
    <td> Důležitost </td>
    <td> Stav</td>

</tr>
";
$conn = mysqli_connect("sql4.webzdarma.cz:3306", "helpdeskkval2958", "7IG5L*23)v0H3TE3U5^1", "helpdeskkval2958");
$sql = "SELECT ID,zamestnanec,datum,problem,reseni,dulezitost,stav FROM  wo";
$result =$conn ->query($sql);
$pocitadlo=0;
if($result->num_rows>0) {
    while (($row = $result->fetch_assoc())&&$pocitadlo<=9 )
    {
        echo "</br>";
        echo "<tr>";
        echo "<td>".$row['ID'] ."</td>";
        echo "<td>".$row['zamestnanec'],' '."</td>";
        echo "<td>".$row ['datum'],' '."</td>";
        echo "<td>".$row ['problem'],' '."</td>";
        echo "<td>".$row ['reseni'],' '."</td>";
        echo "<td>".$row ['dulezitost'],' '."</td>";
        echo "<td>".$row ['stav'],' '."</td>";


        echo "</tr>";

        $pocitadlo++;
    }
}
echo "</div>";
echo"</table>";
?>