<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <?php function __autoload($filename) { require_once $filename . ".php"; } $obj_manage_data = new manage_data(); $result_article = $obj_manage_data->select_data("web_register"); $rs_article = mysql_fetch_array($result_article); while ($rs_article = mysql_fetch_array($result_article)) { echo "<br>article_title" . $rs_article[admin_id] . "<br>"; }
</style> <?php $id_cat_youtube=(explode("-",$_GET[id_cat_youtube])); $id_cat_youtube[0]; $id_cat_youtube[1]; //echo $id_cat_youtube[1]; ?> <!-- require new latest vdo --> <?php function __autoload($filename){ require_once("oop/".$filename.".php"); } $bj_manage = new manage_data(); $result_youtube = $bj_manage->select_data("youtupe where id_cat_youtupe = ".$id_cat_youtube[1]." order by id_youtupe DESC LIMIT 9"); ///$rum_vdo = mysql_num_rows($result_youtube); while($rs_youtube = mysql_fetch_array($result_youtube)){ $embed=$rs_youtube[embed_youtupe]; $title_youtupe=$rs_youtube[title_youtupe]; $id_youtupe=$rs_youtube[id_youtupe]; $id_cat_youtupe=$rs_youtube[id_cat_youtupe]; $thumbnailsPath="youtupe/".$id_cat_youtupe."/".$rs_youtube[id_youtupe]."/thumbnail"; if(!is_dir($thumbnailsPath)){ echo"11".$file; }else{ //else if($handle= opendir($thumbnailsPath)){
<?php $list_id = $_GET['list_id']; $bj = new manage_data(); $result = $bj->select_data("schedule_plan where list_id={$list_id}"); $rs = mysql_fetch_array($result); echo $rs['list_detail'];
require_once "../oop/" . $file_name . ".php"; } /*echo"admin_name".$admin_name."<br>"; echo"admin_surname".$admin_surname."<br>";*/ //echo"admin_username".$admin_username."<br>"; /*echo"admin_password".$admin_password."<br>"; echo"admin_status".$admin_status."<br>"; echo"admin_email".$admin_email."<br>"; echo"admin_address".$admin_address."<br>"; echo"dmin_tel".$dmin_tel."<br>"; */ $obj_manage_data = new manage_data(); $field_select = "admin_username"; //check user duplicate $table_condition = "admin where admin_username='******'"; $result_select_web = $obj_manage_data->select_data($table_condition, $field_select); $num = mysql_num_rows($result_select_web); //check url duplicate $field_select_url = "webre_url"; $table_condition_url = "web_register where webre_url='{$webre_url}'"; $result_select_web_url = $obj_manage_data->select_data($table_condition_url, $field_select_url); $num_url = mysql_num_rows($result_select_web_url); if ($num) { echo "{\"result\":\"user_duplicate\"}"; } else { if ($num_url) { echo "{\"result\":\"url_duplicate\"}"; } else { $table = "admin"; $field = "admin_name ,admin_surname,admin_username ,admin_password,admin_status ,admin_email ,admin_address ,admin_tel"; $values = "'{$admin_name}' ,'{$admin_surname}','{$admin_username}' ,'{$admin_password}','{$admin_status}' ,'{$admin_email}' ,'{$admin_address}' ,'{$admin_tel}'";
<?php $id_youtupe = trim($_GET[id_youtupe]); $ex_id_youtupe = explode("/", $id_youtupe); include_once "../../oop/manage_data.php"; $bj_manage = new manage_data(); $result_youtube = $bj_manage->select_data("youtupe where id_youtupe = {$ex_id_youtupe['1']}"); $rs_youtube = mysql_fetch_array($result_youtube); echo $rs_youtube[embed_youtupe];
<div class="boxTop"> <div class="boxTitle"> กิจกรรม/Update </div> </div> <div class="boxCenter"> <table> <?php $bj_manage = new manage_data(); $resultNews=$bj_manage->select_data("news where news_cat_id=2"); while($rsNews=mysql_fetch_array($resultNews)){ $news_cat_id=$rsNews[news_cat_id]; //จัดการกับรูปภาพ $thumbnailsPath="news/".$news_cat_id."/".$rsNews[news_id]."/thumbnail/"; if(!is_dir($thumbnailsPath)){ }else{ //else if($handle= opendir($thumbnailsPath)){ $imagesFiles = array(); while(false!=($file=readdir($handle))){ if($file!="." && $file!=".."){ $thumbnailsFile = $thumbnailsPath."/".$file; $fileType = pathinfo($thumbnaisFile);//แสดงpath $fileType = strtolower($fileType['extension']);//แสดงpathพร้อม แสดงนามสกุล
</div> <div class="id_youtupe" style="display:none;"> /1 </div> </div> <!-- <div class="contentYoutube"> <?=$embed?> </div> --> </div> <!-- streaming--> <?php $bj_manage = new manage_data(); $result_youtube = $bj_manage->select_data("youtupe order by id_youtupe DESC LIMIT 8"); ///$rum_vdo = mysql_num_rows($result_youtube); while($rs_youtube = mysql_fetch_array($result_youtube)){ $embed=$rs_youtube[embed_youtupe]; $title_youtupe=$rs_youtube[title_youtupe]; $id_youtupe=$rs_youtube[id_youtupe]; $id_cat_youtupe=$rs_youtube[id_cat_youtupe]; $thumbnailsPath="youtupe/".$id_cat_youtupe."/".$rs_youtube[id_youtupe]."/thumbnail"; if(!is_dir($thumbnailsPath)){ }else{ //else if($handle= opendir($thumbnailsPath)){ $imagesFiles = array();
$field_select="webre_id,webre_url,cat_webre_package ,admin_status"; $table_condition="web_register,webcat_register,admin where web_register.webre_cat_id=webcat_register.cat_webre_id and web_register.admin_id=admin.admin_id "; $result=$obj_manage_data->select_data($table_condition,$field_select); */ $webre_id = $_GET['webre_id']; //echo"webre_id"+$webre_id; function __autoload($file) { require_once "../oop/" . $file . ".php"; } $obj_manage_data = new manage_data(); $field_select = "webre_id,webre_url,webre_detail ,webre_start ,webre_end,webre_update ,cat_webre_package,cat_webre_detail ,admin_status,admin_name,admin_surname,admin_username ,admin_password,admin_status,admin_email ,admin_address ,admin_tel"; $table_condition = "web_register,webcat_register,admin\r\nwhere web_register.webre_cat_id=webcat_register.cat_webre_id \r\nand web_register.admin_id=admin.admin_id and webre_id='{$webre_id}'"; $result = $obj_manage_data->select_data($table_condition, $field_select); $rs = mysql_fetch_array($result); $num = mysql_num_rows($result); //echo"num=$num"; ?> <table> <tbody> <tr> <td> เว็บไชต์ ID </td> <td> <?php echo $rs[webre_id];
echo"<script>window.location=\"index.php?page=tv_system\";</script>"; }else{ echo"<script>window.location=\"index.php?page=tv_system\";</script>"; } } if($_POST['action_post']=="edit"){ include("oop/manage_data.php"); $bj_manage_data = new manage_data(); $table="schedule_plan"; $list_id=$_POST['list_id']; $condition="list_id=$list_id"; echo "list_id $list_id"; $result_select=$bj_manage_data->select_data("schedule_plan where list_id=$list_id"); $rs_select=mysql_fetch_array($result_select); //echo "list_picture".$rs_select[list_picture]; if(!$result){ echo "error".mysql_error(); }else{ @unlink("../schedule_plan/$rs_select[list_picture]"); echo"<script>window.location=\"index.php?page=tv_system\";</script>"; } //manage image $rand=rand(1,10000);
$host=$_SERVER['HTTP_HOST']; $userAsUrl = explode(".", $host); if($host!="www.nn-it.com"){ //echo"<script>window.location=\"../index.php?userUrlId=$userAsUrl[1]\"</script>"; $userUrlId=$userAsUrl; } $userUrlId=$_GET['userUrlId']; */ $userUrlId=$_GET['userUrlId']; function __autoload($filename){ require_once "oop/".$filename.".php"; } $obj_manage_data = new manage_data(); $result_admin=$obj_manage_data->select_data("admin where admin_username='******'"); $rs_num=mysql_num_rows($result_admin); if($rs_num){ $_SESSION['member_user_url']=$userUrlId; //echo"<script>window.location=\"../home.html\"</script>"; header('Location: ../view-home.html'); //header("Location: ../dispatcher.php?page=$userUrlId"); //header("Location: ../dispatcher.php?page=home"); //Usering on hosting //echo"<script>window.location=\"../index.php?page=home\"</script>"; }else{ echo"<script>alert(\"User can't found.\");</script>"; }
$result=$obj_manage_data->insert_data($table,$field,$values); if($result){ echo"{\"result\":\"success\"}"; } }//if action if($_POST['action']=="show_data"){ $field_select="webre_id,webre_url,cat_webre_package ,admin_status"; $table_condition="web_register,webcat_register,admin where web_register.webre_cat_id=webcat_register.cat_webre_id and web_register.admin_id=admin.admin_id group by webre_url"; $result=$obj_manage_data->select_data($table_condition,$field_select); $i=1; while($rs=mysql_fetch_array($result)){ ?> <tr> <td> <center> <?=$i?> </center> </td> <td> <?=$rs[webre_url]?> </td> <td>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <?php function __autoload($filename) { require_once $filename . ".php"; } $obj_manage_data = new manage_data(); $result_article = @$obj_manage_data->select_data(article); $rs_article = mysql_fetch_array($result_article); while ($rs_article = mysql_fetch_array($result_article)) { echo "<br>article_title" . $rs_article[article_title] . "<br>"; }
<?php $news_id = $_GET[news_id]; $bj_manage = new manage_data(); $resultNews = $bj_manage->select_data("news where news_id={$news_id}"); $rsNews = mysql_fetch_array($resultNews); echo $rsNews[news_detail];
function insert_data($table, $field, $vaule) { $strSQL = "INSERT INTO {$table} ({$field})VALUES({$vaule})"; mysql_query($strSQL); //$test = "INSERT INTO member()VALUES()"; } function edit_data($table, $setfield, $condition) { $strSQL = "UPDATE {$table} SET {$setfield} {$condition}"; mysql_query($strSQL); //$test ="UPDATE member set dd='aa' where user_id=100"; } function delete_data($table, $condition) { $strSQL = "DELETE FROM {$table} {$condition}"; mysql_query($strSQL); } } //$obj_connect_mysql= new connect_mysql(); $obj_manage_data = new manage_data(); //@$obj_manage_data->set_host_user_pass_dbname(); $obj_manage_data->set_host_user_pass_dbname("localhost", "root", "010535546", "nnit_db"); //select data $result_article = $obj_manage_data->select_data("*", "article"); $rs_article = mysql_fetch_array($result_article); while ($rs_article = mysql_fetch_array($result_article)) { echo "<br>article_title" . $rs_article[article_title] . "<br>"; } // //insert data //
<?php function __autoload($filename){ require_once($filename.".php"); } $bj = new manage_data(); $result=$bj->select_data("schedule_plan"); ?> <table width="100%" id="tableTv"> <thead> <tr bgcolor="#dddddd"> <th> <div class="txtTitle"> ลำดับ </div> </th> <th> <div class="txtTitle"> รายการ </div> </th> <th> <div class="txtTitle"> เริ่มเวลา </div> </th> <th> <div class="txtTitle"> จบเวลา </div>