Разработка информационной системы управления учебным процессом (на примере филиала РГГУ г. Всеволжска)
Дипломная работа - Компьютеры, программирование
Другие дипломы по предмету Компьютеры, программирование
0];$x;
}
get_N_zach($id){
$x=getinfo("SELECT `N_zach` from `students` WHERE `id`=$id");
$x=$x[0];$x;
}
get_group_name($id){
$x=getinfo("SELECT `name` from `group` WHERE `id`=$id");
$x=$x[0];$x;
}
get_group_year($id){
$x=getinfo("SELECT `year` from `group` WHERE `id`=$id");
$x=$x[0];$x;
}
get_group_number($id){
$x=getinfo("SELECT `group_number` from `group` WHERE `id`=$id");
$x=$x[0];$x;
}get_god_ob($id){
$x=getinfo("SELECT `god_ob` from `students` WHERE `id`=$id");
$x=$x[0];$x;
}
get_spec_name($id){
$x=getinfo("SELECT `Name` from `spec` WHERE `id`=$id");
$x=$x[0];$x;
}get_group($id){
$x=getinfo("SELECT `name`, `year`, `group_number` from `group` WHERE `id`=$id");
$x=$x[0].$x[1].$x[2];$x;
}get_predm_name($id){
$x=getinfo("SELECT `Name` from `predm` WHERE `id`=$id");
$x=$x[0];$x;
}get_kaf_ZavDepartment($id){
$x=getinfo("SELECT `ZavDepartment` from `Departments` WHERE `id`=$id");
$x=$x[0];$x;
}
get_stepen_name($id){
$x=getinfo("SELECT `Name` from `stepeni` WHERE `id`=$id");
$x=$x[0];$x;
}
get_name_lectures($id){
$x=getinfo("SELECT `Name` from `lectures` WHERE `id`=$id");
$x=$x[0];$x;
}
get_name_students($id){
$x=getinfo("SELECT `Name` from `students` WHERE `id`=$id");
$x=$x[0];$x;
}get_surname_lectures($id){
$x=getinfo("SELECT `Surname` from `lectures` WHERE `id`=$id");
$x=$x[0];$x;
}get_surname_students($id){
$x=getinfo("SELECT `Surname` from `students` WHERE `id`=$id");
$x=$x[0];$x;
}
get_patronymic_students($id){
$x=getinfo("SELECT `Patronymic` from `students` WHERE `id`=$id");
$x=$x[0];$x;
}
get_patronymic_lectures($id){
$x=getinfo("SELECT `Patronymic` from `lectures` WHERE `id`=$id");
$x=$x[0];$x;
}
get_name_group_li(){
$sql='SELECT `id` FROM `lectures`';(getinfo($sql));
}
get_group_id(){
$sql='SELECT `id` FROM `group`';(getinfo($sql));
}vedomost_add_group($date, $group, $predm){
$sql="INSERT INTO `vedomosti_list`
( `id`,
`id_predm`,_id`,
`date`)('',
'$predm',
'$group',
'$date'
)";($sql);1;
}
find_id_vedomost_group($date, $group, $predm){
$sql="SELECT id from `vedomosti_list` WHERE `id_predm`=$predm AND `group_id`=$group AND `date`='$date'";
$x=getinfo($sql);$x[0];
}get_vedomost_group($ved){
$sql="SELECT group_id from vedomosti_list where id=$ved";
$group_id=getinfo($sql);
$group_id=$group_id[0];
$sql="SELECT id from students where group_id=$group_id";
$ids=getinfo($sql);($x=0; $x<count($ids);$x++){
$sql="SELECT Surname, Name, Patronymic from students where id=$ids[$x]";
$name=getinfo($sql);
$name=$name[0]." ".$name[1]." ".$name[2];
$sql="SELECT N_zach from students where id=$ids[$x]";
$N_zach=getinfo($sql);
$N_zach=$N_zach[0];
$sql="SELECT ocenka from vedomosti where id_stud=$ids[$x] and id_ved=$ved";
$ocenka=getinfo($sql);
$ocenka= $ocenka[0];"";
}
}
get_vedomost_group_list($group){
$sql="SELECT `id` from vedomosti_list WHERE group_id=$group";
$ids=getinfo($sql);($x=0; $x<count($ids);$x++){
$sql="SELECT `id_predm` from vedomosti_list WHERE id=$ids[$x]";
$predm=getinfo($sql);
$predm=$predm[0];
$sql="SELECT `date` from vedomosti_list WHERE id=$ids[$x]";
$date=getinfo($sql);
$date=$date[0];"";
}
}
?>