query("SET CHARACTER SET utf8"); $cisloDna = date("N"); if ($cisloDna > 5) { if ($cisloDna == 6) $date = date('Y-m-d', strtotime($date .' +2 day')); else $date = date('Y-m-d', strtotime($date .' +1 day')); $result = $mysqli->query("SELECT suplovanie_text FROM suplovanie WHERE suplovanie_date = '$date'"); $row = $result->fetch_array(MYSQLI_ASSOC); $text = $row['suplovanie_text']; echo '
' . "\n"; echo '
Suplovanie na deň ' . date("j. n. Y", strtotime($date)) . '' . "\n"; foreach(preg_split("/((\r?\n)|(\r\n?))/", $text) as $key => $line){ echo '
' . "\n"; if ($key == 0) { foreach (explode("\t", $line) as $cell) { echo '
' . $cell . " | " . "\n"; } } else { foreach (explode("\t", $line) as $cell) { echo '
' . $cell . " | " . "\n"; } } echo '
' . "\n"; } echo '
' . "\n"; } else { //na dnes $result = $mysqli->query("SELECT suplovanie_text FROM suplovanie WHERE suplovanie_date = '$date'"); $row = $result->fetch_array(MYSQLI_ASSOC); $text = $row['suplovanie_text']; echo '
' . "\n"; echo '
Suplovanie na deň ' . date("j. n. Y", strtotime($date)) . '' . "\n"; foreach(preg_split("/((\r?\n)|(\r\n?))/", $text) as $key => $line){ echo '
' . "\n"; if ($key == 0) { foreach (explode("\t", $line) as $cell) { echo '
' . $cell . " | " . "\n"; } } else { foreach (explode("\t", $line) as $cell) { echo '
' . $cell . " | " . "\n"; } } echo '
' . "\n"; } echo '
' . "\n"; //na zajtra $date = date('Y-m-d', strtotime($date .' +1 day')); $result = $mysqli->query("SELECT suplovanie_text FROM suplovanie WHERE suplovanie_date = '$date'"); $row = $result->fetch_array(MYSQLI_ASSOC); $text = $row['suplovanie_text']; if ($text != ''){ echo '
' . "\n"; echo '
Suplovanie na deň ' . date("j. n. Y", strtotime($date)) . '' . "\n"; foreach(preg_split("/((\r?\n)|(\r\n?))/", $text) as $key => $line){ echo '
' . "\n"; if ($key == 0) { foreach (explode("\t", $line) as $cell) { echo '
' . $cell . " | " . "\n"; } } else { foreach (explode("\t", $line) as $cell) { echo '
' . $cell . " | " . "\n"; } } echo '
' . "\n"; } echo '
' . "\n"; } } ?>