,,,
-
...
()
" "
:
-
. : ..
: ..
/: ..
: ..
:
-00-1
:
: ..
: ..
. 2005 .
143 ., 36 ., 23 ., 21 , 4 .
(), - , "sunrav testofficepro", web-, , , web- apache, web- php 4, mysql, web- macromedia dreamweaver mx 2004, , .
- , SunRav TestOfficePro.
web- "R@Learning Institute", "" .
web- PHP 4. MySQL web- Apache. , . , , , web-. web- -.
. , web- .
. 2
. 6
1. . 9
1.1 . 9
1.2 . 13
1.3 . 14
1.4 . 16
1.4.1 -. 16
1.4.2 TV-. 16
1.4.3 () . 17
1.4.4 . 18
1.5 . 19
1.5.1 "eLearning Server 3000". 20
1.5.2 "Lotus LearningSpace". 24
1.5.3 "". 28
1.5.4 "SunRav TestOfficePro". 30
1.6 . 35
1.6.1 . 35
1.6.2 . 38
1.7 . 39
1.7.1 . 40
1.7.2 . 41
1.8 -. 48
1.9 . 49
1.10 . 52
1.10.1 .. 52
1.10.2 .. 54
1.10.3 web-. 54
1.11 . 56
1.11.1 PHP 57
1.11.2 MySQL . 60
1.11.3 web-. 61
2. . 63
2.1 . 63
2.2 . 66
2.3 - 73
2.3.1 Web- Apache. 74
2.3.2 Apache. 74
2.3.3 Apache . 77
2.3.4 MySQL. 79
2.4 Macromedia Dreamweaver MX 2004. 81
2.5 .. 86
2.6 web-. 89
2.6.1 . 90
2.6.2 CSS. 92
2.6.3 . 94
2.6.4 . 97
2.6.5 .. 98
2.6.6 web-.. 101
2.6.7 . 102
2.6.8 . 107
2.6.9 Cookies. 107
2.6.10 web-. 109
2.7 web-.. 110
2.7.1 . 111
2.7.2 . 113
2.7.3 . 117
2.8 . 120
3. . 122
3.1 . 122
3.2 . 122
3.3 . 127
3.4 . 128
3.5 131
4. .. 136
4.1 . 136
4.1.1 , .. 136
4.1.2 . 136
4.1.3 . 138
4.1.4 - . 138
4.1.5 . . 140
4.1.6 . 142
4.1.7 .. 143
4.1.8 . 144
4.2 . 145
4.2.1 (1-4) 145
4.2.2 . 148
. 150
. 153
. 155
. - , . . , , , . , . , , .
, , , , ..
, , . . , () , , , , . , , , , . , , "" . , . , , .
. , , .
. . . , , . web-. , , , , , - web- . web- . , , , , Perl, Internet- : , (web- Apache MySQL), , . , . , , Internet- . MySQL SQL-. PHP, .
. web- . , , . , .
, , . . "" , . , , , - . , , .
- , , , , , - , .
() , , , , [1].
, , , , , .
, , .
, , , . , , I , , , .
, - , , . - , - . - - , , , , . - , , . - - , , c, , , , , .
, :
- , , , -, . , .
- , , ( , , ..). - - , , , - - , . , .
- . . - - , . , , , . . , , e-mail, , , , (, , ). , , .
on-line . , - , . , . , , , , . .
. , . , , . , , , , . , , . , . - . , .
, . , - , , . , , , , , , . , , . , , .
, [1]. :
. , , . , .
. . ( ) , . , .
. , .. " ".
. ( ) .
. , .
. "". .
. .
. .
. .
( ). , , , , ..
. , .
. .
, , , , , .
( ) , [2]. , . , .
, , . , -, . .
() ( - ) , ( - ).
, - (), , .
: , - , , , , , - , , , , .
, ( ), . .
: -, TV- () [1]. .
, () , - - .
. . - - 100 . , , .
, - - . - , -, - , .
"". "" "", . TV-, , .
, - , .
- , . - " " - , . . , , . "--" - : "" "" - .
. , - , . , - , . ( 700 ) - . , .
. , ( 1.1).
1.1 -
- ( , -, ), - |
- ; ; ; . |
, , - |
- ; ; ; ; . |
- ; ; ; . |
|
- ; ; ; . |
|
- ; ; . |
, . , . , . , -. - , , , , .
, . , - -.
"eLearning Server 3000" - , , - [3].
/ . web-. IT-, , , .
"eLearning Server 3000" : "", "", "", "" "".
XML - .
. . ePublisher - . eAuthor - . eBoard - , , . eAuthor , , web- . , .
, eLearning Office 3000, : - , , . , . "", , . "" - , . . "" . : , , , . , . " ", , . , , , - .
: RTF PDF. 40 . "ePublisher" .
"ePublisher" :
;
;
, .
"ePublisher", :
(avi, mpeg4);
(wav, mp3);
(gif, jpg, bmp);
html-;
( web-, );
;
;
.
:
exe-, Windows;
html- Internet.
- . - .
"eAuthor" , : , , .
("eAuthor" ). . , . - , , . , , .
, :
( RTF),
( GIF, JPEG, BMP),
( WAV, MP3),
( AVI, MPEG).
, , .
, . .
. : , . , . , .
. . , .
"eBoard" ( ) web-, , web-, . , , online- , , , , - .
LearningSpace [4]. . Lotus Lotus Notes. . LearningSpace . , LearningSpace , . , , , , , .
.
Lotus Notes, , .
, .
.
, .
.
, "".
Lotus . LearningSpace, , Lotus (Lotus Institute), , Lotus (Lotus Education). LearningSpace , , .
. , , , - . , - . , . , World Wide Web, , . LearningSpace , , .
LearningSpace . , . LearningSpace . , , , , ( ) .
LearningSpace , . " LearningSpace" on-line. LearningSpace . , , , , .
" LearningSpace" , , . LearningSpace . , , .
LearningSpace :
- ;
- ;
- ;
- ;
- ;
- "", ;
- Lotus Notes;
- , ;
- ;
- , ;
- ;
- ;
;
- LearningSpace;
(Quick Reference card), LearningSpace.
"" - , () [5].
"" :
(Test Designer) - ;
(Page Designer) - ;
(Project Designer);
(Analitic) - .
(Test Designer) - , , . ( ) .
, , :
, , ;
, , ;
;
, ;
;
;
(, , , ) .
, /. , . , , .
. . , , .. , . .
(Page Designer) - , , , .
(Project Designer) - , , (), (), , () ( ).
(Analitic) - .
, , . , (, , , ..) [6].
tMaker - ; tTester - ; tAdmin - .
, , , .. , , , , - - , HTML OLE . - , , , , .. .
tMaker .
, . MS WORD.
. (, , MS WORD) MS Excel.
. RTF, TXT, XML.
.
" ". , . , .
.
/ / .
. , , , , , , ..
. tTester , , .
. , .
tTester .
. .
. / . .
. , : . .. , - , , - , .
, - .
.
.
. - . :
, .
, tTester .. , , SunRav BookOffice.
. , . , .
. CD DVD , , - .
. / ( ). , :
.
.
.
: , .
. .
. :
. .
, .
. , / .
. , .
tAdmin .
. , , .
. - . , - tAdmin.
:
, ( ).
: , , , , .
: , , , .
. / . : , , , , , , , , . , :
. .
. .
. .
. , , // .
. , , . .
. .
. ( ) . , .
. : Excel, XML, HTML, PDF, RTF, BMP, JPEG, TIFF.
. tAdmin ( , ..) , .
. . . .
- [7]. , , - . , , , , , .
. , , .
:
, - , - / .
, .
:
. , , , , . , , , , .
( ) ( ), . . , .
. : , . . -, , . , , , . , .
, . , , , , ( ), . ( ), .
, , .
, . , , .
- . ( ) ( ). , ( ).
. , , , - . , , .
, , , .. . web-, web- - [7].
, . , , . HTML- . . HTML- .
. , , . . , . , . , , CD, , . - -, - - ( ). , , , [8].
, . , . , . , , .
, , , .
1 , . (, ).
2 , . / , . . - -.
3 , , "" . . . , . , , , , . , .
4 . , .
5 , . "" . , , "" .
1. . , . (, ) [8, 9].
, , . . . , , . , . . , , . , . , .
. , , , , .
? . , : , ; , ; ; , ; . - .
. , , . , , , .
, , , "" "" , , . , -, , .
, , . , . , , . . . , . .
, , - . , .
, , , . , , , . . .
. , . , . ( ) . , , .
, , . .
2. , . / , . [8].
. . , , , . . , , WMware. , . , , , .
. , . (Hasp ..). , , . .. . , , . , . . .., , .
. - , , COPYWRIT, .. . , . . , , . , , , .
, , . , (, ..), . , , , , WMware.
, , web-, . .
3. . [8].
. . , . . .. , , .
. . - - . , , , - .. . - .
- web-. web-, , , .
4. . , [8, 9].
. . , . , - . , , .
.
, . - . . .
, , . , , . , , , web-, - web-, , . , , .
5. [9].
, . . , . , . , , , .
, .
:
1. - web-;
2. ;
3. ;
4. , , web-, ;
5. ;
6. web-, web-. , . , , , .
World Wide Web (WWW). WWW , . . WWW . . . , , , . , , , , , .
WWW :
;
;
;
- .
WWW , , . web-, PHP Java , , . .
. , , , , .
.
, , , .
, . : - , .
. , .
. , , ( ). , . , . , . . web-, . 1.1
1.1 -
, , - MySQL. , , "" .
, , , . , . . web- PHP - , .
, , ( ), , .
, web-. web- PHP 4. MySQL web- Apache. , , , . web- - ().
, , web-, ;
;
- . , . . - ;
. ;
() . ( ). "" , ;
. ;
, , ;
. . - , () . ;
, , , , web-. , ;
web- . HTML-. PHP;
, : web- Macromedia Dreamweaver MX 2004, web- Apache 2, web- PHP 4 MySQL 4.
- :
, ;
;
;
Web- ( ).
web- ;
();
web-;
" " , , , .
, .
, web- . . , , , , .. . , , , . , , .
, 25% , . , .
, , . , , . , , , -. - . , , , , , . .
, . , ( GIF JPEG), , .
. - , . . ( ), . . . - . () 30-40 , .
, . , , . web-, - , , .
web- . , , SQL- , SQL- . , web- . . , SQL- 70-90% HTTP-.
( ) . , web- . .
web- . - PHP, Perl, # (DOT. NET), Java2. ASP , ASP DOT. NET Windows- .
PHP MySQL. web- Apache. web- Macromedia Dreamweaver MX 2004.
PHP - - (open source), (server scripting language), HTML, [11].
PHP HTML.. . , 1.2:
1.2 - PHP
, "" , -. , , , , ( . phtml . php, ) ( ) . PHP- HTML-, , . , . html/htm web- - .
CGI-, , Perl C - , CGI- HTML-, , PHP - - HTML-, ( <? php ? >).
PHP JavaScript/Jscript/VBScript, . , PHP- , , JavaScript- .
MS Internet Information Server , PHP Active Server Pages (ASP), Java , PHP Java Server Pages (JSP). PHP ColdFusion embPerl. , Web-, HTML-. web- PHP-.
PHP , CGI-. : , , (cookies).
PHP (databases), Web- .
: Adabas D, InterBase, Solid, dBase, mSQL, Sybase, Empress, MySQL, Velocis, FilePro, Oracle, Unix dbm, Informix, PostgreSQL, ODBC.
PHP IMAP, SNMP, NNTP, POP3 HTTP, (sockets) .
web- , web- - . : , , .. CGI-, Perl. , CGI- . CGI-, , . PHP - web-, ASP Microsoft ColdFusion Allaire.
PHP C Perl. , , PHP. / .
, PHP, . Perl- PHP- .
( MySQL ) PHP-MySQL -. , , Windows, , Unix. , PHP CGI-, , , web- Apache IIS.
, , , - .
, , , - .
MySQL - , . MySQL , [11].
MySQL TcX , . , MySQL 1996 40 , 10,000 , 500 7 . MySQL . . Unix-, , . Windows, MySQL Windows NT Windows 95/98.
MySQL- .
MySQL SQL ANSI 92, , .
MySQL.
1 , ;
2 50 ;
3 . MySQL ;
4 .
MySQL , . MySQL :
. LOCK/UNLOCK TABLE;
;
.
. . web-, .
web- - Frontpage 2003 Microsoft Dreamweaver MX 2004 Macromedia [7].
FrontPage Microsoft. FrontPage 2000 , Microsoft Office. , , web- . , FrontPage 2002 Microsoft Office XP.
FrontPage , - web- . , , web-, . , , , - , . .
Dreamweaver, FrontPage, , , . , . - web-. , , web-, HTML-, web-, , . , web- Adobe Photoshop Macromedia Dreamweaver - web-. PHP, . , web-.
- , , .
:
;
;
;
, - ;
, ;
.
. .
.
, : "", " ", " ", "", " ", " ", " ", " ", " " "". .
"" . : , , , , , , , , , , . , , , , .. . , - . .
" " . : , , , , , , . , , , .. . - .
" " . : , , , , , , . , , , .. . - .
"" . : , , , , , . , , , .. . - .
" " , . : , , , , . , , , .. . - , .
" " . : , , , , . , , , .. . - .
" " , . : . - .
" " . : , , . , , , .. . - .
" " . : , , , . , , , .. . - .
"" . : , , , , . , , , .. . - .
"" " " "--", "" " " - "--", " " " " - "--", " " " " - "--", " " " " - "--", " " "" - "--", " " " " - "--", " " " " - "--", " " " " - "--", " " " " - "--", "" .
RLI_test. , , .
, . , , .
"users". , . - login - , . Passwd - . md5, PHP. . .
n_group . registration_date , . sex - . student_code . , . . student_codes.
u_admin . , , , , .
users login. login "user_courses" "--", student_code - c "student_codes" "--". "users" 2.1
2.1 - "users"
/ | ||||
1 | login | char(16) | ||
2 | passwd | char(128) | NOT NULL | |
3 | lastname | char(40) | NOT NULL | |
4 | firstname | char(40) | NOT NULL | |
5 | middlename | char(40) | NOT NULL | |
6 | n_group | char(40) | NOT NULL | |
7 | registration_date | date | ||
8 | sex | enum('', '') | ||
9 | char(128) | NOT NULL | ||
10 | student_code | char(10) | NOT NULL, UNIQUE | |
11 | u_admin | enum('y', 'n') | DEFAULT 'n' |
"courses" . id_course. id_course "user_courses" "course_parts" "--", n_teacher "teachers" "--". course_period . , course_period . 2.2
2.2 - "courses"
/ | ||||
1 | id_course | int | , AUTO_INCREMENT | |
2 | course_name | char(128) | NOT NULL | |
3 | course_annotation | text | ||
4 | course_full_description | char(128) | ||
5 | course_picture_link | char(128) | ||
6 | course_period | float | ||
7 | n_teacher | int | NOT NULL |
"course_parts" . id_course_part. id_course_part "questions" "user_tests" "--", n_course "courses" "--". 2.3
2.3 - "course_parts"
/ | ||||
1 | id_course_part | int | , AUTO_INCREMENT | |
2 | n_course | int | NOT NULL | |
3 | n_part | int | NOT NULL | |
4 | download_link | char(128) | NOT NULL | |
5 | download_description | text | ||
6 | test_name | char(128) | ||
7 | , | test_question_count | int | NOT NULL, DEFAULT 5 |
"questions" . "questions" id_question. id_question "answers" "--", n_course_part "course_parts" "--". 2.4
2.4 - "questions"
/ | ||||
1 | id_question | int | , AUTO_INCREMENT | |
2 | n_course_part | int | NOT NULL | |
3 | question_content | char(255) | NOT NULL |
"answers" . id_answer. n_question "questions" "--". 2.5
2.5 - "answers"
/ | ||||
1 | id_answer | int | , AUTO_INCREMENT | |
2 | n_question | int | NOT NULL | |
3 | answer_content | char(255) | NOT NULL | |
4 | right_answer | enum('y', 'n') | NOT NULL, DEFAULT 'n' |
"user_courses" , . "user_courses" id_user_course. id_user_course "user_tests" "--", login "users" "--", n_course "courses" "--". 2.6
2.6 - "user_courses"
/ | ||||
1 | id_user_course | int | , AUTO_INCREMENT | |
2 | login | char(16) | NOT NULL | |
3 | n_course | int | NOT NULL | |
4 | status | enum('reg', 'end', 'not') | NOT NULL | |
5 | registration_date | date | ||
6 | end_date | date |
"user_tests" . "user_tests" id_user_test. n_user_course "user_courses" "--", n_course_part "course_parts" "--". status - reg - , end - , not - . registration_date . end_date . 2.7
2.7 - "user_tests"
/ | ||||
1 | id_user_test | int | , AUTO_INCREMENT | |
2 | n_user_course | int | NOT NULL | |
3 | n_course_part | int | NOT NULL | |
4 | attemps | int | ||
5 | percent | int | ||
6 | last_test_date | date |
"teachers" . "teachers" id_teacher. id_teacher "courses" "--". attemps . last_test_date . 2.8
2.8 - "teachers"
/ | ||||
1 | id_teacher | int | , AUTO_INCREMENT | |
2 | teacher_name | char(128) | NOT NULL | |
3 | teacher_degree | char(128) | NOT NULL | |
4 | teacher_email | char(128) | ||
5 | teacher_photo | char(128) | ||
6 | teacher_about | text |
"correct_codes" , . "correct_codes" student_code. student_code "users" "--". 2.9
2.9 - "correct_codes"
/ | ||||
1 | student_code | int |
"news" . "news" id_news. 2.10
2.10 - "news"
/ | ||||
1 | id_news | int | , AUTO_INCREMENT | |
2 | title | char(128) | NOT NULL | |
3 | date_news | date | ||
4 | body_news | char(128) | NOT NULL | |
5 | autor_news | char(128) |
2.1
2.1 -
, . , web- Apache 2.0.35, PHP 4.1.2, MySQL 4.0.21. Macromedia Dreamweaver MX 2004. . .
Web- , , . Apache . Web- GET ( ), Apache. Apache , GET , , , .
Apache - Web- . IIS (Internet Information Server) Microsoft, Windows. Apache, Windows, Unix- - Linux FreeBSD. , Apache, IIS. IIS , Windows.
Apache - web PHP. , , , .
Apache Windows http: // www. apache. org Apache Windows) [12]. : Typical. , . "C: \Program Files\Apache Group\Apache". 2.2
2.2 - web- Apache
Apache . HTML- C: \Program Files\Apache Group\Apache\htdocs. , : \www, . - cgi html. CGI-, - HTML-.
C: \Program Files\Apache Group\Apache\conf \httpd. conf :
ServerName - . , ServerName , . , #.
DocumentRoot - :/www/html:
DocumentRoot :/www/html
, , HTML-.
ScriptAlias :
ScriptAlias/cgi/":/www/cgi/"
ScriptAlias/cgi-bin/"c:/www/cgi/"
:/www/cgi. , http: // localhost/cgi http: // localhost/cgi-bin, :/www/cgi.
<Directory ":/Program Files/Apache Group/Apache/htdocs"> :
<Directory "c:/www">
Options Indexes Includes AllowOverride All Allow from all </Directory>
, : \www . : , SSI, . access .
, AddHandler:
AddHandler cgi-script. bat. exe. cgi
Apache , . bat. exe . cgi CGI-.
SSI:
Addtype text/html. shtml
AddHandler server-parsed. shtml. html. htm SSI.
.
Apache. :
C: \Program Files\Apache Group\Apache\apache. exe
Apache/2.0.35 (Win32) running...
. Internet Explorer : http: // localhost. Apache. CGI SSI. test. bat c: \www\cgi:
@echo off
echo Content-type: text/html
echo.
echo.
echo Hello!
http: // localhost/cgi/test. bat - Hello! SSI test. html c: \www\html:
SSI Test<br>
<! -tinclude virtual="/index. html" ->
SSI (Server Side Include) - , Web- HTML, .
test. html SSI Test, a - Apache.
Apache 4. 4 Windows http: // www. php. net ( http: // www. php. net/downloads. php) [13].
, 4 C: \Program Files\PHP 4\. .
PHP 2.3
2.3 - PHP 4
php. ini ( , ) :
[mail function] ; For Win32 only. SMTP = localhost
sendmail_from = me@localhost. com
SMTP SMTP-. SMTP- - Linux, Windows SMTP- , Windows. , mail(), , .
httpd. conf ( Apache) :
AddType application/x-httpd-php php
, , #. - . , . php I- application/x-httpd-php.
MIME . , . MIME, , C: \Program Files\Apache Group\Apache\conf. MIME : /. MIME:
application - ( , ).
audio - (audio/mpeg).
image - (audio/png).
text - (text/html - HTML, text/plain - ).
MIME- Content-type.
:
ScriptAlias/_php_/":/Program Files/PHP5/" Action application/x-httpdhp "/_php_/php. exe"
_php_ :/Program Files/PHP 4/, application/x-httpd-php php. exe.
. test. php:
<?
phpinfo ();? >
c: \www\html. http: // localhost/test. php. phpinfo().
MySQL http: // www. mysql. com. : \Progam Files\MySQL\. MySQL server. bat:
@echo off
": \Program Files\MySQL\bin\mysqld"
start/m "C: \Program Files\Apache Group\Apache\apache"
Windows NT 2000, server. bat , :
@echo off
start C: \Progra~l\MySQL\bin\mysqld-nt - standalone
C: \Progra~l\Apache~l\Apache\apache - k start
Apache MySQL server. shutdown. bat, :
@echo off
C: \Progra~l\Apache~l\Apache\apache - k shutdown
C: \Progra~l\MySQL\bin\mysqladmin - u root shutdown
my. ini ( ), :
user=root
password=geijr
MySQL Windows.
, MySQL WinMySQLadmin 1.4, 2.4.
2.4 - WinMySQLadmin 1.4
Dreamweaver 2.5 , , , , , .
2.5 - Dreamweaver MX 2004 Window.
Object (), 2.6 , , ; . Common (). 2.6 .
2.6 - Objects Common
, , : Image (), Rollover Image ( ), , Table (), Tabular Data ( , ), Draw Layer ( ), Navigation Bar ( ), Horizontal Rule ( ), -mail Link ( ), Date ( ), Server-Side Include ( ), Flash Button ( Flash-), Flash Text ( Flash-), Shockwave ( Shockwave-), Generator (, Web- , , ActiveX, , ) .
Objects Forms (), 2.7, (. .2.8) : Form (), Text field ( ), Button (), Checkbox Radio Batton (), List/menu (/), File field ( ) Image field ( ), Hidden field ( ) Jump menu ( ).
2.7 - Objects Forms
Objects Text (), 2.8 - , , , .. ( 2.8).
2.8 - Objects Text
Object () Layout () View (), Web- ( 2.9).
2.9 - Objects Layout
, , PHP - Object - PHP. PHP, , .. ( 2.10).
2.10 - Objects PHP
, , () . PHP- , : , , , , .
. Edit | Preferences ( | ). Preferences (), 2.11 - , , CSS, .
2.11 - Preferences
Dreamweaver . 2.12 inde. php. - , , ( ). PHP . F12, .
2.12 -
( ) ( 2.13). , . Local View, Testing Server Sinchronize.
2.13 -
( ) : , , , , , , . , 1-3 ( ) , .
, , , . , , , , . , , . ( ) , , .. (, ), , .
, , .
. . 5 , , 2.14.
2.14 -
, , . , .
"" . , "" . , . .
, " ". , 2-3 . , .. , , , .
(URL) ( ), , , , - , , . , , () , GIF- . , , . . , , .
, , ( , ). , . , .
4 , , 5- . ( ), , , . , , , . , .
, , . , " " . , . , , . , "" "", . , , .
, , .
. . , , web-. . PHP, .
. , . Verdana, Arial, Sans-serif - .
: , , , , web-.
, . . 2.15.
2.15 -
. - , . java- [11]. popup_me. js, (menu. php - , menu_adm. php - ) (menu_rli. js - , menu_rli_adm. js - ). 2.16.
2.16 -
, , , , . - . 2.17.
2.17 -
, web- ( 2.18).
2.18 -
- , . , , , . - , - . 2. 19.
2. 19 -
CSS. rli_style. css. :
<link href="rli_style. css" rel="stylesheet" type="text/css">
, class , , class=\"buttonOrange\".
rli_style. css :
{ : ; : ; }
2.11
2.11 -
/ | ||
1 | height | |
2 | width | |
3 | border-top | |
4 | border-bottom | |
5 | border-left | |
6 | border-right | |
7 | font-family | |
8 | font-size | |
9 | font-weight | |
10 | color | |
11 | background-color | |
12 | background-image | |
13 | border |
, , , rli_style. css. , , , 2.12.
2.12 -
/ | ||
1 | center,a,div,tr,td,table, input,textarea,p,small,body | |
2 | popfirst, poplast | |
3 | a. m, a. ml | C |
4 | brbt | |
5 | bpics | |
6 | bcoursespic, btrainingpic, bcontactspic, baboutpic, bstudentpic, badminpic | |
7 | bb, bn, bi, bd | |
8 | popuser, a. pmenu | |
9 | textheader | |
10 | textonlightblue | - |
11 | textonlight | () |
12 | textonblue | |
13 | textonorange | |
14 | textrederror | |
15 | a | |
16 | a. light | |
17 | a. notunder | |
18 | buttonBlue | |
19 | buttonOrange | |
20 | buttonFiolete | |
21 | hr_onlightblue_orange | |
22 | hr_onlightblue_blue | |
23 | table_admin |
. :
config, Apache MySQL, ;
data, ;
dbedit, (db_create_rli. php);
files, , ;
images, , ;
news, news.
, 2.13.
2.13 -
/ | |||
1 | 2 | 3 | |
1 | about_contacts. php | ||
2 | about_contacts_right. php | ||
3 | about_faq. php | ||
4 | about_faq_right. php | ||
5 | about_info. php | ||
6 | about_info_right. php | ||
7 | about_teachers. php | ||
8 | about_teachers_right. php | ||
9 | admin. php | ||
10 | admin_add. php | - | |
11 | admin_add_check. php | - | |
12 | admin_del. php | - | |
13 | admin_edit. php | - | |
14 | admin_right. php | ||
15 | admin_update. php | - | |
16 | admin_update_check. php | - | |
17 | body_left. php | ||
18 | body_list_after_header. php | ( ) | |
19 | body_list_footer. php | ||
20 | body_list_header. php | ||
21 | body_right. php | ||
2.13 | |||
1 | 2 | 3 | |
22 | buttom. php | ||
23 | contacts. php | ||
24 | contacts_chat. php | ||
25 | contacts_chat_right. php | ||
26 | contacts_forum. php | ||
27 | contacts_forum_right. php | ||
28 | contacts_guestbook. php | ||
29 | contacts_guestbook_right. php | ||
30 | contacts_right. php | ||
31 | courses. php | ||
32 | courses_for_students. php | ||
33 | courses_for_students_right. php | ||
34 | courses_info. php | ||
35 | courses_info_right. php | ||
36 | courses_literature. php | ||
37 | courses_literature_right. php | ||
38 | courses_organization. php | ||
39 | courses_organization_right. php | ||
40 | courses_registration. php | ||
41 | courses_registration_right. php | ||
42 | courses_right. php | ||
43 | courses_technology. php | ||
44 | courses_technology_right. php | ||
45 | download. php | ||
46 | download_right. php | ||
47 | error. php | ||
48 | error_right. php | ||
49 | find. php | ||
50 | find_right. php | ||
51 | header. php | ||
52 | index. php | ||
53 | login_form. php | ||
54 | menu. php | ||
55 | menu_adm. php | ||
56 | menu_adm_rli. js | ||
57 | menu_rli. js | ||
58 | news. php | ||
59 | news_list_after_header. php | ||
60 | news_list_footer. php | ||
61 | news_list_header. php | ||
62 | news_right. php | ||
2.13 | |||
1 | 2 | 3 | |
63 | option. php | MySQL | |
64 | popup_me. js | ||
65 | progress. php | ||
66 | progress_right. php | ||
67 | rli_style. css | ||
68 | statistics. php | ||
69 | statistics_right. php | ||
70 | student. php | ||
71 | student_right. php | ||
72 | student_shedule_exams. php | ||
73 | student_shedule_exams_right. php | ||
74 | student_shedule_from_teacher. php | ||
75 | student_shedule_from_teacher_right. php | ||
76 | student_shedule_internal. php | ||
77 | student_shedule_internal_right. php | ||
78 | student_shedule_tutorial. php | ||
79 | student_shedule_tutorial_right. php | ||
80 | training. php | ||
81 | training_check_registration. php | ||
82 | training_check_registration_right. php | ||
83 | training_registration. php | ||
84 | training_registration_right. php | ||
85 | training_right. php | ||
86 | training_test. php | ||
87 | training_test_right. php | ||
88 | user_form. php | ||
PHP <? ? >. . include require. ,
<? include "header. php"? >
header. php.
:
<html>, <head> <title>;
header. php, , ;
body_left. php, .
_right. php;
buttom. php.
_right. php . body_list_header. php, , body_list_after_header. php, body_list_footer. php. , , 2. 20.
2.20 -
echo - , . "; " , . HTML, , . , , ../ // .
.
. , , . - , , .
NAME, . : GET POST. , GET URL, ACTION. :
http: // localhost/action. php? =&... =
, , (NAME), NAME=VALUE, VALUE - . . , &. URL- .
, URL-. , ASCII- . % 2- , .
"=" , NAME. POST . , "" .
PHP , .
C HIDDEN. , , , NAME, . , , , . , .
2.14 , .
2.14 -
/ | ||
1 | TEXT | |
2 | CHECKBOX | -. |
3 | SUBMIT | , |
4 | HIDDEN |
, .
TEXT : =. $. HIDDEN .
CHECKBOX - , on, , . , , $ "on". TEXT.
SUBMIT - SUBMIT, , . VALUE. TEXT.
PHP . .
, :
$personal ["name"] $personal ["email"].
, PHP <? php_track_vars? >, , , $HTTP_GET_VARS $HTTP_POST_VARS, .
web- :
Web-.
() ().
web-.
CGI- ( ) .
, CGI-, .
.
(web-) , .
, () () , , , Web-, , . -, .
CGI- () . Web- HTML-. Web- . .
Web-, URL- , QUERY_STRING CGI-, . CGI- QUERY_STRING, .
:
$SERVER = "localhost"; //
$USER = "root"; //
$PASSWD = "geijr"; //
$DB = "rli_test"; // "RLI_test"
$REPLY = "andrewnik@list. ru";
mysql_createdb ($DB); //
:
mysql_connect($SERVER,$USER,$PASSWD))
:
mysql_select_db($DB);
. PHP, RLI_test MySQL . WinMySQLadmin 1.4 Databases.
, MySQL :
mysql_query( );
// - users
mysql_query("CREATE TABLE users
(login char(16) PRIMARY KEY,
passwd char(128) NOT NULL,
lastname char(40) NOT NULL,
firstname char(40) NOT NULL,
middlename char(40) NOT NULL,
n_group char(40) NOT NULL,
registration_date date,
sex enum('', ''),
email char(128) NOT NULL,
student_code char(10) NOT NULL UNIQUE,
u_admin enum('y', 'n') DEFAULT 'n',
FOREIGN KEY (login) REFERENCES user_courses (login),
FOREIGN KEY (student_code) REFERENCES correct_codes (student_code))");
// - courses
mysql_query("CREATE TABLE courses
(id_course int PRIMARY KEY AUTO_INCREMENT,
course_name char(128) NOT NULL,
course_annotation text,
course_full_description char(128),
course_picture_link char(128),
course_period float,
n_teacher int NOT NULL,
FOREIGN KEY (id_course) REFERENCES user_courses (n_course),
FOREIGN KEY (id_course) REFERENCES course_parts (id_course_part))");
// - course_parts
mysql_query("CREATE TABLE course_parts
(id_course_part int PRIMARY KEY AUTO_INCREMENT,
n_course int NOT NULL,
n_part int NOT NULL,
download_link char(128) NOT NULL,
download_description text,
test_name char(128),
test_question_count int NOT NULL DEFAULT 5,FOREIGN KEY (id_course_part) REFERENCES questions (n_course_part),
FOREIGN KEY (id_course_part) REFERENCES user_tests (n_course_part))");
// - questions
mysql_query("CREATE TABLE questions
(id_question int PRIMARY KEY AUTO_INCREMENT,
n_course_part int NOT NULL,
question_content char(255) NOT NULL,
FOREIGN KEY (id_ question) REFERENCES answers (n_ question))");
// - answers
mysql_query("CREATE TABLE answers
(id_answer int PRIMARY KEY AUTO_INCREMENT,
n_question int NOT NULL,
answer_content char(255) NOT NULL,
right_answer enum('y', 'n') DEFAULT 'n' NOT NULL)");
// - user_courses
mysql_query("CREATE TABLE user_courses
(id_user_course int PRIMARY KEY AUTO_INCREMENT,
login char(16) NOT NULL,
n_course int NOT NULL,
status enum('reg', 'end', 'not')),
registration_date date,
end_date date,
FOREIGN KEY (id_ user_course) REFERENCES user_tests (n_user_course))");
// - user_tests
mysql_query("CREATE TABLE user_tests
(id_user_test int PRIMARY KEY AUTO_INCREMENT,
n_user_course int NOT NULL,
n_course_part int NOT NULL,
attemps int,
percent int,
last_test_date date)");
// - teachers
mysql_query("CREATE TABLE teachers
(id_teacher int PRIMARY KEY AUTO_INCREMENT,
teacher_name char(128) NOT NULL,
teacher_degree char(128),
teacher_email char(128),
teacher_photo char(128),
teacher_about text,
FOREIGN KEY (id_teacher) REFERENCES courses (n_teacher))");
// - correct_codes
mysql_query("CREATE TABLE correct_codes
(student_code char(10) PRIMARY KEY)");
// - news
mysql_query("CREATE TABLE news
(id_news int PRIMARY KEY AUTO_INCREMENT,
title char(128) NOT NULL,
date_news date,
body_news char(128) NOT NULL,
autor_news char(100))");
2.15.
2.15 -
/ | ||
1 | int | . MySQL int |
2 | float | . , int, |
3 | char() | . char , . |
4 | date | . yyyy-mm-dd |
5 | text | |
6 | enum(1, , N) |
web-. MySQL data/rli_test. , .
mysql_close().
while() mysql_fetch_row, $result, . , $row . mysql_fetch_row, , , . mysql_fetch_row false, , , .
$row , , , $row [1], . 0, 1.
mysql_fetch_array() , , , $row ["user"] ("user" - ).
Cookie - , . Cookies , , .
Cookies SetCookie. , - name:
name - (), Cookie;
value - ();
expire - ( ). , Cookie "" , . , , , Cookie ;
path - Cookie ();
domain - (). ;
secure - HTTPS-.
.
Cookies , Cookies ( echo - ). Cookies . , Cookies , -, , . Cookies .
Cookies . _I. Cookies, _I "; " ( ). :
mycookiel=valuel; mycookie2=value2
Cookies , . : echo $user_name_. .
Cookies , , , (login_reg) , (login_admin). Cookies user_name_, login_reg, login_admin. , , Cookie, , . Cookie , .
, . 2.21.
( ) . , . , . . , . , () . , , . - , .
2.21 - web-
- . . . , . . . . , . . . . .
web- - :
http: // localhost/rlearning. ru http: // localhost/rlearning. ru/index. php;
http: // www. rlearning. domen. ru http: // www. rlearning. domen. ru/index. php ( domen - ).
( 2.22).
2.22 - web-
, ( ) ( ) .
, .
, . 7 .
"" .
"" . " " - , . .2.7.2. " " . " ", , . " " , .
"" "" " ", web-. .2.7 2.
"". , , . .
" " " " - , "" - ( 2.23), " " - .
2.23 - ""
"Download" , .
"" - , , .
. "" "" - "". ( 2.24). "". . .
2.24 - ""
, . . , .
. "" "" ( 2.25). . , . , , ( 2.26). "" , . " ". . N , , . ( 2.27). , . . 70% , ( 2.28). . , , .
2.25 - ""
2.26 - ""
2.27 - ""
2.28 - " "
, 2N , . 70% . .
( "admin" "cneltyn"), "" ( 2.29). , "users" y "u_admin".
2.29 - ""
( 2.30). , , .
2.30 - ""
( 2.31), .. , .
2.31 - ""
, - , , . "", "" ( 2.32).
2.32 - " "
, . , ( 2.33).
2.33 - " "
.
PHP MySQL. web- Agava. ru. Normal. PHP 4, CGI ( shell, C, Perl ). MySQL ( 500 ).
. "Normal" .
"Normal" . " " , . , .
:
(, , ) ;
-;
;
(cron) -;
3- (- 3- );
, , MySQL, MySQL PHPMyAdmin;
- (, HTTP );
ftp- , ftp-;
- Apache (mime-types, apache handlers, , , HTTP-, hotlink-, IP . ..);
SSH - Java- ;
Analog Webalizer;
-. , , , , ( ).
Normal 250 .
( ) , [18]. 3.1
3.1 -
, . - . | ||
50 | ||
20 | ||
40 | ||
10 | ||
20 | ||
web- | 40 | |
90 | ||
100 | ||
40 | ||
410 |
, :
.
.
.
.
.
, , 3.2
3.2 -
- - | , | - | , |
, |
, . |
0,300 | 0,8 | 410 | 1,15 | 113,16 | |
0,080 | 0,9 | 410 | 1,15 | 35,31 | |
148,47 |
() (3.1):
, |
(3.1) |
Mi - i- , ; Ki - i- ( i = 0.7¸0.9); - , /×; - ; ; - . |
.
, 3.3
3.3 -
, . - . | , / | , | ||
- | 410 | 1.85 | 760.00 | |
20 | 33 | 660.00 | ||
2 | 33 | 66.00 | ||
2 | 21 | 42.00 | ||
- | - | - | 1528.00 |
() (3.2):
, |
(3.2) |
- i- , ., - , , - , - , . |
3.1 410 . : 20 , - 2 , - 2 .
(3.3):
, |
(3.3) |
- ( ), .; - ( 100 ). |
:
.
:
.
" " , 26% 0,2% ( ) , . .
:
.
3.4
3.4 -
, | ,% | , / | , | , . | |
13098.00 | 20 | 2224 | 410 | 482.93 | |
482.93 |
(3.4):
, |
(3.4) |
- i- , .; - i- ,%; - i- , ; - i- , /; - ; - . |
:
.
- - , , , , . 70-75% ( ).
.
, 3.5
3.5 - web- "R@Learning Institute"
, . | |
1 | 148.47 |
2 | 1528.00 |
3 | 201.22 |
4 | 482.93 |
5 | 1069.60 |
3430.22 |
.
() , , () .
() (3.5):
, |
(3.5) |
- ( 3.5), .; - .% ( 20-30% );. |
, :
.
. Web- "R@Learning Institute" , PHP 4 MySQL. web- Apache.
PHP . . web- , PHP. , . , mSQL, MySQL, Oracle, InterBase, PostgreSQL, dBase, API, .
, , , . UNIX, Microsoft Windows 98/XP.
web- Macromedia Dreamweaver MX 2004. Microsoft Windows XP.
, , web-, web- . web-, PHP-, Internet Explorer 5 . Microsoft Windows XP Home Edition Microsoft Windows XP Professional Edition, Internet Explorer 6. Windows 98/NT/2000, UNIX . , Windows XP.
, :
(Windows XP);
(Macromedia Dreamweaver MX 2004);
(Apache, PHP 4, MySQL);
;
.
"" , . ( , ).
Windows XP Home Edition Pentium IV/Celeron, 256 , 3 .
Macromedia Dreamweaver MX 2004 , Windows XP. , , .
, . ( , , , ).
web-:
Intel Celeron 2,8GHz (128k, 400MHz) Box: 2750 .;
- S478 GIGABYTE 8LD533-P i845GL (mATX, 2DDR, SB, SVGA, LAN, U2.0): 1612 .;
- DIMM 256Mb DDR SDRAM M. Tec (PC3200, 400MHz, CL2.5): 646 .;
- 40Gb IDE MAXTOR 6E040L0 7200rpm U-ATA 133: 1509 .;
FDD 3,5 - MITSUMI: 182 .;
CD-ROM - ASUS CD-S520 QuieTrack 52x: 466 .;
- 17 SAMSUNG 793DF 0,20 (1280x1024@65 ) MPRII TCO03: 4206 .;
- Miditower BX-77S ATX2.03, 300w: 1081 .;
- MITSUMI Classic PS/2: 267 .;
- LOGITECH M-SBF90 . PS/2: 227 .;
- SVEN Optima (3,1) 5 : 152 .;
- Windows XP Home Edition: 2122 .;
web- - Macromedia Dreamweaver MX 2004 Studio: 4200 .
:
Intel Celeron 1,8GHz (128k, 400MHz) Box: 1797 .;
- S478 GIGABYTE 8LD533-P i845GL (mATX, 2DDR, SB, SVGA, LAN, U2.0): 1612 .;
- DIMM 256Mb DDR SDRAM M. Tec (PC3200, 400MHz, CL2.5): 646 .;
- 40Gb IDE MAXTOR 6E040L0 7200rpm U-ATA 133: 1509 .;
FDD 3,5 - MITSUMI: 182 .;
CD-ROM - ASUS CD-S520 QuieTrack 52x: 466 .;
- 17 SAMSUNG 793DF 0,20 (1280x1024@65 ) MPRII TCO03: 4206 .;
- Miditower BX-77S ATX2.03, 300w: 1081 .;
- MITSUMI Classic PS/2: 267 .;
- LOGITECH M-SBF90 . PS/2: 227 .;
- SVEN Optima (3,1) 5 : 152 .;
- Windows XP Home Edition: 2122 .
5 2005 "Realm" . .
web- - Agava. ru. web-, , ..750 . .
: 34437 .
, : 34437 .
web- R@Learning Institute , - . , , , , web- . , PHP MySQL Agava. ru 9$ , .
:
;
;
.
:
;
;
;
;
.
, .. .., - . - .
, . .
, - - .
. , .
Internet, , , .
: , , CD-ROM, , , .
, . , ( ). , - - , , , , , . .
, . web- , .
web- R@Learning Institute :
, ;
;
;
. . ;
;
web-. - ;
, , , ;
, ;
;
;
. web-;
;
;
.
, , .
, , , .
209 , .
, , , , , , , , . : - , (), (+). , . , (, ) , . , , . - . .
12.1 044-89 - , - , , .
, :
.
, . - . , ;
.
, , 220. , , , - -:
;
;
;
;
, :
:
;
;
, , , ;
;
;
:
, , , ;
;
:
. , , , , , .
. 209 - , .
( ) - , - .
105-03 -3, [19].
-21.01-97 II- .
(I ) , , .
, 2.2.4 548-96 " " [20] 1, , 209, .. 120 / ( 139 ), , 4.1:
4.1 - ,
, | , | ,% | , / | |||
(t < t) | (t > t) | (t < t) | (t > t) | |||
20-21,9 | 24,1-25 | 19,0-26,0 | 15-75 | 0,1 | 0,1 | |
21,0-22,9 | 25,1-28,0 | 20,0-29,0 | 15-75 | 0,1 | 0,2 |
, .
( ), ( ).
2.2.2 - 2.4 1340-03 [21] - .
. : (), , , , . .
. . . , , . .
. . .
. .
(, ), , .
, . - . , , .
:
1. 300-500 .
2. , .
, . .
, .
. .
( ) 2,0 , - 1,2 .
, , 1,5-2,0 .
600-700 , 500 - .
. :
, ;
( ), 220, 50;
;
( ..), - , ;
(, ..);
;
, ;
, ;
.
105-03 [19] :
;
- , , .
, .. : , , , , . , , , , . , . , , - , , -5, , , .
. :
- , . , , ;
. .
.
30.12.98 . 2775.
" -" . . - , , , -6, -7 .
: ( ).
, , , .
, , , . ( - , , ..).
( . . ) ( ), .
:
;
;
;
;
.
. , . , :
;
, ;
, .
, 4.2
4.2 - ,
q , -2 | ||
1 | 2200 | |
2 | 1401 - 2200 | 2 |
3 | 181 - 1400 | 2 |
4 | 1 - 180 | 10 2. 1. |
1 - 4 , , 4.2
2 3 Q Q ≥ 0,64∙qT∙H2, 1 2 .
, () , , , Q, , (4.1)
, |
(4.1) |
Gi - i- , ; - i- , ∙-1. |
q (∙-2) (4.2):
q = , |
(4.2) |
S - , 2 ( 10 2). |
, 4.3
4.3 - ,
, / | |
() | 13,800 |
20,292 | |
13,400 | |
39,000 | |
27,670 |
- 340 , - 100 , - 80 , - 15 , - 3 .
209: 6,45 x 7,77 .
Q = 340*13,800+100*2,292+80*13,400+15*39,000+3*27,670 = 6661,21 .
:
/2.
4. -5.
, , , .
- , , , . (4.3):
, |
(4.3) |
- , 2.2.2/2.4 1340-03 [21] = 300 .
- 65 ,
F = 4600 [ 6825-91].
:
, z = 1,1;
m =2
, k = 1,4;
, , ( - i) , , , , , .. - u.
, |
(4.4) |
S = 6,45*7,77 = 50,12 2 - ; h = 2,2 - , .. ; A = 7,77 , B = 6,45 - . |
u = 0,52.
:
.
209 5 , : 2 65 4600 . 4.1
4.1 - 209.
- , . web- "R@Learning Institute". PHP 4.
. MySQL web-. , .
- web- Apache, PHP 4 MySQL.
, , .
, "R@Learning Institute".
"R@Learning Institute", .
:
1. , , web-, ;
2. ;
3. - ;
4. ;
5. ;
6. ;
7. , , , web-;
8. web-, ;
9. web-;
10. ;
11. ;
12. ;
13. ;
14. Web- ( );
15. ( ~200 ).
"". 7 , 7 . ( , , ). , .
, , , , .
, . , , .
, , , , ( ), web-, web-.
, , , . .
" " , , 209 - .
1. .. . - .: -, 2003.
2. ( ) , .
3. http: // db. informika. ru/do/npb/index. asp
4. web- "eLearning Server 3000".
5. http: // www. elearn. ru
6. web- "Lotus LearningSpace".
7. http: // www. commed. ru
8. web- "".
9. http: // www. baty. ru
10. web- "SunRav TestOfficePro".
11. http: // www. sunrav. ru
12. .. . - .: -, 2003. - 560 .
13. .. . - .: , 2002. - 238 .
14. .. / . , , . . . - . - : , 2002.
15. ., . PHP . . . - .: -, 2001. - 912 .
16. .. PHP 5. 2-. - .: , 2005. - 576 .
17. Web- java-
18. www. freejavascripts. narod. ru
19. web- web- Apache.
20. http: // www. apache. org
21. web- web- PHP.
22. http: // www. php. net
23. web- MySQL.
24. http: // www. mysql. com
25. , . . 2-. . . - .: -, 2001. - 608 .
26. . JavaScript: Web-. . . - .: , 2001. - 288 .
27. .. - , . - , 2002.
28. 105-03. .
29. 2.2.4 548-96. .
30. 2.2.2 - 2.4 1340-03. - .
.1 "courses_registration. php"
<html>
<head>
<title> Remote Learning Institute | Courses Registration</title>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
</head>
<body>
<? include "header. php"? >
<table width="835" border="0" cellpadding="3" cellspacing="0">
<! - -DWLayoutTable-->
<tr>
<td width="160" height="503" valign="top" bgcolor="#8AD9FF">
<? include "body_left. php";? >
</td>
<td width="659" valign="top" bgcolor="#F9FDFF" class=bd>
<? include "courses_registration_right. php";? >
</td>
</tr>
</table>
<? include "buttom. php"? >
</body>
</html>
.2 "header. php"
<table width="835" border="0" cellpadding="2" cellspacing="0" bgcolor="#0094DE">
<! - -DWLayoutTable-->
<tr>
<td width="280" rowspan="2" valign="top"><img src="images/logo. gif" width="280" height="108"></td>
<td width="520" height="88" valign="top"><div align="center"><img src="images/logo_text. gif" width="265" height="73"></div></td>
<td width="35" valign="top"><div align="right"><img src="images/table_corner_news. gif" width="15" height="15"></div></td>
</tr>
<tr>
<td height="20" colspan="2" valign="top">
<? include "menu. php"? >
</td>
</tr>
</table>
.3 "body_left. php"
<?
echo "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">";
echo "<tr> <td bgcolor=\"#8AD9FF\">";
//echo "$user_name $user_pswd";
if ($login_reg=="yes") {
include "user_form. php";
}
else {
include "login_form. php";
}
$FindScript="find. php";
echo "<hr color=\"#0094DE\" size=\"1\" style=\"border-style: dotted\"></hr>";
echo "<form name=\"form_find\" action=\"$FindScript\" metod=\"get\" style=\"margin: 0px\">";
echo "<input type=\"text\" name=\"find\" class=\"textblockBlue\" style=\"height: 18; width: 110\">|";
echo "<input type=\"submit\" name=\"login\" style=\"height: 18; width: 43\" class=\"buttonBlue\" value=\"\">";
echo "</form>";
echo "<hr color=\"#0094DE\" size=\"1\" style=\"border-style: dotted\"></hr>";
include "news_list_header. php";
echo "";
include "news_list_after_header. php";
echo "25.04.05 C , ";
include "news_list_footer. php";
echo "</td> </tr> </table>";
? >
.4 "courses_registration_right. php"
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="100%" valign="top" bgcolor="#F9FDFF">
<span class="textheader"> </span>
</td>
</tr>
<tr>
<td>
<?
$maxReg=3;
include "body_list_header. php";
echo " ";
include "body_list_after_header. php";
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$strSQL="SELECT * FROM user_courses WHERE login='". $user_name_. "' AND status='reg'";
$res=mysql_query($strSQL);
$cRow=mysql_num_rows($res);
echo " : ". $cRow. "<br>";
$strSQL="SELECT * FROM user_courses WHERE (login='". $user_name_. "' AND n_course='". $id_course. "')";
$resUserCourses=mysql_query($strSQL);
if (! mysql_fetch_row($resUserCourses)) {
if ($cRow<=($maxReg-1)) {
echo " ? ";
echo "<hr color=\"#0094DE\" size=\"1\" style=\"border-style: dotted\"></hr>";
echo "<a class=\"light\" href=\"courses_for_students. php\"></a>";
echo " | <a class=\"light\" href=\"training. php? id_course=". $id_course. "&course_reg=y\"></a>";
}
else {
echo " ( ) ( ". $maxReg. ")";
echo "<hr color=\"#0094DE\" size=\"1\" style=\"border-style: dotted\"></hr>";
echo "<a class=\"light\" href=\"courses_for_students. php\"></a>";
}
}
else {
echo " ";
echo "<hr color=\"#0094DE\" size=\"1\" style=\"border-style: dotted\"></hr>";
echo "<a class=\"light\" href=\"courses_for_students. php\"></a>";
}
include "body_list_footer. php";
? >
</td>
</tr>
</table>
.5 "buttom. php"
<table width="835" border="0" cellpadding="2" cellspacing="0" bgcolor="#77D2FF">
<! - -DWLayoutTable-->
<tr>
<td width="161" height="20" valign="top" bgcolor="#0094DE"><div align="left"><img src="images/table_corner_l_b. gif" width="15" height="15"></div>
</td>
<td width="26" valign="top"><! - -DWLayoutEmptyCell--> </td>
<td width="614" align="right" valign="top"><div align="right"><span class="textonlightblue"> <a class="notunder"
href=mailto: andrewnik@mail. ru>< A&D-STYLE> </a></span></div></td>
<td width="16" valign="top"><div align="right"><span class="textonblue"></span></div></td>
</tr>
</table>
<? include "menu_adm. php"? >
.6 "menu. php"
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
<meta http-equiv=Content-Language content=ru>
<script type="text/javascript" src="popup_me. js"></script>
<link href="rli_style. css" rel="stylesheet" type="text/css">
</head>
<body>
<div><script type="text/javascript" src="menu_rli. js"></script></div>
<table cellspacing=0 cellpadding=0 border=0 id=menu_table>
<tr valign=top>
<td width="20"><a href=index. php title=" "><img src="images/home. gif" width="16" height="16" border="0"></a></td>
<td class=brbt><a class=m onclick="subnews. className='menuclick'; this. blur(); " href=news. php><img src="images/l_corner. gif" width="8" height="8"
border="0"> </a>
<div class=menuc id=subnews><img width=1 height=2></div></td>
<td class=brbt><a class=m onclick="subcourses. className='menuclick'; popcourses. style. visibility='hidden'; this. blur(); " onmouseover="popup(event, this,
'popcourses'); " onmouseout="popdown_1(event, this, 'popcourses'); " id=menuleft href=courses. php><img src="images/l_corner. gif" width="8" height="8"
border="0"> </a>
<div class=menuc id=subcourses><img width=1 height=2></div></td>
<td class=brbt><a class=m onclick="subtraining. className='menuclick'; poptraining. style. visibility='hidden'; this. blur(); " onmouseover="popup(event,
this, 'poptraining'); " onmouseout="popdown_1(event, this, 'poptraining'); " href=courses_organization. php><img src="images/l_corner. gif" width="8"
height="8" border="0"> <b></b></a>
<div class=menuc id=subtraining><img width=1 height=2></div></td>
<td class=brbt><a class=m onclick="subcontacts. className='menuclick'; popdate. style. visibility='hidden'; this. blur(); " onmouseover="popup(event, this,
'popcontacts'); " onmouseout="popdown_1(event, this, 'popcontacts'); " href=contacts. php><img src="images/l_corner. gif" width="8" height="8" border="0">
</a><div class=menuc id=subcontacts><img width=1 height=2></div>
<td class=brbt><a class=m onclick="subabout. className='menuclick'; popabout. style. visibility='hidden'; this. blur(); " onmouseover="popup(event, this,
'popabout'); " onmouseout="popdown_1(event, this, 'popabout'); " href=about_info. php><img src="images/l_corner. gif" width="8" height="8" border="0">
</a>
<div class=menuc id=subabout><img width=1 height=2></div></td>
<td class=brbt><a class=m onclick="subdown. className='menuclick'; this. blur(); " href=download. php><img src="images/l_corner. gif" width="8" height="8"
border="0"> download</a>
<div class=menuc id=subdown><img width=1 height=2></div></td>
<td class=brbt><a class=m onclick="substudent. className='menuclick'; popstudent. style. visibility='hidden'; this. blur(); " onmouseover="popup(event, this,
'popstudent'); " onmouseout="popdown_1(event, this, 'popstudent'); " href=student. php><img src="images/l_corner. gif" width="8" height="8" border="0">
</a>
<div class=menuc id=substudent><img width=1 height=2></div></td>
</tr></table>
</body>
</html>
.1 "training_check_registration_right. php"
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="100%" valign="top" bgcolor="#F9FDFF">
<span class="textheader"> </span>
</td>
</tr>
<tr>
<td>
<?
$submit = 1; //
$dataComplite= 1; //
$err_note="2"; //
$qs=""; //
global $qs,$r_lastname,$r_firstname,$r_middlename,$r_login,$r_pass,$r_pass_c,$r_student_code,$r_sex,$r_n_group,$r_email;
function check_email($str) {
// 1
if (ereg ("^. +@. +\\. +$",$str)) {
return 1;
}
else {
return 0;
}
}
function check_form() {
global $qs,$err_note,$submit, $dataComplite,$r_lastname,$r_middlename,$r_firstname,$r_login,$r_pass,$r_pass_c,$r_student_code,$r_sex,$r_n_group,$r_email;
if ($dataComplite== 1) {
if(! $r_lastname) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_firstname) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_middlename) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_login) {
$err_note = " login";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if($r_pass<>$r_pass_c) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_pass) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_pass_c) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_student_code) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_n_group) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
if(! $r_email) {
$err_note = " ";
$dataComplite= 0;
}
else {
if (check_email($r_email) ==0) {
$err_note = " ";
$dataComplite= 0;
}
}
}
if ($dataComplite== 1) {
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$sqlstr = "SELECT login FROM users WHERE login='". $r_login. "'; ";
$res=mysql_query($sqlstr);
if (mysql_fetch_row($res)) {
$err_note = " login";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$sqlstr = "SELECT student_code FROM users WHERE student_code='". $r_student_code. "'; ";
$res=mysql_query($sqlstr);
if (mysql_fetch_row($res)) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$sqlstr = "SELECT student_code FROM correct_codes WHERE student_code='". $r_student_code. "'; ";
$res=mysql_query($sqlstr);
if (! (mysql_fetch_row($res))) {
$err_note = " ";
$dataComplite= 0;
}
}
if ($dataComplite== 1) {
$qs = "? r_lastname=". urlencode($r_lastname).
"&r_firstname=". urlencode($r_firstname).
"&r_middlename=". urlencode($r_middlename).
"&r_login=". urlencode($r_login).
"&r_pass=". urlencode($r_pass).
"&r_student_code=". urlencode($r_student_code).
"&r_n_group=". urlencode($r_n_group).
"&r_email=". urlencode($r_email).
"&r_sex=". urlencode($r_sex).
"&r_registration_date=". urlencode(date("Y/m/d")).
"&user_login=0";
return 1;
}
}
include "body_list_header. php";
echo " | ";
include "body_list_after_header. php";
$LoginScript = "training. php";
echo "<form name=\"form_reg\" style=\"margin: 0px\">";
echo "<span class=\"textonlightblue\"><b>: </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_lastname</b></span><br>";
echo "<span class=\"textonlightblue\"><b>: </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_firstname</b></span><br>";
echo "<span class=\"textonlightblue\"><b>: </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_middlename</b></span><br>";
echo "<span class=\"textonlightblue\"><b>login: </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_login</b></span><br>";
echo "<span class=\"textonlightblue\"><b>: </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_pass</b></span><br>";
echo "<span class=\"textonlightblue\"><b> : </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_student_code</b></span><br>";
echo "<span class=\"textonlightblue\"><b> : </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_n_group</b></span><br>";
echo "<span class=\"textonlightblue\"><b>: </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_sex</b></span><br>";
echo "<span class=\"textonlightblue\"><b>: </b></span><br>";
echo "<span class=\"textonOrrange\"><b>$r_email</b></span><br>";
echo "</form>";
if (check_form() ==0) {
echo "<form name=\"form_err\" style=\"margin: 0px\">";
include "body_list_footer. php";
include "body_list_header. php";
echo " ";
include "body_list_after_header. php";
echo "<span class=\"textrederror\"> $err_note </span>";
echo "<hr class=hr_onlightblue_orange></hr>";
echo "<input type=\"button\" name=\"back\" style=\"height: 18\" class=\"buttonOrange\" value=\"\" onClick=\"self. history. back(); \">";
include "body_list_footer. php";
}
else {
$surl= "training. php". $qs;
echo "<form method=post action=\"$surl \" name=\"form_but\" style=\"margin: 0px\">";
echo "<hr class=hr_onlightblue_orange></hr>";
echo "<input type=\"button\" name=\"back\" style=\"height: 18\" class=\"buttonOrange\" value=\"\" onClick=\"self. history. back(); \">|";
echo "<input type=\"submit\" style=\"height: 18\" class=\"buttonOrange\" value=\"\">";
include "body_list_footer. php";
}
echo "</form>";
? >
</td>
<div id="error_input"
style="position: absolute;
width: 220px;
top: 45%;
left: 45%;
background: #8AD9FF;
font-size: 11px;
border: 1px solid #0094DE;
padding: 1px;
z-index: 1">
<form name="form_err" style="margin: 0px">
<span class="textonLightBlue"><b> : </b></span><br>
<div style="background: white; padding: 2px">
<span class="textrederror">$err_note</span><br>
<input type="button" align="middle" style="height: 18" class="buttonBlue" value="" onClick="hiddeLayer()">
</form> </div>
</div>
</tr>
</table>
.2 " training_test_right. php"
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td width="100%" valign="top" bgcolor="#F9FDFF">
<span class="textheader"> </span>
</td>
</tr>
<tr>
<td>
<?
include "body_list_header. php";
$TestScript="training_test. php";
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
if ($q_count>1 && $q_count<7) {
//
if ($q_count==6) {
echo " ";
}
else {
echo " ". $q_count;
}
include "body_list_after_header. php";
$str_answer ="SELECT * FROM answers WHERE n_question='";
if ($q_count==2) {
$str_answer = $str_answer. $q_1. "' AND id_answer='";
}
elseif ($q_count==3) {
$str_answer = $str_answer. $q_2. "' AND id_answer='";
}
elseif ($q_count==4) {
$str_answer = $str_answer. $q_3. "' AND id_answer='";
}
elseif ($q_count==5) {
$str_answer = $str_answer. $q_4. "' AND id_answer='";
}
else {
$str_answer = $str_answer. $q_5. "' AND id_answer='";
}
// 1
$str_answer_full = $str_answer. $id_a_1. "'";
$res_answer = mysql_query($str_answer_full);
$row_answer = mysql_fetch_row($res_answer);
if ($row_answer [3] =='y') {
if (isset($a_1)) {
$r_count_1=1;
}
else {
$r_count_1=0;
}
}
else {
if (! (isset($a_1))) {
$r_count_1=1;
}
else {
$r_count_1=0;
}
}
// 2
$str_answer_full = $str_answer. $id_a_2. "'";
$res_answer = mysql_query($str_answer_full);
$row_answer = mysql_fetch_row($res_answer);
if ($row_answer [3] =='y') {
if (isset($a_2)) {
$r_count_2=1;
}
else {
$r_count_2=0;
}
}
else {
if (! (isset($a_2))) {
$r_count_2=1;
}
else {
$r_count_2=0;
}
}
// 3
$str_answer_full = $str_answer. $id_a_3. "'";
$res_answer = mysql_query($str_answer_full);
$row_answer = mysql_fetch_row($res_answer);
if ($row_answer [3] =='y') {
if (isset($a_3)) {
$r_count_3=1;
}
else {
$r_count_3=0;
}
}
else {
if (! (isset($a_3))) {
$r_count_3=1;
}
else {
$r_count_3=0;
}
}
// 4
$str_answer_full = $str_answer. $id_a_4. "'";
$res_answer = mysql_query($str_answer_full);
$row_answer = mysql_fetch_row($res_answer);
if ($row_answer [3] =='y') {
if (isset($a_4)) {
$r_count_4=1;
}
else {
$r_count_4=0;
}
}
else {
if (! (isset($a_4))) {
$r_count_4=1;
}
else {
$r_count_4=0;
}
}
// 5
$str_answer_full = $str_answer. $id_a_5. "'";
$res_answer = mysql_query($str_answer_full);
$row_answer = mysql_fetch_row($res_answer);
if ($row_answer [3] =='y') {
if (isset($a_5)) {
$r_count_5=1;
}
else {
$r_count_5=0;
}
}
else {
if (! (isset($a_5))) {
$r_count_5=1;
}
else {
$r_count_5=0;
}
}
//
$r_count_1=$r_count_1*$r_count_2*$r_count_3*$r_count_4*$r_count_5;
if ($r_count_1==1) {
echo " <br>";
$r_count++;
}
else {
echo " <br>";
}
echo "<hr color=\"#FFDFBF\" size=\"1\" style=\"border-style: dotted\"></hr>";
$r_percent = $r_count/5*100;
if ($q_count==6) {
echo " ". $r_count. " 5 . <br> ". $r_percent. "%. <br><br>";
$res_user_tests=mysql_query("SELECT * FROM user_tests WHERE n_user_course='". $id_course. "' AND n_course_part='". $id_part. "'");
$row_user_tests = mysql_fetch_row($res_user_tests);
if ($row_user_tests [4] >$r_percent) {
$r_percent=$row_user_tests [4] ;
}
$user_tests_SQL = "UPDATE user_tests SET percent='". $r_percent. "', last_test_date='". date("Y/m/d"). "' WHERE n_user_course='". $id_course. "' AND n_course_part='". $id_part. "'";
mysql_query($user_tests_SQL);
if ($r_percent>=70) {
echo " <br>";
$res_user_courses2=mysql_query("SELECT * FROM user_courses WHERE id_user_course='". $id_course. "'");
$row_user_courses2=mysql_fetch_row($res_user_courses2);
$res_course_parts2=mysql_query("SELECT * FROM course_parts WHERE n_course='". $row_user_courses2 [2]. "'");
$res_user_tests2=mysql_query("SELECT * FROM user_tests WHERE n_user_course='". $id_course. "'");
if (mysql_num_rows($res_course_parts2) == mysql_num_rows($res_user_tests2)) {
//$res_user_courses3=mysql_query("SELECT * FROM user_courses WHERE id_user_course='". $id_course. "'");
//$row_user_courses3 = mysql_fetch_row($res_user_tests3);
$user_courses_SQL = "UPDATE user_courses SET status='end', end_date='". date("Y/m/d"). "' WHERE id_user_course='". $id_course. "'";
mysql_query($user_courses_SQL);
};
}
else {
echo " ";
$res_user_tests = mysql_query("SELECT * FROM user_tests WHERE n_user_course='". $id_course. "' AND n_course_part='". $id_part. "'");
$row_user_tests = mysql_fetch_row($res_user_tests);
if ($row_user_tests [3] >2) {
//$res_user_courses=mysql_query("SELECT * FROM user_courses WHERE id_user_course='". $id_course. "'");
//$row_user_courses = mysql_fetch_row($res_user_courses);
$user_courses_SQL = "UPDATE user_courses SET status='not', end_date='". date("Y/m/d"). "' WHERE id_user_course='". $id_course. "'";
mysql_query($user_courses_SQL);
}
}
echo "<hr color=\"#FFDFBF\" size=\"1\" style=\"border-style: dotted\"></hr>";
echo "<a class=\"light\" href=\"training. php\"> <a>";
}
}
if ($q_count>0 && $q_count<6) {
// -
if ($q_count==1) {
$res_user_tests=mysql_query("SELECT * FROM user_tests WHERE n_user_course='". $id_course. "' AND n_course_part='". $id_part. "'");
if (mysql_num_rows($res_user_tests) ==0) {
$user_tests_SQL = "INSERT INTO user_tests values('0','". $id_course. "','". $id_part. "','1','0','". date("Y/m/d"). "')";
mysql_query($user_tests_SQL);
}
else {
$row_user_tests = mysql_fetch_row($res_user_tests);
$row_user_tests [3] ++;
if ($row_user_tests [3] <4) {
$user_tests_SQL = "UPDATE user_tests SET attemps='". $row_user_tests [3]. "', last_test_date='". date("Y/m/d"). "' WHERE n_user_course='". $id_course. "' AND n_course_part='". $id_part. "'";
mysql_query($user_tests_SQL);
}
}
echo " ". $q_count;
include "body_list_after_header. php";
}
$str_question ="SELECT * FROM questions WHERE id_question='";
if ($q_count==1) {
$res_question=mysql_query($str_question. $q_1. "'");
}
elseif ($q_count==2) {
$res_question=mysql_query($str_question. $q_2. "'");
}
elseif ($q_count==3) {
$res_question=mysql_query($str_question. $q_3. "'");
}
elseif ($q_count==4) {
$res_question=mysql_query($str_question. $q_4. "'");
}
else {
$res_question=mysql_query($str_question. $q_5. "'");
}
$row_question=mysql_fetch_row($res_question);
echo "<b>". $row_question [2]. "</b><br>";
echo "<form name=\"form_test\" action=\"$TestScript\" metod=\"get\" style=\"margin: 0px\">";
$strSQL="SELECT * FROM answers WHERE n_question='". $row_question [0]. "'";
$res_answer=mysql_query($strSQL);
//$answer_count=1;
//echo "<form>";
//
//while ($row_answer=mysql_fetch_row($res_answer)) {
//echo "<input name=\"a_". $answer_count. "\" type=\"checkbox\">". $row_answer [2] ;
//echo "<input name=\"id_a_". $answer_count. "\" type=\"hidden\" value=". $row_answer [0]. "><br>";
//$answer_count++;
//}
$mas_count=0;
while ($mas_temp=mysql_fetch_row($res_answer)) {
$mas_answer [$mas_count] [0] =$mas_temp [0] ;
$mas_answer [$mas_count] [1] =0;
$mas_count++;
}
$mas_count--;
for ($i=1; $i<=5; $i++) {
mt_srand(time());
while (true) {
$mas_index=mt_rand(0,$mas_count);
if ($mas_answer [$mas_index] [1] ==0) {
$mas_answer [$mas_index] [1] =1;
break;
}
}
$strSQL="SELECT * FROM answers WHERE id_answer='". $mas_answer [$mas_index] [0]. "'";
$res_answer=mysql_query($strSQL);
$row_answer=mysql_fetch_row($res_answer);
echo "<input name=\"a_". $i. "\" type=\"checkbox\">". $row_answer [2] ;
echo "<input name=\"id_a_". $i. "\" type=\"hidden\" value=". $row_answer [0]. "><br>";
}
echo "<input name=\"id_course\" type=\"hidden\" value=". $id_course. ">";
echo "<input name=\"id_part\" type=\"hidden\" value=". $id_part. ">";
echo "<input name=\"q_1\" type=\"hidden\" value=". $q_1. ">";
echo "<input name=\"q_2\" type=\"hidden\" value=". $q_2. ">";
echo "<input name=\"q_3\" type=\"hidden\" value=". $q_3. ">";
echo "<input name=\"q_4\" type=\"hidden\" value=". $q_4. ">";
echo "<input name=\"q_5\" type=\"hidden\" value=". $q_5. ">";
echo "<input name=\"q_count\" type=\"hidden\" value=". ++$q_count. ">";
echo "<input name=\"r_count\" type=\"hidden\" value=". $r_count. ">";
echo "<hr color=\"#FFDFBF\" size=\"1\" style=\"border-style: dotted\"></hr>";
echo "<input type=\"submit\" name=\"test_ok\" style=\"height: 18; width: 41\" class=\"buttonOrange\" value=\"\">";
echo "</form>";
}
include "body_list_footer. php";
? >
</td>
</tr>
</table>
.1 "admin_edit. php"
<html>
<head>
<title> Remote Learning Institute | Administration</title>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
</head>
<body>
<?
include "header. php";
$ScriptAdmAdd="admin_add. php";
$ScriptAdmDel="admin_del. php";
$ScriptAdmMdf="admin_update. php";
global $SelectT;
echo "<table width=\"835\" border=\"0\" cellpadding=\"3\" background=\"#FAF1D8\" cellspacing=\"0\" >";
echo "<tr><td>";
include "body_list_header. php";
echo " : ";
include "body_list_after_header. php";
echo "<table splitcell=3><tr>";
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$ListF=mysql_list_fields($DB,$SelectT);
$CounterF=0;
while ($CounterF < mysql_num_fields($ListF)) {
$stItem=mysql_field_name($ListF,$CounterF);
$CounterF++;
$massField [$CounterF] =$stItem;
echo "<td bgcolor=#ffcc00 class=\"textblockBlue\">$massField [$CounterF] </td>";
}
echo "<td bgcolor=#ffcc00 class=\"textblockBlue\"></td>";
echo "</tr><tr>";
$strSQL ="SELECT * FROM ". $SelectT. "; ";
$res=mysql_query($strSQL);
while ($Row=mysql_fetch_row($res)) {
for ($CounterF=0; $CounterF< mysql_num_fields($ListF); $CounterF++) {
echo "<td class=\"textblockBlue\">$Row [$CounterF] </td>";
}
echo "<td class=\"table_admin\" align=\"center\">";
echo "<a href=\"$ScriptAdmMdf". "? t_name=". urlencode($SelectT). "&t_index=". urlencode($Row [0]). "\"><a>|";
echo "<a href=\"$ScriptAdmDel". "? t_name=". urlencode($SelectT). "&t_index=". urlencode($Row [0]). "\"><a>";
echo "</td></tr><tr>";
}
$ScriptAdmAdd=$ScriptAdmAdd. "? t_name=". urlencode($SelectT);
mysql_free_result($ListF);
echo "</tr></table>";
echo "<tr><td colspan=2><table>";
echo "<form name=\"FormName\" method=\"post\" margin=\"0\" action=$ScriptAdmAdd>";
echo "<input type=\"submit\" name=\"select\" style=\"height: 18\" class=\"buttonOrange\" value=\"\">|";
echo "<a class=\"light\" href=admin. php></a>";
echo "</form>";
include "body_list_footer. php";
echo "</table></td></tr></table>";
include "buttom. php";
? >
</body>
</html>
.2 "admin_add. php"
<html>
<head>
<title> Remote Learning Institute | Administration</title>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
</head>
<body>
<? include "header. php"? >
<?
$ScriptAdm = "admin_add_check. php";
global $t_name,$t_index;
echo "<table width=\"835\" border=\"0\" cellpadding=\"3\" background=\"#FAF1D8\" cellspacing=\"0\" >";
echo "<tr><td>";
include "body_list_header. php";
echo " : ";
include "body_list_after_header. php";
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$t_name= urldecode($t_name);
$ListF=mysql_list_fields($DB,$t_name);
$CounterF=0;
echo "<form name=\"FormName\" method=\"get\" margin=\"0\" action=\"$ScriptAdm\">";
while ($CounterF < mysql_num_fields($ListF)) {
$stItem=mysql_field_name($ListF,$CounterF);
$CounterF++;
$massField [$CounterF] =$stItem;
echo "<span class=\"textonlightblue\"><b>$massField [$CounterF] </b></span><br>";
echo "<input type=\"text\" name=\"". $massField [$CounterF]. "\" class=\"textblockBlue\"><br>";
}
echo "<input type=\"hidden\" name=\"t_name\" value=\"". $t_name. "\"class=\"textblockBlue\"><br>";
echo "<input type=\"button\" name=\"back\" style=\"height: 18\" class=\"buttonOrange\" value=\"\" onClick=\"self. history. back(); \">|";
echo "<input type=\"submit\" name=\"select\" style=\"height: 18\" class=\"buttonOrange\" value=\"\">";
echo "</form>";
include "body_list_footer. php";
echo "</td></tr></table>";
include "buttom. php"? >
</body>
</html>
.3 "admin_del. php"
<html>
<head>
<title> Remote Learning Institute | Administration</title>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
</head>
<body>
<? include "header. php";
$ScriptAdm ="admin_edit. php";
global $t_name,$t_index;
echo "<table width=\"835\" border=\"0\" cellpadding=\"3\" background=\"#FAF1D8\" cellspacing=\"0\" >";
echo "<tr><td>";
include "body_list_header. php";
echo " : ";
include "body_list_after_header. php";
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$ListF=mysql_list_fields($DB,$t_name);
$CounterF=0;
$ScriptAdm = $ScriptAdm. "? SelectT=". urlencode($t_name);
while ($CounterF < mysql_num_fields($ListF)) {
$stItem=mysql_field_name($ListF,$CounterF);
$massField [$CounterF] =$stItem;
$CounterF++;
}
$strSQL="DELETE FROM ". $t_name. " WHERE ". $massField [0]. "='". $t_index. "'";
mysql_query($strSQL);
echo "<form name=\"FormName\" method=\"post\" margin=\"0\" action=$ScriptAdm>";
echo "<span class=\"textonlightblue\"><b> </b></span><br>";
echo "<input type=\"submit\" name=\"select\" style=\"height: 18\" class=\"buttonOrange\" value=\"\">";
echo "</form>";
include "body_list_footer. php";
echo "</td></tr></table>";
include "buttom. php";
? >
</body>
</html>
.4 "admin_update. php"
<html>
<head>
<title> Remote Learning Institute | Administration</title>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
</head>
<body>
<? include "header. php"? >
<?
$ScriptAdm = "admin_update_check. php";
global $t_name,$t_index;
echo "<table width=\"835\" border=\"0\" cellpadding=\"3\" background=\"#FAF1D8\" cellspacing=\"0\" >";
echo "<tr><td>";
include "body_list_header. php";
echo " : ";
include "body_list_after_header. php";
require "option. php";
mysql_connect($SERVER,$USER,$PASSWD) or die(mysql_error());
mysql_select_db($DB);
$t_name= urldecode($t_name);
$ListF=mysql_list_fields($DB,$t_name);
$CounterF=0;
echo "<form name=\"FormName\" method=\"get\" margin=\"0\" action=\"$ScriptAdm\">";
$stItem=mysql_field_name($ListF,$CounterF);
$sqlstr = "SELECT * FROM ". $t_name. " WHERE ". $stItem. "='". $t_index. "'; ";
$res=mysql_query($sqlstr);
$Row=mysql_fetch_row($res);
echo "<input type=\"hidden\" name=\"id_tab\" value=\"". $Row [0]. "\">";
while ($CounterF < mysql_num_fields($ListF)) {
$stItem=mysql_field_name($ListF,$CounterF);
$CounterF++;
$massField [$CounterF] =$stItem;
echo "<span class=\"textonlightblue\"><b>$massField [$CounterF] </b></span><br>";
echo "<input type=\"text\" name=\"". $massField [$CounterF]. "\" class=\"textblockBlue\" value=\"". $Row [$CounterF-1]. "\"><br>";
}
echo "<input type=\"hidden\" name=\"t_name\" value=\"". $t_name. "\"class=\"textblockBlue\"><br>";
echo "<input type=\"button\" name=\"back\" style=\"height: 18\" class=\"buttonOrange\" value=\"\" onClick=\"self. history. back(); \">|";
echo "<input type=\"submit\" name=\"select\" style=\"height: 18\" class=\"buttonOrange\" value=\"\">";
echo "</form>";
include "body_list_footer. php";
echo "</td></tr></table>";
include "buttom. php"? >
</body>
</html>
- ... () " "
Copyright (c) 2024 Stud-Baza.ru , , , .