<?php

	require_once('pdoconfig.php');



	$catid=$_REQUEST['catid'];

	$pid=$_REQUEST['project_id'];

	$act=$_REQUEST['act'];

	$pname=$_REQUEST['pname'];

	$plink=$_REQUEST['plink'];

	$user=$_REQUEST['user'];

	$action1=$_REQUEST['action'];



     $uploadresume=$_FILES["file"]["name"];

	//if($active=='on'){ $aa1=1;}else{ $aa1=0;}





/*if($category=='' || strlen($category)>50)

{

   die("Something went wrong! <br> <a href='category_master.php'>Continue</a>");   

}*/



       if($act == "add")

		{

			$sql="insert into aa_project_master set project_name=?,audio_link=?, user_id=?,approve=?"; 

			$arr=array($pname,$plink,$user,$action1);

			$res=$action->insertp($sql,$arr);

			$prod_id=$res;

	            if($res>0)

	            {

	                /***************Image1************************************/

           		 if($uploadresume!='')



	        {



	        



		        $file_tmp =$_FILES['file']['tmp_name'];	   



	            $pos=strpos($uploadresume,".");     



	            if($uploadresume=="")



				{



				$new_file_name="";



				}



				else



				{



				$new_file_name="Project".'-'.$prod_id.substr($uploadresume, $pos,strlen($uploadresume)-$pos);



				}



				move_uploaded_file($file_tmp,"../images/projects/".$new_file_name);



				//echo $new_file_name;



				$qry="update aa_project_master set file=? where project_id=?";

				$arr=array($new_file_name,$prod_id);

		        $action->updatep($qry,$arr);



			}

			

	            ?>

			    <script>

			        alert("Data Save successfully");

			        window.location.href="projects.php";				    

			    </script>

			    <?php

		    }

	    }

	    else if($act == "edit")

		{

			$sql="update aa_project_master set project_name=?,audio_link=?, user_id=?,approve=? where project_id=?"; 

			$arr=array($pname,$plink,$user,$action1,$catid);			

			$res1=$action->updatep($sql,$arr);				

            $prod_id1=$res1;

            

	            if($res1>0)

	            {

	                	 if($uploadresume!='')



	        {



	        



		        $file_tmp =$_FILES['file']['tmp_name'];	   



	            $pos=strpos($uploadresume,".");     



	            if($uploadresume=="")



				{



				$new_file_name="";



				}



				else



				{



				$new_file_name="Project".'-'.$catid.substr($uploadresume, $pos,strlen($uploadresume)-$pos);



				}



				move_uploaded_file($file_tmp,"../images/projects/".$new_file_name);



			

				$qry="update aa_project_master set file=? where project_id=?";

				$arr=array($new_file_name,$catid);

		        $action->updatep($qry,$arr);



			}

	            ?>

			    <script>

			        alert("Data update successfully");

			        window.location.href="projects.php";				    

			    </script>

			    <?php

		    }			

	    }

	    

	    else if($act == "del")

		{

		  

			$sql="delete from aa_project_master where project_id=?"; 

			$arr=array($pid);

			

			$res=$action->deletep($sql,$arr);

				



	            if($res)

	            {

	            ?>

			    <script>

			        alert("Data delete successfully");

			        window.location.href="projects.php";				    

			    </script>

			    <?php

		    }			

	    }

	    

		

?>