Разработка информационной системы управления учебным процессом (на примере филиала РГГУ г. Всеволжска)
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
-
- Структура таблицы `lectures`
-
TABLE `lectures` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Surname` varchar(50) NOT NULL,
`Name` varchar(50) NOT NULL,
`Patronymic` varchar(50) NOT NULL,
`Stepen_id` int(11) NOT NULL,
`Departmen_id` int(11) NOT NULL,
`items_id` varchar(500) NOT NULL,KEY `id_2` (`id`), KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
- --------------------------------------------------------
-
- Структура таблицы `predm`
-
TABLE `predm` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) NOT NULL,KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
- --------------------------------------------------------
-
- Структура таблицы `spec`
-
TABLE `spec` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) NOT NULL,KEY (`id`)
ПРОДОЛЖЕНИЕ ПРИЛОЖЕНИЯ 1
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
-
- Структура таблицы `stepeni`
-
TABLE `stepeni` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(50) NOT NULL,KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
- --------------------------------------------------------
-
- Структура таблицы `students`
-TABLE `students` (
`id` int(11) NOT NULL AUTO_INCREMENT, `Surname` varchar(50) NOT NULL, `Name` varchar(50) NOT NULL, `Patronymic` varchar(50) NOT NULL, `Specialty` varchar(50) NOT NULL, `Entered` year(4) NOT NULL,
`group_id` int(11) NOT NULL, `N_zach` varchar(20) NOT NULL,KEY (`id`), UNIQUE KEY `N_zach` (`N_zach`), UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
-
- Структура таблицы `vedomosti`
-TABLE `vedomosti` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_stud` int(11) NOT NULL,
`id_ved` int(11) NOT NULL,
`ocenka` varchar(20) NOT NULL,KEY (`id`),KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
- --------------------------------------------------------
- Структура таблицы `vedomosti_list`TABLE `vedomosti_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_predm` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`prep` int(11) NOT NULL,
`date` date NOT NULL,KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
ПРИЛОЖЕНИЕ 2
Листинг файла functions.php
<?php
("HOST_DB", "localhost");("DB_USER", "user");("DB_PASS", "pass");("DB_NAME", "database");
getinfo($sql)
{
$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli->query('SET NAMES utf8');
$result = $mysqli->query($sql);( $row = $result->fetch_assoc() ){($row as $fieldValue){
$data[] .= $fieldValue;
}
}
$result->close();
$mysqli->close();$data;
};execute($sql){
$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {
("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli->query('SET NAMES utf8');
$mysqli->query($sql);
$mysqli->close();1;
}
get_all_id_students(){
$sql='SELECT `id` FROM `students`';(getinfo($sql));
}get_all_id_groups(){
$sql='SELECT `id` FROM `group`';(getinfo($sql));
}
get_all_id_lectures(){
$sql='SELECT `id` FROM `lectures`';(getinfo($sql));
}
all_info_students(){
$ids=get_all_id_students();($ids as $id){
"";
$sql="SELECT `id`, `Surname`,`Name`,`Patronymic`,`Specialty`,`Entered`,`group_id`, `N_zach` FROM `students` where `id`=$id";
$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli->query('SET NAMES utf8');
$result = $mysqli->query($sql);
( $result->fetch_assoc() as $key => $value){($key=="Specialty")$value=get_spec_name ($value);($key=="group_id")$value=get_group($value);"";
}
$result->close();
$mysqli->close();
"
";
};
}
all_info_groups(){
$ids=get_all_id_groups();($ids as $id){"";
$sql="SELECT `id`, `name`,`year`,`group_number` FROM `group` where `id`=$id";
$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli->query('SET NAMES utf8');
$result = $mysqli->query($sql);( $result->fetch_assoc() as $key => $value){"";
}
$result->close();
$mysqli->close();"
";
};
}get_name_group_full($id){
$sql="SELECT `name`,`year`,`group_number` FROM `group` where `id`=$id";
$group=getinfo($sql);
$group=$group[0].$group[1].$group[2];$group;
}
all_info_lectures(){
$ids=get_all_id_lectures();($ids as $id){"";
$sql="SELECT `id`, `Surname`,`Name`,`Patronymic`,`Stepen_id`,`Departmen_id`,`items_id` FROM `lectures` where `id`=$id";
$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli->query('SET NAMES utf8');
$result = $mysqli->query($sql);( $result->fetch_assoc() as $key => $value){($key=="Stepen_id")$value=get_stepen_name ($value);($key=="Departmen_id")$value=get_kaf_name ($value);($key=="items_id")$value=get_items_name ($value);""; }
$result->close();
$mysqli->close();
"
";
};
}
get_all_info_spec(){
$count= getinfo("SELECT count(`id`) from `spec");
$count=$count[0];
$sql="SELECT `id`, `Name` from `spec`";
$mysqli = new mysqli(HOST_DB, DB_USER, DB_PASS, DB_NAME);
(mysqli_connect_errno()) {("Connect failed: %s\n", mysqli_connect_error());
}
$mysqli->query('SET NAMES utf8');
$result = $mysqli->query($sql);($k=1; $k $value){($key=="id")$id=$value;($key=="Name")$Name=$value;
ПРОДОЛЖЕНИЕ ПРИЛОЖЕНИЯ 2
if(($id)&&($Name)) {
echo "
" ;
$id=""; $Name="";
};
};
};
$result->close();
$mysqli->close();
}
get_all_info_predm(){
$count= getinfo("SELECT count(`id`) from `predm");
$count=$count[0];
$sql="SELECT `id`, `Name` from `predm`";
$mysqli = new