//??????? teacher
$fname      = $_POST['fname'];
$name       = $_POST['name'];
$sname      = $_POST['sname'];
$ulogon     = $_POST['ulogon'];
$upass      = $_POST['upass'];
$uexp       = $_POST['uexp'];
$ustepen1   = $_POST['ustepen1'];
$ustepen2   = $_POST['ustepen2'];
$uzvan1     = $_POST['uzvan1'];
$uzvan2     = $_POST['uzvan2'];
$udolzn     = $_POST['udolzn'];
// ???? ????????
$bnumber    = $_POST['bnumber'];
$bmonth     = $_POST['bmonth'];
$byear      = $_POST['byear'];
             //??????? icq
$icq        = $_POST['icq'];
             //??????? works[1-5]
$work1      = $_POST['work1'];
$work2      = $_POST['work2'];
$work3      = $_POST['work3'];
$work4      = $_POST['work4'];
$work5      = $_POST['work5'];
$izd1       = $_POST['izd1'];
$izd2       = $_POST['izd2'];
$izd3       = $_POST['izd3'];
$izd4       = $_POST['izd4'];
$izd5       = $_POST['izd5'];
$iyear1     = $_POST['iyear1'];
$iyear2     = $_POST['iyear2'];
$iyear3     = $_POST['iyear3'];
$iyear4     = $_POST['iyear4'];
$iyear5     = $_POST['iyear5'];
             //??????? kaf
$kname      = $_POST['kname'];
             //??????? emails[1-2]
$email1     = $_POST['email1'];
$email2     = $_POST['email2'];
             //??????? courses[1-5]
$ncourse1   = $_POST['ncourse1'];
$ncourse2   = $_POST['ncourse2'];
$ncourse3   = $_POST['ncourse3'];
$ncourse4   = $_POST['ncourse4'];
$ncourse5   = $_POST['ncourse5'];
$ctype1     = $_POST['ctype1'];
$ctype2     = $_POST['ctype2'];
$ctype3     = $_POST['ctype3'];
$ctype4     = $_POST['ctype4'];
$ctype5     = $_POST['ctype5'];
             //??????? interests[1-4]
$ninterest1 = $_POST['ninterest1'];
$ninterest2 = $_POST['ninterest2'];            
$ninterest3 = $_POST['ninterest3'];
$ninterest4 = $_POST['ninterest4'];
             //??????? graduation[1-2]
$ugrad1     = $_POST['ugrad1'];
$ugrad2     = $_POST['ugrad2'];
$spec1      = $_POST['spec1'];            
$spec2      = $_POST['spec2'];
$years1     = $_POST['years1'];            
$years2     = $_POST['years2'];
$yearf1     = $_POST['yearf1'];
$yearf2     = $_POST['yearf2'];            
             //??????? hobbies[1-2]
$hname1     = $_POST['hname1'];
$hname2     = $_POST['hname2'];

//    ?????????? ????? ?????????? ??????????? ????????, ???? ?? ?? 2 ??????????
//    1 - ??? ??? ? ???? 2-?????????

if (!$fname || !$sname || !$name || !$ulogon || !$upass)
  {  
    echo '??, ???????? ????? ?? ??? ??????????? ????????. <br />'
       .'????????? ?? ????????? ??????? ? ???????? ???? ???????????? ?????.';
    echo '<a href="www.form.rudn.net/mform.html">????????? ? ?????????? ?????</a>';
    exit;
  }  
if (!$bnumber || !$bmonth || !$byear || !$uexp || !$kname || !$udolzn || !$ugrad1 || !$spec1 || !$years1 || !$yearf1 || !$email1)           
  {
  	echo '?? ?? ????????? ???? ??? ????????? ???????????? ?????!<br />'
  	     .'????????? ?? ????????? ??????? ? ???????? ????.';
  	echo '<a href="www.form.rudn.net/mform.html">????????? ? ?????????? ?????</a>';     
  }

if (!get_magic_quotes_gpc()) //????????? ?? ?????????? ?? ?????????? ??????? ?????? ? ???????           
  {                          // ???? ??? (!) ?? ??????? ??????? ? ?????? ? ? ????? ????? ?????
  	$fname      = addslashes($fname);
    $name       = addslashes($name);
    $sname      = addslashes($sname);
    $ulogon     = addslashes($ulogon);
    $upass      = addslashes($upass);
    $uexp       = intval($uexp);
    $ustepen1   = addslashes($ustepen1);
    $ustepen2   = addslashes($ustepen2);
    $uzvan1     = addslashes($uzvan1);
    $uzvan2     = addslashes($uzvan2);
    $udolzn     = addslashes($udolzn);
    $bnumber    = intval($bnumber);
    $bmonth     = intval($bmonth);
    $byear      = intval($byear);
    $icq        = addslashes($icq);
    $work1      = addslashes($work1);
    $work2      = addslashes($work2);
    $work3      = addslashes($work3);
    $work4      = addslashes($work4);
    $work5      = addslashes($work5);
    $izd1       = addslashes($izd1);
    $izd2       = addslashes($izd2);
    $izd3       = addslashes($izd3);
    $izd4       = addslashes($izd4);
    $izd5       = addslashes($izd5);
    $iyear1     = intval($iyear1);
    $iyear2     = intval($iyear2);
    $iyear3     = intval($iyear3);
    $iyear4     = intval($iyear4);
    $iyear5     = intval($iyear5);
    $kname      = addslashes($kname);
    $email1     = addslashes($email1);
    $email2     = addslashes($email2);
    $ncourse1   = addslashes($ncourse1);
    $ncourse2   = addslashes($ncourse2);
    $ncourse3   = addslashes($ncourse3);
    $ncourse4   = addslashes($ncourse4);
    $ncourse5   = addslashes($ncourse5);
    $ctype1     = addslashes($ctype1);
    $ctype2     = addslashes($ctype2);
    $ctype3     = addslashes($ctype3);
    $ctype4     = addslashes($ctype4);
    $ctype5     = addslashes($ctype5);
    $ninterest1 = addslashes($ninterest1);
    $ninterest2 = addslashes($ninterest2);
    $ninterest3 = addslashes($ninterest3);
    $ninterest4 = addslashes($ninterest4);
    $ugrad1     = addslashes($ugrad1);
    $ugrad2     = addslashes($ugrad2);
    $spec1      = addslashes($spec1);            
    $spec2      = addslashes($spec2);
    $years1     = intval($years1);            
    $years2     = intval($years2);
    $yearf1     = intval($yearf1);
    $yearf2     = intval($yearf2);
    $hname1     = addslashes($hname1);
    $hname2     = addslashes($hname2);     
  }
//??????????? ???? ????????            
$str = "{$byear}-{$bmonth}-{$bnumber}"; 

//????????? ?????????? ????? ? ??
$dblocation = "127.0.0.1";
$dbname     = "prepod";
$dbuser     = "root";
$dbpassword = "multiscan";
//Connecting to database...
$db = @mysql_connect($dblocation, $dbuser, $dbpassword);
// Prove that no connection Errors
if (!$db)
  {
  	echo 'Error :: can not connect to database! <br />';
  	echo 'Try again later...';
  	exit;
  }
if (! @mysql_select_db($dbname, $db))
  {
  	echo( "<P> No database found 
                       ??????????? ???????? ??????????.</P>" ); 
    exit(); 

  }
//***** Making queries to the database ******\\
 //??????? teacher
$query_teacher = "insert into teacher (teacher_key, fname, name, sname, bdate, ulogon, upass, uexp, ustepen1, ustepen2, uzvan1, uzvan2, udolzn) 
                  values (NULL, '".$fname."', '".$name."','".$sname."','".$str."', '".$ulogon."', '".$upass."', '".$uexp."', '".$ustepen1."', '".$ustepen2."', '".$uzvan1."', '".$uzvan2."', '".$udolzn."')";            
//??????? works[1-5]
$query_works1 = "insert into work1 (teacher_key, work1, izd1, iyear1) 
                 values (NULL,'".$work1."', '".$izd1."', '".$iyear1."')";
$query_works2 = "insert into work2 (teacher_key, work2, izd2, iyear2) 
                 values (NULL,'".$work2."','".$izd2."', '".$iyear2."')";            
$query_works3 = "insert into work3 (teacher_key, work3, izd3, iyear3) 
                 values (NULL,'".$work3."','".$izd3."', '".$iyear3."')";
$query_works4 = "insert into work4 (teacher_key, work4, izd4, iyear4) 
                 values (NULL,'".$work4."','".$izd4."', '".$iyear4."')";
$query_works5 = "insert into work5 (teacher_key, work5, izd5, iyear5) 
                 values (NULL,'".$work5."','".$izd5."', '".$iyear5."')";
//??????? icq      
$query_icq = "insert into icq (teacher_key, icq) 
              values (NULL, '".$icq."')";      
//??????? kaf   
$query_kaf = "insert into kaf (kkey, teacher_key, kname) 
              values (NULL,,'".$kname."')";         
//??????? emails[1-2]
$query_email1 = "insert into emails1 (mkode1, teacher_key, email1) 
                 values (NULL,,'".$email1."')";            
$query_email2 = "insert into emails2 (mkode2, teacher_key, email2) 
                 values (NULL,,'".$email2."'";
//??????? courses[1-5]
$query_courses1 = "insert into cours1 (kcourse1, teacher_key, ncourse1, ctype1) 
                   values (NULL,,'".$ncourse1."','".$ctype1."')";
$query_courses2 = "insert into cours2 (kcourse2, teacher_key, ncourse2, ctype2) 
                   values (NULL,,'".$ncourse2."','".$ctype2."')";
$query_courses3 = "insert into cours3 (kcourse3, teacher_key, ncourse3, ctype3) 
                   values (NULL,,'".$ncourse3."','".$ctype3."')";
$query_courses4 = "insert into cours4 (kcourse4, teacher_key, ncourse4, ctype4) 
                   values (NULL,,'".$ncourse4."','".$ctype4."')";
$query_courses5 = "insert into cours5 (kcourse5, teacher_key, ncourse5, ctype5) 
                   values (NULL,,'".$ncourse5."','".$ctype5."')";  
//??????? interests[1-4]
$query_interests1 = "insert into inrerests1 (teacher_key, ninterest1) 
                     values (,'".$ninterest1."')";
$query_interests2 = "insert into inrerests2 (teacher_key, ninterest2) 
                     values (,'".$ninterest2."')";
$query_interests3 = "insert into inrerests3 (teacher_key, ninterest3) 
                     values (,'".$ninterest3."')";
$query_interests4 = "insert into inrerests4 (teacher_key, ninterest4) 
                     values (,'".$ninterest4."')";
//??????? graduation[1-2]
$query_graduation1 = "insert into graduation1 (teacher_key, ugrad1, spec1, years1, yearf1) 
                      values(,'".$ugrad1."', '".$spec1."', '".$years1."','".$yearf1."')";
$query_graduation2 = "insert into graduation2 (teacher_key, ugrad2, spec2, years2, yearf2) 
                      values(,'".$ugrad2."', '".$spec2."', '".$years2."','".$yearf2."')";
//??????? hobbies[1-2]
$query_hobbies1 = "insert into hobbies1 (teacher_key, hname1) 
                   values (,'".$hname1."')";
$query_hobbies2 = "insert into hobbies2 (teacher_key, hname2) 
                   values (,'".$hname2."')";
// Inserting all Queries into Database            
$result1  = mysql_query($query_teacher);
if (!$result1)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result2  = mysql_query($query_works1);
if (!$result2)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }            
$result3  = mysql_query($query_works2);            
if (!$result3)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result4  = mysql_query($query_works3);
if (!$result4)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result5  = mysql_query($query_works4);
if (!$result5)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result6  = mysql_query($query_works5);
if (!$result6)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result7  = mysql_query($query_icq);
if (!$result7)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result8  = mysql_query($query_kaf);
if (!$result8)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result9  = mysql_query($query_email1);
if (!$result9)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result10 = mysql_query($query_email2);
if (!$result10)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result11 = mysql_query($query_courses1);
if (!$result11)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result12 = mysql_query($query_courses2);
if (!$result12)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result13 = mysql_query($query_courses3);
if (!$result13)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result14 = mysql_query($query_courses4);
if (!$result14)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result15 = mysql_query($query_courses5);
if (!$result15)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result16 = mysql_query($query_interests1);
if (!$result16)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result17 = mysql_query($query_interests2);
if (!$result17)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result18 = mysql_query($query_interests3);
if (!$result18)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result19 = mysql_query($query_interests4);
if (!$result19)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result20  = mysql_query($query_graduation1);
if (!$result20)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result21  = mysql_query($query_graduation2);
if (!$result21)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result22 = mysql_query($query_hobbies1);
if (!$result22)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }
$result23 = mysql_query($query_hobbies2);
if (!$result23)
   {
   	echo "ERROR! No data added";
   }
else 
   {
   	echo "Operation complete sucessifully",mysql_affected_rows();
   }



///////////////////////////////////////////////////////////////////////
**********************************************************************
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
SQL
////////////////////////////////////////////////////////////////////////
***********************************************************************

create database prepod;
use prepod;

create table teacher 
(
teacher_key int unsigned not null auto_increment primary key,
fname     char(25)  not null,
name      char(25)  not null,
sname    char(25)  not null,
bdate      char(10)       not null,
ulogon    char(15)  not null,
upass     char(15)   not null,
uexp       char(4)    not null,
ustepen1 char(10)   not null,
ustepen2 char(25) not null,
uzvan1    char(25) not null,
uzvan2    char(10)   not null,
udolzn     char(25) not null
);

create table icq
(
teacher_key int unsigned not null references teacher(teacher_key),
icq char(10),
primary key (teacher_key, icq)
)type=InnoDB;			

create table work1
(
teacher_key int unsigned not null references teacher(teacher_key),
work1 char(180),
izd1    char(50),
iyear1   char(4),
primary key (teacher_key)
)type=InnoDB;

create table work2
(
teacher_key int unsigned not null references teacher(teacher_key),
work2 char(180),
izd2    char(50),
iyear2   char(4),
primary key(teacher_key)
)type=InnoDB;

create table work3
(
teacher_key int unsigned not null references teacher(teacher_key),
work3 char(180),
izd3    char(50),
iyear3   char(4),
primary key(teacher_key)
)type=InnoDB;

create table work4
(
teacher_key int unsigned not null references teacher(teacher_key),
work4 char(180),
izd4    char(50),
iyear4   char(4),
primary key(teacher_key)
)type=InnoDB;

create table work5
(
teacher_key int unsigned not null references teacher(teacher_key),
work5 char(180),
izd5    char(50),
iyear5   char(4),
primary key(teacher_key)
)type=InnoDB;

create table kaf
(
teacher_key int unsigned not null references teacher(teacher_key),
kname char(200),
primary key(teacher_key)
)type=InnoDB;

create table emails1
(
teacher_key int unsigned not null references teacher(teacher_key),
email1 char(60),
primary key(teacher_key)
)type=InnoDB;

create table emails2
(
teacher_key int unsigned not null references teacher(teacher_key),
email2 char(60),
primary key(teacher_key)
)type=InnoDB;

create table cours1
(
teacher_key int unsigned not null references teacher(teacher_key),
ncourse1 char(200),
ctype1     char(15),
primary key(teacher_key)
)type=InnoDB;

create table cours2
(
teacher_key int unsigned not null references teacher(teacher_key),
ncourse2 char(200),
ctype2     char(15),
primary key(teacher_key)
)type=InnoDB;


create table cours3
(
teacher_key int unsigned not null references teacher(teacher_key),
ncourse3 char(200),
ctype3     char(15),
primary key(teacher_key)
)type=InnoDB;

create table cours4
(
teacher_key int unsigned not null references teacher(teacher_key),
ncourse4 char(200),
ctype4     char(15),
primary key(teacher_key)
)type=InnoDB;

create table cours5
(
teacher_key int unsigned  not null references teacher(teacher_key),
ncourse5 char(200),
ctype5     char(15),
primary key(teacher_key)
)type=InnoDB;


create table ninterests1
(
teacher_key int unsigned not null references teacher(teacher_key),
ninterest1 char(200),
primary key(teacher_key)
)type=InnoDB;


create table ninterests2
(
teacher_key int unsigned not null references teacher(teacher_key),
ninterest2 char(200),
primary key(teacher_key)
)type=InnoDB;


create table ninterests3
(
teacher_key int unsigned not null references teacher(teacher_key),
ninterest3 char(200),
primary key(teacher_key)
)type=InnoDB;

create table ninterests4
(
teacher_key int unsigned not null references teacher(teacher_key),
ninterest4 char(200),
primary key(teacher_key)
)type=InnoDB;

create table graduation1
(
teacher_key int unsigned not null references teacher(teacher_key),
ugrad1 char(200),
spec1 char(100),
years1 char(4),
yearf1 char(4),
primary key(teacher_key)
)type=InnoDB;

create table graduation2
(
teacher_key int unsigned not null references teacher(teacher_key),
ugrad2 char(200),
spec2 char(100),
years2 char(4),
yearf2 char(4),
primary key(teacher_key)
)type=InnoDB;

create table hobbies1
(
teacher_key int unsigned not null references teacher(teacher_key),
hname1 char(200),
primary key(teacher_key)
)type=InnoDB;

create table hobbies2
(
teacher_key int unsigned not null references teacher(teacher_key),
hname2 char(200),
primary key(teacher_key)
)type=InnoDB;