require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); include '../../include/conf.php'; session_start(); date_default_timezone_set('Asia/Kolkata'); $mal_ses_id=$_SESSION['userid']; $MALA_CU_DAY_AR_KAR=date("Y-m-d"); $prodid=$_REQUEST['prodid']; $id_pay = $_REQUEST['id_pay']; $mas=date('Y-m-d', strtotime($_REQUEST["prodid"])); $n_t_d=strtotime($mas); $id=strtotime($mas); ?> $Query_sp_in = "SELECT * from shop_category "; $name_fin_sp_in=$DB->query($Query_sp_in); $num_max_job_sp_in=mysql_num_rows($name_fin_sp_in); while ($name_j_sp_in = mysql_fetch_array($name_fin_sp_in)) { ?> } $get_app = mysqli_query($conn, "select * from tbl_appointment_office where id='$id_pay'"); $set_app = mysqli_fetch_array($get_app, MYSQLI_ASSOC); $formattedTime = sprintf('%02d:%02d', $set_app['hour_date'], $set_app['min_date']); $mytime = $formattedTime.' '.$set_app['am_date']; ?>