query($Query); header("location:view_disease.php?sucess=sucess"); //header("location:view_product.php?msg=sucess"); } ?> PRESCRIPTION FOR ALOPECIA

Qty. Medicine Name When Dosage How to take
 4  Tonsilin  After food  2-2-2  In Honey
 1  Param  Before food  1-1-1  -
 1  Saram  After food  1-1-1  -
 1  Maval  Before food  1-1-1  -
'; $category=trim(addslashes($_REQUEST['category'])); $new=trim(addslashes($new)); if ($_REQUEST["form_action"] == "Update") { $Query="UPDATE `tbl_disease` SET `name`='" .$category. "',`desc`='" .$job_description. "',`title1`='" .$title1. "',`title2`='" .$title2. "',`video_code1`='" .$video_code1. "',`video_code2`='" .$video_code2. "',`video_code3`='" .$video_code3. "',`video_code3`='" .$video_code3. "',`title3`='" .$title3. "',`title4`='" .$title4. "' WHERE `id`='".$_REQUEST['id']."'"; $DB->query($Query); $flag="sucess"; } if ($_REQUEST["form_action"] == "Insert") { $Query_last_invoice = "SELECT name from tbl_disease where (name='".$category."' ) "; $name_last_invoice=$DB->query($Query_last_invoice); $noo=mysql_num_rows($name_last_invoice); if($noo==0) { $Query = "insert into $tablename values( NULL,'". $category . "','0','".$new."')"; $DB->query($Query); if($_REQUEST['id']!='') { header("location:view_disease.php?sucess=sucess"); } $flag="sucess"; } else { $flag="failure"; } } } date_default_timezone_set("Asia/Kolkata"); $tablename='tbl_job_details'; if ($update_option == 1) { $id=$_REQUEST['id']; $Query_last_data = "SELECT * from tbl_disease where id='$id' "; $name_last_data=$DB->query($Query_last_data); $row_12_123=mysql_fetch_array($name_last_data); $category=$row_12_123['name']; $desc=$row_12_123['desc']; $status=$row_12_123['status']; $title1=$row_12_123['title1']; $title2=$row_12_123['title2']; $video_code1=$row_12_123['video_code1']; $video_code2=$row_12_123['video_code2']; $title3=$row_12_123['title1']; $title4=$row_12_123['title2']; $video_code3=$row_12_123['video_code3']; $video_code4=$row_12_123['video_code4']; } ?>
Success! Data Added Sucessfully.
Danger! Already Exists.

Add Disease

'; ?>
Active In Active
'; echo''; echo''; } else { echo''; echo''; } ?>