. , , ,

,,,

- — ,

-

...

()

" "

:

-

. : ..

: ..

/: ..

: ..

:

-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.

1.1

- , , , , , - , .

() , , , , [1].

, , , , , .

, , .

, , , . , , I , , , .

, - , , . - , - . - - , , , , . - , , . - - , , c, , , , , .

, :

- , , , -, . , .

- , , ( , , ..). - - , , , - - , . , .

- . . - - , . , , , . . , , e-mail, , , , (, , ). , , .

on-line . , - , . , . , , , , . .

. , . , , . , , , , . , , . , . - . , .

, . , - , , . , , , , , , . , , . , , .

 


1.2

, [1]. :

. , , . , .

. . ( ) , . , .

. , .. " ".

. ( ) .

. , .

. "". .

. .

. .

. .

( ). , , , , ..

. , .

. .

, , , , , .

 

1.3

( ) , [2]. , . , .

, , . , -, . .

() ( - ) , ( - ).

, - (), , .

: , - , , , , , - , , , , .

, ( ), . .


1.4

: -, TV- () [1]. .

 

1.4.1 -

, () , - - .

. . - - 100 . , , .

 

1.4.2 TV-

, - - . - , -, - , .

"". "" "", . TV-, , .

 

1.4.3 ()

, - , .

- , . - " " - , . . , , . "--" - : "" "" - .

. , - , . , - , . ( 700 ) - . , .

1.4.4

. , ( 1.1).

1.1 -

- ( , -, ), -

- ;

;

;

.

, , -

- ;

;

;

;

.

- ;

;

;

.

- ;

;

;

.

- ;

;

.

, . , . , . , -. - , , , , .

 

1.5

, . , - -.

1.5.1 "eLearning Server 3000"

"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- , , , , - .

 

1.5.2 "Lotus LearningSpace"

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.

 

1.5.3 ""

"" - , () [5].

"" :

(Test Designer) - ;

(Page Designer) - ;

(Project Designer);

(Analitic) - .

(Test Designer) - , , . ( ) .

, , :

, , ;

, , ;

;

, ;

;

;

(, , , ) .

, /. , . , , .

. . , , .. , . .

(Page Designer) - , , , .

(Project Designer) - , , (), (), , () ( ).

(Analitic) - .

 

1.5.4 "SunRav TestOfficePro"

, , . , (, , , ..) [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 ( , ..) , .

 

1.6

. . . .

 

1.6.1

- [7]. , , - . , , , , , .

. , , .

:

, - , - / .

, .

:

. , , , , . , , , , .

( ) ( ), . . , .

. : , . . -, , . , , , . , .

, . , , , , ( ), . ( ), .

, , .

, . , , .

- . ( ) ( ). , ( ).

. , , , - . , , .

1.6.2

, , , .. . web-, web- - [7].

, . , , . HTML- . . HTML- .

 


1.7

. , , . . , . , . , , CD, , . - -, - - ( ). , , , [8].

, . , . , . , , .


1.7.1

, , , .

1 , . (, ).

2 , . / , . . - -.

3 , , "" . . . , . , , , , . , .

4 . , .

5 , . "" . , , "" .

1.7.2

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-. , . , , , .

 

1.8 -

World Wide Web (WWW). WWW , . . WWW . . . , , , . , , , , , .

WWW :

;

;

;

- .

WWW , , . web-, PHP Java , , . .

 

1.9

. , , , , .

.

, , , .

, . : - , .

. , .

. , , ( ). , . , . , . . web-, . 1.1


1.1 -

, , - MySQL. , , "" .

, , , . , . . web- PHP - , .


1.10

, , ( ), , .

, web-. web- PHP 4. MySQL web- Apache. , , , . web- - ().

 

1.10.1

, , web-, ;

;

- . , . . - ;

. ;

() . ( ). "" , ;

. ;

, , ;

. . - , () . ;

, , , , web-. , ;

web- . HTML-. PHP;

, : web- Macromedia Dreamweaver MX 2004, web- Apache 2, web- PHP 4 MySQL 4.

 

1.10.2

- :

, ;

;

;

Web- ( ).

web- ;

();

web-;

" " , , , .

 

1.10.3 web-

, .

, web- . . , , , , .. . , , , . , , .

, 25% , . , .

, , . , , . , , , -. - . , , , , , . .

, . , ( GIF JPEG), , .

. - , . . ( ), . . . - . () 30-40 , .

, . , , . web-, - , , .

 

1.11

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.

 

1.11.1 PHP

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.

, , , - .

, , , - .

 

1.11.2 MySQL

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-, .

 

1.11.3 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-.


2.

 

2.1

- , , .

:

;

;

;

, - ;

, ;

.

. .

.

, : "", " ", " ", "", " ", " ", " ", " ", " " "". .

"" . : , , , , , , , , , , . , , , , .. . , - . .

" " . : , , , , , , . , , , .. . - .

" " . : , , , , , , . , , , .. . - .

"" . : , , , , , . , , , .. . - .

" " , . : , , , , . , , , .. . - , .

" " . : , , , , . , , , .. . - .

" " , . : . - .

" " . : , , . , , , .. . - .

" " . : , , , . , , , .. . - .

"" . : , , , , . , , , .. . - .

"" " " "--", "" " " - "--", " " " " - "--", " " " " - "--", " " " " - "--", " " "" - "--", " " " " - "--", " " " " - "--", " " " " - "--", " " " " - "--", "" .

 

2.2

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 email 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 -

 

2.3 -

, . , web- Apache 2.0.35, PHP 4.1.2, MySQL 4.0.21. Macromedia Dreamweaver MX 2004. . .


2.3.1 Web- Apache

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. , , , .

2.3.2 Apache

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.

2.3.3 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().

2.3.4 MySQL

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

2.4 Macromedia Dreamweaver MX 2004

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 -


2.5

( ) : , , , , , , . , 1-3 ( ) , .

, , , . , , , , . , , . ( ) , , .. (, ), , .

, , .

. . 5 , , 2.14.

2.14 -

, , . , .

"" . , "" . , . .

, " ". , 2-3 . , .. , , , .

(URL) ( ), , , , - , , . , , () , GIF- . , , . . , , .

, , ( , ). , . , .

4 , , 5- . ( ), , , . , , , . , .

, , . , " " . , . , , . , "" "", . , , .

, , .

 

2.6 web-

. . , , web-. . PHP, .

 

2.6.1

. , . 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 -

2.6.2 CSS

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

 

2.6.3

. :

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

2.6.4

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, , . , , ../ // .

.

 

2.6.5

. , , . - , , .

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, .

 

2.6.6 web-

web- :

Web-.

() ().

web-.

CGI- ( ) .

, CGI-, .

.

(web-) , .

, () () , , , Web-, , . -, .

CGI- () . Web- HTML-. Web- . .

Web-, URL- , QUERY_STRING CGI-, . CGI- QUERY_STRING, .

 

2.6.7

:

$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().

 


2.6.8

while() mysql_fetch_row, $result, . , $row . mysql_fetch_row, , , . mysql_fetch_row false, , , .

$row , , , $row [1], . 0, 1.

mysql_fetch_array() , , , $row ["user"] ("user" - ).

2.6.9 Cookies

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.6.10 web-

, . 2.21.

( ) . , . , . . , . , () . , , . - , .

2.21 - web-


- . . . , . . . . , . . . . .

 

2.7 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-

, ( ) ( ) .

, .

 

2.7.1

, . 7 .

"" .

"" . " " - , . .2.7.2. " " . " ", , . " " , .

"" "" " ", web-. .2.7 2.

"". , , . .

" " " " - , "" - ( 2.23), " " - .

2.23 - ""


"Download" , .

"" - , , .

 

2.7.2

. "" "" - "". ( 2.24). "". . .

2.24 - ""


, . . , .

. "" "" ( 2.25). . , . , , ( 2.26). "" , . " ". . N , , . ( 2.27). , . . 70% , ( 2.28). . , , .


2.25 - ""

2.26 - ""


2.27 - ""

2.28 - " "


, 2N , . 70% . .

 

2.7.3

( "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 - " "


.

 

2.8

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 .


3.

 

3.1

( ) , [18]. 3.1

3.1 -

, . - .
50
20
40
10
20
web- 40
90
100
40
410

3.2

, :

.

.

.

.

.

, , 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.3

() , , () .

() (3.5):

,

(3.5)

- ( 3.5), .;

- .% ( 20-30% );.

, :


.

 

3.4

. 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 .

3.5

web- R@Learning Institute , - . , , , , web- . , PHP MySQL Agava. ru 9$ , .

:

;

;

.

:

;

;

;

;

.

, .. .., - . - .

, . .

, - - .

. , .

Internet, , , .

: , , CD-ROM, , , .

, . , ( ). , - - , , , , , . .

, . web- , .

web- R@Learning Institute :

, ;

;

;

. . ;

;

web-. - ;

, , , ;

, ;

;

;

. web-;

;

;

.

, , .

, , , .


4.

 

4.1

 

4.1.1 ,

209 , .

, , , , , , , , . : - , (), (+). , . , (, ) , . , , . - . .

12.1 044-89 - , - , , .

 

4.1.2

, :

.

, . - . , ;

.

, , 220. , , , - -:

;

;

;

;

, :

:

;

;

, , , ;

;

;

:

, , , ;

;

:

. , , , , , .

. 209  - , .

 

4.1.3

( ) - , - .

105-03 -3, [19].

-21.01-97 II- .

(I ) , , .

 

4.1.4 -

, 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

, .

( ), ( ).

 


4.1.5 .

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;

;

( ..), - , ;

(, ..);

;

, ;

, ;

.

 

4.1.6

105-03 [19] :

;

- , , .

, .. : , , , , . , , , , . , . , , - , , -5, , , .

 

4.1.7

. :

- , . , , ;

. .


4.1.8

.

30.12.98 . 2775.

" -" . . - , , , -6, -7 .

: ( ).

, , , .

, , , . ( - , , ..).

( . . ) ( ), .

:

;

;

;

;

.

. , . , :

;

, ;

, .

 

4.2

4.2.1 (1-4)

, 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.2.2

, , , .

- , , , . (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-->&nbsp; </td>

<td width="614" align="right" valign="top"><div align="right"><span class="textonlightblue"> <a class="notunder"

href=mailto: andrewnik@mail. ru>&lt; A&D-STYLE&gt; </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">

&nbsp; </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>

- ... () &quot; &quot;

 

 

 

! , , , .
. , :