Gecko [ www.stclareschooldimapur.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
vendors	[ DIR ]	drwxr-xr-x
activitycalendar.php	9.01 KB	-rw-r--r--
add10topper.php	7.01 KB	-rw-r--r--
add12topper.php	7.01 KB	-rw-r--r--
addaboutus.php	6.13 KB	-rw-r--r--
addaward.php	4.1 KB	-rw-r--r--
addbanner.php	5.38 KB	-rw-r--r--
adddetailmessage.php	6.19 KB	-rw-r--r--
addevent.php	7.61 KB	-rw-r--r--
addfacility.php	4.2 KB	-rw-r--r--
addfeesdata.php	8.46 KB	-rw-r--r--
addfeesheading.php	6.37 KB	-rw-r--r--
addgeninfo.php	5.12 KB	-rw-r--r--
addhistory.php	4.19 KB	-rw-r--r--
addintro.php	4.15 KB	-rw-r--r--
addmissionwithdrawal.php	9.05 KB	-rw-r--r--
addmoment.php	5.41 KB	-rw-r--r--
addnotice.php	6.29 KB	-rw-r--r--
addphotogallery.php	5.44 KB	-rw-r--r--
addphotos.php	4.89 KB	-rw-r--r--
addschoolinformation.php	4.26 KB	-rw-r--r--
addvision.php	4.19 KB	-rw-r--r--
admin.php	5.24 KB	-rw-r--r--
administration.php	8.99 KB	-rw-r--r--
assesment.php	8.94 KB	-rw-r--r--
booklist.php	8.93 KB	-rw-r--r--
cocurricular.php	9.01 KB	-rw-r--r--
contactlist.php	5.53 KB	-rw-r--r--
curriculum.php	9.36 KB	-rw-r--r--
dashboard.php	40.13 KB	-rw-r--r--
editfooter.php	18.56 KB	-rw-r--r--
examination.php	8.96 KB	-rw-r--r--
find.php	4.27 KB	-rw-r--r--
geninfo.php	5.03 KB	-rw-r--r--
index.php	31.9 KB	-rw-r--r--
list10topper.php	5.68 KB	-rw-r--r--
list12topper.php	5.68 KB	-rw-r--r--
listaboutus.php	5.36 KB	-rw-r--r--
listaward.php	5.23 KB	-rw-r--r--
listbanner.php	5.35 KB	-rw-r--r--
listdetailmessage.php	5.54 KB	-rw-r--r--
listevent.php	5.77 KB	-rw-r--r--
listfacility.php	5.25 KB	-rw-r--r--
listfeesdata.php	5.57 KB	-rw-r--r--
listfeesheading.php	5.37 KB	-rw-r--r--
listhistory.php	5.25 KB	-rw-r--r--
listintro.php	5.25 KB	-rw-r--r--
listmoment.php	5.36 KB	-rw-r--r--
listnotice.php	5.57 KB	-rw-r--r--
listphotogallery.php	5.4 KB	-rw-r--r--
listphotos.php	5.58 KB	-rw-r--r--
listschoolinformation.php	5.33 KB	-rw-r--r--
listvision.php	5.24 KB	-rw-r--r--
logout.php	302 B	-rw-r--r--
profile.php	9.74 KB	-rw-r--r--
rules.php	8.94 KB	-rw-r--r--
sportcorner.php	8.9 KB	-rw-r--r--
studenttcdetails.php	5.87 KB	-rw-r--r--

Code Editor : editfooter.php

<?php
require('include/header.php');
$title='';
$location='';
$opening='';
$phone='';
$mobile='';
$whatsapp='';
$email='';
$facebook='';
$instagram='';
$twitter='';
$youtube='';
$copyname='';
$year='';
$map='';
$msg='';
$image='';
$image_required='required';
if(isset($_GET['id']) && $_GET['id']!=''){
   $image_required='';
   $id=get_safe_value($con,$_GET['id']);
   $res=mysqli_query($con,"select * from footer where id='$id'");
   
   $check=mysqli_num_rows($res);
   if($check>0){
      $row=mysqli_fetch_assoc($res);
      $title=$row['title'];
         $location=$row['location'];
            $opening=$row['opening'];
               $phone=$row['phone'];
                  $mobile=$row['mobile'];
                     $whatsapp=$row['whatsapp'];
                        $email=$row['email'];
                           $map=$row['map'];
                            $facebook=$row['facebook'];
                             $instagram=$row['instagram'];
                              $twitter=$row['twitter'];
                               
                               $youtube=$row['youtube'];
                                $copyname=$row['copyname'];
                                 $year=$row['year'];
      $image=$row['image'];
     
   }else{ 
      header('Location:editfooter.php');
      die();
   }
  
  
}

if(isset($_POST['submit'])){
   $title=get_safe_value($con,$_POST['title']);
     $location=get_safe_value($con,$_POST['location']);
       $opening=get_safe_value($con,$_POST['opening']);
         $phone=get_safe_value($con,$_POST['phone']);
           $mobile=get_safe_value($con,$_POST['mobile']);
             $whatsapp=get_safe_value($con,$_POST['whatsapp']);
               $email=get_safe_value($con,$_POST['email']);
                 $map=get_safe_value($con,$_POST['map']);
                   $facebook=get_safe_value($con,$_POST['facebook']);
                     $instagram=get_safe_value($con,$_POST['instagram']);
                       $twitter=get_safe_value($con,$_POST['twitter']);
                         $youtube=get_safe_value($con,$_POST['youtube']);
                           $copyname=get_safe_value($con,$_POST['copyname']);
                             $year=get_safe_value($con,$_POST['year']);
   //$image=get_safe_value($con,$_POST['image']);

//image format validation---------
   	
	if(isset($_GET['id']) && $_GET['id']==0){
		if($_FILES['image']['type']!='image/png' && $_FILES['image']['type']!='image/jpg' && $_FILES['image']['type']!='image/jpeg'){
			$msg="Please select only png,jpg and jpeg image formate";
		}
	}else{
		if($_FILES['image']['type']!=''){
				if($_FILES['image']['type']!='image/png' && $_FILES['image']['type']!='image/jpg' && $_FILES['image']['type']!='image/jpeg'){
				$msg="Please select only png,jpg and jpeg image formate";
			}
		}
	}
//image format validation---------   
$msg="";
if($msg==''){
   if(isset($_GET['id']) && $_GET['id']!=''){

if($_FILES['image']['name']!=''){
         $image=rand(111111111,999999999).'_'.$_FILES['image']['name'];
          $images=rand(111111111,999999999).'_'.$_FILES['images']['name'];
        
         move_uploaded_file($_FILES['image']['tmp_name'],PROFILE_IMAGE_SERVER_PATH.$image);
         $update_sql="update footer set title='$title',image='$image',location='$location',opening='$opening',phone='$phone',mobile='$mobile',whatsapp='$whatsapp',email='$email',map='$map',facebook='$facebook',instagram='$instagram',twitter='$twitter',youtube='$youtube',copyname='$copyname',year='$year' where id='$id'";
      }else{
         $update_sql="update footer set title='$title',location='$location',opening='$opening',phone='$phone',mobile='$mobile',whatsapp='$whatsapp',email='$email',map='$map',facebook='$facebook',instagram='$instagram',twitter='$twitter',youtube='$youtube',copyname='$copyname',year='$year' where id='$id'";
      }
 
      mysqli_query($con,$update_sql);

}
   else{
      $image=rand(111111111,999999999).'_'.$_FILES['image']['name'];

//$image=rand(111111111,999999999).'_'.$_FILES['image']['name'];
move_uploaded_file($_FILES['image']['tmp_name'],PROFILE_IMAGE_SERVER_PATH.$image);
   mysqli_query($con,"insert into footer(title,image,location,opening,phone,mobile,whatsapp,email,map,facebook,instagram,twitter,youtube,copyname,year,status,date_created) values('$title','$image','$location','$opening','$phone','$mobile','$whatsapp','$email','$map','$facebook','$instagram','$twitter','$youtube','$copyname','$year',1, current_timestamp())");
}

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

exit;
die();
}
}

if(isset($_GET['type']) && $_GET['type']!=''){
   $type=get_safe_value($con, $_GET['type']);
   if($type=='status'){
      $operation=get_safe_value($con, $_GET['operation']);
      $id=get_safe_value($con, $_GET['id']);

if($operation=='active'){
         $status=1;

}else{
         $status=0;
      }

$update_status_sql="update footer set status='$status' where id='$id'";
      mysqli_query($con,$update_status_sql);

}

//For Delete categories-----------------------------------------------------------------------------------
   if($type=='delete'){
           $id=get_safe_value($con, $_GET['id']);

$delete_sql="delete from footer where id='$id'";
      mysqli_query($con,$delete_sql);

}

}
//For Delete categories------------------------------------------------------------------------------------
$sql="select * from footer order by id asc";
$res=mysqli_query($con, $sql); 
?>

<div class="col-lg-12">
                                                    <div class="card">
                                                        <div class="card-header">Footer Settings
                                                       
                </div>

</div>
      <div class="card-body card-block">
        <form method="post" enctype="multipart/form-data">
          <div class="form-group">
        <div class="input-group">
         <div class="input-group-addon"><i class="fa fa-user"></i></div>
            <input type="text" id="title" name="title" placeholder="School Name" class="form-control" required value="<?php echo $title ?>">
               </div>
              </div>

<div class="form-group">
         <label for="image" class=" form-control-label">School Logo</label>
          <input type="file" name="image" class="form-control" <?php echo $image_required ?>value="<?php echo $image?>">
             <?php
             if($image!=''){
              echo "
              <img width='150px' src='".PROFILE_IMAGE_SITE_PATH.$image."'/>";
                                           
       }
       ?>
      </div>

<div class="form-group">
             <label for="location" class=" form-control-label">Location</label>
        <div class="input-group">
         <div class="input-group-addon"><i class="fa fa-user"></i></div>
            <input type="text" id="location" name="location" placeholder="Enter School Location" class="form-control" required value="<?php echo $location ?>">
               </div>
              </div>
              
                <div class="form-group">
             <label for="opening" class=" form-control-label">Openning Hours</label>
        <div class="input-group">
         <div class="input-group-addon"><i class="fa fa-user"></i></div>
            <input type="text" id="opening" name="opening" placeholder="Enter School Location" class="form-control" required value="<?php echo $opening ?>">
               </div>
              </div>
              
              
                  <div class="form-group">
             <label for="social" class=" form-control-label">Social Media Accounts</label>
        <div class="input-group">
         <div class="input-group-addon"><i class="fa fa-facebook-square "></i></div>
            <input type="text" id="facebook" name="facebook" placeholder="Enter Facebook link" class="form-control" required value="<?php echo $facebook ?>">
            
              </div>
              
               
              <div class="input-group">
             <div class="input-group-addon"><i class="fa fa-instagram"></i></div>
              <input type="text" id="instagram" name="instagram" placeholder="Enter instagram link" class="form-control" required value="<?php echo $instagram ?>">
              
                </div>
              
               
              <div class="input-group">
               <div class="input-group-addon"><i class="fa fa-twitter "></i></div>
                <input type="text" id="twitter" name="twitter" placeholder="Enter twitter link" class="form-control" required value="<?php echo $twitter ?>">
                
                  </div>
              
               
              <div class="input-group">
                 <div class="input-group-addon"><i class=" fafa-youtube-play "></i></div>
                  <input type="text" id="youtube" name="youtube" placeholder="Enter Yoube link" class="form-control" required value="<?php echo $youtube ?>">
               </div>
              </div>
              
              
              
                  <div class="form-group">
             <label for="phone" class=" form-control-label">Contact Us</label>
        <div class="input-group">
         <div class="input-group-addon"><i class="fa fa-user"></i></div>
            <input type="text" id="phone" name="phone" placeholder="Enter Phone No." class="form-control" required value="<?php echo $phone ?>">
            
       
              <div class="input-group">
             <div class="input-group-addon"><i class="fa fa-user"></i></div>
              <input type="text" id="mobile" name="mobile" placeholder="Enter Mobile No." class="form-control" required value="<?php echo $mobile ?>">
              </div>
        
              
              
              <div class="input-group">
               <div class="input-group-addon"><i class="fa fa-user"></i></div>
                <input type="text" id="whatsapp" name="whatsapp" placeholder="Enter Whatsapp No." class="form-control" required value="<?php echo $whatsapp ?>">
                
                  
              </div>
              
               
              <div class="input-group">
                 <div class="input-group-addon"><i class="fa fa-user"></i></div>
                  <input type="text" id="email" name="email" placeholder="Enter Email Address" class="form-control" required value="<?php echo $email ?>">
            
              </div>
              </div>
 <div class="form-group">
             <label for="map" class=" form-control-label">Google Map Embed Url</label>
        <div class="input-group">
         <div class="input-group-addon"><i class="fa fa-user"></i></div>
            <input type="text" id="map" name="map" placeholder="Enter School Location" class="form-control" required value="<?php echo $map ?>">
               </div>
              </div>

<div class="form-group">
             <label for="copyname" class=" form-control-label">Copyright name</label>
        <div class="input-group">
         <div class="input-group-addon"><i class="fa fa-user"></i></div>
            <input type="text" id="copyname" name="copyname" placeholder="Enter Copyright name" class="form-control" required value="<?php echo $copyname ?>">
            
              </div>
              
               
              <div class="input-group">
                    <div class="input-group-addon"><i class="fa fa-user"></i></div>
              <input type="text" id="year" name="year" placeholder="Enter Copyright Year" class="form-control" required value="<?php echo $year ?>">
               </div>
              </div>

<div class="form-actions form-group"><button type="submit" name="submit" class="btn btn-success btn-sm">Submit</button></div>
                                                            </form>
                                                        </div>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="breadcrumbs">
            <div class="col-sm-4">
                <div class="page-header float-left">
                    <div class="page-title">
                        <h1>Dashboard</h1>
                    </div>
                </div>
            </div>
          
        </div>

<div class="col-md-12">
                        <div class="card">
                            <div class="card-header">
                                <strong class="card-title">Footer Settings</strong>

</div>

</div>
                          
                            <div class="card-body">
                                <table id="bootstrap-data-table-export" class="table table-striped table-bordered">
                                    <thead>
                                        <tr>
                                        <th class="serial">#</th>
                                            <th>Title</th>
                                            <th>Main Image</th>
                                             <th>Location</th>
                                            <th>Opening Hours</th>
                                              <th>Phone No.</th>
                                                <th>Mobile No.</th>
                                                  <th>Whatsapp No.</th>
                                                    <th>Email</th>
                                                      <th>facebook</th>
                                                        <th>Instagram</th> 
                                                        <th>Twitter</th>
                                                          <th>Youtube</th>
                                                        <th>Map Link</th>
                                                    <th>Copyright Name</th>
                                                    <th>Copyright Year</th>
                                                    <th></th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    <?php
                                    $i=1;
                                    while($row=mysqli_fetch_assoc($res)){ ?>
                                       
                                    <tr>
                                        <tr>
                                        <td class="serial"><?php echo $i ?></td>
                                               
                                       <td> <?php echo $row['title'] ?></td>
                                       <td> <img width='150px'src="<?php echo PROFILE_IMAGE_SITE_PATH.$row['image'] ?>"></td>
                                      
                                        <td> <?php echo $row['location'] ?></td>
                                         <td> <?php echo $row['opening'] ?></td>
                                          <td> <?php echo $row['phone'] ?></td>
                                           <td> <?php echo $row['mobile'] ?></td>
                                        <td> <?php echo $row['whatsapp'] ?></td>
                                        <td> <?php echo $row['email'] ?></td>
                                        <td> <?php echo $row['facebook'] ?></td> <td> <?php echo $row['instagram'] ?></td> 
                                        <td> <?php echo $row['twitter'] ?></td> 
                                        <td> <?php echo $row['youtube'] ?></td>
                                         <td> <?php echo $row['map'] ?></td>
                                        <td> <?php echo $row['copyname'] ?></td>
                                        <td> <?php echo $row['year'] ?></td>
                                           
                                            
                                            
                                            
                                            <td>
                                            
                                            <?php
                                          if($row['status']==1){
                                             echo "<span class='badge badge-complete'><a href='?type=status&operation=deactive&id=".$row['id']."'>Active</a></span>&nbsp &nbsp";

}else{
                                             echo "<span class='badge badge-pending'><a href='?type=status&operation=active&id=".$row['id']."'> Deactive</a></span>&nbsp &nbsp";

}
                     // for edit button code
                                          
                                          echo "<span class='badge badge-edit'><a href='editfooter.php?id=".$row['id']."'> Edit</a></span> ";
                                          
                                          
                                          //for delete button code
                                          // echo "<a href='?type=delete&id=".$row['id']."'> Delete</a> ";
                                          echo "<span class='badge badge-delete'><a href='?type=delete&id=".$row['id']."'> Delete</a></span>&nbsp ";

?>
                                       </td>                                      
                                    </tr>
                                    <?php $i++; }  ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>

</div>
            </div>
        </div>

</div>

<?php 
    require('include/footer.php');
    ?>

${this.title}

Code Editor : editfooter.php