Arrangement-system
Vil du programmere et arrangementssystem for mig?Har forgæves forsøgt, men kan ikke få det til at fungere.
Systemet skal bestå af:
1. En indtastningsside (web)
2. En visningsside, hvor man kan klikke på arrangementsart for at sortere oversigten (web). Arrangementer før d.d. skal ikke være synlige.
3. En side, hvor man kan ændre/redigere i tidligere indtastede data (web)
Det, jeg har lavet hidtil, er flg.:
===========
arrangementer.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<LINK REL="STYLESHEET" HREF="http://www.silkeborg-kirke.dk/sk.css" TYPE="text/css">
<title>Indtast arrangementer</title>
<style type="text/css">
<?php
date_default_timezone_set('Europe/Copenhagen');
$script_tz = date_default_timezone_get();
if (strcmp($script_tz, ini_get('date.timezone'))){
echo 'Script timezone differs from ini-set timezone.';
} else {
echo 'Script timezone and ini-set timezone match.';
}
?>
.ds_box {
background-color: #FFF;
border: 1px solid #000;
position: absolute;
z-index: 32767;
}
.ds_tbl {
background-color: #FFF;
}
.ds_head {
background-color: #333;
color: #FFF;
font-family: Arial, Helvetica, sans-serif;
font-size: 13px;
font-weight: bold;
text-align: center;
letter-spacing: 2px;
}
.ds_subhead {
background-color: #CCC;
color: #000;
font-size: 12px;
font-weight: bold;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
width: 32px;
}
.ds_cell {
background-color: #EEE;
color: #000;
font-size: 13px;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
padding: 5px;
cursor: pointer;
}
.ds_cell:hover {
background-color: #F3F3F3;
} /* This hover code won't work for IE */
</style>
</head>
<body>
<table class="ds_box" cellpadding="0" cellspacing="0" id="ds_conclass" style="display: none;">
<tr><td id="ds_calclass">
</td></tr>
</table>
<script type="text/javascript">
// <!-- <![CDATA[
// Project: Dynamic Date Selector (DtTvB) - 2006-03-16
// Script featured on JavaScript Kit- http://www.javascriptkit.com
// Code begin...
// Set the initial date.
var ds_i_date = new Date();
ds_c_month = ds_i_date.getMonth() + 1;
ds_c_year = ds_i_date.getFullYear();
// Get Element By Id
function ds_getel(id) {
return document.getElementById(id);
}
// Get the left and the top of the element.
function ds_getleft(el) {
var tmp = el.offsetLeft;
el = el.offsetParent
while(el) {
tmp += el.offsetLeft;
el = el.offsetParent;
}
return tmp;
}
function ds_gettop(el) {
var tmp = el.offsetTop;
el = el.offsetParent
while(el) {
tmp += el.offsetTop;
el = el.offsetParent;
}
return tmp;
}
// Output Element
var ds_oe = ds_getel('ds_calclass');
// Container
var ds_ce = ds_getel('ds_conclass');
// Output Buffering
var ds_ob = '';
function ds_ob_clean() {
ds_ob = '';
}
function ds_ob_flush() {
ds_oe.innerHTML = ds_ob;
ds_ob_clean();
}
function ds_echo(t) {
ds_ob += t;
}
var ds_element; // Text Element...
var ds_monthnames = [
'January', 'February', 'March', 'April', 'May', 'June',
'July', 'August', 'September', 'October', 'November', 'December'
]; // You can translate it for your language.
var ds_daynames = [
'Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'
]; // You can translate it for your language.
// Calendar template
function ds_template_main_above(t) {
return '<table cellpadding="3" cellspacing="1" class="ds_tbl">'
+ '<tr>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_py();"><<</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_pm();"><</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_hi();" colspan="3">[Close]</td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_nm();">></td>'
+ '<td class="ds_head" style="cursor: pointer" onclick="ds_ny();">>></td>'
+ '</tr>'
+ '<tr>'
+ '<td colspan="7" class="ds_head">' + t + '</td>'
+ '</tr>'
+ '<tr>';
}
function ds_template_day_row(t) {
return '<td class="ds_subhead">' + t + '</td>';
// Define width in CSS, XHTML 1.0 Strict doesn't have width property for it.
}
function ds_template_new_week() {
return '</tr><tr>';
}
function ds_template_blank_cell(colspan) {
return '<td colspan="' + colspan + '"></td>'
}
function ds_template_day(d, m, y) {
return '<td class="ds_cell" onclick="ds_onclick(' + d + ',' + m + ',' + y + ')">' + d + '</td>';
// Define width the day row.
}
function ds_template_main_below() {
return '</tr>'
+ '</table>';
}
// This one draws calendar...
function ds_draw_calendar(m, y) {
// First clean the output buffer.
ds_ob_clean();
// Here we go, do the header
ds_echo (ds_template_main_above(ds_monthnames[m - 1] + ' ' + y));
for (i = 0; i < 7; i ++) {
ds_echo (ds_template_day_row(ds_daynames[i]));
}
// Make a date object.
var ds_dc_date = new Date();
ds_dc_date.setMonth(m - 1);
ds_dc_date.setFullYear(y);
ds_dc_date.setDate(1);
if (m == 1 || m == 3 || m == 5 || m == 7 || m == 8 || m == 10 || m == 12) {
days = 31;
} else if (m == 4 || m == 6 || m == 9 || m == 11) {
days = 30;
} else {
days = (y % 4 == 0) ? 29 : 28;
}
var first_day = ds_dc_date.getDay();
var first_loop = 1;
// Start the first week
ds_echo (ds_template_new_week());
// If sunday is not the first day of the month, make a blank cell...
if (first_day != 0) {
ds_echo (ds_template_blank_cell(first_day));
}
var j = first_day;
for (i = 0; i < days; i ++) {
// Today is sunday, make a new week.
// If this sunday is the first day of the month,
// we've made a new row for you already.
if (j == 0 && !first_loop) {
// New week!!
ds_echo (ds_template_new_week());
}
// Make a row of that day!
ds_echo (ds_template_day(i + 1, m, y));
// This is not first loop anymore...
first_loop = 0;
// What is the next day?
j ++;
j %= 7;
}
// Do the footer
ds_echo (ds_template_main_below());
// And let's display..
ds_ob_flush();
// Scroll it into view.
ds_ce.scrollIntoView();
}
// A function to show the calendar.
// When user click on the date, it will set the content of t.
function ds_sh(t) {
// Set the element to set...
ds_element = t;
// Make a new date, and set the current month and year.
var ds_sh_date = new Date();
ds_c_month = ds_sh_date.getMonth() + 1;
ds_c_year = ds_sh_date.getFullYear();
// Draw the calendar
ds_draw_calendar(ds_c_month, ds_c_year);
// To change the position properly, we must show it first.
ds_ce.style.display = '';
// Move the calendar container!
the_left = ds_getleft(t);
the_top = ds_gettop(t) + t.offsetHeight;
ds_ce.style.left = the_left + 'px';
ds_ce.style.top = the_top + 'px';
// Scroll it into view.
ds_ce.scrollIntoView();
}
// Hide the calendar.
function ds_hi() {
ds_ce.style.display = 'none';
}
// Moves to the next month...
function ds_nm() {
// Increase the current month.
ds_c_month ++;
// We have passed December, let's go to the next year.
// Increase the current year, and set the current month to January.
if (ds_c_month > 12) {
ds_c_month = 1;
ds_c_year++;
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Moves to the previous month...
function ds_pm() {
ds_c_month = ds_c_month - 1; // Can't use dash-dash here, it will make the page invalid.
// We have passed January, let's go back to the previous year.
// Decrease the current year, and set the current month to December.
if (ds_c_month < 1) {
ds_c_month = 12;
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
}
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Moves to the next year...
function ds_ny() {
// Increase the current year.
ds_c_year++;
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Moves to the previous year...
function ds_py() {
// Decrease the current year.
ds_c_year = ds_c_year - 1; // Can't use dash-dash here, it will make the page invalid.
// Redraw the calendar.
ds_draw_calendar(ds_c_month, ds_c_year);
}
// Format the date to output.
function ds_format_date(d, m, y) {
// 2 digits month.
m2 = '00' + m;
m2 = m2.substr(m2.length - 2);
// 2 digits day.
d2 = '00' + d;
d2 = d2.substr(d2.length - 2);
// YYYY-MM-DD
return y + '-' + m2 + '-' + d2;
}
// When the user clicks the day.
function ds_onclick(d, m, y) {
// Hide the calendar.
ds_hi();
// Set the value of it, if we can.
if (typeof(ds_element.value) != 'undefined') {
ds_element.value = ds_format_date(d, m, y);
// Maybe we want to set the HTML in it.
} else if (typeof(ds_element.innerHTML) != 'undefined') {
ds_element.innerHTML = ds_format_date(d, m, y);
// I don't know how should we display it, just alert it to user.
} else {
alert (ds_format_date(d, m, y));
}
}
// And here is the end.
// ]]> -->
</script>
</head>
<body>
<!-- Her er formularen -->
<H1 align=center>Indskriv arrangement</A></H1>
<form name="svarskema" method="post" action="arrangementer.php">
<center><table border=0>
<tr>
<td align=right valign=center>Dato:</td>
<td>
<input onclick="ds_sh(this);" name="date" value="Klik for dato" readonly="readonly" style="cursor: text" /><br />
</td>
</tr>
<tr>
<td align=right>Tid:</td>
<td>
<SELECT name="tid">
<OPTION selected value="10:00">10:00</OPTION>
<OPTION>08:00</OPTION><OPTION>08:30</OPTION>
<OPTION>09:00</OPTION><OPTION>09:30</OPTION>
<OPTION>10:30</OPTION><OPTION>11:30</OPTION>
<OPTION>12:00</OPTION><OPTION>12:30</OPTION>
<OPTION>13:00</OPTION><OPTION>13:30</OPTION>
<OPTION>14:00</OPTION><OPTION>14:30</OPTION>
<OPTION>15:00</OPTION><OPTION>15:30</OPTION>
<OPTION>16:00</OPTION><OPTION>16:30</OPTION>
<OPTION>17:00</OPTION><OPTION>17:30</OPTION>
<OPTION>18:00</OPTION><OPTION>18:30</OPTION>
<OPTION>19:00</OPTION><OPTION>19:30</OPTION>
<OPTION>20:00</OPTION><OPTION>20:30</OPTION>
<OPTION>21:00</OPTION><OPTION>21:30</OPTION>
<OPTION>22:00</OPTION><OPTION>22:30</OPTION>
<OPTION>23:00</OPTION><OPTION>23:30</OPTION>
</SELECT>
</td></tr>
<tr>
<td align=right>Art:</td>
<td>
<SELECT name="art">
<OPTION selected value="Gudstjeneste">Gudstjeneste</OPTION>
<OPTION>Gudstjeneste</OPTION>
<OPTION>Musik</OPTION>
<OPTION>For børn</OPTION>
<OPTION>For unge</OPTION>
<OPTION>For familien</OPTION>
<OPTION>Foredrag</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td align=right>Begivenhed:</td
><td>
<SELECT name="begivenhed">
<OPTION selected value="Højmesse">Højmesse</OPTION>
<OPTION>Gudstjeneste</OPTION>
<OPTION>Aftenkirke</OPTION>
<OPTION>Rytmisk gudstjeneste</OPTION>
<OPTION>Børnegudstjeneste</OPTION>
<OPTION>BUSK-gudstjeneste</OPTION>
<OPTION>Meditationsgudstjeneste</OPTION>
<OPTION>Midnatsgudstjeneste</OPTION>
<OPTION>Musikgudstjeneste</OPTION>
<OPTION>Koncert</OPTION>
<OPTION>Babysalmesang</OPTION>
</SELECT>
</td>
</tr>
<tr>
<td align=right>Ved:</td>
<td>
<SELECT name="ved">
<OPTION>Anette Kortegaard</OPTION>
<OPTION>Chr. Højlund</OPTION>
<OPTION>Leif Kristiansen</OPTION>
<OPTION>Karin Viller Hansen</OPTION>
<OPTION>Niels Jørgen Munk Møller</OPTION>
<OPTION>Dorte Madsen</OPTION>
</td>
</tr>
<tr><td align=right>Diverse:</td><td><textarea name="diverse"></textarea></td></tr>
<tr><td align=right></td><td><input type="submit" name="send" value="OK - send af sted"></td></tr></table>
</form>
<p>
<a href="vis_arr.php">Vis arrangementer</A>
</center>
<?php
// Hent indholdet af formularens felter
$dato = $_REQUEST["dato"];
$tid = $_REQUEST["tid"];
$art = $_REQUEST["art"];
$begivenhed = $_REQUEST["begivenhed"];
$beskrivelse = $_REQUEST["beskrivelse"];
$diverse = $_REQUEST["diverse"];
// Skab forbindelse til databasen her
include("connect.php"); //Inkluder filen der connecter til min database
//Indsæt indholdet af formularfelterne i databasen
mysql_query("INSERT INTO `arr`(`arrID`, `dato`, `tid`, `art`, `begivenhed`, `beskrivelse`, `ved`, `diverse`) values(NULL, '$dato', '$tid', '$art', '$begivenhed', '$beskrivelse', '$ved', '$diverse')") or die(mysql_error());
?>
</body>
</html>
======================
vis_arr.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<LINK REL="STYLESHEET" HREF="http://www.silkeborg-kirke.dk/sk.css" TYPE="text/css">
<title>Vis arrangementer</title>
</head>
<body>
<center>
<?php
// Skab forbindelse til databasen her
include("connect.php"); //Inkluder filen der connecter til min database
//Laver en forespørgsel i tabellen min_tabel
$svar = mysql_query("SELECT * FROM arr WHERE dato>=now() ORDER BY dato ASC") or die(mysql_error());
//Udskriver de fundne data i en tabel
print "<table border=0><tr>";
while ($row = mysql_fetch_array($svar))
{
print "<td>".$row["dato"]."</td>
<td>".$row["tid"]."</td>
<td>".$row["begivenhed"]."</td>
<td>".$row["ved"]."</td>
</tr>";
}
print "</table>";
?>
<p>
<a href="arrangementer.php">Indskriv arrangement</a>
</center>
</body>
</html>
