bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php
ini_set('display_errors', 1);
require_once("includes/application_includes.php");
$db = new Database(DB_SERVER,DB_USER,DB_PASSWORD,'bmse');

$orderdetails = $db->getRows("SELECT * FROM `bmse_order_details` WHERE  `expoidstatus`='update' order by id DESC limit 2000");

$i=$j=$k=$total=0;
foreach($orderdetails as $orderdetail) {
  
    
    # Booths
    if ($orderdetail['item_type_id']==1) {
        $expoinfo = $db->getRow("SELECT `expo_id` FROM `bmse_expo_rooms` WHERE `id`=".$orderdetail['item_id']." and type=1");
        
        
        if ($expoinfo) {
            $db->Query("UPDATE `bmse_order_details` set `expo_id`=".$expoinfo['expo_id'].", `expoidstatus`='updated' WHERE `id`=".$orderdetail['id']."");
            $i++;
        }
        
    }
    
    # Lectures
    if ($orderdetail['item_type_id']==2) {
        $expoinfo = $db->getRow("SELECT `expo_id` FROM `bmse_expo_lecture_slots` WHERE `id`=".$orderdetail['item_id']."");
        
        if ($expoinfo) {
            $db->Query("UPDATE `bmse_order_details` set `expo_id`=".$expoinfo['expo_id'].", `expoidstatus`='updated' WHERE `id`=".$orderdetail['id']."");
            $j++;
        }
    }
    
    # extras, electricity, late fee and transfer fees
    if ($orderdetail['item_type_id']==4 || $orderdetail['item_type_id']==5 || $orderdetail['item_type_id']==7 || $orderdetail['item_type_id']==8) {
        $expoinfo = $db->getRow("SELECT `expo_id` FROM `bmse_expo_rooms` WHERE `id`=".$orderdetail['booth_id']." and type=1");
       
        if ($expoinfo) {
            $db->Query("UPDATE `bmse_order_details` set `expo_id`=".$expoinfo['expo_id'].", `expoidstatus`='updated' WHERE `id`=".$orderdetail['id']."");
            $k++;
        }
    }
    
    
    $total=$i+$j+$k;
}

echo "Updated records - $total";