<? include ("../connection/connect.php"); $sql = "select * from thesis inner join abstract on (abstract.abst_id=thesis.abst_id) inner join app on (app.app_id=thesis.app_id) inner join chepter on (chepter.ch_id=thesis.ch_id) inner join ref on (ref.ref_id=thesis.ref_id) inner join tbc on (tbc.tbc_id=thesis.tbc_id) inner join thesis_name on (thesis.proname_id=thesis_name.proname_id) inner join thesis_type on (thesis.projecttype_id=thesis_type.projecttype_id) inner join thesis_year on(thesis.year_id=thesis_year.year_id) inner join publishers on (publishers.pub_id=thesis.pub_id) inner join campus on (campus.campus_id=publishers.campus_id) inner join faculty on (faculty.faculty_id=publishers.faculty_id) inner join branch on (branch.branch_id=publishers.branch_id) where project_id=$id_thesis"; mysql_query("SET NAMES UTF8"); $result = mysql_query($sql); $row = mysql_num_rows($result); $fetch_st=mysql_fetch_array($result); //echo $row; //$fetch_st =mysql_fetch_array($result); $project_id=$fetch_st['project_id']; $pro_nameth =$fetch_st['pro_nameth']; $pro_nameeg =$fetch_st['pro_nameeg']; $projecttype_id =$fetch_st['projecttype_id']; //$university =$fetch_st['university']; $pro_year=$fetch_st['pro_year']; //ส่วนของผู้พัฒนา $sql_develop = "select * from pro_developer where project_id=$project_id"; $result_develop = mysql_query($sql_develop) or die(mysql_error()); $row_name_develop = mysql_num_rows($result_develop); if($row_name_develop != 1) { $i=1; while($fetch_develop = mysql_fetch_array($result_develop)) { $student_id = $fetch_develop['student_id']; $sql_name_develop = "select * from developer where student_id=$student_id"; $result_name_develop = mysql_query($sql_name_develop) or die(mysql_error()); $fetch_name = mysql_fetch_array($result_name_develop); if($name_develop == "") { $name_develop ="คนที่ ".$i." ". $fetch_name['lead_name']. "". $fetch_name['first_name']. " " . $fetch_name['ser_name']; } else { $name_develop = $name_develop."<br>"."คนที่ ".$i." ". $fetch_name['lead_name']. "". $fetch_name['first_name']. " " . $fetch_name['ser_name']; } $i++; } } else { $fetch_develop = mysql_fetch_array($result_develop); $student_id = $fetch_develop['student_id']; $sql_name_develop = "select * from developer where student_id=$student_id"; $result_name_develop = mysql_query($sql_name_develop) or die(mysql_error()); $fetch_name = mysql_fetch_array($result_name_develop); $name_develop = $fetch_name['lead_name']. "". $fetch_name['first_name']. "" . $fetch_name['ser_name']; } //ส่วนของคณะกรรมการ// $sql_contributor = "select * from pro_contributor where project_id=$project_id"; $result_contributor = mysql_query($sql_contributor) or die(mysql_error()); $num = mysql_num_rows($result_contributor); $fetch_contributor = mysql_fetch_array($result_contributor); $a=$fetch_contributor['contri_id']; $sql= "select * from contributor where contri_id=$a and status_con='1'"; $result_sql = mysql_query($sql); $num = mysql_num_rows($result_sql); //echo $num; $fet = mysql_fetch_array($result_sql); $master_contributor = $fet['contri_leadname'].$fet['contri_fname']." ".$fet['contri_lname']; //ส่วนของอาจารย์ที่ปรึกษา// $sql_aj = "select * from pro_aj where project_id=$project_id"; //echo $sql_aj . "<br>"; $result_aj = mysql_query($sql_aj) or die(mysql_error()); $row_name_aj= mysql_num_rows($result_aj); if($row_name_aj != 1) { while($fetch_aj = mysql_fetch_array($result_aj)) { $aj_id = $fetch_aj['aj_id']; $sql_name_aj = "select * from aj_comment where aj_id=$aj_id"; //echo "dddd : " . " " . $sql_name_aj . "<br>";// $result_name_aj= mysql_query($sql_name_aj) or die(mysql_error()); $fetch_nameaj= mysql_fetch_array($result_name_aj); if($name_aj== "") { $name_aj = $fetch_nameaj['aj_leadname']. "". $fetch_nameaj['aj_fname']. "" . $fetch_nameaj['aj_lname']; } else { $name_aj = $name_aj . " " . "และ". " " . $fetch_nameaj['aj_leadname']. "". $fetch_nameaj['aj_fname']. "" . $fetch_nameaj['aj_lname']; } } } else { $fetch_aj= mysql_fetch_array($result_aj); $aj_id = $fetch_aj['aj_id']; $sql_name_aj = "select * from aj_comment where aj_id=$aj_id"; //echo "sql1 : " . " " . $sql_name_aj . "<br>"; $result_name_aj = mysql_query($sql_name_aj) or die(mysql_error()); $fetch_nameaj = mysql_fetch_array($result_name_aj); $name_aj = $fetch_nameaj['aj_leadname']. "". $fetch_nameaj['aj_fname']. " " . $fetch_nameaj['aj_lname']; } ?> <table width="700" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td width="776"><form id="show_thesis" name="show_thesis" method="post" action="../register/login.php?id_thesis=<? echo $id_thesis;?>" enctype="multipart/form-data"> <div id="divResult"></div> <div align="center" id="newspaper-b"> <table width="650" height="321" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CADFFF"> <tr> <th height="36" colspan="2" ><div align="center" class="style12">รายละเอียดปริญญานิพนธ์</div></th> </tr> <tr> <td width="239" class="style12 style14"><div align="left" class="style19">ชื่อปริญญานิพนธ์ภาษาไทย (Title) : </div></td> <td width="405"><div align="left"><? echo $fetch_st['pro_nameth'];?></div></td> </tr> <tr> <td width="239" class="style18"><div align="left" class="style19">ชื่อปริญญานิพนธ์ภาษาอังกฤษ (English Title) : </div></td> <td><div align="left"><? echo $fetch_st['pro_nameeg'];?></div></td> </tr> <tr> <td width="239" valign="top" class="style18"> <div align="left" class="style19">ชื่อ- สกุลผู้พัฒนา (Creator) : </div></td> <td><div align="left"><? echo $name_develop?></div></td> </tr> <tr> <td width="239" valign="top" class="style18"><div align="left" class="style19">สถาบัน/หน่วยงาน (Publisher):</div></td> <td><div align="left"> <p>มหาวิทยาลัยเทคโนโลยีราชมงคลรัตนโกสินทร์ </p> </div> <p><? echo $fetch_st['campus_name'];?> คณะ <? echo $fetch_st['faculty_name'];?> สาขา <? echo $fetch_st['branch_name'];?></p></td> </tr> <tr> <td class="style18"><div align="left" class="style19">ประธานกรรมการ</div></td> <td><div align="left"><? echo $master_contributor ?> </div></td> </tr> <? $sql_contributor = "select * from pro_contributor where project_id=$project_id"; $result_contributor = mysql_query($sql_contributor) or die(mysql_error()); $num = mysql_num_rows($result_contributor); $i=1; while ($fetch_contributor = mysql_fetch_array($result_contributor)) { $a=$fetch_contributor['contri_id']; $sql= "select * from contributor where contri_id=$a and status_con=2"; $result_sql = mysql_query($sql); $num = mysql_num_rows($result_sql); //echo $num; $fet = mysql_fetch_array($result_sql); $mas_contributor = $fet['contri_leadname'].$fet['contri_fname']." ".$fet['contri_lname']; if ($num!=0) { ?> <tr> <td><div align="left" class="style19">กรรมการ <? /*echo $i; */?></div></td> <td><div align="left"> <? echo $mas_contributor; ?> </div></td> </tr> <? $i++; } } ?> <tr> <td width="239" valign="top" class="style18"><div align="left" class="style19">อาจารย์ที่ปรึกษา(Commenttator ): </div></td> <td><div align="left"><? echo $name_aj?></div></td> </tr> <tr> <td width="239" class="style18"><div align="left" class="style19">ปีที่พัฒนา (Year):</div></td> <td><div align="left"><? echo $fetch_st['year_name'];?></div></td> </tr> <tr> <td class="style18"><div align="left" class="style19">ประเภทปริญญานิพนธ์ (Type): </div></td> <td><div align="left"><? echo $fetch_st ['projecttype_name'] ?></div></td> </tr> <tr> <td height="26" class="style18"><div align="left" class="style19">บทคัดย่อไทย (Thai Abstract):</div></td> <td><div align="left"><a href="../admin/upload_pdf/abstract/<? echo $fetch_st['abstname_th']; ?>"></a><a href="../admin/upload_pdf/abstract/<? echo $fetch_st['abstname_eg']; ?>"><img src="../images/icon-pdf.png" alt="" width="18" height="19" border="0" /></a></div></td> </tr> <tr> <td height="26" class="style18"><div align="left" class="style19">บทคัดย่อภาษาอังกฤษ (English Abstract):</div></td> <td><a href="../admin/upload_pdf/abstract/<? echo $fetch_st['abstname_eg']; ?>"><div align="left"><img src="../images/icon-pdf.png" alt="" width="18" height="19" border="0" /></div></a></td> </tr> <tr> <td height="26" class="style18"><div align="left" class="style19">เอกสารฉบับเต็ม (Fulltext): </div></td> <td><div align="left"> <input name="input" type="submit" value="ดาวน์โหลดเอกสารฉบับเต็ม" /><input name="input" type="submit" value="ยืมซีดีแนบปริญญานิพนธ์" /> </div></td> </tr> <? $i++; ?> </table> <p> </p> </form></td> </tr> </table> <p> </p>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
Load balance : Server 01
Load balance : Server 01
