1#@!#!123s

22527 1#@!#!123s
: / home / parchhayin / www / admin /
Filename : team.php
back
<?php
include('main.php');
error_reporting('E_ALL ^ E_NOTICE');
if(isset($_POST['add'])) {
$title=mysqli_real_escape_string($con, $_POST['title']);
$desc=mysqli_real_escape_string($con, $_POST['desc']);
//$cat=mysqli_real_escape_string($con, $_POST['cat']);
    $string = '0123456789abcd';
    $string_shuffled = str_shuffle($string);
    $rename = substr($string_shuffled, 0, 4);
	
	
	$allowed =  array('gif','png' ,'jpg');
	$image =  $_FILES['image']['name'];	
    $extension = pathinfo($image, PATHINFO_EXTENSION); 
	$image_tmp =$_FILES['image']['tmp_name'];
	$image=$rename.($image); 
	

move_uploaded_file($image_tmp,"../images/$image");

 $insert = mysqli_query($con, "insert into team(title,image,des) values('$title','$image','$desc')");

 if($insert) {
 echo "<meta http-equiv='refresh' content='0'>";
   echo "<script>alert('add succesfully');</script>";    
   }
   
  else {
	echo "<script>alert('not added please try again')</script>";   


}
}
?>

 <div class="content-page">
                <!-- Start content -->
                <div class="content">
                    <div class="container">

                        <!-- Page-Title -->
                        <div class="row">
                            <div class="col-sm-12">
                               
                             <!--   <h4 class="pull-left page-title">Welcome !</h4>-->
                                <ol class="breadcrumb pull-right">
                                   
                                      <li><a href="index.php">Dashboard</a></li>
                                    <li class="active">Team Member Add</li>
                                </ol>
                            </div>
                        </div>
    
 
<div class="row">
                            <div class="col-lg-12">
                                <div class="panel panel-default">
                                  
                                    <div class="panel-body">
									
<h4 class="hed"><i class="fa fa-user"></i>  Team Member</h4> <hr/></br>
<form class="form-horizontal m-t-20" action="" method="post" enctype="multipart/form-data">
      
	             <div class="col-xs-3">Title</div>
					  <div class="col-xs-9">
                       
 
 <input type="text" name="title" class="form-control input-lg"><br/>   
  
                    </div>
					
                 <div class="col-xs-3">Image</div>
                        <div class="col-xs-9">
                       
 
 <input type="file" name="image" class="form-control input-lg "><br/>    
  
 
  
                    
                    </div>   
                     <div class="col-xs-3">Desc</div>
					  <div class="col-xs-9">
                       
 
 <textarea name="desc" class="form-control ckeditor" id="js-my-textarea1"></textarea><br/>   
  
 
  
                    
                    </div>
                      
					      
       
     <div class="form-group text-center m-t-40">
                        <div class="col-xs-12">
                        
                         <input type="submit" name="add" value="Insert" class="btn btn-lg btn-success" />     
  
      
      </div>
          </div>
	  </br>
     
</form>
 <h4 class="hed"><i class="fa fa-user"></i> View All Team Member</h4> <hr/></br>
  
 
  <?php

	$tbl_name="team";		//your table name
	// How many adjacent pages should be shown on each side?
	$adjacents = 1;
	

	 $query2 = "SELECT COUNT(*) as num FROM $tbl_name";
	$total_pages = mysqli_fetch_array(mysqli_query($con, $query2));
	 $total_pages = $total_pages['num'];
	/* Setup vars for query. */
	$targetpage = "team.php"; 	//your file name  (the name of this file)
	$limit = 10; 
									//how many items to show per page
	$page =  $_GET['page'];
	if($page) 
		$start = ($page - 1) * $limit; 			//first item to display on this page
	else
		$start = 0;								//if no page var is given, set start to 0

         
     $raw_results = mysqli_query($con, "SELECT * FROM $tbl_name LIMIT $start, $limit") or die(mysqli_error());
			
	
	/* Setup page vars for display. */
	if ($page == 0) $page = 1;					//if no page var is given, default to 1.
	$prev = $page - 1;							//previous page is page - 1
	$next = $page + 1;							//next page is page + 1
	$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
	$lpm1 = $lastpage - 1;						//last page minus 1
	
	/* 
		Now we apply our rules and draw the pagination object. 
		We're actually saving the code to a variable in case we want to draw it more than once.
	*/
	$pagination = "";
	if($lastpage > 1)
	{	
		$pagination .= "<div class=\"pagination\">";
		//previous button
		if ($page > 1) 
			$pagination.= "<a href=\"$targetpage?page=$prev\">&nbsp;&nbsp;previous</a>";
		else
			$pagination.= "<span class=\"disabled\">&nbsp;&nbsp;previous</span>";	
		
		//pages	
		if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
		{	
			for ($counter = 1; $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
			}
		}
		elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
		{
			//close to beginning; only hide later pages
			if($page < 1 + ($adjacents * 2))		
			{
				for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">&nbsp;&nbsp;$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">&nbsp;&nbsp;$lastpage</a>";		
			}
			//in middle; hide some front and some back
			elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
				}
				$pagination.= "...";
				$pagination.= "<a href=\"$targetpage?page=$lpm1\">&nbsp;&nbsp;$lpm1</a>";
				$pagination.= "<a href=\"$targetpage?page=$lastpage\">&nbsp;&nbsp;$lastpage</a>";		
			}
			//close to end; only hide early pages
			else
			{
				$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
				$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
				$pagination.= "...";
				for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
				{
					if ($counter == $page)
						$pagination.= "<span class=\"current\">&nbsp;&nbsp;$counter</span>";
					else
						$pagination.= "<a href=\"$targetpage?page=$counter\">&nbsp;&nbsp;$counter</a>";					
				}
			}
		}
		
		//next button
		if ($page < $counter - 1) 
			$pagination.= "<a href=\"$targetpage?page=$next\">&nbsp;&nbsp;next </a>";
		else
			$pagination.= "<span class=\"disabled\">&nbsp;&nbsp;next </span>";
		$pagination.= "</div>\n";		
	}

  ?>
  </form>
  <form method="post">							
<?php

	 
	echo "<table id='news'>
	 <tr>
     <th> S.No</th>
	 <th>Title</th>
	 <th>Image</th>	 
	 <th>Edit Details</th>	 
	<th>Delete</th>
	 </tr> ";
	 $s=1;
	 while($row = mysqli_fetch_array($raw_results)) {
		 
	    $id = $row['id'];
		
		$title =$row['title'];
		$pic1 =$row['image'];
		
	   echo "<tr>";
	    echo "<td>$s</td>";
		echo "<td>$title</td>";
		
	    echo "<td><img src='../images/$pic1' height='100' width='120' style='border:2px solid #f00; border-radius:10px 0;' /></td>";	
	   echo "<td><a href='team-edit.php?id=$id' class='btn btn-info'>Edit </a></td>";
	 
	   echo "<td><button onclick='return checkMe()' name='id' value='".$id."' type='submit' class='btn btn-danger'><i class='fa fa-trash'></i> </button>
   
   </td>";	
	$s=$s+1; 
	  }
	$id = $_POST['id'];  
 
 if($id != ""){ 
 
  $query = mysqli_query($con,"DELETE FROM $tbl_name WHERE id ='$id'");
	  

	  echo "<meta http-equiv='refresh' content='0'>";
	   
 }
		   
echo "</tr>";
 echo "</table>";
?>
<?=$pagination ?>

</form>

  <script language="javascript">

 function checkMe() {
    if (confirm("Are you sure you want to delete")) {
       
        return true;
    } else {
        
        return false;
    }
}
	 </script>   
	                                </div> <!-- panel-body -->
                                </div> <!-- panel -->
                            </div> <!-- col -->

                        </div> <!-- End row -->
	
   
  <?php include('footer.php'); ?>