1:
function getDayName($dayNr){
2:
$dayNames = array (
3:
'Söndag', 'Måndag', 'Tisdag', 'Onsdag',
4:
'Torsdag', 'Fredag', 'Lördag');
5:
return $dayNames[$dayNr];
6:
}
7:
8:
function getMonthName($monthNr){
9:
$monthNames = array(
10:
1 => 'januari', 'Februari', 'Mars', 'April', 'Maj', 'Juni',
11:
'Juli', 'Augusti', 'September', 'Oktober', 'November', 'December');
12:
return $monthNames[$monthNr];
13:
}
14:
15:
function zerofill($mStretch, $iLength = 2)
16:
{
17:
$sPrintfString = '%0' . (int)$iLength . 's';
18:
return sprintf($sPrintfString, $mStretch);
19:
}
20:
21:
// Lagg till event
22:
if (isset($_POST['submitted'])) {
23:
$m = $_POST["month"];
24:
$d = $_POST["day"];
25:
$y = $_POST["year"];
26:
$h = $_POST["hours"];
27:
$min = $_POST["min"];
28:
29:
30:
$kurs_date = $y."-".$m."-".$d." ".$h.":".$min.":00";
31:
$kurs_namn = htmlentities($_POST["kurs_namn"]);
32:
$kurs_teacher = htmlentities($_POST["kurs_teacher"]);
33:
34:
35:
$q = "INSERT INTO schedule (kurs_namn, kurs_date, kurs_teacher, schedule_name) VALUES('$kurs_namn', '$kurs_date', '$kurs_teacher','b2')";
36:
$r = mysqli_query($mysqli, $q) or die(mysqli_error($mysqli));
37:
38:
if ($r) {
39:
40:
// OK
41:
echo '<p class="error">Händelsen är nu inlagd i databasen!</p>';
42:
echo '<p><a href="schema.php">Tillbaka</a></p>';
43:
44:
} else {
45:
echo '<p class="error">Ett fel uppstod det gick inte att lägga in händelsen i databasen. Var god försök igen!</p>';
46:
}
47:
48:
mysqli_close($mysqli);
49:
} // End på submit
50:
51:
// show form
52:
echo "
53:
<form method=\"post\" action=\"".$_SERVER["PHP_SELF"]."\">
54:
55:
<p>Lägg till fält i schema</p>
56:
57:
<table width=\"400\">
58:
";
59:
// input kursnamn
60:
echo "
61:
<tr>
62:
<td><p><b>Kursnamn </b><em>(Max 255 tecken)</em></p></td>
63:
<td>
64:
<input type=\"text\" name=\"kurs_namn\" size=\"25\" maxlength=\"255\" class=\"skugga\"/>
65:
</td>
66:
</tr>
67:
";
68:
69:
// select datum ar, manad, dag
70:
echo"
71:
<tr>
72:
<td><p><b>Datum </b></p></td>
73:
<td>
74:
<SELECT name='year' class='select1'>";
75:
$year = date("Y");
76:
for($i=$year-1;$i<=$year+5;$i++){
77:
if($year == $i){
78:
$sel = "SELECTED";
79:
}else{
80:
$sel = "";
81:
}
82:
echo "<option value='$i' $sel>$i</option>";
83:
}
84:
echo"</SELECT> ";
85:
86:
echo"<SELECT name='month' class='select1'>";
87:
$month = date("n");
88:
for($i=1;$i<=12;$i++){
89:
if($month == $i){
90:
$sel = "SELECTED";
91:
}else{
92:
$sel = "";
93:
}
94:
$selmonth = getMonthName($i);
95:
echo "<option value='$i' $sel>$selmonth</option>";
96:
}
97:
echo"</SELECT> ";
98:
99:
echo"<SELECT name='day' class='select1'>";
100:
$day = date("j");
101:
for($i=1;$i<=31;$i++){
102:
if($day == $i){
103:
$sel = "SELECTED";
104:
}else{
105:
$sel = "";
106:
}
107:
echo "<option value='$i' $sel>$i</option>";
108:
}
109:
echo"</SELECT>";
110:
echo"</td></tr>";
111:
112:
// input tid
113:
echo"
114:
<tr>
115:
<td><p><b>Tid </b><em>(hh:mm)</em></p></td>
116:
<td>
117:
<select name='hours' class='select1'>";
118:
$hours = date("H");
119:
for ($x=1; $x <= 24; $x++) {
120:
if($hours == $x){
121:
$sel = "SELECTED";
122:
}else{
123:
$sel = "";
124:
}
125:
echo "<option value='$x' $sel>$x</option>";
126:
}
127:
echo "</select> :";
128:
echo "<select name='min' class='select1'>";
129:
130:
$min = date("i");
131:
for ($x=0; $x <= 59; $x++) {
132:
if($min == $x){
133:
$sel = "SELECTED";
134:
}else{
135:
$sel = "";
136:
}
137:
138:
$minutes = zerofill($x);
139:
echo "<option value='$x' $sel>$minutes</option>";
140:
}
141:
echo "</select>";
142:
143:
echo"</td></tr>";
144:
145:
146:
// input larare
147:
echo"
148:
<tr>
149:
<td><p><b>Lärare </b><em>(Max 50 tecken)</em></p></td>
150:
<td>
151:
<input type=\"text\" name=\"kurs_teacher\" size=\"25\" maxlength=\"255\" class=\"skugga\"/>
152:
</td>
153:
</tr>
154:
";
155:
156:
157:
echo"
158:
<tr><td></td><td align=\"right\">
159:
<input type=\"hidden\" name=\"m\" value=\"".$m."\">
160:
<input type=\"hidden\" name=\"d\" value=\"".$d."\">
161:
<input type=\"hidden\" name=\"y\" value=\"".$y."\">
162:
<input type=\"hidden\" name=\"h\" value=\"".$h."\">
163:
<input type=\"hidden\" name=\"min\" value=\"".$min."\">
164:
<input type=\"submit\" name=\"submit\" value=\"Lägg till\" class=\"select1\">
165:
<input type=\"hidden\" name=\"submitted\" value=\"TRUE\" />
166:
</form>
167:
</td></tr>
168:
</table>
169:
";
170:
mysqli_close($mysqli);
171:
}
