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 : addbanner.php

<?php

require('include/header.php');

$title='';

$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 banner where id='$id'");

$check=mysqli_num_rows($res);

if($check>0){

$row=mysqli_fetch_assoc($res);

$title=$row['title'];

$image=$row['image'];

}else{

header('Location:listbanner.php');

die();

}

if(isset($_POST['submit'])){

$title=get_safe_value($con,$_POST['title']);

//$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'];

move_uploaded_file($_FILES['image']['tmp_name'],BANNER_IMAGE_SERVER_PATH.$image);

$update_sql="update banner set title='$title',image='$image' where id='$id'";

}else{

$update_sql="update banner set title='$title' 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'],BANNER_IMAGE_SERVER_PATH.$image);

mysqli_query($con,"insert into banner(title,image,status,date_created) values('$title','$image',1, current_timestamp())");

}

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

exit;

die();

}

<div class="card-header">Add banners

<li><a href="listbanner.php">List Banner</a></li>

</ol>

</div>

</div>

<label for="image" class=" form-control-label">Image</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='".BANNER_IMAGE_SITE_PATH.$image."'/>";

}

</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>

<?php

require('include/footer.php');

${this.title}

Code Editor : addbanner.php