$product="active"; $caller1="open"; $dis="active"; $ids=$_REQUEST['ids']; $video_detil="active"; require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); $Query_last_data_disease = "SELECT * from tbl_disease where id='$ids' "; $name_last_data_disease=$DB->query($Query_last_data_disease); $row_12_123_disease=mysql_fetch_array($name_last_data_disease); session_start(); ?> if($_REQUEST['id']!='') { $update_option =1; } if(isset($_POST['sumbit'])) { date_default_timezone_set('Asia/Kolkata'); $date_ss = date('Y-m-d H:i:s ', time()); $tablename = "`tbl_disease_video`"; $title=trim(addslashes($_REQUEST['title'])); $video_code=trim(addslashes($_REQUEST['video_code'])); if ($_REQUEST["form_action"] == "Update") { $Query="UPDATE `tbl_disease_video` SET `title`='" .$title. "',`video_code`='" .$video_code. "' WHERE `id`='".$_REQUEST['id']."'"; $DB->query($Query); $flag="sucess"; } if ($_REQUEST["form_action"] == "Insert") { //$Query_last_invoice = "SELECT title from tbl_disease_video where (title='".$title."' ) "; //$name_last_invoice=$DB->query($Query_last_invoice); $noo=0; if($noo==0) { $ids=$_REQUEST['ids']; $Query = "insert into $tablename values( NULL,'". $title . "','". $video_code . "','0','0','".$ids."')"; $DB->query($Query); header("location:view_disease_video.php?msg=sucess&ids=$ids"); exit(); } else { $flag="failure"; } } } date_default_timezone_set("Asia/Kolkata"); $tablename='tbl_video'; if ($update_option == 1) { $id=$_REQUEST['id']; $Query_last_data = "SELECT * from tbl_disease_video where id='$id' "; $name_last_data=$DB->query($Query_last_data); $row_12_123=mysql_fetch_array($name_last_data); $title=$row_12_123['title']; $video_code=$row_12_123['video_code']; } ?>