Liebes PHP.de-Forum,
heute habe ich eine kompliziertere Frage (denke ich)
Ich habe folgenden JavaScript-Code:
Die Funktion ajaxSQLQuery sendet ein Request an eine PHP-Datei, welche das Request anschließend an MySQL weiterleitet. Wenn ich nun aber diesen Code ausführe, kommt der Fehler
Die Datenbank sieht folgendermaßen aus:
Hier die Struktur:
Warum tritt dieser Fehler auf? Mache ich etwas falsch?
Vielen Dank im Voraus
heute habe ich eine kompliziertere Frage (denke ich)
Ich habe folgenden JavaScript-Code:
Code:
var pupilGroups = ["test"]; var value = '<table class="w3-table" id="timetable"><thead><th>Zeit</th><th>Montag</th><th>Dienstag</th><th>Mittwoch</th><th>Donnerstag</th><th>Freitag</th></thead><tbody>'; var timetable = ajaxSQLQuery("SELECT NAME, TIME, STATE, GROUPS, DAY FROM topics ORDER BY FIELD (DAY, 'Montag', 'Dienstag', 'Mittwoch', 'Donnerstag', 'Freitag');"); function stateHTML (index) { if (timetable[index][2] === 12) { return("<td id='l:" + timetable[index][0] + "' class='alert alert-success'>" + timetable[index][0] + "</td>"); } else { switch(timetable[index][2]) { case 4: return("<td id='l:" + timetable[index][0] + "' class='alert alert-warning'>" + timetable[index][0] + "</td>"); case 5: return("<td id='l:" + timetable[index][0] + "' class='alert alert-warning'>" + timetable[index][0] + "</td>"); case 10: return("<td id='l:" + timetable[index][0] + "' class='alert alert-warning'>" + timetable[index][0] + "</td>"); default: return("<td id='l:" + timetable[index][0] + "' class='alert alert-danger'>" + timetable[index][0] + "</td>"); } } } var i; for (i = 0; i < timetable.length; i++) { if (!timetable[i][3].some(r=> pupilGroups.includes(r))) { timetable.splice(i, 1) } } var one = []; var two = []; var three = []; var four = []; var five = []; var six = []; var seven = []; var eight = []; var nine = []; for (i = 0; i < timetable.length; i++) { var current = timetable[i]; switch (current[1]) { case "08:30:00": one.push(stateHTML(i)); case "09:15:00": two.push(stateHTML(i)); case "10:00:00": three.push(stateHTML(i)); case "11:15:00": four.push(stateHTML(i)); case "12:00:00": five.push(stateHTML(i)); case "13:15:00": six.push(stateHTML(i)); case "14:00:00": seven.push(stateHTML(i)); case "14:30:00": eight.push(stateHTML(i)); case "15:15:00": nine.push(stateHTML(i)); } } for (i = 0; i < one.length; i++) { value += "<tr>" + one[i]; } value += "</tr>"; for (i = 0; i < two.length; i++) { value += "<tr>" + two[i]; } value += "</tr>"; for (i = 0; i < three.length; i++) { value += "<tr>" + three[i]; } value += "</tr>"; for (i = 0; i < four.length; i++) { value += "<tr>" + four[i]; } value += "</tr>"; for (i = 0; i < five.length; i++) { value += "<tr>" + five[i]; } value += "</tr>"; for (i = 0; i < six.length; i++) { value += "<tr>" + six[i]; } value += "</tr>"; for (i = 0; i < seven.length; i++) { value += "<tr>" + seven[i]; } value += "</tr>"; for (i = 0; i < eight.length; i++) { value += "<tr>" + eight[i]; } value += "</tr>"; for (i = 0; i < nine.length; i++) { value += "<tr>" + nine[i]; } value += "</tr></tbody></table>"; document.write(value);
Code:
Uncaught TypeError: timetable is undefined
Code:
+--------------+----------+-------+----------+------------+ | NAME | TIME | STATE | GROUPS | DAY | +--------------+----------+-------+----------+------------+ | NuT 8 | 08:30:00 | 12 | ["test"] | Montag | | Freiarbeit | 10:00:00 | 12 | ["test"] | Montag | | Sport | 11:15:00 | 12 | ["test"] | Montag | | Mathe 8 | 08:30:00 | 12 | ["test"] | Dienstag | | Freiarbeit | 10:00:00 | 12 | ["test"] | Dienstag | | Freiarbeit | 11:15:00 | 12 | ["test"] | Dienstag | | Wirtschaft 8 | 08:30:00 | 12 | ["test"] | Mittwoch | | French | 10:00:00 | 12 | ["test"] | Mittwoch | | Englisch | 11:15:00 | 12 | ["test"] | Mittwoch | | Musik | 08:30:00 | 12 | ["test"] | Donnerstag | | Freiarbeit | 10:00:00 | 12 | ["test"] | Donnerstag | | Kunst 8 | 11:15:00 | 12 | ["test"] | Donnerstag | | Freiarbeit | 08:30:00 | 12 | ["test"] | Freitag | | Freiarbeit | 10:00:00 | 12 | ["test"] | Freitag | | Freiarbeit | 11:15:00 | 12 | ["test"] | Freitag | +--------------+----------+-------+----------+------------+ 15 rows in set (0.003 sec)
Code:
+---------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+---------+----------------+ | INDEX | int(11) | NO | PRI | NULL | auto_increment | | NAME | varchar(255) | YES | | NULL | | | TIME | time | YES | | NULL | | | ENDTIME | time | YES | | NULL | | | STATE | tinyint(2) | NO | MUL | NULL | | | GROUPS | longtext | YES | | NULL | | | DAY | varchar(10) | YES | | NULL | | | ROOM | varchar(3) | YES | | NULL | | | TEACHER | varchar(255) | YES | | NULL | | +---------+--------------+------+-----+---------+----------------+ 9 rows in set (0.031 sec)
Vielen Dank im Voraus
Kommentar