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/nils-diplom/Dateistruktur/admin/get_user.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/nils-diplom/Dateistruktur/admin/get_user.php')
-rwxr-xr-x | doc/nils-diplom/Dateistruktur/admin/get_user.php | 158 |
1 files changed, 158 insertions, 0 deletions
diff --git a/doc/nils-diplom/Dateistruktur/admin/get_user.php b/doc/nils-diplom/Dateistruktur/admin/get_user.php new file mode 100755 index 0000000..52aee37 --- /dev/null +++ b/doc/nils-diplom/Dateistruktur/admin/get_user.php @@ -0,0 +1,158 @@ +<?php + +include("../header.php"); +include("adminfuncs.php"); + +$path = "LIST/".$_SESSION['file']; +$scriptpath = "LIST/parse-exel.pl"; + + +//______________Auslesen des EXCEL-FILES_____________________________________________________________________ + + $handle = popen("perl $scriptpath $path", "r"); // parsen des XLS-Files + $inhalt = fread($handle, filesize ("$path")); // Parsingergebnis in Variable schreiben + + $lines = explode(">>>",$inhalt); // Zeilenweise aufsplitten... + $count = count($lines); // Anzahl der Ergebnisse bestimmen... + + for ($i = 0; $i < $count; $i++) // Inhalte in zweidimensionales Array schreiben + { + $cont = explode(">",$lines[$i]); + $countcont = count($cont); + for ($c = 0; $c < $countcont; $c++) + { + $dim[$i][$c] = $cont[$c]; // $dim enthält die Daten der Studenten + } + } + +//____________________________________________________________________________________________________________ + + + +?> + +<table width="100%" border="0" cellspacing="0" cellpadding="0"> + <tr> + <td class="titel_15">STUDENTENLISTE<br><br></td> + </tr> + <tr> + <td> </td> + </tr> + <tr> + <td class=text> + +<? + +if (isset($_GET['load'])) +{ + + $group = $_GET['thegroup']; + + while(list($strName ,$value) = each($_GET)) + { + if(is_array($value)) + { + foreach($value as $value_array) + { + $message = add_user_from_list($dim[$value_array][1], $dim[$value_array][2], $dim[$value_array][3], $group); + print "> ".$message."<br>"; //Ausgabe der Fehlermeldung + } + } + } +} + +?> + + </td> + </tr> + <tr> + <td> </td> + </tr> + <tr> + <td valign="top" class="text"> + <tr> + + <table> + +<form action=<?=$_POST['PHP_SELF'].SID?>> + +<tr colspan=2><td class="text">In welche GRUPPE sollen die Nutzer aufgenommen werden:</td> + <td width=400> + <select class="inputtext" name="thegroup" size="1" width=190> + <? + + $sql = "SELECT groups FROM groups"; + + $stmt = dbconnect($sql); + + OCIExecute($stmt); + + $nrows = OCIFetchStatement($stmt, $results); + + + for ( $i = 0; $i < $nrows; $i++ ) + { + reset($results); + + while ( $column = each($results) ) + { + $data = $column['value']; //Liste mit vorhandenen Benutzern füllen + } + + if ($_POST['all_group'] == $data[$i]) print "<option selected>" . $data[$i] . "</option>\n"; else print "<option>$data[$i]</option>\n"; + } + + ?> + + </select> + </td> + </tr> + +<tr colspan=2> + <td> </td> + </tr> + <tr colspan=2> + <td colspan=2 class=randoben> </td> + </tr> +<tr valign=top colspan=2><td> + + +<? + +print "<p><select name=List[] size=$count multiple>"; + + + for ($l = 0; $l < $count; $l++) + { + print "<option value=$l>"; + for ($ll = 1; $ll < 4; $ll++) + { + print $dim[$l][$ll] . " "; + } + print "</option>"; + } + + +?> + +</select></p> + +</td> +<td colspan=2> +<input class=inputsubmit type=submit name=load width=179 height=15 border=0> +</td> +</tr> +</form> + +</table> + + </td> </tr></table> + <tr> + <td width="200" align="right" valign="top" class="randmenu"><p> </td> + </tr> + </table> + + +<? +include("../footer.php"); +?>
\ No newline at end of file |