Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("conn.php");
- if ($sql = $baza->prepare("SELECT imie, data_urodzin FROM osoby WHERE
- data_urodzin >= DATE(NOW() - INTERVAL 30 DAY) AND data_urodzin <= DATE(NOW() + INTERVAL 31 DAY)")) {
- $sql->execute();
- $sql->bind_result($imie, $dataUrodzin);
- while ($sql->fetch())
- $terminy[] = array(
- "imie" => $imie,
- "okazja" => "urodziny",
- "dataUrodzin " => $dataUrodzin
- );
- $sql->close();
- }
- if ($sql = $baza->prepare("SELECT imie, data_imienin FROM osoby WHERE
- data_imienin >= DATE(NOW() - INTERVAL 30 DAY) AND data_imienin <= DATE(NOW() + INTERVAL 31 DAY)")) {
- $sql->execute();
- $sql->bind_result($imie, $dataImienin);
- while ($sql->fetch()) {
- $terminy[] = array(
- "imie" => $imie,
- "okazja" => "imieniny",
- "dataImienin " => $dataImienin,
- );
- }
- $sql->close();
- }
- echo json_encode($terminy);
- $baza->close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement