1#@!#!123s

https 1#@!#!123s
: / proc / thread-self / root / home / mahadevanandsiva / www / admin /
Filename : events.php
back
<?php 
include "header.php";
?>
<div class="app-content content">
      <div class="content-wrapper">
      	<div class="col-md-12 bg-white"style="height:100%;">
      		<div class="col-md-4">
      			<h4>Add Events</h4>
      			<form id="frm" enctype="multipart/form-data" method="post" action="ajax.php">
				  
				  	<div class="form-group col-md-12">
					      <label for="inputState">Category</label>
					      <select id="cat"name="cat" class="form-control">
					        <option selected>Select...</option>
					        <?php
					        require "config.php";
					        	$sel=$con->prepare("SELECT * FROM categories");
								$sel->execute();
									while ($row=$sel->fetch(PDO::FETCH_ASSOC))
									{
										echo "<option value='".$row['catid']."'>".$row['catname']."</option>";
									}

					        ?>
					      </select>
					   </div>

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

						  
						    <label for="exampleFormControlFile1">  Thumbnail Image</label>
						    <input type="file" class="form-control-file" name="fileimage">
						  	<input type="hidden" name="type"value="4">
											      
					   </div>
					   <div class="form-group col-md-12">

						  
						    <label for="exampleFormControlFile1"> Event File</label>
						    <input type="file" class="form-control-file" name="filepdf">
						  
											      
					   </div>
				      <button type="submit" class="btn btn-primary">Submit</button>

				</form>

      		</div>
      		<br>
      		<br>
      		<table id="dtBasicExample" class="table table-striped table-bordered table-sm" cellspacing="0" width="100%">
  <thead style="background:#136285;color:white;">
    <tr>
      <th scope="col">#</th>
      <th scope="col">Category</th>
      <!-- <th scope="col">Thumbnail</th> -->
      <th scope="col">Events</th>
      <th scope="col">Actions</th>
    </tr>
  </thead>
  <tbody>
  	<?php
  	$c=0;$seld=$con->prepare("SELECT * FROM events ");
  $seld->execute();
  $cnt=$seld->rowCount();
    if(isset($_GET['page']))
    {
      $page=$_GET['page'];
    }
    else
    {
      $page=1;
    }
    $st=($page-1)*6;

    $sel1=$con->prepare("SELECT * FROM events limit $st,6");
	$sel1->execute();
	while ($row1=$sel1->fetch(PDO::FETCH_ASSOC))
		{
			$c++;
			$catid=$row1['catid'];
			$csel=$con->prepare("SELECT * FROM categories where catid='$catid'");
			$csel->execute();
			$crow=$csel->fetch(PDO::FETCH_ASSOC);
			?>
			<tr>
		      <th scope="row"><?php echo $c; ?></th>
		      <td><?php echo $crow['catname']; ?><br><img  style="width:100px;height:100px;"src="<?php echo 'img/e/'.$row1['image']; ?>"></td>
		      <td><a href="<?php echo 'img/e/'.$row1['pdf']; ?>">View</a></td>
          <td>
            <button type="button" class="btn btn-primary"onclick="edit(<?php echo $row1['eid'];?>)">Edit</button>
            <button type="button" class="btn btn-danger" onclick="del(<?php echo $row1['eid'];?>)">Delete</button>
          </td>
		    </tr>
			<?php

		}
  	?>

    
    
  </tbody>
</table>
<?php 
      $to=($cnt/6)+1;
        for($i=1;$i<=$to;$i++)
        {
      ?>
      <a class="btn btn-secondary text-white" href="events.php?page=<?php echo $i; ?>"><?php echo $i; ?></a>
      <?php   
        }
      ?>
      		
      	</div>
      </div>
  </div>
  <?php
  include "footer.php";
  ?>
  <script type="text/javascript">
  	
      function del(val)
      {
         $.ajax({
          url: "ajax.php",
          type:"post",
          data:{v:val,type:'5'},
           success: function(result){
               alert(result);
               location.reload();
          }
        });
      } 
      
   function edit(val)
   {
      $.ajax({
          url: "ajax.php",
          type:"post",
          data:{v:val,type:'6'},
           success: function(result){
            $("#frm").html(result);
               
          }
        });
      }
       
       
  </script>