1#@!#!123s

file_get_contents 1#@!#!123s
: / home / maintdesigns / public_html / Admin /
Filename : projects.php
back
<?php 

session_start();

if(!$_SESSION['isLogged']) {



		echo "<script language='javascript'>alert(' access deny');window.location.replace('index.html');</script>";

           

}



include("header.php");

include("menu.php");?>

  

<style>

#myInput {

    background-image: url('/css/searchicon.png'); /* Add a search icon to input */

    background-position: 10px 12px; /* Position the search icon */

    background-repeat: no-repeat; /* Do not repeat the icon image */

    width: 100%; /* Full-width */

    font-size: 16px; /* Increase font-size */

    padding: 12px 20px 12px 40px; /* Add some padding */

    border: 1px solid #ddd; /* Add a grey border */

    margin-bottom: 12px; /* Add some space below the input */

}



#myTable {

    border-collapse: collapse; /* Collapse borders */

    width: 100%; /* Full-width */

    border: 1px solid #ddd; /* Add a grey border */

    font-size: 18px; /* Increase font-size */

}



#myTable th, #myTable td {

    text-align: left; /* Left-align text */

    padding: 12px; /* Add padding */

}



#myTable tr {

    /* Add a bottom border to all table rows */

    border-bottom: 1px solid #ddd; 

}



#myTable tr.header, #myTable tr:hover {

    /* Add a grey background color to the table header and on hover */

    background-color: #f1f1f1;

}

</style>

    <div class="wrap-fluid">

        <div class="container-fluid paper-wrap bevel tlbr">



    

            <div id="paper-top">

                <div class="row">

                    <div class="col-sm-3">

                        <h2 class="tittle-content-header">



                            <span class="icon-menu"></span>





                            <span>Projects

                            </span>

                        </h2>



                    </div>



                    <div class="col-sm-6">

                        <div class="devider-vertical visible-lg"></div>



                    </div>

                    

                </div>

            </div>

        





  <ul id="breadcrumb">

                <li>

                    <span class="entypo-home"></span>

                </li>

                <li><i class="fa fa-lg fa-angle-right"></i>

                </li>

                <li>Home

                </li>

                <li><i class="fa fa-lg fa-angle-right"></i>

                </li>

                <li><a href="projects_category.php">Projects</a>

                </li>
                	<?PHP

                 	include('../connection.php');

                    $sql1="select * from category where id=".$_GET['id'];

					$query1=mysqli_query($con,$sql1);
					$res1=mysqli_fetch_assoc($query1);?>
                
                 <li><i class="fa fa-lg fa-angle-right"></i>

                </li>

                <li><?php echo $res1['name'];?>

                </li>
                <?php if($_GET['sub_id']!=0)
				{?>
                  <li><i class="fa fa-lg fa-angle-right"></i>

                </li>
               <?php $sql2="select * from `sub-category` where id=".$_GET['sub_id'];

					$query2=mysqli_query($con,$sql2);
					$res2=mysqli_fetch_assoc($query2);?>

                <li><?php echo $res2['name'];?>
				<?php }?>
                 <?php if($_GET['sub_sub_id']!=0)
				{?>
                  <li><i class="fa fa-lg fa-angle-right"></i>

                </li>
               <?php $sql3="select * from `sub-sub-category` where id=".$_GET['sub_sub_id'];

					$query3=mysqli_query($con,$sql3);
					$res3=mysqli_fetch_assoc($query3);?>

                <li><?php echo $res3['name'];?>
				<?php }?>

  </ul>



     

  <div class="content-wrap">

                <div class="row">

                    <div class="col-sm-12">

                        <div class="nest" id="FootableClose">

                             <div class="title-alt">
							 
							 
		
			 <h6><a href="addproject.php?id=<?php echo $res1['id'];?>&&sub_id=<?php echo $_GET['sub_id'];?>&&sub_sub_id=<?php echo $_GET['sub_sub_id'];?>">Add New Project</a></h6><br/><?php ?>
                
                
 
                            </div>

                            <div class="body-nest" id="Footable">

                               
 <table class="table-striped footable-res footable metro-blue" id="myTable" data-page-size="20">

                                    <thead>

                                        <tr>

                                            

                                            <td>Project Name</td>

                                            <td>Description</td>

                                             <td>Location</td>

                                              <td>Date</td>



                                            <td data-hide="phone"></td>
  										<td data-hide="phone"></td>
                                            <td></td>

                                        </tr>

                                    </thead>

                                    <tbody>

				

                 <?php if(!isset($_GET['sub_id'])) {
                           $_GET['sub_id']=0; } 
						   if(!isset($_GET['sub_sub_id'])) {
                           $_GET['sub_sub_id']=0; }
						   
 				
                    $sql4="select * from projects where category_id=".$_GET['id']." and sub_category_id=".$_GET['sub_id']."  and sub_sub_category_id=".$_GET['sub_sub_id']." order by id desc";
					$query4=mysqli_query($con,$sql4);

					$count=mysqli_num_rows($query4);?>

												</tbody>
                                      <form name="form1" method="post" onsubmit="return confirm('Are you sure you want to delete ?')" action="deleteproject.php?count=<?php echo $count;?>&&category_id=<?php echo $_GET['id'];?>&&sub_id=<?php echo $_GET['sub_id'];?>&&sub_sub_id=<?php echo $_GET['sub_sub_id'];?>">
                
             
                                                <?php

					while($res4=mysqli_fetch_assoc($query4))

					{?>

                                        <tr>

                                            <td><?php echo $res4['name'];?></td>

                                             <td><?php echo $res4['description'];?></td>

                                              <td><?php echo $res4['location'];?></td>

                                              <td><?php echo $res4['date'];?></td>

                                                

                                                  <td><a href="gallery.php?category_id=<?php echo $_GET['id'];?>&&sub_id=<?php echo $_GET['sub_id'];?>&&sub_sub_id=<?php echo $_GET['sub_sub_id'];?>&&project_id=<?php echo $res4['id'];?>">view gallery</a></td>

                                             <td> <a class="star" href="editproject.php?category_id=<?php echo $_GET['id'];?>&&sub_id=<?php echo $_GET['sub_id'];?>&&sub_sub_id=<?php echo $_GET['sub_sub_id'];?>&&project_id=<?php echo $res4['id'];?>"><img src="images/edit.png"/></a>
                 
                                              </td>

                                             <td data-value="500874333932"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<?php echo $res4['id']; ?>" /></td>

                                        </tr>

                                        <?php }?>

                                        <input name="delete" type="submit" id="delete" value="DELETE" /></form>

                                    

                                    <tfoot>

                                        <tr>

                                            <td colspan="9">

                                                <div class="pagination pagination-centered"></div>

                                            </td>

                                        </tr>

                                    </tfoot>

                                </table>

                            </div>

                        </div>



                    </div>

                </div>

            </div>

            </div>



            <div class="footer-space"></div>

            <div id="footer">

                <div class="devider-footer-left"></div>

                <div class="time">

                    <p id="spanDate"></p>

                    <p id="clock"></p>

              </div>

                <div class="devider-footer"></div>



            </div>

         





        </div>

    

<script>



function myFunction() {

  // Declare variables 

  var input, filter, table, tr, td, i;

  input = document.getElementById("myInput");

  filter = input.value.toUpperCase();

  table = document.getElementById("myTable");

  tr = table.getElementsByTagName("tr");



  // Loop through all table rows, and hide those who don't match the search query

  for (i = 0; i < tr.length; i++) {

    td = tr[i].getElementsByTagName("td")[0];

    if (td) {

      if (td.innerHTML.toUpperCase().indexOf(filter) > -1) {

        tr[i].style.display = "";

      } else {

        tr[i].style.display = "none";

      }

    } 

  }

}

</script>



<?php include("footer.php");

?>