1#@!#!123s

https 1#@!#!123s
: / home / mahadevanandsiva / www / admin /
Filename : ajax.php
back
<?php
require "config.php";

//insert job vacancy 
if($_POST['type']==1)
{
	$catname=$_POST['catname'];

	$ins=$con->prepare("INSERT into categories(catname)values('$catname')");
	if($ins->execute())
	{
		header('location:addcat.php');
	}

	
}
elseif($_POST['type']==2)
{
	$sel=$con->prepare("SELECT * FROM categories");
	$sel->execute();
		echo '<table class="table table-dark">
  <thead>
    <tr>
      <th scope="col">#</th>
      <th scope="col">Name</th>
      
    </tr>
  </thead>
  <tbody>';
  $c=0;
	while ($row=$sel->fetch(PDO::FETCH_ASSOC)) 
	{
		$c++;
	echo '
    <tr>
      <th scope="row">'.$c.'</th>
      <td>'.$row['catname'].'</td>
      
    </tr>';
	}
	echo ' </tbody>
</table>';
}
elseif ($_POST['type']==3)
{
	$catid=$_POST['cat'];
	
$filepdf=rand(0,99);
$fileimg=rand(0,99);	
	  

  	if (move_uploaded_file($_FILES['fileimage']['tmp_name'], 'img/n/'.$fileimg.$_FILES['fileimage']['name']) && move_uploaded_file($_FILES['filepdf']['tmp_name'], 'img/n/'.$filepdf.$_FILES['filepdf']['name']))
  	 {
  	 	$fileimg1=$fileimg.$_FILES['fileimage']['name'];
  	 	$filepdf1=$filepdf.$_FILES['filepdf']['name'];

  	 	$stmt=$con->prepare("INSERT into news(catid,image,pdf)values('$catid','$fileimg1','$filepdf1')");
	    $stmt->execute();
         echo "<script>alert('Uploaded');window.location.href='newsletter.php';</script>";

      
  		

  	  }

else
  	  {
  	  	echo "<script>alert('Upload Failed');window.location.href='newsletter.php';</script>";
  	  }
}
elseif ($_POST['type']==4)
{
	$catid=$_POST['cat'];
	
$filepdf=rand(0,99);
$fileimg=rand(0,99);	
	  

  	if (move_uploaded_file($_FILES['fileimage']['tmp_name'], 'img/e/'.$fileimg.$_FILES['fileimage']['name']) && move_uploaded_file($_FILES['filepdf']['tmp_name'], 'img/e/'.$filepdf.$_FILES['filepdf']['name']))
  	 {
  	 	$fileimg1=$fileimg.$_FILES['fileimage']['name'];
  	 	$filepdf1=$filepdf.$_FILES['filepdf']['name'];

  	 	$stmt=$con->prepare("INSERT into events(catid,image,pdf)values('$catid','$fileimg1','$filepdf1')");
	    $stmt->execute();
         echo "<script>alert('Uploaded');window.location.href='events.php';</script>";

      
  		

  	  }
  	  else
  	  {
  	  	 echo "<script>alert('Upload Failed');window.location.href='events.php';</script>";;
  	  }
}
elseif ($_POST['type']==5)
{
	$val=$_POST['v'];
	$del=$con->prepare("DELETE FROM events WHERE eid='$val'");
	if($del->execute())
	{
		echo "Deleted";
	}
}
elseif ($_POST['type']==6)
{
	$val=$_POST['v'];
	$sel=$con->prepare("SELECT * FROM events WHERE eid='$val'");
	$sel->execute();
	$row=$sel->fetch(PDO::FETCH_ASSOC);
	$catid=$row['catid'];
	echo '<div class="form-group col-md-12">
					      <label for="inputState">Category</label>
					      <select id="cat"name="cat" class="form-control">';
					        
					        
					        	$sel1=$con->prepare("SELECT * FROM categories");
								$sel1->execute();
									while ($row1=$sel1->fetch(PDO::FETCH_ASSOC))
									{
										echo '<option';

										echo ' value="'.$row1['catid'].'"';
										if($row1['catid']==$catid)
										{
											echo 'selected="selected"';
										}
										echo'>'.$row1['catname'].'</option>';
									}

					       echo '
					      </select>
					   </div>

					   <div class="form-group col-md-12">

						  
						    <label for="exampleFormControlFile1">  Thumbnail Image</label>
						    <input type="file" class="form-control-file" name="fileimage" value="'.$row['image'].'">
						  	<input type="hidden" name="type"value="7">
						  	<input type="hidden" name="eid" value="'.$val.'">
											      
					   </div>
					   <div class="form-group col-md-12">

						  
						    <label for="exampleFormControlFile1"> Event File</label>
						    <input type="file" value="'.$row['pdf'].'"class="form-control-file" name="filepdf">
						  
											      
					   </div>
				      <button type="submit" class="btn btn-primary">Update</button>';
}
elseif ($_POST['type']==7)
{
	$val=$_POST['eid'];
	$catid=$_POST['cat'];
	$filepdf=rand(0,99);
	$fileimg=rand(0,99);

	if (isset($_POST['cat']))
  	 {
  	 	
	    if(isset($_FILES['filepdf']))
  	 	{
  	 		  	 	move_uploaded_file($_FILES['filepdf']['tmp_name'], 'img/e/'.$filepdf.$_FILES['filepdf']['name']);
  	 		  	 	$filepdf1=$filepdf.$_FILES['filepdf']['name'];
  	 		  	 	$stmt=$con->prepare("UPDATE events set catid='$catid',pdf='$filepdf1' WHERE eid='$val'");
	   				 $stmt->execute();

  	 	}

  	 	if(isset($_FILES['fileimage'])){
  	 		move_uploaded_file($_FILES['fileimage']['tmp_name'], 'img/e/'.$fileimg.$_FILES['fileimage']['name']);
  	 	
  	 	$fileimg1=$fileimg.$_FILES['fileimage']['name'];
  	 	

  	 	$stmt=$con->prepare("UPDATE events set catid='$catid',image='$fileimg1' WHERE eid='$val'");
	    $stmt->execute();

  	 	}

         echo "<script>location.href='events.php';</script>";

      
  		

  	  }
  	  else
  	  {
  	  	echo "<script>alert('Faileds');location.href='events.php';</script>";
  	  }
}
elseif ($_POST['type']==8)
{
	$val=$_POST['v'];
	$del=$con->prepare("DELETE FROM news WHERE nid='$val'");
	if($del->execute())
	{
		echo "Deleted";
	}
}
elseif ($_POST['type']==9)
{
	$val=$_POST['v'];
	$sel=$con->prepare("SELECT * FROM news WHERE nid='$val'");
	$sel->execute();
	$row=$sel->fetch(PDO::FETCH_ASSOC);
	$catid=$row['catid'];
	echo '<div class="form-group col-md-12">
					      <label for="inputState">Category</label>
					      <select id="cat"name="cat" class="form-control">';
					        
					        
					        	$sel1=$con->prepare("SELECT * FROM categories");
								$sel1->execute();
									while ($row1=$sel1->fetch(PDO::FETCH_ASSOC))
									{
										echo '<option';

										echo ' value="'.$row1['catid'].'"';
										if($row1['catid']==$catid)
										{
											echo 'selected="selected"';
										}
										echo'>'.$row1['catname'].'</option>';
									}

					       echo '
					      </select>
					   </div>

					   <div class="form-group col-md-12">

						  
						    <label for="exampleFormControlFile1">  Thumbnail Image</label>
						    <input type="file" class="form-control-file" name="fileimage" value="'.$row['image'].'">
						  	<input type="hidden" name="type"value="10">
						  	<input type="hidden" name="nid" value="'.$val.'">
											      
					   </div>
					   <div class="form-group col-md-12">

						  
						    <label for="exampleFormControlFile1"> Event File</label>
						    <input type="file" value="'.$row['pdf'].'"class="form-control-file" name="filepdf">
						  
											      
					   </div>
				      <button type="submit" class="btn btn-primary">Update</button>';
}
elseif ($_POST['type']==10)
{
	$val=$_POST['nid'];
	$catid=$_POST['cat'];
	$filepdf=rand(0,99);
	$fileimg=rand(0,99);

	if (isset($_POST['cat']))
  	 {
  	 	
	    if(isset($_FILES['filepdf']))
  	 	{
  	 		  	 	move_uploaded_file($_FILES['filepdf']['tmp_name'], 'img/n/'.$filepdf.$_FILES['filepdf']['name']);
  	 		  	 	$filepdf1=$filepdf.$_FILES['filepdf']['name'];
  	 		  	 	$stmt=$con->prepare("UPDATE news set catid='$catid',pdf='$filepdf1' WHERE nid='$val'");
	   				 $stmt->execute();

  	 	}

  	 	if(isset($_FILES['fileimage'])){
  	 		move_uploaded_file($_FILES['fileimage']['tmp_name'], 'img/n/'.$fileimg.$_FILES['fileimage']['name']);
  	 	
  	 	$fileimg1=$fileimg.$_FILES['fileimage']['name'];
  	 	

  	 	$stmt=$con->prepare("UPDATE news set catid='$catid',image='$fileimg1' WHERE nid='$val'");
	    $stmt->execute();

  	 	}

         echo "<script>location.href='newsletter.php';</script>";

      
  		

  	  }
  	  else
  	  {
  	  	echo "<script>alert('Faileds');location.href='newsletter.php';</script>";
  	  }
}

?>