$product_mal="active"; $caller1="open"; $pro_de_mal="active"; require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); session_start(); ?> if(isset($_POST['sumbit'])) { if ($_REQUEST["form_action"] == "Insert") { date_default_timezone_set('Asia/Kolkata'); $date_ss = date('Y-m-d H:i:s ', time()); $tablename = "`tbl_doctor_appointment`"; $date=trim(addslashes($_REQUEST['date'])); $date = date("Y-m-d", strtotime($date)); $product_name=trim(addslashes($_REQUEST['product_name'])); $one_line=trim(addslashes($_REQUEST['one_line'])); $price=trim(addslashes($_REQUEST['price'])); $int_price=trim(addslashes($_REQUEST['int_price'])); echo $sell_price=trim(addslashes($_REQUEST['sell_price'])); $ean=trim(addslashes($_REQUEST['ean'])); if($sell_price=='') { echo $sell_price=100; } $weight=trim(addslashes($_REQUEST['weight'])); $category=trim(addslashes($_REQUEST['category'])); $job_description=trim(addslashes($_REQUEST['job_description'])); $sp_ins=trim(addslashes($_REQUEST['sp_ins'])); $disease=0; $company=trim(addslashes($_REQUEST['company'])); //$reason_to_min=trim(addslashes($_REQUEST['reason_to_min'])); $used_for=trim(addslashes($_REQUEST['used_for'])); $dosage=trim(addslashes($_REQUEST['dosage'])); //$Query_last_invoice = "SELECT date from tbl_doctor_appointment where (date='".$date."' ) "; //$name_last_invoice=$DB->query($Query_last_invoice); //$noo=mysql_num_rows($name_last_invoice); $tablename = "shop_product_malayasia"; /* '".trim( $_REQUEST['job_code'] )."','".$new_job_name."','".$des."','".trim( $_REQUEST['job_priority'] )."','".$job_po_no."','".trim( $_REQUEST['pricing'] )."','".trim( $_REQUEST['job_type'] )."','','".$est_time_new."','".$date."','".trim( $_REQUEST['user_type'] )."','','', '".trim( $clientemail )."','','','','','','','','','','','','','','','','','','','','','','','1','','','','','','',''*/ $Query="INSERT INTO $tablename VALUES (NULL,'".trim($product_name)."','".$sp_ins."','".$job_description."','$used_for','$dosage','$one_line','','','','$ean','','','','','$sell_price','$weight','','0','0','0','0','".$disease."','0','1','1','1','1','1','0','0','0','0','0','0','0','0000-00-00 00:00:00','0000-00-00 00:00:00','0','".$sell_price."','vie','0')"; $DB->query($Query); $mysql_insert_id= mysql_insert_id(); } } ?>