<?php 
session_start();
include_once('include/config.inc.php');

include_once('include/function.php');

switch($_REQUEST['do']) {
	case "collageinfo" :
		$collagepre = mysqli_escape_string($con,$_REQUEST['collagepre']);
		$collagename = mysqli_escape_string($con,$_REQUEST['collagename']);
		$collageaddr = mysqli_escape_string($con,$_REQUEST['collageaddr']);
		$collagephone = mysqli_escape_string($con,$_REQUEST['collagephone']);
		$collageemail = mysqli_escape_string($con,$_REQUEST['collageemail']);
		
		$doid = mysqli_escape_string($con,$_REQUEST['doid']);
		$UserID = mysqli_escape_string($con,$_REQUEST['UserID']);
					
					
			if($_FILES['logo']['name']!= NULL){

				$logo = time().'_'.$_FILES['logo']['name'];

				move_uploaded_file($_FILES['logo']['tmp_name'],"images/uploads/".$logo);
				 

			} 
             
					
					if(empty($doid)){
						
						$check=mysqli_query($con,"insert into collageinfo(user_id,collagepre,collagename,
						collageaddr,collagephone
						,collageemail,logo)
				values('".$UserID."','".$collagepre."','".$collagename."','".$collageaddr."'
				,'".$collagephone."','".$collageemail."','".$logo."')");
				
					if($check){
									$_SESSION['msg']=' Record Add Successfully .';
								}else{
									$_SESSION['msg']='Record Not Add Failed! ';
								}	
					}else{
						if(!empty($logo)){
							$check=mysqli_query($con,"Update collageinfo set logo='".$logo."'
						  where id='".$doid."'");
						}
						$check=mysqli_query($con,"Update collageinfo set user_id='".$UserID."',
						collagename='".$collagename."',collageaddr='".$collageaddr."',
                       collagephone='".$collagephone."',collageemail='".$collageemail."'
					   where id='".$doid."'");
			
				
					if($check){
									$_SESSION['msg']=' Record Update Successfully .';
								}else{
									$_SESSION['msg']='Record Not Update Failed! ';
								}
					}
						
					 header("Location:collegeinformation.php");
						break;

}