Viewing file:  reg_standard.php (11.33 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
';
//Standard 5-6
//$information .= "\n";
//num_student
$host="localhost";
$username="root";
$pass_word="";
$db="reg";
//mysql_query("SET NAMES TIS620");
mysql_connect( $host,$username,$pass_word) or die ("ติดต่อกับฐานข้อมูล Mysql ไม่ได้ ");
mysql_select_db($db) or die("เลือกฐานข้อมูลไม่ได้");
$sql = "SELECT * FROM StudentMaster where (admitDate < '$search_term_date_end')";
$dbquery = mysql_query($sql);
$num_student_all =mysql_num_rows($dbquery) ;
//echo "นักศึกษาทั้งหมด $num_student_all
";
$sql2 = "SELECT * FROM StudentMaster WHERE (studentStatus = '1') and (admitDate < '$search_term_date_end')";
$dbquery2 = mysql_query($sql2);
$num_student_now =mysql_num_rows($dbquery2) ;
//echo "นักศึกษาที่กำลังศึกษาอยู่ $num_student
";
$sql2 = "SELECT * FROM StudentMaster WHERE studentStatus = '5' and (admitDate < '$search_term_date_end')";
$dbquery2 = mysql_query($sql2);
$num_student_out =mysql_num_rows($dbquery2) ;
//echo "นักศึกษาที่่ลาออก $num_student_out
";
//นับจำนวนนักศึกษา
$sql2 = "SELECT * FROM StudentMaster WHERE studentStatus = '1' and (admitDate < '$search_term_date_end')";
$dbquery2 = mysql_query($sql2);
$num_studentYear_1=0;
$num_studentYear_2=0;
$num_student2Year_2=0;
$num_studentYear_3=0;
$num_studentYear_4=0;
while($row = mysql_fetch_array($dbquery2))
{
$studentCode=$row["studentCode"];
$studentYear=$row["studentYear"];
$admitAcadYear=$row["admitAcadYear"];
//if($studentYear=='1'){$num_studentYear_1++;}
//if($studentYear=='2'){$num_studentYear_2++;}
//if($studentYear=='3'){$num_studentYear_3++;}
//if($studentYear=='4'){$num_studentYear_4++;}
$studentCode;
$studentCode_check = substr($studentCode, 0, 6);
if($admitAcadYear=='2550'){$num_studentYear_1++;}
if($admitAcadYear=='2549')
{
if($studentCode_check=='492101')
{
$num_studentYear_2++;
}
if($studentCode_check=='492103')
{
$num_student2Year_2++;
}
//$num_studentYear_2++;
}
if($admitAcadYear=='2548'){$num_studentYear_3++;}
if($admitAcadYear=='2547'){$num_studentYear_4++;}
}
$information .= "\n";
$information .= "\n";
$information .= "$num_student_all";
$information .= "\n";
$information .= "\n";
$information .= "$num_student_now";
$information .= "\n";
$information .= "\n";
$information .= "$num_student_out";
$information .= "\n";
//---------------------------------------------------------------------------student_year1
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_1";
$information .= "\n";
$information .= "\n";
$information .= "17";
$information .= "\n";
$sum_year1_Term1=$num_studentYear_1*17;
$information .= "\n";
$information .= "$sum_year1_Term1";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_1";
$information .= "\n";
$information .= "\n";
$information .= "20";
$information .= "\n";
$sum_year1_Term2=$num_studentYear_1*20;
$information .= "\n";
$information .= "$sum_year1_Term2";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_1";
$information .= "\n";
$information .= "\n";
$information .= "12";
$information .= "\n";
$sum_year1_Term3=$num_studentYear_1*12;
$information .= "\n";
$information .= "$sum_year1_Term3";
$information .= "\n";
$information .= "\n";
$information .= "\n";
//---------------------------------------------------------------------------student_year2
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_2";
$information .= "\n";
$information .= "\n";
$information .= "17";
$information .= "\n";
$sum_year2_Term1=$num_studentYear_2*17;
$information .= "\n";
$information .= "$sum_year2_Term1";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_2";
$information .= "\n";
$information .= "\n";
$information .= "18";
$information .= "\n";
$sum_year2_Term2=$num_studentYear_2*18;
$information .= "\n";
$information .= "$sum_year2_Term2";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_2";
$information .= "\n";
$information .= "\n";
$information .= "7";
$information .= "\n";
$sum_year2_Term3=$num_studentYear_2*7;
$information .= "\n";
$information .= "$sum_year2_Term3";
$information .= "\n";
$information .= "\n";
$information .= "\n";
//-------------------------------------------------------------------------------------------------------------------------
//---------------------------------------------------------------------------student 2 _year2
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_student2Year_2";
$information .= "\n";
$information .= "\n";
$information .= "15.5";
$information .= "\n";
$sum2_year2_Term1=$num_student2Year_2*15.5;
$information .= "\n";
$information .= "$sum2_year2_Term1";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_student2Year_2";
$information .= "\n";
$information .= "\n";
$information .= "7.5";
$information .= "\n";
$sum2_year2_Term2=$num_student2Year_2*7.5;
$information .= "\n";
$information .= "$sum2_year2_Term2";
$information .= "\n";
$information .= "\n";
$information .= "\n";
//-------------------------------------------------------------------------------------------------------------------------
//---------------
//$information .= "\n";
//$information .= "$num_student2Year_2";
//$information .= "\n";
//-----------------------------------------------------------------student_year 4
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_3";
$information .= "\n";
$information .= "\n";
$information .= "13";
$information .= "\n";
$sum_year3_Term1=$num_studentYear_3*13;
$information .= "\n";
$information .= "$sum_year3_Term1";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_3";
$information .= "\n";
$information .= "\n";
$information .= "16";
$information .= "\n";
$sum_year3_Term2=$num_studentYear_3*16;
$information .= "\n";
$information .= "$sum_year3_Term2";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_3";
$information .= "\n";
$information .= "\n";
$information .= "5";
$information .= "\n";
$sum_year3_Term3=$num_studentYear_3*5;
$information .= "\n";
$information .= "$sum_year3_Term3";
$information .= "\n";
$information .= "\n";
$information .= "\n";
//-----------------------------------------------------------------student_year 3
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_4";
$information .= "\n";
$information .= "\n";
$information .= "10";
$information .= "\n";
$sum_year4_Term1=$num_studentYear_4*10;
$information .= "\n";
$information .= "$sum_year4_Term1";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "\n";
$information .= "$num_studentYear_4";
$information .= "\n";
$information .= "\n";
$information .= "10";
$information .= "\n";
$sum_year3_Term2=$num_studentYear_3*10;
$information .= "\n";
$information .= "$sum_year4_Term2";
$information .= "\n";
$information .= "\n";
$information .= "\n";
//-------------------------------------------
$information .= "\n";
//$prem=1;
//$information .= "\n";
return $information;
}
$server = new soap_server;
$server->configureWSDL('ws_standard_on_reg', 'urn:ws_standard_on_reg_wsdl');
$server->register('num_student',
array('search_num_student' => 'xsd:string','search_term_date_start' => 'xsd:string','search_term_date_end' => 'xsd:string'),
array('information' => 'xsd:string'),
'http://58.147.103.67/ws_standard_on_reg/',
'http://58.147.103.67/ws_standard_on_reg/',
'rpc',
'encoded',
'Search_For_Student_Rent');
$HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';
$server->service($HTTP_RAW_POST_DATA);
?>
|