Gecko [ myeducation.co.th ]

Name	Size	Permission
PageWrapper_0NotFound.php	498 B	-rw-r--r--
PageWrapper_0NotFound_New.php	317 B	-rw-r--r--
PageWrapper_1Home.php	4.44 KB	-rw-r--r--
PageWrapper_1Home_Edit.php	4.54 KB	-rw-r--r--
PageWrapper_1Home_List.php	4.11 KB	-rw-r--r--
PageWrapper_1Home_Profile.php	8.91 KB	-rw-r--r--
PageWrapper_AmphurList.php	3.98 KB	-rw-r--r--
PageWrapper_Category_Content.p...	1.82 KB	-rw-r--r--
PageWrapper_Category_Content_E...	2.85 KB	-rw-r--r--
PageWrapper_Category_Content_L...	3.5 KB	-rw-r--r--
PageWrapper_Category_Content_L...	4.05 KB	-rw-r--r--
PageWrapper_Category_Content_L...	668 B	-rw-r--r--
PageWrapper_Category_Content_L...	5.71 KB	-rw-r--r--
PageWrapper_Category_Content_L...	4.34 KB	-rw-r--r--
PageWrapper_Management_Content...	17.58 KB	-rw-r--r--
PageWrapper_Management_Content...	5.71 KB	-rw-r--r--
PageWrapper_Management_Content...	1.72 KB	-rw-r--r--
PageWrapper_Management_Content...	6.91 KB	-rw-r--r--
PageWrapper_MemberList.php	6.29 KB	-rw-r--r--
PageWrapper_NotFound.php	312 B	-rw-r--r--
PageWrapper_Product.php	10.07 KB	-rw-r--r--
PageWrapper_ProductEdut.php	20.96 KB	-rw-r--r--
PageWrapper_ProductProfile.php	3.63 KB	-rw-r--r--
PageWrapper_Product_Category.p...	2.59 KB	-rw-r--r--
PageWrapper_Product_Category2....	2.24 KB	-rw-r--r--
PageWrapper_Product_Category3....	4.45 KB	-rw-r--r--
PageWrapper_Product_CategoryEd...	3.2 KB	-rw-r--r--
PageWrapper_Product_CategoryEd...	3.68 KB	-rw-r--r--
PageWrapper_Product_CategoryEd...	7.98 KB	-rw-r--r--
PageWrapper_Product_Category_L...	3.58 KB	-rw-r--r--
PageWrapper_Product_Category_L...	5.87 KB	-rw-r--r--
PageWrapper_Product_Category_L...	4.59 KB	-rw-r--r--
PageWrapper_Product_Dash_Board...	2.97 KB	-rw-r--r--
PageWrapper_Product_Dash_Board...	3.28 KB	-rw-r--r--
PageWrapper_Product_Dash_Board...	10.1 KB	-rw-r--r--
PageWrapper_Product_List.php	5.7 KB	-rw-r--r--
PageWrapper_Product_Property.p...	4.77 KB	-rw-r--r--
PageWrapper_Product_PropertyEd...	4.01 KB	-rw-r--r--
PageWrapper_Product_Property_L...	3.75 KB	-rw-r--r--
PageWrapper_Province.php	2.1 KB	-rw-r--r--
PageWrapper_Province_Edit.php	1.84 KB	-rw-r--r--
PageWrapper_Register.php	18.03 KB	-rw-r--r--
PageWrapper_RegisterEdit.php	20.56 KB	-rw-r--r--
PageWrapper_Register_ShowHome....	3.87 KB	-rw-r--r--
PageWrapper_Showpage.php	1.66 KB	-rw-r--r--
PageWrapper_ShowpageEdut.php	1.73 KB	-rw-r--r--
PageWrapper_Showpage_List.php	1.87 KB	-rw-r--r--
PageWrapper_SubDistrict.php	3.77 KB	-rw-r--r--
PageWrapper_SubDistrict_Add.ph...	3.35 KB	-rw-r--r--
PageWrapper_SubDistrict_Edit.p...	2.96 KB	-rw-r--r--
PageWrapper_System_PaymentEdut...	4.67 KB	-rw-r--r--
PageWrapper_amphur.php	2.41 KB	-rw-r--r--
PageWrapper_amphur_Edit.php	4.46 KB	-rw-r--r--
PageWrapper_contact.php	2.97 KB	-rw-r--r--
PageWrapper_contactview.php	3.97 KB	-rw-r--r--
PageWrapper_system_payment_lis...	2.3 KB	-rw-r--r--
StatusShowPage.php	473 B	-rw-r--r--
Text_Froala_Editor.php	2.14 KB	-rw-r--r--
Text_Froala_Editor2.php	1.7 KB	-rw-r--r--

Code Editor : PageWrapper_Category_Content_Language_List.php

<?PHP
	include '../model/controller/v_config.php';   
	
	$CID = trim($_GET['ID']);

$str_sql="
	SELECT category_content_language.CategoryContentLanguage_ID, category_content_language.CategoryContent_ID, category_content.CategoryContent_Name, category_content_language.Member_ID, member.Member_PrefixNameEN, position.Position_Name, category_content_language.CategoryContentLanguage_NameTH, 
	member.Member_NameEN,
	category_content_language.CategoryContentLanguage_NameEN, category_content_language.CategoryContentLanguage_Date, category_content_language.CategoryContentLanguage_Time, category_content_language.CategoryContentLanguage_IMG
FROM category_content INNER JOIN (position INNER JOIN (member INNER JOIN category_content_language ON member.Member_ID = category_content_language.Member_ID) ON position.Position_ID = member.Position_ID) ON category_content.CategoryContent_ID = category_content_language.CategoryContent_ID
	WHERE category_content_language.StatusCategoryContentLanguage_ID = 1 AND
	category_content_language.CategoryContent_ID = $CID
	ORDER BY category_content_language.CategoryContent_ID
	";					
	$objQuery = $objConnect->query($str_sql);		
?>

<div class="table-responsive">		 
			<table class="table table-hover" id="module_datatable"  style="white-space: nowrap;">
				  
				<thead>
					<tr>
						<th>#</th>					
						<th> IMAGE </th>						
						<th> MENU </th>						
						<th> LANGUAGE </th>		
						<th> UPDATE </th>	
						<th> EDIT </th>
						<th> DELETE</th>
						
						<th> ADD CONTENT </th>
					</tr>
				</thead>
				<tbody>
					<?PHP
						$i = 0;
						while($objResult = mysqli_fetch_array($objQuery)) {		
						$i++;

$DataBase_ID = $objResult["CategoryContentLanguage_ID"];
						$CategoryContentID = $objResult["CategoryContent_ID"];

$str_sql2 = "
						SELECT content.Content_ID, content.CategoryContent_ID, category_content.CategoryContent_Name, content.CategoryContentLanguage_ID, category_content_language.CategoryContentLanguage_NameTH, category_content_language.CategoryContentLanguage_NameEN, category_content_language.CategoryContentLanguage_IMG, content.StatusContent_ID, Status_Content.StatusContent_Name, content.Member_ID, member.Member_PrefixNameEN, member.Member_NameEN, content.Content_Name, content.Content_Content1, content.Content_Content2, content.Content_Content3, content.Content_Content4, content.Content_Content5, content.Content_Sort, content.Content_Date, content.Content_Time, content.Content_Number, content.Content_Visitors, member.Position_ID, position.Position_Name
						FROM position INNER JOIN (member INNER JOIN (Status_Content INNER JOIN ((content INNER JOIN category_content ON content.CategoryContent_ID = category_content.CategoryContent_ID) INNER JOIN category_content_language ON content.CategoryContentLanguage_ID = category_content_language.CategoryContentLanguage_ID) ON Status_Content.StatusContent_ID = content.StatusContent_ID) ON member.Member_ID = content.Member_ID) ON position.Position_ID = member.Position_ID
						WHERE 
						content.CategoryContentLanguage_ID = $DataBase_ID AND
						content.CategoryContent_ID = $CategoryContentID 						
						ORDER BY content.Content_Name
						";					
						$objQuery2 = $objConnect->query($str_sql2);	
						$chk_num_CategoryContentLanguage = mysqli_num_rows($objQuery2);

<td><?=$objResult["CategoryContent_Name"];?></td>
						<td><?=$objResult["CategoryContentLanguage_NameTH"];?> / <?=$objResult["CategoryContentLanguage_NameEN"];?> </td>
					
						<td style="font-size: smaller;">
						<b><?=$objResult["Position_Name"];?> : </b> <?=$objResult["Member_NameEN"];?> 			
								<b>วันที่ : </b> <?=$objResult["CategoryContentLanguage_Date"];?> 
								<b>เวลา : </b> <?=$objResult["CategoryContentLanguage_Time"];?>							
									
							</td>

<?PHP if($chk_num_CategoryContentLanguage == 0){ ?>

<td>
							<a class="btn btn-danger glyphicon glyphicon-minus" 
							href="../model/controller/Delete_img.php?
											Per_ID=<?=$DataBase_ID;?>&
											ID=<?=$CategoryContentID;?>&
											table=category_content_language&
											Fut=CategoryContentLanguage_ID&
											Form=category_content_language&								
											"
							onClick="return confirm('DELETE THIS INFORMATION ?');"></a>
						</td>

<?PHP }else{ ?>

<?PHP } ?>

</tr>
						<?PHP
							}
						?>
				</tbody>
			</table>
		</div>

${this.title}

Code Editor : PageWrapper_Category_Content_Language_List.php