query("insert into tbl_chef_course set name='$name',status='1'"); $_SESSION['sess_msg']='Recipe Course added successfully'; }else{ $sql=" update tbl_chef_course set name='$name'"; $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Recipe Course updated successfully'; } header("location:courses-list.php"); exit(); }elseif($_REQUEST['recipe']==2){ if($_REQUEST['id']=='' && $_REQUEST['recipe']==2){ $obj->query("insert into tbl_chef_prep set name='$name',status='1'"); $_SESSION['sess_msg']='Recipe Prepration added successfully'; }else{ $sql=" update tbl_chef_prep set name='$name'"; $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Recipe Prepration updated successfully'; } header("location:courses-list.php"); exit(); }elseif($_REQUEST['recipe']==3){ if($_REQUEST['id']=='' && $_REQUEST['recipe']==3){ $obj->query("insert into tbl_chef_holiday set name='$name',status='1'"); $_SESSION['sess_msg']='Recipe Holiday added successfully'; }else{ $sql=" update tbl_chef_holiday set name='$name'"; $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Recipe Holiday updated successfully'; } header("location:courses-list.php"); exit(); }else{ if($_REQUEST['id']=='' && $_REQUEST['recipe']==4){ $obj->query("insert into tbl_chef_additional set name='$name',status='1'"); $_SESSION['sess_msg']='Recipe Additional added successfully'; }else{ $sql=" update tbl_chef_additional set name='$name'"; $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Recipe Additional updated successfully'; } header("location:courses-list.php"); exit(); } } if($_REQUEST['recipe']==1){ if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_chef_course where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } }elseif($_REQUEST['recipe']==2){ if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_chef_prep where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } }elseif($_REQUEST['recipe']==3){ if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_chef_holiday where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } }else{ if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_chef_additional where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } } ?>

Admin: AddUpdate Press Release Heading: