View file File name : bigsquare-addf.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); include("../include/simpleimage.php"); validate_admin(); $title=mysqli_real_escape_string($GLOBALS['conn'],$_POST['title']); $target_url=mysqli_real_escape_string($GLOBALS['conn'],$_POST['target_url']); $description=mysqli_real_escape_string($GLOBALS['conn'],$_POST['description']); $show_on_home=mysqli_real_escape_string($GLOBALS['conn'],$_POST['show_on_home']); $keytitle=mysqli_real_escape_string($GLOBALS['conn'],$_POST['keytitle']); $catAr=getCategoryArray($cat_id,$array=''); if(count($catAr)>0){ $bcategories=implode(",",$catAr); } if($_REQUEST['submitForm']=='yes'){ if($_FILES['photo']['size']>0 && $_FILES['photo']['error']==''){ $Image=new SimpleImage(); $img=time().$_FILES['photo']['name']; move_uploaded_file($_FILES['photo']['tmp_name'],"../upload_images/bigsquarebanner/".$img); copy("../upload_images/bigsquarebanner/".$img,"../upload_images/bigsquarebanner/thumb/".$img); $Image->load("../upload_images/bigsquarebanner/thumb/".$img); $Image->resize(280,280); $Image->save("../upload_images/bigsquarebanner/thumb/".$img); } if($_REQUEST['id']==''){ $obj->query("insert into $tbl_bigsquarebanner set title='$title',target_url='$target_url',show_on_home='$show_on_home',description='$description',photo='$img',status=1,keytitle='$keytitle'"); $_SESSION['sess_msg']='Banner added sucessfully'; }else{ $sql="update $tbl_bigsquarebanner set title='$title',show_on_home='$show_on_home',target_url='$target_url',description='$description',status=1,keytitle='$keytitle'"; if($img){ $imageArr=$obj->query("select photo from $tbl_bigsquarebanner where id=".$_REQUEST['id']); $resultImage=$obj->fetchNextObject($imageArr); @unlink("../upload_images/bigsquarebanner/".$resultImage->photo); @unlink("../upload_images/bigsquarebanner/thumb/".$resultImage->photo); $sql.=" , photo='$img' "; } $sql.=" where id='".$_REQUEST['id']."'"; $obj->query($sql); $_SESSION['sess_msg']='Banner updated sucessfully'; } header("location:bigsquare-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from $tbl_bigsquarebanner where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title><?php echo SITE_TITLE; ?></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="css/admin.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" language="javascript"> function validate(obj) { <?php if($_REQUEST['id']==''){ ?> if(obj.photo.value==''){ alert("Please select image"); obj.photo.focus(); return false; } <?php } ?> } </script> </head> <body> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <?php include("header.php") ?> <link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" /> <script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script> <script type="text/javascript"> $(document).ready(function(){ $('#category').autocomplete({ search: function () {}, source: function (request, response) { $.ajax( { url:"getCategoryTree.php" , dataType: "json", data: { q: request.term, }, success: function (data) { response(data); } }); }, minLength: 2, select: function( event, ui ) { $( "#category" ).val( ui.item.value ); $( "#hdnId" ).val( ui.item.key ); var cat_id=$( "#hdnId" ).val(); //alert(cat_id); return false; } }); }) </script> <tr> <td align="right" class="paddRtLt70" valign="top"> <table width="99%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="middle" class="headingbg bodr text14"> <em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: Add Big Square Banners<span style="float:right; padding-right:10px;"> <input type="button" name="add" value="View Banners" class="button" onclick="location.href='bigsquare-list.php'" /></span></td> </tr> <tr> <td height="100" align="left" valign="top" bgcolor="#f3f4f6" class="bodr"> <form name="frm" method="POST" enctype="multipart/form-data" action="" onsubmit="return validate(this)"> <input type="hidden" name="submitForm" value="yes" /> <input type="hidden" name="id" value="<?php echo $_REQUEST['id'];?>" /> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td align="center" colspan="2" class="paddRt14 paddBot11"> <font color="#FF0000"><strong><?php echo $_SESSION['sess_msg']; $_SESSION['sess_msg']='';?></strong></font></td> </tr> <tr> <td width="18%" align="right" class="paddBot11 paddRt14"> </td> <td width="82%" align="left" class="paddBot11"></td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"><strong>Title :</strong></td> <td align="left" class="paddBot11"> <input name="title" size="36" id="title" value="<?php echo stripslashes($result->title);?>" > </td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"><strong>Key Title :</strong></td> <td align="left" class="paddBot11"> <input name="keytitle" size="36" id="keytitle" value="<?php echo stripslashes($result->keytitle);?>" > </td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"><strong>Short Description :</strong></td> <td align="left" class="paddBot11"> <input name="description" size="36" id="description" value="<?php echo stripslashes($result->description);?>" > </td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Banner Image(280px X 280px):<br/> </strong></td> <td align="left" class="paddBot11"><input type="file" name="photo" /><br/> <?php if(is_file("../upload_images/bigsquarebanner/thumb/".$result->photo)){ ?> <img src="../upload_images/bigsquarebanner/thumb/<?php echo $result->photo; ?>" /><?php } ?></td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"><strong>Traget URL :</strong></td> <td align="left" class="paddBot11"><textarea name="target_url" rows="8" cols="40" id="target_url"><?php echo stripslashes($result->target_url);?></textarea></td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"><strong>Show On Home:</strong></td> <td align="left" class="paddBot11"><input type="checkbox" name="show_on_home" value="1" <?php if($result->show_on_home==1){?>checked<?php } ?>></td> </tr> <tr> <td align="right" class="paddRt14 paddBot11"> </td> <td align="left" class="paddBot11"> </td> </tr> <tr> <td width="18%" align="right" class="paddRt14 paddBot11"> </td> <td width="82%" align="left" class="paddBot11"> <input type="submit" name="submit" value="Submit" class="submit" border="0"/> <input name="Reset" type="reset" id="Reset" value="Reset" class="submit" border="0" /> </td> </tr> </table> </form> </td> </tr> </table> </td> </tr> </table> </td> </tr> <?php include('footer.php'); ?> </table> </body> </html>