diff options
| author | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-30 15:43:52 +0100 |
|---|---|---|
| committer | Benjamin Franzke <benjaminfranzke@googlemail.com> | 2013-01-30 15:43:52 +0100 |
| commit | 8ea6ea6db019f68436a69f36aae55a9f205efa35 (patch) | |
| tree | 5c367520523c42b1935491d199b4e8f3c17b4708 /doc/niels-diplom/Dateistruktur/results/user_result.php | |
| parent | ec6e82dbcdc153b9973240cdff91a03b6d2dc886 (diff) | |
| download | sqltutor-plugin-8ea6ea6db019f68436a69f36aae55a9f205efa35.tar.gz sqltutor-plugin-8ea6ea6db019f68436a69f36aae55a9f205efa35.tar.bz2 sqltutor-plugin-8ea6ea6db019f68436a69f36aae55a9f205efa35.zip | |
doc: Nils Weber doesnt have an 'e' in his firstname
Diffstat (limited to 'doc/niels-diplom/Dateistruktur/results/user_result.php')
| -rwxr-xr-x | doc/niels-diplom/Dateistruktur/results/user_result.php | 187 |
1 files changed, 0 insertions, 187 deletions
diff --git a/doc/niels-diplom/Dateistruktur/results/user_result.php b/doc/niels-diplom/Dateistruktur/results/user_result.php deleted file mode 100755 index dc09f63..0000000 --- a/doc/niels-diplom/Dateistruktur/results/user_result.php +++ /dev/null @@ -1,187 +0,0 @@ -<?php
-
- include("../header.php");
-
- $user = $_SESSION['user'];
-
- //$sql = "SELECT lesson_ID as Aufgabe, Datum, Statement as Lösung FROM logon WHERE STUD_ID = '$user' order by logon.DATUM";
-
- $sql ="SELECT LO.NR as Aufgabe, tmp.DATUM, tmp.STATEMENT FROM LESSON_ORDER LO join (SELECT * FROM LOGON WHERE STUD_ID = '$user') tmp ON tmp.LESSON_ID = LO.LESSON_ID order by LO.NR";
-
- $stmt = dbconnect($sql);
-
- OCIExecute($stmt);
-
-?>
-
-
-<tr >
-<td class=titel>persönliche Auswertung von <?echo $_SESSION['fname'] . " " . $_SESSION['name']?></td>
-</tr>
-
-<tr>
-<td><br></td>
-</tr>
-
-<tr>
-<td bgcolor=#e99900 colspan=2 class=text>Ihre bisher erfolgreichen Anfragen waren:</td>
-</tr>
-
-<tr>
-<td>
-
-
-
-
-<?
-
-
-$nrows = OCIFetchStatement($stmt,$results); //Ergebnisse in Array eintragen...
-
-
-if ( $nrows > 0 ) {
- print "<BR><TABLE Border=1 class=text>\n";
- print "<TR>\n";
- while ( list( $key, $val ) = each( $results ) ) {
- print "<TH>$key</TH>\n";
- }
- print "</TR>\n";
-
- for ( $i = 0; $i < $nrows; $i++ ) {
- reset($results);
- print "<TR>\n";
- while ( $column = each($results) ) {
- $data = $column['value'];
- print "<TD>$data[$i]</TD>\n";
- }
- print "</TR>\n";
- }
-
- print "<tr><td colspan=3 class=text>$nrows Datensätzen ausgewählt<BR></td></tr>";
- print "</TABLE><BR>";
- }
-
-else
- {
- print "<TABLE BORDER=\"1\">\n";
- print "<tr><td class=text>Bisher wurden noch keine Aufgaben erfolgreich gelöst...<BR>\n</td></tr>";
- print "</TABLE><BR>";
-
- }
-?>
-<br><br>
-</td>
-</tr>
-
-<tr>
-<td bgcolor=#e99900 colspan=2 class=text>Anfrageversuche waren:</td>
-</tr>
-
-<tr>
-<td>
-
-<?
-
-//$sql = "SELECT lesson_ID as Aufgabe, Datum, Statement as Lösung FROM ERROR_LOG WHERE STUD_ID = '$user' order by ERROR_LOG.DATUM";
-
-$sql = "SELECT LO.NR as Aufgabe, tmp.DATUM, tmp.STATEMENT FROM LESSON_ORDER LO join (SELECT * FROM ERROR_LOG WHERE STUD_ID = '$user') tmp ON tmp.LESSON_ID = LO.LESSON_ID order by LO.NR";
-
-$stmt = dbconnect($sql);
-
-OCIExecute($stmt);
-
-$nrows = OCIFetchStatement($stmt,$results); //Ergebnisse in Array eintragen...
-
-
-if ( $nrows > 0 ) {
- print "<BR><TABLE BORDER=\"1\" class=text>\n";
- print "<TR>\n";
- while ( list( $key, $val ) = each( $results ) ) {
- print "<TH>$key</TH>\n";
- }
- print "</TR>\n";
-
- for ( $i = 0; $i < $nrows; $i++ ) {
- reset($results);
- print "<TR>\n";
- while ( $column = each($results) ) {
- $data = $column['value'];
- print "<TD>$data[$i]</TD>\n";
- }
- print "</TR>\n";
- }
-
- print "<tr><td colspan=3 class=text>$nrows Datensätzen ausgewählt<BR></td></tr>";
- print "</TABLE><BR>";
- }
-
-else
- {
- print "<TABLE BORDER=\"1\">\n";
- print "<tr><td class=text>Es wurden keine Daten gefunden...<BR>\n</td></tr>";
- print "</TABLE><BR>";
-
- }
-
-?>
-<br><br>
-</td>
-</tr>
-
-<tr>
-<td bgcolor=#e99900 colspan=2 class=text>Praktikumsdauer:</td>
-</tr>
-
-<tr>
-<td>
-
-<?
-
-$start = $_SESSION['since'];
-
-$sql = "select round(max(datum) - min(datum),2) as \"BENÖTIGTE ZEIT IN TAGEN\" from (select datum from ERror_log where Stud_id = '$user' union select datum from Logon where Stud_id = '$user')";
-
-$stmt = dbconnect($sql);
-
-OCIExecute($stmt);
-
-$nrows = OCIFetchStatement($stmt,$results); //Ergebnisse in Array eintragen...
-
-
-if ( $nrows > 0 ) {
- print "<BR><TABLE BORDER=\"1\" class=text>\n";
- print "<TR>\n";
- while ( list( $key, $val ) = each( $results ) ) {
- print "<TH valign=left>$key</TH>\n";
- }
- print "</TR>\n";
-
- for ( $i = 0; $i < $nrows; $i++ ) {
- reset($results);
- print "<TR>\n";
- while ( $column = each($results) ) {
- $data = $column['value'];
- print "<TD>$data[$i]</TD>\n";
- }
- print "</TR>\n";
- }
- print "</TABLE>\n";
-} else {
- echo "No data found<BR>\n";
-}
-print "$nrows Records Selected<BR>\n";
-
-?>
-
-</td>
-</tr>
-
-</table>
-</table>
-</table>
-
-
-<?
-include("../footer.php");
-?>
-
|