File: /var/www/clients/client2/web716/web/zakazky/indexold.php
<!DOCTYPE html>
<html>
<head>
<title>Všechny veřejné zakázky</title>
<head />
<body>
<!-- Top content -->
<?php
$sOrder = $_REQUEST["order"];
$oZajem = $_REQUEST["zajem"];
$iUloz = $_REQUEST["ulozzajem"];
$iUloz1 = $_REQUEST["truefalse"];
$iUlozZpracovano = $_REQUEST["ulozzpracovano"];
$iUlozOdeslano = $_REQUEST["ulozodeslano"];
$link = mysqli_connect("db:3306", "c2dbschamann", "Mirosa21519", "c2db_zakazky");
$link->set_charset("utf8");
if (!$link) {
echo "Error: Unable to connect to MySQL." ;
echo "Debugging errno: " . mysqli_connect_errno();
echo "Debugging error: " . mysqli_connect_error();
exit;
}
//echo "Success: A proper connection to MySQL was made! The my_db database is great." . PHP_EOL;
//echo "Host information: " . mysqli_get_host_info($link) . PHP_EOL;
if ($iUloz != "") {
if ($iUloz1 == "0") {
$sSQLText = "UPDATE `import_zakazky` SET `ZAJEM` = '1' WHERE `ID` = ".$iUloz;
} else {
$sSQLText = "UPDATE `import_zakazky` SET `ZAJEM` = '0' WHERE `ID` = ".$iUloz;
}
$result = mysqli_query($link,$sSQLText);
}
if ($iUlozZpracovano != "") {
if ($iUloz1 == "0") {
$sSQLText = "UPDATE `import_zakazky` SET `ZPRACOVANI` = '1' WHERE `ID` = ".$iUlozZpracovano;
} else {
$sSQLText = "UPDATE `import_zakazky` SET `ZPRACOVANI` = '0' WHERE `ID` = ".$iUlozZpracovano;
}
$result = mysqli_query($link,$sSQLText);
}
if ($iUlozOdeslano != "") {
if ($iUloz1 == "0") {
$sSQLText = "UPDATE `import_zakazky` SET `ODESLANO` = '1' WHERE `ID` = ".$iUlozOdeslano;
} else {
$sSQLText = "UPDATE `import_zakazky` SET `ODESLANO` = '0' WHERE `ID` = ".$iUlozOdeslano;
}
$result = mysqli_query($link,$sSQLText);
}
if ($oZajem == "") {
$sSQLText = "SELECT * FROM import_zakazky where `LIMIT` >= CURDATE() ORDER BY ".$sOrder;
} else {
if ($oZajem == "TRUE") {
$sSQLText = "SELECT * FROM import_zakazky where `ZAJEM` = 1 AND `LIMIT` >= CURDATE() ORDER BY ".$sOrder;
} else {
$sSQLText = "SELECT * FROM import_zakazky ORDER BY ".$sOrder;
}
}
$result = mysqli_query($link,$sSQLText);
$rows = mysqli_num_rows($result);
//echo $sSQLText;
?>
<p>
Počet záznamů: <?php echo $rows; ?> <a href="?zajem=VSE&order=`ZALOZEO` DESC"><button>Vše</button></a>
<table>
<tr>
<td><a href="?zajem=TRUE&order=`LIMIT` DESC"><button>Zájem</button></a></td>
<td>Zpracování</td>
<td>Odesláno</td>
<td>Popis</td>
<td>Režim</td>
<td> </td>
<td><a href="?order=`ZALOZEO` DESC, `ID` DESC"><button>Datum zadání</button></a></td>
<td><a href="?order=`LIMIT` ASC"><button>Podání do</button></a></td>
</tr>
<?php
if ($rows) {
// echo $rows;
while ($row = mysqli_fetch_array($result)) {
echo "<tr>";
echo " <td width='1%'><a href='?ulozzajem=". $row['ID'] . "&truefalse=".$row['ZAJEM']."&order=".$sOrder."'>".$row['ZAJEM']."</a></td>";
echo " <td width='1%'><a href='?ulozodeslano=". $row['ID'] . "&truefalse=".$row['ODESLANO']."&order=".$sOrder."'>".$row['ODESLANO']."</a></td>";
echo " <td width='1%'><a href='?ulozzpracovano=". $row['ID'] . "&truefalse=".$row['ZPRACOVANI']."&order=".$sOrder."'>".$row['ZPRACOVANI']."</a></td>";
echo " <td width='57%'><a href='". $row['URL'] . "' target=_blank>". $row['NAZEV'] . "</a></td>";
echo " <td width='10%'>". $row['ZADAVATEL'] . "</td>";
echo " <td width='10%'>". $row['REZIM'] . "</td>";
echo " <td width='10%'>". $row['ZALOZEO'] . "</td>";
echo " <td width='10%'>". $row['LIMIT'] . "</td>";
echo "</tr>";
}
}
mysqli_close($link);
?>
</table>
</body>
</html>