|
|
|
|
|
|
|
|
ระดับ ปวช. |
|
|
|
|
|
|
|
ปวช.อุตสาหกรรม สาขาวิชาไฟฟ้าและอิเล็กทรอนิกส์(ไฟฟ้ากำลัง) |
$year = $_POST['year'];
$strSQL46 = "SELECT * FROM studentend where 1 AND section_studentend='ปวช.อุตสาหกรรม สาขาวิชาไฟฟ้าและอิเล็กทรอนิกส์(ไฟฟ้ากำลัง)'";
if($year != "")
{
$strSQL46 .= " AND (year_studentend like '%$year%') ";
}
$objQuery46 = mysql_query($strSQL46) or die ("Error Query [".$strSQL46."]");
$objResult46 = mysql_fetch_array($objQuery46);
$quantity_studentend46= $objResult46["quantity_studentend"];
echo $quantity_studentend46;
?>
|
$year = $_POST['year'];
$strSQL1 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรม สาขาวิชาไฟฟ้าและอิเล็กทรอนิกส์(ไฟฟ้ากำลัง)'";
if($year != "")
{
$strSQL1 .= " AND (year_alumni like '%$year%') ";
}
$objQuery1 = mysql_query($strSQL1) or die ("Error Query [".$strSQL1."]");
$objResult1 = mysql_fetch_array($objQuery1);
$id_alumni1= $objResult1["id_alumni"];
echo $id_alumni1;
?> |
if($id_alumni1 != "" and $quantity_studentend46 != "" )
{
$per1=($id_alumni1*100)/$quantity_studentend46; echo number_format($per1,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL16 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรม สาขาวิชาไฟฟ้าและอิเล็กทรอนิกส์(ไฟฟ้ากำลัง)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL16 .= " AND (year_alumni like '%$year%') ";
}
$objQuery16 = mysql_query($strSQL16) or die ("Error Query [".$strSQL16."]");
$objResult16 = mysql_fetch_array($objQuery16);
$id_alumni16= $objResult16["id_alumni"];
echo $id_alumni16;
?>
|
if($id_alumni1 != "0" and $id_alumni16 != "0" )
{
$per16=($id_alumni16*100)/$id_alumni1; echo number_format($per16,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL31 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรม สาขาวิชาไฟฟ้าและอิเล็กทรอนิกส์(ไฟฟ้ากำลัง)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL31 .= " AND (year_alumni like '%$year%') ";
}
$objQuery31 = mysql_query($strSQL31) or die ("Error Query [".$strSQL31."]");
$objResult31 = mysql_fetch_array($objQuery31);
$id_alumni31= $objResult31["id_alumni"];
echo $id_alumni31;
?>
|
if($id_alumni1 != "0" and $id_alumni31 != "0" )
{
$per31=($id_alumni31*100)/$id_alumni1; echo number_format($per31,2) ;
}
else
{
echo '-';
}
?>
|
ปวช.อุตสาหกรรม สาขาวิชาการก่อสร้าง(ก่อสร้าง) |
$year = $_POST['year'];
$strSQL47 = "SELECT * FROM studentend where 1 AND section_studentend='ปวช.อุตสาหกรรม สาขาวิชาการก่อสร้าง(ก่อสร้าง)'";
if($year != "")
{
$strSQL47 .= " AND (year_studentend like '%$year%') ";
}
$objQuery47 = mysql_query($strSQL47) or die ("Error Query [".$strSQL47."]");
$objResult47 = mysql_fetch_array($objQuery47);
$quantity_studentend47= $objResult47["quantity_studentend"];
echo $quantity_studentend47;
?>
|
$year = $_POST['year'];
$strSQL2 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรม สาขาวิชาการก่อสร้าง(ก่อสร้าง)'";
if($year != "")
{
$strSQL2 .= " AND (year_alumni like '%$year%') ";
}
$objQuery2 = mysql_query($strSQL2) or die ("Error Query [".$strSQL2."]");
$objResult2 = mysql_fetch_array($objQuery2);
$id_alumni2= $objResult2["id_alumni"];
echo $id_alumni2;
?>
|
if($id_alumni2 != "" and $quantity_studentend47 != "" )
{
$per2=($id_alumni2*100)/$quantity_studentend47; echo number_format($per2,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL17 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรม สาขาวิชาการก่อสร้าง(ก่อสร้าง)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL17 .= " AND (year_alumni like '%$year%') ";
}
$objQuery17 = mysql_query($strSQL17) or die ("Error Query [".$strSQL17."]");
$objResult17 = mysql_fetch_array($objQuery17);
$id_alumni17= $objResult17["id_alumni"];
echo $id_alumni17;
?>
|
if($id_alumni2 != "0" and $id_alumni17 != "0" )
{
$per17=($id_alumni17*100)/$id_alumni2; echo number_format($per17,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL32 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรม สาขาวิชาการก่อสร้าง(ก่อสร้าง)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL32 .= " AND (year_alumni like '%$year%') ";
}
$objQuery32 = mysql_query($strSQL32) or die ("Error Query [".$strSQL32."]");
$objResult32 = mysql_fetch_array($objQuery32);
$id_alumni32= $objResult32["id_alumni"];
echo $id_alumni32;
?>
|
if($id_alumni2 != "0" and $id_alumni32 != "0" )
{
$per32=($id_alumni32*100)/$id_alumni2; echo number_format($per32,2) ;
}
else
{
echo '-';
}
?>
|
ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การบัญชี) |
$year = $_POST['year'];
$strSQL48 = "SELECT * FROM studentend where 1 AND section_studentend='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การบัญชี)'";
if($year != "")
{
$strSQL48 .= " AND (year_studentend like '%$year%') ";
}
$objQuery48 = mysql_query($strSQL48) or die ("Error Query [".$strSQL48."]");
$objResult48 = mysql_fetch_array($objQuery48);
$quantity_studentend48= $objResult48["quantity_studentend"];
echo $quantity_studentend48;
?>
|
$year = $_POST['year'];
$strSQL3 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การบัญชี)'";
if($year != "")
{
$strSQL3 .= " AND (year_alumni like '%$year%') ";
}
$objQuery3 = mysql_query($strSQL3) or die ("Error Query [".$strSQL3."]");
$objResult3 = mysql_fetch_array($objQuery3);
$id_alumni3= $objResult3["id_alumni"];
echo $id_alumni3;
?>
|
if($id_alumni3 != "" and $quantity_studentend48 != "" )
{
$per3=($id_alumni3*100)/$quantity_studentend48; echo number_format($per3,2) ;
}
else
{
echo '-';
}?>
|
$year = $_POST['year'];
$strSQL18 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การบัญชี)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL18 .= " AND (year_alumni like '%$year%') ";
}
$objQuery18 = mysql_query($strSQL18) or die ("Error Query [".$strSQL18."]");
$objResult18 = mysql_fetch_array($objQuery18);
$id_alumni18= $objResult18["id_alumni"];
echo $id_alumni18;
?>
|
if($id_alumni3 != "0" and $id_alumni18 != "0" )
{
$per18=($id_alumni18*100)/$id_alumni3; echo number_format($per18,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL33 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การบัญชี)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL33 .= " AND (year_alumni like '%$year%') ";
}
$objQuery33 = mysql_query($strSQL33) or die ("Error Query [".$strSQL33."]");
$objResult33 = mysql_fetch_array($objQuery33);
$id_alumni33= $objResult33["id_alumni"];
echo $id_alumni33;
?>
|
if($id_alumni3 != "0" and $id_alumni33 != "0" )
{
$per33=($id_alumni33*100)/$id_alumni3; echo number_format($per33,2) ;
}
else
{
echo '-';
}
?>
|
ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การขาย) |
$year = $_POST['year'];
$strSQL49 = "SELECT * FROM studentend where 1 AND section_studentend='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การขาย)'";
if($year != "")
{
$strSQL49 .= " AND (year_studentend like '%$year%') ";
}
$objQuery49 = mysql_query($strSQL49) or die ("Error Query [".$strSQL49."]");
$objResult49 = mysql_fetch_array($objQuery49);
$quantity_studentend49= $objResult49["quantity_studentend"];
echo $quantity_studentend49;
?>
|
$year = $_POST['year'];
$strSQL4 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การขาย)'";
if($year != "")
{
$strSQL4 .= " AND (year_alumni like '%$year%') ";
}
$objQuery4 = mysql_query($strSQL4) or die ("Error Query [".$strSQL4."]");
$objResult4 = mysql_fetch_array($objQuery4);
$id_alumni4= $objResult4["id_alumni"];
echo $id_alumni4;
?>
|
if($id_alumni4 != "" and $quantity_studentend49 != "" )
{
$per4=($id_alumni4*100)/$quantity_studentend49; echo number_format($per4,2) ;
}
else
{
echo '-';
}?>
|
$year = $_POST['year'];
$strSQL19 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การขาย)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL19 .= " AND (year_alumni like '%$year%') ";
}
$objQuery19 = mysql_query($strSQL19) or die ("Error Query [".$strSQL19."]");
$objResult19 = mysql_fetch_array($objQuery19);
$id_alumni19= $objResult19["id_alumni"];
echo $id_alumni19;
?>
|
if($id_alumni4 != "0" and $id_alumni19 != "0" )
{
$per19=($id_alumni19*100)/$id_alumni4; echo number_format($per19,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL34 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(การขาย)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL34 .= " AND (year_alumni like '%$year%') ";
}
$objQuery34 = mysql_query($strSQL34) or die ("Error Query [".$strSQL34."]");
$objResult34 = mysql_fetch_array($objQuery34);
$id_alumni34= $objResult34["id_alumni"];
echo $id_alumni34;
?>
|
if($id_alumni4 != "0" and $id_alumni34 != "0" )
{
$per34=($id_alumni34*100)/$id_alumni4; echo number_format($per34,2) ;
}
else
{
echo '-';
}
?>
|
ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(ค้าปลีก) |
$year = $_POST['year'];
$strSQL50 = "SELECT * FROM studentend where 1 AND section_studentend='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(ค้าปลีก)'";
if($year != "")
{
$strSQL50 .= " AND (year_studentend like '%$year%') ";
}
$objQuery50 = mysql_query($strSQL50) or die ("Error Query [".$strSQL50."]");
$objResult50 = mysql_fetch_array($objQuery50);
$quantity_studentend50= $objResult50["quantity_studentend"];
echo $quantity_studentend50;
?>
|
$year = $_POST['year'];
$strSQL5 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(ค้าปลีก)'";
if($year != "")
{
$strSQL5 .= " AND (year_alumni like '%$year%') ";
}
$objQuery5 = mysql_query($strSQL5) or die ("Error Query [".$strSQL5."]");
$objResult5 = mysql_fetch_array($objQuery5);
$id_alumni5= $objResult5["id_alumni"];
echo $id_alumni5;
?>
|
if($id_alumni5 != "" and $quantity_studentend50 != "" )
{
$per5=($id_alumni5*100)/$quantity_studentend50; echo number_format($per5,2) ;
}
else
{
echo '-';
}?>
|
$year = $_POST['year'];
$strSQL20 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(ค้าปลีก)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL20 .= " AND (year_alumni like '%$year%') ";
}
$objQuery20 = mysql_query($strSQL20) or die ("Error Query [".$strSQL20."]");
$objResult20 = mysql_fetch_array($objQuery20);
$id_alumni20= $objResult20["id_alumni"];
echo $id_alumni20;
?>
|
if($id_alumni5 != "0" and $id_alumni20 != "0" )
{
$per20=($id_alumni20*100)/$id_alumni5; echo number_format($per20,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL35 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(ค้าปลีก)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL35 .= " AND (year_alumni like '%$year%') ";
}
$objQuery35 = mysql_query($strSQL35) or die ("Error Query [".$strSQL35."]");
$objResult35 = mysql_fetch_array($objQuery35);
$id_alumni35= $objResult35["id_alumni"];
echo $id_alumni35;
?>
|
if($id_alumni5 != "0" and $id_alumni35 != "0" )
{
$per35=($id_alumni35*100)/$id_alumni5; echo number_format($per35,2) ;
}
else
{
echo '-';
}
?>
|
ปวช.พาณิชยกรรม
สาขาวิชาพณิชยการ(คอมพิวเตอร์ธุรกิจ) |
$year = $_POST['year'];
$strSQL51 = "SELECT * FROM studentend where 1 AND section_studentend='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(คอมพิวเตอร์ธุรกิจ)'";
if($year != "")
{
$strSQL51 .= " AND (year_studentend like '%$year%') ";
}
$objQuery51 = mysql_query($strSQL51) or die ("Error Query [".$strSQL51."]");
$objResult51 = mysql_fetch_array($objQuery51);
$quantity_studentend51= $objResult51["quantity_studentend"];
echo $quantity_studentend51;
?>
|
$year = $_POST['year'];
$strSQL6 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(คอมพิวเตอร์ธุรกิจ)'";
if($year != "")
{
$strSQL6 .= " AND (year_alumni like '%$year%') ";
}
$objQuery6 = mysql_query($strSQL6) or die ("Error Query [".$strSQL6."]");
$objResult6 = mysql_fetch_array($objQuery6);
$id_alumni6= $objResult6["id_alumni"];
echo $id_alumni6;
?>
|
if($id_alumni6 != "" and $quantity_studentend51 != "" )
{
$per6=($id_alumni6*100)/$quantity_studentend51; echo number_format($per6,2) ;
}
else
{
echo '-';
}?>
|
$year = $_POST['year'];
$strSQL21 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(คอมพิวเตอร์ธุรกิจ)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL21 .= " AND (year_alumni like '%$year%') ";
}
$objQuery21 = mysql_query($strSQL21) or die ("Error Query [".$strSQL21."]");
$objResult21 = mysql_fetch_array($objQuery21);
$id_alumni21= $objResult21["id_alumni"];
echo $id_alumni21;
?>
|
if($id_alumni6 != "0" and $id_alumni21 != "0" )
{
$per21=($id_alumni21*100)/$id_alumni6; echo number_format($per21,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL36 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.พาณิชยกรรม สาขาวิชาพณิชยการ(คอมพิวเตอร์ธุรกิจ)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL36 .= " AND (year_alumni like '%$year%') ";
}
$objQuery36 = mysql_query($strSQL36) or die ("Error Query [".$strSQL36."]");
$objResult36 = mysql_fetch_array($objQuery36);
$id_alumni36= $objResult36["id_alumni"];
echo $id_alumni36;
?>
|
if($id_alumni6 != "0" and $id_alumni36 != "0" )
{
$per36=($id_alumni36*100)/$id_alumni6; echo number_format($per36,2) ;
}
else
{
echo '-';
}
?>
|
ปวช.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและการท่องเที่ยว(การโรงแรม) |
$year = $_POST['year'];
$strSQL52 = "SELECT * FROM studentend where 1 AND section_studentend='ปวช.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและการท่องเที่ยว(การโรงแรม)'";
if($year != "")
{
$strSQL52 .= " AND (year_studentend like '%$year%') ";
}
$objQuery52 = mysql_query($strSQL52) or die ("Error Query [".$strSQL52."]");
$objResult52 = mysql_fetch_array($objQuery52);
$quantity_studentend52= $objResult52["quantity_studentend"];
echo $quantity_studentend52;
?>
|
$year = $_POST['year'];
$strSQL7 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและการท่องเที่ยว(การโรงแรม)'";
if($year != "")
{
$strSQL7 .= " AND (year_alumni like '%$year%') ";
}
$objQuery7 = mysql_query($strSQL7) or die ("Error Query [".$strSQL7."]");
$objResult7 = mysql_fetch_array($objQuery7);
$id_alumni7= $objResult7["id_alumni"];
echo $id_alumni7;
?>
|
if($id_alumni7 != "" and $quantity_studentend52 != "" )
{
$per7=($id_alumni7*100)/$quantity_studentend52; echo number_format($per7,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL22 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและการท่องเที่ยว(การโรงแรม)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL22 .= " AND (year_alumni like '%$year%') ";
}
$objQuery22 = mysql_query($strSQL22) or die ("Error Query [".$strSQL22."]");
$objResult22 = mysql_fetch_array($objQuery22);
$id_alumni22= $objResult22["id_alumni"];
echo $id_alumni22;
?>
|
if($id_alumni7 != "0" and $id_alumni22 != "0" )
{
$per22=($id_alumni22*100)/$id_alumni7; echo number_format($per22,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL37 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวช.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและการท่องเที่ยว(การโรงแรม)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL37 .= " AND (year_alumni like '%$year%') ";
}
$objQuery37 = mysql_query($strSQL37) or die ("Error Query [".$strSQL37."]");
$objResult37 = mysql_fetch_array($objQuery37);
$id_alumni37= $objResult37["id_alumni"];
echo $id_alumni37;
?>
|
if($id_alumni7 != "0" and $id_alumni37 != "0" )
{
$per37=($id_alumni37*100)/$id_alumni7; echo number_format($per37,2) ;
}
else
{
echo '-';
}
?>
|
รวม |
$sum7=$quantity_studentend46+$quantity_studentend47+$quantity_studentend48+$quantity_studentend49+$quantity_studentend50+$quantity_studentend51+$quantity_studentend52; echo $sum7;?>
|
$sum1=$id_alumni1+$id_alumni2+$id_alumni3+$id_alumni4+$id_alumni5+$id_alumni6+$id_alumni7; echo $sum1;?>
|
if($sum1 != "" and $sum7 != "" )
{
$sumper1=($sum1*100)/$sum7; echo number_format($sumper1,2) ;
}
else
{
echo '-';
}
?>
|
$sum3=$id_alumni16+$id_alumni17+$id_alumni18+$id_alumni19+$id_alumni20+$id_alumni21+$id_alumni22; echo $sum3;?>
|
if($sum1 != "0" and $sum3 != "0" )
{
$sumper3=($sum3*100)/$sum1; echo number_format($sumper3,2) ;
}
else
{
echo '-';
}
?>
|
$sum5=$id_alumni31+$id_alumni32+$id_alumni33+$id_alumni34+$id_alumni35+$id_alumni36+$id_alumni37; echo $sum5;?>
|
if($sum1 != "0" and $sum5 != "0" )
{
$sumper5=($sum5*100)/$sum1; echo number_format($sumper5,2) ;
}
else
{
echo '-';
}
?>
|
ระดับ ปวส. |
|
|
|
|
|
|
|
ปวส.อุตสาหกรรม สาขาวิชาเครื่องกลไฟฟ้า(ไฟฟ้ากำลัง) |
$year = $_POST['year'];
$strSQL53 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.อุตสาหกรรม สาขาวิชาเครื่องกลไฟฟ้า(ไฟฟ้ากำลัง)'";
if($year != "")
{
$strSQL53 .= " AND (year_studentend like '%$year%') ";
}
$objQuery53 = mysql_query($strSQL53) or die ("Error Query [".$strSQL53."]");
$objResult53 = mysql_fetch_array($objQuery53);
$quantity_studentend53= $objResult53["quantity_studentend"];
echo $quantity_studentend53;
?>
|
$year = $_POST['year'];
$strSQL8 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรม สาขาวิชาเครื่องกลไฟฟ้า(ไฟฟ้ากำลัง)'";
if($year != "")
{
$strSQL8 .= " AND (year_alumni like '%$year%') ";
}
$objQuery8 = mysql_query($strSQL8) or die ("Error Query [".$strSQL8."]");
$objResult8 = mysql_fetch_array($objQuery8);
$id_alumni8= $objResult8["id_alumni"];
echo $id_alumni8;
?>
|
if($id_alumni8 != "" and $quantity_studentend53 != "" )
{
$per8=($id_alumni8*100)/$quantity_studentend53; echo number_format($per8,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL23 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรม สาขาวิชาเครื่องกลไฟฟ้า(ไฟฟ้ากำลัง)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL23 .= " AND (year_alumni like '%$year%') ";
}
$objQuery23 = mysql_query($strSQL23) or die ("Error Query [".$strSQL23."]");
$objResult23 = mysql_fetch_array($objQuery23);
$id_alumni23= $objResult23["id_alumni"];
echo $id_alumni23;
?>
|
if($id_alumni8 != "0" and $id_alumni23 != "0" )
{
$per23=($id_alumni23*100)/$id_alumni8; echo number_format($per23,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL38 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรม สาขาวิชาเครื่องกลไฟฟ้า(ไฟฟ้ากำลัง)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL38 .= " AND (year_alumni like '%$year%') ";
}
$objQuery38 = mysql_query($strSQL38) or die ("Error Query [".$strSQL38."]");
$objResult38 = mysql_fetch_array($objQuery38);
$id_alumni38= $objResult38["id_alumni"];
echo $id_alumni38;
?>
|
if($id_alumni8 != "0" and $id_alumni38 != "0" )
{
$per38=($id_alumni38*100)/$id_alumni8; echo number_format($per38,2) ;
}
else
{
echo '-';
}
?>
|
ปวส.อุตสาหกรรม สาขาวิชาการก่อสร้าง(การก่อสร้าง) |
$year = $_POST['year'];
$strSQL54 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.อุตสาหกรรม สาขาวิชาการก่อสร้าง(การก่อสร้าง)'";
if($year != "")
{
$strSQL54 .= " AND (year_studentend like '%$year%') ";
}
$objQuery54 = mysql_query($strSQL54) or die ("Error Query [".$strSQL54."]");
$objResult54 = mysql_fetch_array($objQuery54);
$quantity_studentend54= $objResult54["quantity_studentend"];
echo $quantity_studentend54;
?>
|
$year = $_POST['year'];
$strSQL9 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรม สาขาวิชาการก่อสร้าง(การก่อสร้าง)'";
if($year != "")
{
$strSQL9 .= " AND (year_alumni like '%$year%') ";
}
$objQuery9 = mysql_query($strSQL9) or die ("Error Query [".$strSQL9."]");
$objResult9 = mysql_fetch_array($objQuery9);
$id_alumni9= $objResult9["id_alumni"];
echo $id_alumni9;
?>
|
if($id_alumni9 != "" and $quantity_studentend54 != "" )
{
$per9=($id_alumni9*100)/$quantity_studentend54; echo number_format($per9,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL24 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรม สาขาวิชาการก่อสร้าง(การก่อสร้าง)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL24 .= " AND (year_alumni like '%$year%') ";
}
$objQuery24 = mysql_query($strSQL24) or die ("Error Query [".$strSQL24."]");
$objResult24 = mysql_fetch_array($objQuery24);
$id_alumni24= $objResult24["id_alumni"];
echo $id_alumni24;
?>
|
if($id_alumni9 != "0" and $id_alumni24 != "0" )
{
$per24=($id_alumni24*100)/$id_alumni9; echo number_format($per24,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL39 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรม สาขาวิชาการก่อสร้าง(การก่อสร้าง)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL39 .= " AND (year_alumni like '%$year%') ";
}
$objQuery39 = mysql_query($strSQL39) or die ("Error Query [".$strSQL39."]");
$objResult39 = mysql_fetch_array($objQuery39);
$id_alumni39= $objResult39["id_alumni"];
echo $id_alumni39;
?>
|
if($id_alumni9 != "0" and $id_alumni39 != "0" )
{
$per39=($id_alumni39*100)/$id_alumni9; echo number_format($per39,2) ;
}
else
{
echo '-';
}
?>
|
ปวส.บริหารธุรกิจ สาขาวิชาการบัญชี(ม.6) |
$year = $_POST['year'];
$strSQL55 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.บริหารธุรกิจ สาขาวิชาการบัญชี(ม.6)'";
if($year != "")
{
$strSQL55 .= " AND (year_studentend like '%$year%') ";
}
$objQuery55 = mysql_query($strSQL55) or die ("Error Query [".$strSQL55."]");
$objResult55 = mysql_fetch_array($objQuery55);
$quantity_studentend55= $objResult55["quantity_studentend"];
echo $quantity_studentend55;
?>
|
$year = $_POST['year'];
$strSQL10 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาการบัญชี(ม.6)'";
if($year != "")
{
$strSQL10 .= " AND (year_alumni like '%$year%') ";
}
$objQuery10 = mysql_query($strSQL10) or die ("Error Query [".$strSQL10."]");
$objResult10 = mysql_fetch_array($objQuery10);
$id_alumni10= $objResult10["id_alumni"];
echo $id_alumni10;
?>
|
if($id_alumni10 != "" and $quantity_studentend55 != "" )
{
$per10=($id_alumni10*100)/$quantity_studentend55; echo number_format($per10,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL25 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาการบัญชี(ม.6)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL25 .= " AND (year_alumni like '%$year%') ";
}
$objQuery25 = mysql_query($strSQL25) or die ("Error Query [".$strSQL25."]");
$objResult25 = mysql_fetch_array($objQuery25);
$id_alumni25= $objResult25["id_alumni"];
echo $id_alumni25;
?>
|
if($id_alumni10 != "0" and $id_alumni25 != "0" )
{
$per25=($id_alumni25*100)/$id_alumni10; echo number_format($per25,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL40 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาการบัญชี(ม.6)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL40 .= " AND (year_alumni like '%$year%') ";
}
$objQuery40 = mysql_query($strSQL40) or die ("Error Query [".$strSQL40."]");
$objResult40 = mysql_fetch_array($objQuery40);
$id_alumni40= $objResult40["id_alumni"];
echo $id_alumni40;
?>
|
if($id_alumni10 != "0" and $id_alumni40 != "0" )
{
$per40=($id_alumni40*100)/$id_alumni10; echo number_format($per40,2) ;
}
else
{
echo '-';
}
?>
|
ปวส.บริหารธุรกิจ สาขาวิชาการตลาด(ปวช.) |
$year = $_POST['year'];
$strSQL56 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.บริหารธุรกิจ สาขาวิชาการตลาด(ปวช.)'";
if($year != "")
{
$strSQL56 .= " AND (year_studentend like '%$year%') ";
}
$objQuery56 = mysql_query($strSQL56) or die ("Error Query [".$strSQL56."]");
$objResult56 = mysql_fetch_array($objQuery56);
$quantity_studentend56= $objResult56["quantity_studentend"];
echo $quantity_studentend56;
?>
|
$year = $_POST['year'];
$strSQL11 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาการตลาด(ปวช.)'";
if($year != "")
{
$strSQL11 .= " AND (year_alumni like '%$year%') ";
}
$objQuery11 = mysql_query($strSQL11) or die ("Error Query [".$strSQL11."]");
$objResult11 = mysql_fetch_array($objQuery11);
$id_alumni11= $objResult11["id_alumni"];
echo $id_alumni11;
?>
|
if($id_alumni11 != "" and $quantity_studentend56 != "" )
{
$per11=($id_alumni11*100)/$quantity_studentend56; echo number_format($per11,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL26 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาการตลาด(ปวช.)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL26 .= " AND (year_alumni like '%$year%') ";
}
$objQuery26 = mysql_query($strSQL26) or die ("Error Query [".$strSQL26."]");
$objResult26 = mysql_fetch_array($objQuery26);
$id_alumni26= $objResult26["id_alumni"];
echo $id_alumni26;
?>
|
if($id_alumni11 != "0" and $id_alumni26 != "0" )
{
$per26=($id_alumni26*100)/$id_alumni11; echo number_format($per26,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL41 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาการตลาด(ปวช.)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL41 .= " AND (year_alumni like '%$year%') ";
}
$objQuery41 = mysql_query($strSQL41) or die ("Error Query [".$strSQL41."]");
$objResult41 = mysql_fetch_array($objQuery41);
$id_alumni41= $objResult41["id_alumni"];
echo $id_alumni41;
?>
|
if($id_alumni11 != "0" and $id_alumni41 != "0" )
{
$per41=($id_alumni41*100)/$id_alumni11; echo number_format($per41,2) ;
}
else
{
echo '-';
}
?>
|
ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ปวช.) |
$year = $_POST['year'];
$strSQL57 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ปวช.)'";
if($year != "")
{
$strSQL57 .= " AND (year_studentend like '%$year%') ";
}
$objQuery57 = mysql_query($strSQL57) or die ("Error Query [".$strSQL57."]");
$objResult57 = mysql_fetch_array($objQuery57);
$quantity_studentend57= $objResult57["quantity_studentend"];
echo $quantity_studentend57;
?>
|
$year = $_POST['year'];
$strSQL12 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ปวช.)'";
if($year != "")
{
$strSQL12 .= " AND (year_alumni like '%$year%') ";
}
$objQuery12 = mysql_query($strSQL12) or die ("Error Query [".$strSQL12."]");
$objResult12 = mysql_fetch_array($objQuery12);
$id_alumni12= $objResult12["id_alumni"];
echo $id_alumni12;
?>
|
if($id_alumni12 != "" and $quantity_studentend57 != "" )
{
$per12=($id_alumni12*100)/$quantity_studentend57; echo number_format($per12,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL27 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ปวช.)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL27 .= " AND (year_alumni like '%$year%') ";
}
$objQuery27 = mysql_query($strSQL27) or die ("Error Query [".$strSQL27."]");
$objResult27 = mysql_fetch_array($objQuery27);
$id_alumni27= $objResult27["id_alumni"];
echo $id_alumni27;
?>
|
if($id_alumni12 != "0" and $id_alumni27 != "0" )
{
$per27=($id_alumni27*100)/$id_alumni12; echo number_format($per27,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL42 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ปวช.)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL42 .= " AND (year_alumni like '%$year%') ";
}
$objQuery42 = mysql_query($strSQL42) or die ("Error Query [".$strSQL42."]");
$objResult42 = mysql_fetch_array($objQuery42);
$id_alumni42= $objResult42["id_alumni"];
echo $id_alumni42;
?>
|
if($id_alumni12 != "0" and $id_alumni42 != "0" )
{
$per42=($id_alumni42*100)/$id_alumni12; echo number_format($per42,2) ;
}
else
{
echo '-';
}
?>
|
ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ม.6) |
$year = $_POST['year'];
$strSQL58 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ม.6)'";
if($year != "")
{
$strSQL58 .= " AND (year_studentend like '%$year%') ";
}
$objQuery58 = mysql_query($strSQL58) or die ("Error Query [".$strSQL58."]");
$objResult58 = mysql_fetch_array($objQuery58);
$quantity_studentend58= $objResult58["quantity_studentend"];
echo $quantity_studentend58;
?>
|
$year = $_POST['year'];
$strSQL13 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ม.6)'";
if($year != "")
{
$strSQL13 .= " AND (year_alumni like '%$year%') ";
}
$objQuery13 = mysql_query($strSQL13) or die ("Error Query [".$strSQL13."]");
$objResult13 = mysql_fetch_array($objQuery13);
$id_alumni13= $objResult13["id_alumni"];
echo $id_alumni13;
?>
|
if($id_alumni13 != "" and $quantity_studentend58 != "" )
{
$per13=($id_alumni13*100)/$quantity_studentend58; echo number_format($per13,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL28 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ม.6)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL28 .= " AND (year_alumni like '%$year%') ";
}
$objQuery28 = mysql_query($strSQL28) or die ("Error Query [".$strSQL28."]");
$objResult28 = mysql_fetch_array($objQuery28);
$id_alumni28= $objResult28["id_alumni"];
echo $id_alumni28;
?>
|
if($id_alumni13 != "0" and $id_alumni28 != "0" )
{
$per28=($id_alumni28*100)/$id_alumni13; echo number_format($per28,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL43 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.บริหารธุรกิจ สาขาวิชาคอมพิวเตอร์ธุรกิจ(ม.6)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL43 .= " AND (year_alumni like '%$year%') ";
}
$objQuery43 = mysql_query($strSQL43) or die ("Error Query [".$strSQL43."]");
$objResult43 = mysql_fetch_array($objQuery43);
$id_alumni43= $objResult43["id_alumni"];
echo $id_alumni43;
?>
|
if($id_alumni13 != "0" and $id_alumni43 != "0" )
{
$per43=($id_alumni43*100)/$id_alumni13; echo number_format($per43,2) ;
}
else
{
echo '-';
}
?>
|
ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ปวช.) |
$year = $_POST['year'];
$strSQL59 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ปวช.)'";
if($year != "")
{
$strSQL59 .= " AND (year_studentend like '%$year%') ";
}
$objQuery59 = mysql_query($strSQL59) or die ("Error Query [".$strSQL59."]");
$objResult59 = mysql_fetch_array($objQuery59);
$quantity_studentend59= $objResult59["quantity_studentend"];
echo $quantity_studentend59;
?>
|
$year = $_POST['year'];
$strSQL14 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ปวช.)'";
if($year != "")
{
$strSQL14 .= " AND (year_alumni like '%$year%') ";
}
$objQuery14 = mysql_query($strSQL14) or die ("Error Query [".$strSQL14."]");
$objResult14 = mysql_fetch_array($objQuery14);
$id_alumni14= $objResult14["id_alumni"];
echo $id_alumni14;
?>
|
if($id_alumni14 != "" and $quantity_studentend59 != "" )
{
$per14=($id_alumni14*100)/$quantity_studentend59; echo number_format($per14,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL29 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ปวช.)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL29 .= " AND (year_alumni like '%$year%') ";
}
$objQuery29 = mysql_query($strSQL29) or die ("Error Query [".$strSQL29."]");
$objResult29 = mysql_fetch_array($objQuery29);
$id_alumni29= $objResult29["id_alumni"];
echo $id_alumni29;
?>
|
if($id_alumni14 != "0" and $id_alumni29 != "0" )
{
$per29=($id_alumni29*100)/$id_alumni14; echo number_format($per29,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL44 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ปวช.)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL44 .= " AND (year_alumni like '%$year%') ";
}
$objQuery44 = mysql_query($strSQL44) or die ("Error Query [".$strSQL44."]");
$objResult44 = mysql_fetch_array($objQuery44);
$id_alumni44= $objResult44["id_alumni"];
echo $id_alumni44;
?>
|
if($id_alumni14 != "0" and $id_alumni44 != "0" )
{
$per44=($id_alumni44*100)/$id_alumni14; echo number_format($per44,2) ;
}
else
{
echo '-';
}
?>
|
ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ม.6) |
$year = $_POST['year'];
$strSQL60 = "SELECT * FROM studentend where 1 AND section_studentend='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ม.6)'";
if($year != "")
{
$strSQL60 .= " AND (year_studentend like '%$year%') ";
}
$objQuery60 = mysql_query($strSQL60) or die ("Error Query [".$strSQL60."]");
$objResult60 = mysql_fetch_array($objQuery60);
$quantity_studentend60= $objResult60["quantity_studentend"];
echo $quantity_studentend60;
?>
|
$year = $_POST['year'];
$strSQL15 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ม.6)'";
if($year != "")
{
$strSQL15 .= " AND (year_alumni like '%$year%') ";
}
$objQuery15 = mysql_query($strSQL15) or die ("Error Query [".$strSQL15."]");
$objResult15 = mysql_fetch_array($objQuery15);
$id_alumni15= $objResult15["id_alumni"];
echo $id_alumni15;
?>
|
if($id_alumni15 != "" and $quantity_studentend60 != "" )
{
$per15=($id_alumni15*100)/$quantity_studentend60; echo number_format($per15,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL30 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ม.6)' AND direct2_alumni='ตรง'";
if($year != "")
{
$strSQL30 .= " AND (year_alumni like '%$year%') ";
}
$objQuery30 = mysql_query($strSQL30) or die ("Error Query [".$strSQL30."]");
$objResult30 = mysql_fetch_array($objQuery30);
$id_alumni30= $objResult30["id_alumni"];
echo $id_alumni30;
?>
|
if($id_alumni15 != "0" and $id_alumni30 != "0" )
{
$per30=($id_alumni30*100)/$id_alumni15; echo number_format($per30,2) ;
}
else
{
echo '-';
}
?>
|
$year = $_POST['year'];
$strSQL45 = "SELECT COUNT(id_alumni) AS id_alumni FROM alumni where 1 AND vocation_alumni='ทำงาน' AND section_alumni='ปวส.อุตสาหกรรมการท่องเที่ยว สาขาวิชาการโรงแรมและบริการ(ม.6)' AND direct2_alumni='ไม่ตรง'";
if($year != "")
{
$strSQL45 .= " AND (year_alumni like '%$year%') ";
}
$objQuery45 = mysql_query($strSQL45) or die ("Error Query [".$strSQL45."]");
$objResult45 = mysql_fetch_array($objQuery45);
$id_alumni45= $objResult45["id_alumni"];
echo $id_alumni45;
?>
|
if($id_alumni15 != "0" and $id_alumni45 != "0" )
{
$per45=($id_alumni45*100)/$id_alumni15; echo number_format($per45,2) ;
}
else
{
echo '-';
}
?>
|
รวม |
$sum8=$quantity_studentend53+$quantity_studentend54+$quantity_studentend55+$quantity_studentend56+$quantity_studentend57+$quantity_studentend58+$quantity_studentend59+$quantity_studentend60; echo $sum8;?>
|
$sum2=$id_alumni8+$id_alumni9+$id_alumni10+$id_alumni11+$id_alumni12+$id_alumni13+$id_alumni14+$id_alumni15; echo $sum2;?>
|
if($sum2 != "" and $sum8 != "" )
{
$sumper2=($sum2*100)/$sum8; echo number_format($sumper2,2) ;
}
else
{
echo '-';
}
?>
|
$sum4=$id_alumni23+$id_alumni24+$id_alumni25+$id_alumni26+$id_alumni27+$id_alumni28+$id_alumni29+$id_alumni30; echo $sum4;?>
|
if($sum2 != "0" and $sum4 != "0" )
{
$sumper4=($sum4*100)/$sum2; echo number_format($sumper4,2) ;
}
else
{
echo '-';
}
?>
|
$sum6=$id_alumni38+$id_alumni39+$id_alumni40+$id_alumni41+$id_alumni42+$id_alumni43+$id_alumni44+$id_alumni45; echo $sum6;?>
|
if($sum2 != "0" and $sum6 != "0" )
{
$sumper6=($sum6*100)/$sum2; echo number_format($sumper6,2) ;
}
else
{
echo '-';
}
?>
|