1#@!#!123s

: / home / jnclnmuac / www / web / admin /
Filename : all.php
back
<?php 
require_once("connection.php"); 
if(isset($_POST['save']))
{
    $content=$_POST["editor"];
    $content=mysqli_real_escape_string($dbCon,$content);
    $added_on=date('Ymdhis');
    $pimg=$_FILES['pimg']['name'];
    $dest="img/".$added_on.$pimg;
    move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
    $sql="insert into about_us(p_msg, added_on, pic)
     values('$content','$added_on','$dest')";
    $query_run= mysqli_query($dbCon, $sql);
    if($query_run)
    {
        header("location:home.php");
        echo "Data Save";
    }
    else{
        echo "Pleaase try again";
    }
}
if(isset($_POST['update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
       
        $sql="update about_us set p_msg='$content' where flag='p'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: principle_desk.php");
        }
    }
   
    //Previous Principle
    if(isset($_POST['previous_principle']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
       
        $sql="update about_us set p_msg='$content' where flag='pp'";
        var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: prev_principle.php");
        }
    }

    //About College
    if(isset($_POST['abtc_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update about_us set p_msg='$content', added_on='$added_on' where flag='abtc'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: about_clg.php");
        }
    }
	//About College image
	if(isset($_POST['abtc_update_img']))
    {
        
        $added_on=date('Ymdhis');
   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
    
     move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update about_us set pic='$dest', added_on='$added_on' where flag='abtc'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: about_clg.php");
        }
    }
	
	//Department Science College
    if(isset($_POST['s_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update tbl_dep set p_msg='$content', added_on='$added_on' where flag='s'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: science.php");
        }
    }

	//Department Science image
	if(isset($_POST['s_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update tbl_dep set pic='$dest', added_on='$added_on' where flag='s'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: science.php");
        }
    }
	
	//Department arts College
    if(isset($_POST['a_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update tbl_dep set p_msg='$content', added_on='$added_on' where flag='a'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: arts.php");
        }
    }

	//Department arts image
	if(isset($_POST['a_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update tbl_dep set pic='$dest', added_on='$added_on' where flag='a'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: arts.php");
        }
    }
	
	//Admission content
    if(isset($_POST['ad_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update tbl_academics set p_msg='$content', added_on='$added_on' where flag='ad'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: adm.php");
        }
    }

	//Admission  image
	if(isset($_POST['ad_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update tbl_academics set pic='$dest', added_on='$added_on' where flag='ad'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: adm.php");
        }
    }
	
	
	//Courses content
    if(isset($_POST['co_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update tbl_academics set p_msg='$content', added_on='$added_on' where flag='co'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: courses.php");
        }
    }

	//Courses  image
	if(isset($_POST['co_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update tbl_academics set pic='$dest', added_on='$added_on' where flag='co'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: courses.php");
        }
    }
	
	
	 //Principal content
    if(isset($_POST['p_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update about_us set p_msg='$content', added_on='$added_on' where flag='p'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: principle_desk.php");
        }
    }

	//Principal image
	if(isset($_POST['p_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update about_us set pic='$dest', added_on='$added_on' where flag='p'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: principle_desk.php");
        }
    }
	
	//vc content
    if(isset($_POST['vc_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update about_us set p_msg='$content', added_on='$added_on' where flag='vc'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: vc.php");
        }
    }

	//vc image
	if(isset($_POST['vc_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update about_us set pic='$dest', added_on='$added_on' where flag='vc'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: vc.php");
        }
    }
	
	//student support menu
	
	
	//regulation content
    if(isset($_POST['rr_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update student_support set p_msg='$content', added_on='$added_on' where flag='rr'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: rules_regulation.php");
        }
    }

	//regulation image
	if(isset($_POST['rr_img']))
    {
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update student_support set pic='$dest', added_on='$added_on' where flag='rr'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: rules_regulation.php");
        }
    }
	
	
	//ncc content
    if(isset($_POST['ncc_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update student_support set p_msg='$content', added_on='$added_on' where flag='ncc'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: ncc.php");
        }
    }

	//ncc image
	if(isset($_POST['ncc_img']))
    {
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update student_support set pic='$dest', added_on='$added_on' where flag='ncc'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: ncc.php");
        }
    }
	
	//nss content
    if(isset($_POST['nss_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update student_support set p_msg='$content', added_on='$added_on' where flag='nss'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: nss.php");
        }
    }

	//nss image
	if(isset($_POST['nss_img']))
    {
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update student_support set pic='$dest', added_on='$added_on' where flag='nss'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: nss.php");
        }
    }
	
	//canteen content
    if(isset($_POST['c_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update student_support set p_msg='$content', added_on='$added_on' where flag='c'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: canteen.php");
        }
    }

	//canteen image
	if(isset($_POST['c_img']))
    {       
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
		move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update student_support set pic='$dest', added_on='$added_on' where flag='c'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: canteen.php");
        }
    }
	
	//hostel content
    if(isset($_POST['h_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update student_support set p_msg='$content', added_on='$added_on' where flag='h'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: hostel.php");
        }
    }

	//hostel image
	if(isset($_POST['h_img']))
    {
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
		move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update student_support set pic='$dest', added_on='$added_on' where flag='h'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: hostel.php");
        }
    }
	
	//club content
    if(isset($_POST['cl_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update student_support set p_msg='$content', added_on='$added_on' where flag='cl'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: club.php");
        }
    }

	//club image
	if(isset($_POST['cl_img']))
    {
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
		move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update student_support set pic='$dest', added_on='$added_on' where flag='cl'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: club.php");
        }
    }
	
	//24*7 internet content
    if(isset($_POST['in_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update student_support set p_msg='$content', added_on='$added_on' where flag='in'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: internet.php");
        }
    }

	//24*7 internet image
	if(isset($_POST['in_img']))
    {
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
		move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update student_support set pic='$dest', added_on='$added_on' where flag='in'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: internet.php");
        }
    }
	
	//Placement / Career Councelling Cell content
    if(isset($_POST['pcl_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='pcl'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: pcell.php");
        }
    }
	
	//College Development Cell content
    if(isset($_POST['cdc_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='cdc'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: cdcell.php");
        }
    }
	
	//Disciplinary / Admission Cell content
    if(isset($_POST['dac_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='dac'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: admcell.php");
        }
    }
	
	//Grievance Redressal / Anti Ragging Cell content
    if(isset($_POST['grc_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='grc'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: gcell.php");
        }
    }
	
	//Internal Quality Assurance (IQAC) Cell content
    if(isset($_POST['iqac_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='iqac'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: iqacell.php");
        }
    }
	
	//Advisory Committee for Central Library content
    if(isset($_POST['acfcl_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='acfcl'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: librarycell.php");
        }
    }
	
	//Women Cell / Anti Sexual Harassment Cell content
    if(isset($_POST['wchc_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='wchc'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: wcell.php");
        }
    }
	
	//Steering Committee for NAAC content
    if(isset($_POST['scfn_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update commitee_cell set p_msg='$content', added_on='$added_on' where flag='scfn'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: naacell.php");
        }
    }
	
	//update time table
    if(isset($_POST['time-table']))
    {
        $session=$_POST["session"];
        $added_on=date('Ymdhis');
        $pdf=$_FILES['pdf']['name'];
        $type=$_FILES['pdf']['type'];
        $dest="pdf/".$added_on.$pdf;
        move_uploaded_file($_FILES["pdf"]["tmp_name"],$dest);
        if($type=='application/pdf' or $type=='application/vnd.openxmlformats-officedocument.wordprocessingml.document')
        {	
            $sql="insert into time_table(time_table_file, added_on, session)
            values('$dest','$added_on', '$session')";
            $query_run= mysqli_query($dbCon, $sql);
            if($query_run)
            {
                header("location:time_table.php");
                echo "Data Save";
            }
        }
        else
            {
                echo "<script>
                window.alert('Pls select correct file type');
                window.location.href='ssr.php';</script>";
            }
    }
	
	
	//SSR
    if(isset($_POST['ssr_upload']))
    {
        $session=$_POST["session"];
        $added_on=date('Ymdhis');
        $pdf=$_FILES['pdf']['name'];
        $type=$_FILES['pdf']['type'];
        $dest="pdf/".$added_on.$pdf;
        move_uploaded_file($_FILES["pdf"]["tmp_name"],$dest);
        if($type=='application/pdf' or $type=='application/vnd.openxmlformats-officedocument.wordprocessingml.document')
        {	
            $sql="insert into ssr(ssr_file, added_on, session)
            values('$dest','$added_on', '$session')";
            $query_run= mysqli_query($dbCon, $sql);
            if($query_run)
            {
                header("location:ssr.php");
                echo "Data Save";
            }
        }
        else
                {
                    echo "<script>
                    window.alert('Pls select correct file type');
                    window.location.href='ssr.php';
                    </script>";
                }
    }
	
	 //aqar
    if(isset($_POST['aqar_upload']))
    {
        $content=$_POST["aqar_session"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $pdf=$_FILES['pdf']['name'];
        $type=$_FILES['pdf']['type'];
        //echo $type;
        $dest="pdf/".$added_on.$pdf;
        move_uploaded_file($_FILES["pdf"]["tmp_name"],$dest);
        if($type=='application/pdf' or $type=='application/vnd.openxmlformats-officedocument.wordprocessingml.document')
        {
                $sql="insert into aqar (aqar_file, added_on,aqar_session)
                 values('$dest','$added_on','$content')";
                $query_run= mysqli_query($dbCon, $sql);
                if($query_run)
                {
                    header("location:aqar.php");
                    echo "Data Save";
                }
                
        }
        else
                {
                    echo "<script>
                    window.alert('Pls select correct file type');
                    window.location.href='aqar.php';
                    </script>";
                }
    }
	
	//fee_str
    if(isset($_POST['fee_str_upload']))
    {
        $session=$_POST["session"];
        $added_on=date('Ymdhis');
        $pdf=$_FILES['pdf']['name'];
        $type=$_FILES['pdf']['type'];
        $dest="pdf/".$added_on.$pdf;
        move_uploaded_file($_FILES["pdf"]["tmp_name"],$dest);
        
        if($type=='application/pdf' or $type=='application/vnd.openxmlformats-officedocument.wordprocessingml.document')
        {	
            $sql="insert into fee_str(fee_str_file, added_on, session)
            values('$dest','$added_on', '$session')";
            $query_run= mysqli_query($dbCon, $sql);
            if($query_run)
            {
                header("location:fee_str.php");
                echo "Data Save";
            }
        }
        else
                {
                    echo "<script>
                    window.alert('Pls select correct file type');
                    window.location.href='fee_str.php';
                    </script>";
                }
    }
	
	//academic calender
    if(isset($_POST['acal_upload']))
    {
        $session=$_POST["session"];
        $added_on=date('Ymdhis');
        $pdf=$_FILES['pdf']['name'];
        $type=$_FILES['pdf']['type'];
        $dest="pdf/".$added_on.$pdf;
        move_uploaded_file($_FILES["pdf"]["tmp_name"],$dest);
          
        if($type=='application/pdf' or $type=='application/vnd.openxmlformats-officedocument.wordprocessingml.document')
        {	
            $sql="insert into tbl_acal(acal_file, added_on, session)
            values('$dest','$added_on', '$session')";
            $query_run= mysqli_query($dbCon, $sql);
            if($query_run)
            {
                header("location:a_calender.php");
                echo "Data Save";
            }
        }
        else
                {
                    echo "<script>
                    window.alert('Pls select correct file type');
                    window.location.href='a_calender.php';
                    </script>";
                }
    }
	
	//acheivement content
    if(isset($_POST['ach_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update about_us set p_msg='$content', added_on='$added_on' where flag='ach'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: achivement.php");
        }
    }
	//acheivement image
	if(isset($_POST['ach_img']))
    {
        $added_on=date('Ymdhis');   
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
		move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update about_us set pic='$dest', added_on='$added_on' where flag='ach'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: achivement.php");
        }
    }
	
	
	//contact details update
    if(isset($_POST['contact_update']))
    {   
        $content=$_POST["address"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $phone=$_POST["phone"];
        $mobile=$_POST["mobile"];
        $email=$_POST["email"];
        $email=mysqli_real_escape_string($dbCon,$email);
        $gmap=$_POST["map"];
        $gmap=mysqli_real_escape_string($dbCon,$gmap);
        $sql="update contact_details set con_address='$content', phone='$phone', mobile='$mobile', email='$email', gmap='$gmap' where flag='con'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location:contact_details.php");
        }
    }
    
    //Department Commerce College
    if(isset($_POST['com_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update tbl_dep set p_msg='$content', added_on='$added_on' where flag='com'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: commerce.php");
        }
    }

	//Department Commerce image
	if(isset($_POST['com_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update tbl_dep set pic='$dest', added_on='$added_on' where flag='com'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: commerce.php");
        }
    }
	
	//Department Law College
    if(isset($_POST['law_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update tbl_dep set p_msg='$content', added_on='$added_on' where flag='law'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: law.php");
        }
    }

	//Department Law image
	if(isset($_POST['law_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update tbl_dep set pic='$dest', added_on='$added_on' where flag='law'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: law.php");
        }
    }
	
	//Department Education College
    if(isset($_POST['edu_update']))
    {
        $content=$_POST["editor"];
        $content=mysqli_real_escape_string($dbCon,$content);
        $added_on=date('Ymdhis');
        $sql="update tbl_dep set p_msg='$content', added_on='$added_on' where flag='edu'";
        //var_dump($sql);
        //echo $sql;
        $query_run=mysqli_query($dbCon, $sql);
        //var_dump($query_run);
        if($query_run)
        {
            header("location: education.php");
        }
    }

	//Department Education image
	if(isset($_POST['edu_update_img']))
    {
        $added_on=date('Ymdhis');
		$pimg=$_FILES['pimg']['name'];
		$dest="img/".$added_on.$pimg;
        move_uploaded_file($_FILES["pimg"]["tmp_name"],$dest);
        $sql="update tbl_dep set pic='$dest', added_on='$added_on' where flag='edu'";
        $query_run=mysqli_query($dbCon, $sql);
        if($query_run)
        {
            header("location: education.php");
        }
    }
	
?>
<script>
        CKEDITOR.replace('editor');
        var editor = CKEDITOR.replace( 'ckfinder' );
            CKFinder.setupCKEditor( editor );
    </script>