18 Adrian Runceanu
Transcript of 18 Adrian Runceanu
-
7/31/2019 18 Adrian Runceanu
1/9
Analele Universit ii Constantin Brncui din Trgu Jiu, Seria Inginerie, Nr. 1/2011
Annals of the Constantin Brncui University of Trgu Jiu, Engineering Series, Issue 1/2011
180
O PROPUNERE DE
APLICAIE PENTRUGESTIUNEA STUDENILOR
Adrian Runceanu,Universitatea Constantin Brncui,
Targu-Jiu, Romania,[email protected]
REZUMAT n aceast lucrare propun oabordare web-based pentru gestiunea studenilordintr-o instituie de nvmnt dezvoltat cuajutorul bazelor de date MySQL i a limbajului de
scripting PHP.CUVINTE CHEIE: aplicaie, gestiune, studeni
1. INTRODUCEREIdeea a fost de a folosi resursele
fiecare departament are i s prezinte osoluie practic cu pstrarea securitateadatelor n minte. Din cauzaconstrngerilor n ceea ce privete bugetul
pe proiect alocate pn n prezent i
intervalul de timp pentru proiect, unuldintre cea mai potrivit soluie a fost de afolosi gratuit software open source (deApache ca server web, server MySQL cao baz de date backend i php ca o partelimbajul de server). Aceste trei programevor fi instalate pe fiecare masina in fiecaredepartament. Avnd n vederecomplexitatea de configurare Apache,MySQL si PHP, soluia este de a folosiXAMPP
(http://www.apachefriends.org/en/xampp.html).
Acesta este un drum liber ambalatpreconfigurat Apache, MySQL, pachetphp, care pur i simplu trebuie s fieinstalat.Fiecare departament comunic la baza sade date proprii locale prin intermediulunui browser web, astfel nct s poatinsera, terge, actualizarea i selectai dedate prin intermediul browser-ului web.La fiecare punct fix care le fac un fiier
A PROPOSAL FOR AMANAGEMENT APPLICATION
FOR STUDENTS
Adrian Runceanu,University Constantin Brncui,
Trgu-Jiu, Romnia, [email protected]
ABSTRACT. In this paper we propose a web-basedapproach to management students in an educationalinstitution developed using MySQL database and PHPscripting language.
KEY WORDS: application, management, student
1. INTRODUCTIONThe idea was to use the resources each
department has and to present a practicalsolution with keeping security of the data inmind. Due to the constraints regarding the
budget on the project allocated until now and thetime frame for the project, one of the most
suitable solution was to use free open sourcesoftwares (Apache as a web server, MySQLserver as a backend database and php as a serverside language). These three programs will beinstalled on each machine in every department.Considering the complexity of configuringApache, MySQL and php, the solution is to useXAMPP
(http://www.apachefriends.org/en/xampp.html).
It is a free packaged preconfigured
Apache, MySQL, php bundle, which simplyneeds to be installed.Each department communicates to its
own local database via a web browser, so theycan insert, delete, update and select data via theweb browser. At every fixed point they make adump file of the data that are not updated to theMain database. This action is performed by firstcreating a duplicate of each table and insertingthem with all the data that has not been updatedto the Main until that moment. Which is known
from a column called copied (Boolean value), ifcopied 1 else 0. After the creation of new tables
-
7/31/2019 18 Adrian Runceanu
2/9
Analele Universit ii Constantin Brncui din Trgu Jiu, Seria Inginerie, Nr. 1/2011
Annals of the Constantin Brncui University of Trgu Jiu, Engineering Series, Issue 1/2011
181
dump de date care nu sunt actualizate labaza de date principal. Aceast aciuneeste efectuat de ctre primul crearea unuiduplicat de fiecare tabel i inserarea lor cutoate datele care nu a fost actualizat la
Main pn n acel moment. Care estecunoscut dintr-o coloan numit copiat(Boolean valoare), n cazul n care copiatun altfel 0. Dup crearea de noi tabele iintroducerea de date non actualizate, acesttabel este nou fac obiectul unui dumpingn fiier folosind comanda mysqldump.
and insertion of non updated data, this new tableis dumped into file using mysqldump command.
mysqldump-u% mysqluser mysqlpassword-p%%% nod student_dump workdir%% \student_dump.sql
Acest lucru se realizeaz prin intermediulunui fiier batch, care creeaz fiierul deimagine memorie, fermoare fiierul icripteaz-l. Aceste date este acum gata
pentru a fi expediate la Main.Pe de altparte, Principal, decripteaz datele, unzipsea i de date este actualizat n baza sa dedate. Aceast aciune este, de asemenea,efectuat prin intermediul unui fiier batch,care recreeaz aceste tabel dump din
fiierul de imagine memorie.
This is done via a batch file, whichcreates the dump file, zips the file andencrypts it. This data is now ready to bedispatched to the Main.
On the other side, the Main,decrypts the data, unzips it and the data isupdated in its database. This action is also
performed through a batch file, whichrecreates these dump table from the dumpfile.
mysql-u mysqluser% mysqlpassword-p%%%% departamente workdir
-
7/31/2019 18 Adrian Runceanu
3/9
Analele Universit ii Constantin Brncui din Trgu Jiu, Seria Inginerie, Nr. 1/2011
Annals of the Constantin Brncui University of Trgu Jiu, Engineering Series, Issue 1/2011
182
proiecte, s aloce teme si proiecte pentrufiecare elev, pentru a da marca pentrulaborator lucrri i proiecte, indicnd ctevaobservaii de fiecare elev manualCererea poate fi gsit la
http://www.runceanu.ro/adrian/gestiune/index.php.Cererea are dou tipuri de utilizatori: studenii administrator. Doar administratorul, de faptasistentul sau profesorul care gestioneaz
baza de date a proiectelori a studenilor, aparolelor de acces pe un modul nadministraia. Alti utilizatori a acestuisoftware, studeni, au acces numai peinterfata destinate n mod special pentru ei.Dupa autentificare n, un elev va fi capabil de
a ncrca tema proiectului i pentru avizualiza notelor acordate de ctre un
profesor de la munca de laboratori proiectelaboratori la proiect.
themes and projects for each student, to givemark for laboratory works and the drafts,indicating a few observations of each studenthandbook
The application can be find at
http://www.runceanu.ro/adrian/gestiune/index.php.The application has two types of
users: students and administrator. Only theadministrator, in fact the assistant or theteacher who manage the database of projectsand students, has passwords for the access ona module in administration. Other users ofthis software, the students, have access onlyon the interface specifically intended forthem. After login in, a student will be able to
upload theme of the project and to view themarks given by a teacher at the laboratorywork and projects
2.1. Modulul destinat studenilor
2.1.1. nregistrarea i logareaUn student, pentru a avea acces la
facilitile oferite de site trebuie s se
2.1. Module for students
2.1.1. Registration and loggingA student, to have access to the
facilities offered by the site, must register.
-
7/31/2019 18 Adrian Runceanu
4/9
Analele Universit ii Constantin Brncui din Trgu Jiu, Seria Inginerie, Nr. 1/2011
Annals of the Constantin Brncui University of Trgu Jiu, Engineering Series, Issue 1/2011
183
nregistreze. Acest lucru se face prinintermediul butonului "nregistrareStudent" aflat n meniul superior n parteadin dreapta a primei pagini.Pentru a se nregistra studentul va trebui s
introduc n formularul ce va aprea datelepersonale (username, nume, prenume, an,grupa, email, parola).
O dat nregistrat va putea s selogheze utiliznd loginbox-ul de pe prima
pagin. Doar logat, un student va putea sfac upload de proiect sau s i vizualizezenotele obinute pn la un moment dat.
Un vizitator nenregistrat al site-ului va putea doar s vad o list destudeni, mpreun cu detaliile lor.
Meniul din partea de sus a interfeeigrafice are 3 rubrici, i anume: "Home","Login Student" i "nregistrare Student".
This is done through the button "Studentregistration" under the menu in the upperright side of the first page.
For registration the student willhave to introduce in the form personal data
(username, name, year, the group, email,password).Once registered will be able to
login using login box on the first page.Only logged, a student will be able toupload the project or to view the marksobtained by a time.
An unregistered visitor of the sitewill only be able to see a list of students,and their details.The menu at the top of the graphical user
interface has 3 sections, namely: "Home","Login Student" and "Student registration".
2.1.2. Lista de studentiDup nregistrare, un student nou se
poate conecta la aplicaie utiliznd butonulde logare a studenilor. Meniul care apareeste format din 4 rubrici: Home, Paginastudentului, Note si Logout.
Apelnd butonul "Paginastudentului" din cadrul meniului din parteade sus se va deschide o pagin n care
2.1.2. The list of studentsAfter registration, a new student
can connect to applications using thebutton logging students. The menu thatappears is comprised of 4 sections:"Home", "Student Page", "Marks" and"Logout".
Using the "Student Page" of the topmenu it be will opened a page in which the
-
7/31/2019 18 Adrian Runceanu
5/9
-
7/31/2019 18 Adrian Runceanu
6/9
Analele Universit ii Constantin Brncui din Trgu Jiu, Seria Inginerie, Nr. 1/2011
Annals of the Constantin Brncui University of Trgu Jiu, Engineering Series, Issue 1/2011
185
Meniul care apare este format din 6rubrici: Home, Sterge Student, TemeLaborator, Adauga Proiect, NoteProiect i Logout.
Apsnd pe butonul StergeStudent apare lista cu toi studenii din
baza de date, la momentul respectiv, i careau n dreptul lor cte un marcator detergere x, pe care prin apsare se poareefectua eliminarea propriu-zis astudentului.
Apsnd pe butonul TemeLaborator apare lista derulatoare cu toistudenii din baza de date, la momentul
respectiv.Pentru fiecare student selectat sepoate acorda o not la o tem de lucrarepractic de laborator.
Numrul de teme de laborator estestabilit de ctre administrator.
Apsnd pe butonul AdaugaProiect se pot executa dou activitilegate de evidena proiectelor alocatestudenilori anume:
- adugarea unui nou proiect;- alocarea unui proiect dejaexistent unui student.
The menu that appears its consistof 6 sections: "Home", "Remove Student","Theme Laboratory", "Add Project","Project Notes" and "Logout".Clicking on the button "Delete Student" itwill appear the list of all students from thedatabase, at that time, and they have onright side an erase marker "x", which isused to delete students from the database.
Clicking on the button "LaboratoryTheme", it will appear the list of allstudents from the database, at that time.
For each selected student may begiven a mark for a laboratory practice
theme paper. The number of laboratorythemes is established by the administrator.Clicking on the button "Add
Project" they can be run two activitiesrelated to the evidence of students allocatedto projects namely:
- Adding a new project;- Allocating an existing project of a
student.
1. The adding of a new project can
be done in the first part of the page. Youcan add the name of the project (which
-
7/31/2019 18 Adrian Runceanu
7/9
Analele Universit ii Constantin Brncui din Trgu Jiu, Seria Inginerie, Nr. 1/2011
Annals of the Constantin Brncui University of Trgu Jiu, Engineering Series, Issue 1/2011
186
1. Adugarea unui proiect se poate face nprima parte a pagini. Se pot aduga numeleproiectului (care trebuie s fie diferit dedenumirile proiectelor existente) i detaliilegate de cerinele pe care trebuie s le
ndeplinesc proiectul respectiv n viziuneaprofesorului(asistentului) care a stabilitacea tem de proiect.2. Alocarea unei teme de proiect unuistudent de poate face n cea de a doua partea aceleai pagini. Se poate alege numelestudentului care nu are niciun proiect alocatla momentul respectiv i denumirea
proiectului alocat. Ambele informaii(numele studentului i denumireastudentului) se selecteaz din dou liste
derulatoare.Ca observaie, am luat n calcul c unstudent care a primit un proiect s nu maiapar n lista derulatoare cu toi studenii
pentru a evita situaia n care acelaistudent primete dou sau mai multedenumiri de proiect.Asemntor, denumirile de proiecte care aufost deja alocate unor studeni, dispar dinlista derulatoare corespunztoare, pentru aevita situaia n care un proiect cu aceeaidenumire s fie alocat la doi sau mai mulistudeni.
Apsnd pe butonul Note Proiectse poate acorda nota unui student care auploadat anterior acestei aciuni tema de
proiect alocat.Profesorul(asistentul) are posibilitatea sdownloadeze fiierul de tip arhiv ZIP ceconine rezolvarea propus de ctre fiecarestudent n parte la proiectul care i-a fost
alocat i s acorde apoi nota pe care oconsider.
3.GHIDULPROGRAMATORULUI
Aplicaia "Sistem on-line deeviden a studenilor dintr-o facultate" afost implementat prin tehnologia PHP,tehnologie care permite o dezvoltare maisistematic a unei aplicaii cu baze de date.Ca Application Server am folosit Apache,
baza de date a fost MySQL, iar mediul de
should be different from the names ofexisting projects) and details of therequirements that need to be accomplished
by the project in teachers (assistants)vision, who established the theme of the
project.
2. Assigning a theme project to astudent can be done in the second part ofthe same page. It may be choose the nameof the student who has no project assignedat that time and the name of the project.Both information (student name and the
project name) are selected from twounrolled lists.
As an observation, we thought that
a student who has received a draft not toappear anymore in the unroll list of allstudents, to avoid the situation in which astudent receives two or more projectnames.
Also, the names of the projects thathave already been allocated to students,disappear from the appropriate unroll list,to avoid the situation where a draft of thesame name to be assigned to two or morestudents.
Clicking on the button "ProjectMarks" a mark can be give to a studentwho uploaded earlier the project themeallocated.
The professor (assistant) has theopportunity to download the *.zip archivefile which contain the solution proposed byeach student to the project which wasallocated and then to give you theconsidered mark.
3. PROGRAMMERS GUIDEThe application "on-line registration
system for university students" has beenimplemented by PHP technology, whichallows a systematic development of anapplication with databases. As we usedApplication Server Apache, the database isMySQL, environment and development has
been used Macromedia Dreamweaver 8.0.The application is a solution to keep
the record of students who participate to alaboratory.
-
7/31/2019 18 Adrian Runceanu
8/9
Analele Universit ii Constantin Brncui din Trgu Jiu, Seria Inginerie, Nr. 1/2011
Annals of the Constantin Brncui University of Trgu Jiu, Engineering Series, Issue 1/2011
187
dezvoltare utilizat a fost MacromediaDreamweaver 8.0.
Aplicaia reprezint o soluie pentruinerea evidenei studenilor ce particip laun laborator.
3.1. Baza de daten baza de date reinem toate
elementele ce interfereaz n aplicaianoastri tipurile de legturi dintre acestea.n total am creat 4 tabele necesare. Tabelele
bazei de date au fost create folosindPhpMyAdmin.
n figura urmtoare sunt prezentatecele patru tabele ce alctuiesc baza de datenecesar, ct i legturile ntre acestea..
3.1. DatabaseIn the database we keep all the
interfering elements in our application andtypes of connections between them. So, we
created the 4 necessary tables. The tables ofthe database were created usingPhpMyAdmin.
In the next picture are presented thenext four tables that make up the databaserequired, as well as connections betweenthem.
1. Tabela studeni conine elementele cedefinesc un student nscris pe site, i anumenume, prenume, parola, email, an i grupa.2. Tabela situaie_note conine nregistrri cucmpurile sn_id, student_id, tema_id i nota.
Prin aceast tabel se face asocierea ntre unstudent, o tem
1. The table students contains items thatstudents define a student enrolled at the site,namely: name, password, email and thegroup.2. The table situatie_note contains records
with the fields: situatie_note, sn_id,student_id, and tema_id. This table is the
-
7/31/2019 18 Adrian Runceanu
9/9