query("SELECT * FROM branch WHERE deleted_at IS NULL") ; if ( $get_branch->num_rows > 0 ){ while ( $row_branch = $get_branch->fetch_assoc() ){ $branch_all[$row_branch['branch_id']] = $row_branch['branch_name'] ; } } //trash media if($_POST['trash_media']){ $media_id = $_POST['trash_media']; $today_date = date("Y-m-d H:i:s"); foreach($media_id as $value){ $update = $mysqli->query("UPDATE media SET deleted_at = '$today_date' WHERE media_id = '$value' "); } if($update){ $_SESSION['media_delete'] = 'success'; header('Refresh:0'); exit; }else{ $_SESSION['media_delete'] = 'failed'; header('Refresh:0'); exit; } } // form submit if ($_POST['hide'] == 1){ $boolean_redirect = false ; // set image in variable $image = $_FILES["image"]["name"] ; // check status switch($_POST['hide_status']){ case 'new' : if ( $image != '' ){ $filetype = $_FILES["image"]["type"]; $filetype = explode('/', $filetype)[1]; $mysqli->query("INSERT INTO media (filetype) VALUES ('$filetype')"); $id = $mysqli->insert_id; $file_name = 'media-'.$id.'.'.$filetype ; if(move_uploaded_file( $_FILES["image"]["tmp_name"], $_SERVER['DOCUMENT_ROOT'].'/uploads/Media/'.$file_name )){ $update = $mysqli->query("UPDATE media SET file = '$file_name' WHERE media_id = '$id'"); } if($update){ $_SESSION['media_upload'] = 'success'; header('Location: media-setting.php?page_mode=edit&page='.$id.''); exit; }else{ $_SESSION['media_upload'] = 'failed'; header('Refresh:0'); exit; } } break ; case 'edit' : $media_id = $_POST['hidden_media_id']; $remove_photo = $_POST['remove_photo'] ; if ($remove_photo == 1){ $update = $mysqli->query("UPDATE media SET file = '', filetype = '' WHERE media_id = '$media_id'"); } if($image != ''){ $filetype = $_FILES["image"]["type"]; $filetype = explode('/', $filetype)[1]; $file_name = 'media-'.$media_id.'.'.$filetype ; if(move_uploaded_file( $_FILES["image"]["tmp_name"], $_SERVER['DOCUMENT_ROOT'].'/uploads/Media/'.$file_name )){ $update = $mysqli->query("UPDATE media SET file = '$file_name' WHERE media_id = '$media_id'"); } if($update){ $_SESSION['media_edit'] = 'success'; header('Location: media-setting.php?page_mode=edit&page='.$media_id.''); exit; }else{ $_SESSION['media_edit'] = 'failed'; header('Location: media-setting.php?page_mode=edit&page='.$media_id.''); exit; } } break ; } } // mode type | all list | new | edit switch($page_mode){ // new customer case 'new' : // check permission if ( !permissionCheck($row_user, 'user-new-user-new') ){ header('Location: index.php') ; exit ; } // active menu bar $active_main_menu = 'setting' ; $active_sub_menu = 'setting-media' ; // start header here include 'requires/page_header.php' ; include 'requires/page_top.php' ; ?>

Sorry. Some error occured. Uplaod failed!' .'

' ; } unset($_SESSION['media_upload']); unset($_SESSION['media_edit']); ?>

query("SELECT * FROM media WHERE media_id = '$page' LIMIT 1"); $row_page = mysqli_fetch_assoc($mysqli_data); // start header here include 'requires/page_header.php'; include 'requires/page_top.php'; ?>

Media edit success' .'

' ; }else if($_SESSION['media_edit'] == 'failed'){ echo '

Media edit failed' .'

' ; }else if($_SESSION['media_upload'] == 'success'){ echo '

Media uplaoded sucess' .'

' ; } unset($_SESSION['media_upload']); unset($_SESSION['media_edit']); ?>

query($mysqli_query." ORDER BY created_at DESC LIMIT $start_from, " . $limit) ; // set search url $search_url = 'search='.$search ; // load pagination $page_pagination = nextPrevious($product_page, $limit, $search_url, $mysqli_query); // start header here include 'requires/page_header.php' ; include 'requires/page_top.php' ; ?>

num_rows > 0){ while ($row_page = $mysqli_page->fetch_array(MYSQLI_ASSOC)){ $media_id = $row_page['media_id']; $file = $row_page['file']; echo ' '; } }else{ echo ' ' ; } ?>


	'.PATH.'uploads/Media/'.dataFilter($row_page['file']).'		'.$row_page['created_at'].'
'.$lang['no_data'].'