PHP common::delete Examples

Example #1

File: articles_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    $obj_setting->delete('news_category', "id={$id}");
    $_SESSION['success_msg'] = 'Category deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/page/news_category.php' . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('news_category', "id={$id}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT category_name FROM news_category id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->tab_title;
} else {
    $pageName = 'There is no Category exists with this id.';
}
unset($obj_setting);

Example #2

File: code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

/********************************************************************************************************************

#Coder       : Kapil Verma

#Description : This Code is used to display list of all product and remove any on them 


*********************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_product = new common();
$currentTimestamp = getCurrentTimestamp();
if ($prod_id != '' && $action == 'delete') {
    $deleteProduct = $obj_product->delete(TBL_MEMBER, 'id =' . $prod_id);
    unlink(LIST_ROOT_ADMIN . "/members/upload/" . $file);
    $_SESSION['msg'] = RECORD_DELETE;
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/admin/members/index.php";</script>';
}
$getProduct = $obj_product->read(TBL_MEMBER);
?>

Example #3

File: code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

/********************************************************************************************************************

#Coder       : Manoj Pandit

#Description : This Code is used to display list of all product and remove any on them 


*********************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_block = new common();
$currentTimestamp = getCurrentTimestamp();
if ($model_id != '' && $action == 'delete') {
    $logoname = $obj_block->getNameById(TBL__HTMLTEMPLATE, 'id=' . $model_id);
    /*if($logoname->image!='') {
    		@chmod(LIST_ROOT_ADMIN."/images/new_model/",0777);
    		unlink(LIST_ROOT_ADMIN."/images/new_model/".$logoname->image);
    				
    	}*/
    $deleteProduct = $obj_block->delete(TBL__HTMLTEMPLATE, 'id =' . $model_id);
    $_SESSION['msg'] = 'Car Template Successfully Deleted';
    unset($obj_block);
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/htmltemplate/index.php";</script>';
    exit;
}
$getBlock = $obj_block->read(TBL__HTMLTEMPLATE, '', ' creation_date DESC');
unset($obj_block);

Example #4

File: page_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('pages', " id={$pageid}");
    $_SESSION['success_msg'] = 'Page deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/page/index.php' . $addToUrl . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('pages', " id={$pageid}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT name FROM pages where id='" . $pageid . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->name;
} else {
    $pageName = 'There is no page exists with this page id.';
}
unset($obj_setting);

Example #5

File: code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

/********************************************************************************************************************

#Coder       : Manoj Pandit

#Description : This Code is used to display list of all product and remove any on them 


*********************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_block = new common();
$currentTimestamp = getCurrentTimestamp();
if ($model_id != '' && $action == 'delete') {
    $logoname = $obj_block->getNameById(TBL_NEW_MODEL, 'id=' . $model_id);
    /*if($logoname->image!='') {
    		@chmod(LIST_ROOT_ADMIN."/images/new_model/",0777);
    		unlink(LIST_ROOT_ADMIN."/images/new_model/".$logoname->image);
    				
    	}*/
    $deleteProduct = $obj_block->delete(TBL_NEW_MODEL, 'id =' . $model_id);
    $_SESSION['msg'] = 'New Model Successfully Deleted';
    unset($obj_block);
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/new_model/index.php";</script>';
    exit;
}
$getBlock = $obj_block->read(TBL_NEW_MODEL, '', ' creation_date DESC');
unset($obj_block);

Example #6

File: contact_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('contact', " id={$id}");
    $_SESSION['success_msg'] = 'Enquiry deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/contact/car/index.php' . $addToUrl . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('contact', " id={$contactid}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT * FROM contact where id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->name;
} else {
    $pageName = 'No enquiry exists with this id.';
}
unset($obj_setting);

Example #7

File: contact_multiple_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('email_log', " id IN('{$pageid}')");
    $_SESSION['success_msg'] = 'Enquiry deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/contact/log/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('contact', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT * FROM email_log where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->name;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'No Enquiry exists with these ids.';

Example #8

File: delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
echo $totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('brands', " id IN('{$pageid}')");
    $_SESSION['success_msg'] = 'Brands deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/new_stock/brands/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('brands', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT * FROM brands where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->title;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'No Enquiry exists with these ids.';

Example #9

File: news_category_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    $obj_setting->delete('news_category', "id={$id}");
    $obj_setting->delete('news_articles', "category_id={$id}");
    $_SESSION['success_msg'] = 'Category and its associated articles deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/page/news_category.php' . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('news_category', "id={$id}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT category_name FROM news_category id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->tab_title;
} else {
    $pageName = 'There is no Category exists with this id.';
}
unset($obj_setting);

Example #10

File: accessories_multiple_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    $obj_setting->delete('accessories', " id IN('{$id}')");
    $_SESSION['success_msg'] = 'Products deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/accessories/index.php' . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('accessories', " id IN('{$totalIds}')");
if ($total_rows < 0) {
    $pageName = 'There are no accessories exists with these banner ids.';
}
unset($obj_setting);

Example #11

File: guest_multiple_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode(",", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('contact', " FIND_IN_SET(id,'{$pageid}')");
    $_SESSION['success_msg'] = 'Enquiry deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/contact/general/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('contact', " FIND_IN_SET(id,'{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT * FROM contact where FIND_IN_SET(id,'{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->name;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'No Enquiry exists with these ids.';

Example #12

File: banner_multiple_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('banner', " id IN('{$pageid}')");
    $_SESSION['success_msg'] = 'Banner deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/banner/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('banner', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT * FROM banner where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->title;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'No Banner exists with these ids.';

Example #13

File: contact_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('email_log', " id={$id}");
    $_SESSION['success_msg'] = 'Enquiry deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/contact/log/index.php' . $addToUrl . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('email_log', " id={$contactid}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT * FROM email_log where id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->email;
} else {
    $pageName = 'No enquiry exists with this id.';
}
unset($obj_setting);

Example #14

File: page_edit_code.php Project: pankajsinghjarial/SYLC-NEWSITE

        /*
        echo "<pre>";
        print_r($_FILES);
        print_r($_POST); 
        print_r($medias);
        die;
        */
        if (isset($main_image)) {
            if ($main_image) {
                $image_name = $main_image;
            } else {
                $image_name = time() . '-' . $_FILES['image']['name'];
                //$path = LIST_ROOT.'/images/reviews/media/';
                $path = LIST_ROOT_ADMIN_REVIEW_IMAGEPATH . '/';
                move_uploaded_file($_FILES["image"]["tmp_name"], $path . $image_name);
            }
        }
        $_SESSION['success_msg'] = 'Review has been updated successfully.';
        $dataArr = array('short_description' => $short_description, 'old_new' => $old_new, 'editorial' => $editorial, 'pdsf' => $pdsf, 'mpg' => $mpg, 'image' => $image_name, 'make' => $make, 'model' => $model, 'year' => $year, 'expert' => $expert, 'ensemble' => $ensemble, 'characteristique' => $characteristique, 'updated' => getCurrentTimestamp(), 'make_name' => $make_name, 'model_name' => $model_name);
        $review_id = $obj_setting->update('reviews', $dataArr, "id=" . $id);
        $obj_setting->delete('reviews_media', " review_id IN('{$id}')");
        foreach ($medias as $media) {
            $dataArrMedia = array('review_id' => $id, 'media_type' => $media['mediatype'], 'order_id' => $media['order'], 'media_name' => $media['value'], 'updated' => getCurrentTimestamp());
            $review_media_id = $obj_setting->save('reviews_media', $dataArrMedia);
        }
        echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/reviews";</script>';
        exit;
    }
}
unset($obj_setting);
unset($obj);

Example #15

File: guest_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('car_inquiry', " id={$id}");
    $_SESSION['success_msg'] = 'Enquiry deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/contact/guest/index.php' . $addToUrl . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('car_inquiry', " id={$contactid}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT * FROM car_inquiry where id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->name;
} else {
    $pageName = 'No enquiry exists with this id.';
}
unset($obj_setting);

Example #16

File: news_category_multiple_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    $obj_setting->delete('news_category', "id IN('{$id}')");
    $obj_setting->delete('news_articles', "category_id IN('{$id}')");
    $_SESSION['success_msg'] = 'Category and its associated articles deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/page/news_category.php' . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('news_category', "id IN('{$totalIds}')");
if ($total_rows < 0) {
    $pageName = 'There are no Category exists with these ids.';
}
unset($obj_setting);

Example #17

File: code.php Project: pankajsinghjarial/SYLC-NEWSITE

/********************************************************************************************************************

#Coder       : Keshav Sharma

#Description : This Code is used to display list of all product and remove any on them 


*********************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_block = new common();
$currentTimestamp = getCurrentTimestamp();
if ($bid != '' && $action == 'delete') {
    $logoname = $obj_block->getNameById(TBL_USED_CAR, 'id=' . $bid);
    //chmod(DEFAULT_ADMIN_URL."/images/used_car/image/",0777);
    if ($logoname->image != '') {
        unlink(LIST_ROOT_ADMIN . "/images/used_car/image/" . $logoname->image);
    }
    //chmod(DEFAULT_ADMIN_URL."/images/used_car/dispo/",0777);
    if ($logoname->dispo != '') {
        unlink(LIST_ROOT_ADMIN . "/images/used_car/dispo/" . $logoname->dispo);
    }
    $deleteProduct = $obj_block->delete(TBL_USED_CAR, 'id =' . $bid);
    $_SESSION['msg'] = 'Car Successfully Deleted';
    unset($obj_block);
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/used_car/index.php";</script>';
    exit;
}
$getBlock = $obj_block->read(TBL_USED_CAR, '', ' creation_date DESC');
unset($obj_block);

Example #18

File: home_banner_multiple_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    $obj_setting->delete('rot_banner', " id IN('{$id}')");
    $_SESSION['success_msg'] = 'Banner deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/home/index.php' . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('rot_banner', " id IN('{$totalIds}')");
if ($total_rows < 0) {
    $pageName = 'There are no banner exists with these banner ids.';
}
unset($obj_setting);

Example #19

File: code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

/********************************************************************************************************************

#Coder       : Keshav Sharma

#Description : This Code is used to display list of all product and remove any on them 


*********************************************************************************************************************/
extract($_GET);
extract($_POST);
$obj_block = new common();
$currentTimestamp = getCurrentTimestamp();
if ($bid != '' && $action == 'delete') {
    $deleteProduct = $obj_block->delete(TBL_LEADS, 'id =' . $bid);
    $_SESSION['msg'] = 'User info Successfully Deleted';
    unset($obj_block);
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/leads/index.php";</script>';
    exit;
}
$getBlock = $obj_block->read(TBL_LEADS, '', ' created_at DESC');
unset($obj_block);

Example #20

File: logistique_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    $obj_setting->delete('content_page', " id={$id}");
    $_SESSION['success_msg'] = 'Tab deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/logistique/index.php' . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('content_page', " id={$id}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT tab_title FROM content_page where page_name='logistique' and id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->tab_title;
} else {
    $pageName = 'There is no Tab exists with this id.';
}
unset($obj_setting);

Example #21

File: guest_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('newsletter_subscriber', " id={$id}");
    $_SESSION['success_msg'] = 'Enquiry deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/contact/newsletter/index.php' . $addToUrl . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('newsletter_subscriber', " id={$id}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT * FROM newsletter_subscriber where id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->name;
} else {
    $pageName = 'No enquiry exists with this id.';
}
unset($obj_setting);

Example #22

File: contact_multiple_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('contact', " id IN('{$pageid}')");
    $_SESSION['success_msg'] = 'Enquiry deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/contact/consult/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('contact', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT * FROM contact where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->name;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'No Enquiry exists with these ids.';

Example #23

File: car_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($car_id) and $car_id != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $total_rows = $obj_setting->numberOfRows('car', " car_id={$car_id}");
    if ($total_rows > 0) {
        $obj_setting->delete('car', " car_id={$car_id}");
        $obj_setting->delete('contact', " car_id={$car_id}");
        $obj_setting->delete('car_flat', " car_id={$car_id}");
        $_SESSION['success_msg'] = 'Car deleted successfully.';
        if (!empty($_REQUEST['type']) && $_REQUEST['type'] == 'nostock') {
            echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/new_stock/new_car/index.php";</script>';
        }
        echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/car/index.php' . $addToUrl . '";</script>';
    } else {
        $pageName = 'There is no car exists with this car id.';
    }
}
unset($obj_setting);

Example #24

File: sync.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

include_once "../conf/config.inc.php";
$common = new common();
$timenow = mktime();
$expireid = $common->CustomQuery("SELECT * FROM `ebay_car` where endtimestamp < " . $timenow);
while ($expire = mysql_fetch_object($expireid)) {
    $common->delete('contact', " car_id={$expire->car_id}");
    $common->delete('ebay_car', " car_id={$expire->car_id}");
}

Example #25

File: car_multiple_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode(",", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if ($totalIds != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('car', " car_id IN ({$totalIds})");
    $obj_setting->delete('contact', " car_id IN ({$totalIds})");
    $_SESSION['success_msg'] = 'Cars deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/car/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('pages', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT name FROM pages where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->name;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {

Example #26

File: page_multiple_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('pages', " id IN('{$pageid}')");
    $_SESSION['success_msg'] = 'Pages deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/page/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('pages', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT name FROM pages where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->name;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'There are no pages exists with these page ids.';

Example #27

File: home_banner_delete_code.php Project: pankajsinghjarial/SYLC-NEWSITE

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    $obj_setting->delete('rot_banner', " id={$id}");
    $_SESSION['success_msg'] = 'Banner deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/home/index.php' . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('rot_banner', " id={$id}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT name FROM rot_banner where id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->name;
} else {
    $pageName = 'There is no banner exists with this page id.';
}
unset($obj_setting);

Example #28

File: user_multiple_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
$totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($totalIds) and $totalIds != '') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('users', " id IN('{$totalIds}')");
    $_SESSION['success_msg'] = 'User deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/users/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('users', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT * FROM users where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->name;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'No User exists with these ids.';

Example #29

File: faq_delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
$obj_setting = new common();
if (isset($id) and $id != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('faq', " id={$id}");
    $_SESSION['success_msg'] = 'FAQ deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/faq/index.php' . $addToUrl . '";</script>';
}
$total_rows = $obj_setting->numberOfRows('faq', " id={$contactid}");
if ($total_rows > 0) {
    $singlePage = $obj_setting->customQuery("SELECT * FROM faq where id='" . $id . "'");
    $getPageName = $db->fetchNextObject($singlePage);
    $pageName = $getPageName->name;
} else {
    $pageName = 'No FAQ exists with this id.';
}
unset($obj_setting);

Example #30

File: delete_code.php Project: pankajsinghjarial/SYLC-AMERICAN

<?php

extract($_GET);
extract($_POST);
#getting array of ids from multiple checkbox and then imploding those ids with ',' to put in IN()
echo $totalIds = implode("','", $allselect);
$obj_setting = new common();
# Here we are deleting all selected pages
if (isset($pageid) and $pageid != '' and isset($action) and $action == 'delete') {
    if (isset($searchtext) and $searchtext != '') {
        $addToUrl = '?searchtext=' . $searchtext . '&searchcombo=' . $searchcombo;
    } else {
        $addToUrl = '';
    }
    $obj_setting->delete('new_car', " id IN('{$pageid}')");
    $_SESSION['success_msg'] = 'Cars deleted successfully.';
    echo '<script>location.href="' . DEFAULT_ADMIN_URL . '/new_stock/new_car/index.php' . $addToUrl . '";</script>';
}
#taking imploded ids and checking if these ids exists in database or not
#if not then we are showing error message and if found then we are fetching names
#of those pages to show
$total_rows = $obj_setting->numberOfRows('new_car', " id IN('{$totalIds}')");
if ($total_rows > 0) {
    $totalNames = array();
    $singlePage = $obj_setting->customQuery("SELECT * FROM new_car where id IN('{$totalIds}')");
    while ($getPageName = $db->fetchNextObject($singlePage)) {
        $totalNames[] = $getPageName->model_name;
    }
    $pageName = implode("&nbsp;,&nbsp;", $totalNames);
} else {
    $pageName = 'No Enquiry exists with these ids.';