Tag (Typ = INT (auto_inc) <> Essen (Typ = varchar[255] <> 01 <> Lasagne <> 02 <> Lasagne <> 03 <> Pizza <> 04 <> Spagetti <> ......
Tweet
# phpMyAdmin MySQL-Dump
# version 2.2.2
# [url]http://phpwizard.net/phpMyAdmin/[/url]
# [url]http://phpmyadmin.sourceforge.net/[/url] (download page)
#
# Host: localhost
# Erstellungszeit: 04. März 2002 um 15:06
# Server Version: 3.23.38
# PHP Version: 4.0.6
# Datenbank : `essen`
# --------------------------------------------------------
#
# Tabellenstruktur für Tabelle `liste`
#
CREATE TABLE liste (
tag date NOT NULL default '0000-00-00',
essen varchar(255) default NULL,
PRIMARY KEY (tag)
) TYPE=MyISAM;
#
# Daten für Tabelle `liste`
#
INSERT INTO liste VALUES ('2003-01-01', 'Lasagne');
INSERT INTO liste VALUES ('2003-01-02', 'Pizza');
INSERT INTO liste VALUES ('2003-01-03', 'Wiener Schnitzel');
INSERT INTO liste VALUES ('2003-01-04', 'Canneloni');
INSERT INTO liste VALUES ('2003-01-05', 'Italienischer Salat');
INSERT INTO liste VALUES ('2003-01-06', 'Kartoffelausflauf');
INSERT INTO liste VALUES ('2003-01-07', 'Kassler');
INSERT INTO liste VALUES ('2003-01-08', 'Sauerkraut mit Püree');
INSERT INTO liste VALUES ('2003-01-09', 'Semmelknödel');
INSERT INTO liste VALUES ('2003-01-10', 'Pilzragout');
INSERT INTO liste VALUES ('2003-01-11', 'Bauernsalat mit Brot');
INSERT INTO liste VALUES ('2003-01-12', 'Combinatione');
INSERT INTO liste VALUES ('2003-01-13', 'Schweizer Wurstsalat mit Pommes');
<html>
<head>
<title>KW suchen Maske</title>
</head>
<body>
<form method = post action = "suchen.php">
<input type="text" name="kw">
<input type="submit" name="submit">
<input type"text" name="jahr">
</form>
</body>
</html>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Show</title>
</head>
<body>
<?php
include("var.inc.php");
$firstday = date ("D",mktime(0,0,0,1,1,$jahr));
$firststamp = mktime(0,0,0,1,1,$jahr);
if ($firstday == "Sun")
{
$firstsunday = 1;
}
if ($firstday == "Sat")
{
$firstsunday = 2;
}
if ($firstday == "Fri")
{
$firstsunday = 3;
}
if ($firstday == "Thu")
{
$firstsunday = 4;
}
if ($firstday == "Wed")
{
$firstsunday = 5;
}
if ($firstday == "Tue")
{
$firstsunday = 6;
}
if ($firstday == "Mon")
{
$firstsunday = 7;
}
if ($kw == 1)
{
$start = "$jahr-01-01";
$stop = "$jahr-01-0$firstsunday";
}
else
{
$start = date("Y-m-d",((($kw-2)*7+$firstsunday)*24*60*60+$firststamp));
$stop = date("Y-m-d",((($kw-2)*7+$firstsunday+6)*24*60*60+$firststamp));
}
$conn = mysql_connect($dbserver,$dbuser,$dbpass);
mysql_select_db("essen",$conn);
$query = "SELECT * from liste WHERE tag >= '$start' AND tag <= '$stop'";
$result = mysql_query($query,$conn);
echo "Kalenderwoche :".$kw."<br>";
echo "Von : ".$start;
echo " bis ".$stop."<br>";
while ($zeileholen = mysql_fetch_array($result,MYSQL_ASSOC))
{
$splitter = explode("-",$zeileholen["tag"]);
echo date("D",mktime(0,0,0,$splitter[1],$splitter[2],$splitter[0]))." ".$zeileholen["tag"]." ".$zeileholen["essen"]."<br>";
}
?>
</body>
</html>
<?php // Datenbank Variablen $dbserver = "localhost"; // Datenbankserveradresse $dbname = "essen"; // Name der Datenbank $dbuser = ""; // Username des Datenbankbenutzers $dbpass = ""; // Passwort des Datenbankbenutzers ?>
Kommentar