PHP uge Beispiele

Beispiel #1

Datei: overview.php Projekt: Nicolai-/Hours

            if ($_GET['range'] == "3months") {
                $checkdata = mysql_query("SELECT * FROM checks WHERE user = '******' AND (MONTH(date) = '" . date('m') . "' OR MONTH(date) = '" . (date('m') - 1) . "' OR MONTH(date) = '" . (date('m') - 2) . "') AND YEAR(date) = '" . date('Y') . "' ORDER BY date asc, checkin asc");
            } else {
                if ($_GET['range'] == "6months") {
                    $checkdata = mysql_query("SELECT * FROM checks WHERE user = '******' AND (MONTH(date) = '" . date('m') . "' OR MONTH(date) = '" . (date('m') - 1) . "' OR MONTH(date) = '" . (date('m') - 2) . "' OR MONTH(date) = '" . (date('m') - 3) . "' OR MONTH(date) = '" . (date('m') - 4) . "' OR MONTH(date) = '" . (date('m') - 5) . "') AND YEAR(date) = '" . date('Y') . "' ORDER BY date asc, checkin asc");
                } else {
                    if ($_GET['range'] == "thisyear") {
                        $checkdata = mysql_query("SELECT * FROM checks WHERE user = '******' AND YEAR(date) = '" . date('Y') . "' ORDER BY date asc, checkin asc");
                    } else {
                        if ($_GET['range'] == "coming") {
                            $checkdata = mysql_query("SELECT * FROM checks WHERE user = '******' AND date > '" . date('Y-m-d') . "' ORDER BY date asc, checkin asc");
                        } else {
                            if ($_GET['range'] == "all") {
                                $checkdata = mysql_query("SELECT * FROM checks WHERE user = '******' ORDER BY date asc, checkin asc");
                            } else {
                                $checkdata = mysql_query("SELECT * FROM checks WHERE user = '******' AND week = '" . uge() . "' AND YEAR(date) = '" . date('Y') . "' ORDER BY date desc, checkin desc");
                            }
                        }
                    }
                }
            }
        }
    }
}
$checks = mysql_num_rows($checkdata);
if ($checks > 0) {
    ?>

		<table id="checks">
			<tr>
				<th>Uge</th>

Beispiel #2

Datei: topbar.php Projekt: Nicolai-/Hours

<?php

echo "<div id='topbar'>";
echo "Uge " . uge() . " - " . dag() . " " . dato() . " " . tid() . " - " . $username . " &#8226; ";
echo "<a href='mailto:CKM@Bang-Olufsen.dk?subject=Feedback til Timer'><img src='images/feedback.png' /></a> &#8226; ";
echo "<a href='overview.php'>Overblik</a> &#8226; ";
echo "<a href='add.php'>Tilf&oslash;j</a> &#8226; ";
echo "<a href='settings.php'>Indstillinger</a> &#8226; ";
echo "<a href='logout.php'>Log ud</a>";
echo "</div>";