<option value="1">Yes</option>
<option value="0">No</option>
</select>
</th>
</tr>
</thead>
<tbody onload="loading()">
<!--<div id="loading" style="position: absolute; z-index: 2; background: #000; width: 940px; height: 200px"></div>-->
<?php if($total_query < 1){?><tr><td class="no-record" colspan="8">No records found.</td></tr><?php }?>
<?php
$row=0;
foreach($data as $inspiration){
$loop_data = get_inspiration($inspiration['inspiration_id']);
?>
<tr id="<?php echo "row_".$row?>" onclick="selectRow('<?php echo $row;?>')">
<td width="38"><input type="checkbox" value="<?php echo $inspiration['inspiration_id']?>" name="inspiration_id[]" id="<?php echo "check_".$row?>" onmouseover="downCheck()" onmouseout="upCheck()" onclick="selectRowCheck('<?php echo $row;?>')"></td>
<td width="652"><a href="<?php echo $prefix_url."project-detail/".$inspiration['inspiration_id'];?>"><?php echo $inspiration['name'];?></a></td>
<td width="135"><?php echo format_date($inspiration['date_created']);?></td>
<td width="135" class="hidden"><?php echo view_status('active', $loop_data['active']);?></td>
<td width="135"><?php echo view_status('inspiration_visibility', $loop_data['inspiration_visibility']);?></td>
</tr>
<?php
$row++;
}
?>
<?php
// PREDEFINED VALUE
$inspiration_id = clean_number($_REQUEST['ins_id']);
// CALL FUNCTION
$inspiration = get_inspiration($inspiration_id);
$banner = get_inspiration_images($inspiration_id);
$latest_id_img = get_latest_inspiration_image_id();
$count_images = count_inspiration_images($inspiration_id);
$products = get_products();
$featured_ct = get_inspiration_featured($inspiration_id);
$featured_js = get_inspiration_featured($inspiration_id);
$category = get_category();
/* -- FUNCTIONS -- */
if(isset($_POST['btn_edit_inspiration'])){
/* -- INSPIRATION -- */
// PREDEFINED VALUE
$name = addslashes($_POST['inspiration_name']);
$description = '';
$date_created = current_date_sql();
$active = 1;
$visibility = 1;
$sort = $_POST['order_banner'];
$category = $_POST['inspiration_category'];
// DELETE
if ($_POST['option-action'] == "delete") {
foreach ($inspiration_id as $inspiration_id) {
// DELETING IMAGES
delete_inspiration_image($inspiration_id);
// DELETING FEATURED
delete_inspiration_featured($inspiration_id);
// DELETING INSPIRATION
delete_inspiration($inspiration_id);
}
$_SESSION['alert'] = "success";
$_SESSION['msg'] = "Success delete item(s)";
} else {
if ($_POST['option-action'] == "visibility") {
foreach ($inspiration_id as $inspiration_id) {
$get_data = get_inspiration($inspiration_id);
// PREDEFINED VALUE
$name = "";
$description = "";
$active = "";
$visibility = $_POST['option-option'];
if ($visibility == "yes") {
update_inspirations(1, $inspiration_id);
} else {
update_inspirations(0, $inspiration_id);
}
}
$_SESSION['alert'] = "success";
$_SESSION['msg'] = "Changes successfuly saved";
}
}
<?php
include "../../../static/general.php";
include "../../../../static/general.php";
// DEFINED VARIABLE
$ajx_id = $_POST['bid'];
function get_inspiration($post_ins_id)
{
$conn = connDB();
$sql = "SELECT * FROM tbl_inspiration_image WHERE `inspiration_image_id` = '{$post_ins_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
function delete_inspiration($post_ins_id)
{
$conn = connDB();
$sql = "DELETE FROM tbl_inspiration_image WHERE `inspiration_image_id` = '{$post_ins_id}'";
$query = mysql_query($sql, $conn);
$result = mysql_fetch_array($query);
return $result;
}
// CALL FUNCTION
$get_inspiration = get_inspiration($ajx_id);
if (!empty($ajx_id)) {
unlink("../../../../../" . $get_inspiration['image']);
delete_inspiration($ajx_id);
}
