芝麻web文件管理V1.00

编辑当前文件:/home/krishnamexports/public_html/panel/pages/home_setting/home_setting.php

<?php

include_once("fckeditor/fckeditor.php");

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

{

$website     		    = mysqli_real_escape_string($cn,$_POST['website']);

$tagline                = mysqli_real_escape_string($cn,$_POST['tagline']);

$logo    				= $_FILES['logo']['name'];

$contact    		    = $_POST['contact'];

$email   	  		    = $_POST['email'];

$address     	 	    = $_POST['address'];

$embed_map              = $_POST['embed_map'];

$meta_keyword 	        = mysqli_real_escape_string($cn,$_POST['meta_keyword']);

$meta_description       = mysqli_real_escape_string($cn,$_POST['meta_description']);

$fav_icon    	        = $_FILES['fav_icon']['name'];

$category_id1			= $_POST['category_id1'];

$gallery1    			= $_FILES['gallery1']['name'];

$title1				    = $_POST['title1'];

$subtitle1				= $_POST['subtitle1'];

$category_id2			= $_POST['category_id2'];

$gallery2    			= $_FILES['gallery2']['name'];

$title2				    = $_POST['title2'];

$subtitle2				= $_POST['subtitle2'];

$category_id3			= $_POST['category_id3'];

$gallery3    			= $_FILES['gallery3']['name'];

$title3				    = $_POST['title3'];

$subtitle3				= $_POST['subtitle3'];

$category_id4			= $_POST['category_id4'];

$gallery4   			= $_FILES['gallery4']['name'];

$title4				    = $_POST['title4'];

$subtitle4				= $_POST['subtitle4'];

$category_id5			= $_POST['category_id5'];

$gallery5   			= $_FILES['gallery5']['name'];

$title5				    = $_POST['title5'];

$subtitle5				= $_POST['subtitle5'];

$category_id6			= $_POST['category_id6'];

$gallery6   			= $_FILES['gallery6']['name'];

$title6				    = $_POST['title6'];

$subtitle6				= $_POST['subtitle6'];

$category_id7			= implode(',',$_POST['category_id7']);

$title7				    = $_POST['title7'];

$subtitle7				= $_POST['subtitle7'];

$about_title            = $_POST['about_title'];

$about_description      = $_POST['about_description'];

$discount_title         = mysqli_real_escape_string($cn,$_POST['discount_title']);

$discount_description   = mysqli_real_escape_string($cn,$_POST['discount_description']);

$product_count          = $_POST['product_count'];

$sql     = mysqli_query($cn,"select * from `tbl_home`");

$sqlData = mysqli_fetch_array($sql);

if(!empty($logo))

{

move_uploaded_file($_FILES['logo']['tmp_name'],'../logo/'.$logo);

}

else

{

$logo = $_POST['old_logo'];

}

if(!empty($fav_icon))

{

move_uploaded_file($_FILES['fav_icon']['tmp_name'],'../logo/'.$fav_icon);

}

else

{

$fav_icon = $_POST['old_fav_icon'];

}

if(!empty($gallery1))

{

move_uploaded_file($_FILES['gallery1']['tmp_name'],'../home_setting/'.$gallery1);

}

else

{

$gallery1 		     = $sqlData['gallery1'];

}

if(!empty($gallery2))

{

move_uploaded_file($_FILES['gallery2']['tmp_name'],'../home_setting/'.$gallery2);

}

else

{

$gallery2 		     = $sqlData['gallery2'];

}

if(!empty($gallery3))

{

move_uploaded_file($_FILES['gallery3']['tmp_name'],'../home_setting/'.$gallery3);

}

else

{

$gallery3 		     = $sqlData['gallery3'];

}

if(!empty($gallery4))

{

move_uploaded_file($_FILES['gallery4']['tmp_name'],'../home_setting/'.$gallery4);

}

else

{

$gallery4 		     = $sqlData['gallery4'];

}

if(!empty($gallery5))

{

move_uploaded_file($_FILES['gallery5']['tmp_name'],'../home_setting/'.$gallery5);

}

else

{

$gallery5		     = $sqlData['gallery5'];

}

if(!empty($gallery6))

{

move_uploaded_file($_FILES['gallery6']['tmp_name'],'../home_setting/'.$gallery6);

}

else

{

$gallery6		     = $sqlData['gallery6'];

}

$sqlSubject	= mysqli_query ($cn, "update `tbl_home` set `tagline`='".$tagline."', `website`='".$website."', `logo`='".$logo."', `contact`='".$contact."', `email`='".$email."', `address`='".$address."', `embed_map`='".$embed_map."', `meta_keyword`='".$meta_keyword."', `meta_description`='".$meta_description."', `fav_icon`='".$fav_icon."', `category_id1`='".$category_id1."', `gallery1`='".$gallery1."', `title1`='".$title1."', `subtitle1`='".$subtitle1."', `category_id2`='".$category_id2."', `gallery2`='".$gallery2."', `title2`='".$title2."', `subtitle2`='".$subtitle2."', `category_id3`='".$category_id3."', `gallery3`='".$gallery3."', `title3`='".$title3."', `subtitle3`='".$subtitle3."', `category_id4`='".$category_id4."', `gallery4`='".$gallery4."', `title4`='".$title4."', `subtitle4`='".$subtitle4."', `category_id5`='".$category_id5."', `gallery5`='".$gallery5."', `title5`='".$title5."', `subtitle5`='".$subtitle5."', `category_id6`='".$category_id6."', `gallery6`='".$gallery6."', `title6`='".$title6."', `subtitle6`='".$subtitle6."', `category_id7`='".$category_id7."', `title7`='".$title7."', `subtitle7`='".$subtitle7."', `about_title`='".$about_title."', `about_description`='".$about_description."', `discount_title`='".$discount_title."', `discount_description`='".$discount_description."', `product_count`='".$product_count."' where `id`='1'");

if ($sqlSubject)

{

echo '<div class="alert alert-success"><strong>Success!</strong> Home Setting Updated Successfully.</div>';

}

else

{

echo '<div class="alert alert-danger"><strong>Danger!</strong> Some Error Occur.Please Try Again Later.</div>';

}

$sql             = mysqli_query($cn, "select * from tbl_home where id='1'");

$sqlData         = mysqli_fetch_array($sql);

$arrayOurProduct = explode(',',$sqlData['category_id7']);

<style>

.heading-title{

background: linear-gradient(120deg, #5983e8,#00e4d0);

text-align: center;

color:

white;

padding:10px;

font-size: 15px;

font-weight: 600;

}

</style>

<h3 class="heading-title">WEBSITE DETAIL</h3>

<label for="exampleInputPassword4">Logo Tagline</label>

<input type="text" class="form-control" name="tagline" value="<?php echo $sqlData['tagline'];?>" id="exampleInputPassword4" placeholder="Logo Tagline">

</div>

<label for="exampleInputPassword4">Website Title</label>

<input type="text" class="form-control" name="website" value="<?php echo $sqlData['website'];?>" id="exampleInputPassword4" placeholder="Website Title">

</div>

<label for="exampleInputPassword4">Website Logo</label>

<img src="../logo/<?php echo $sqlData['logo'];?>" height="50" width="150" style="background:#000;">

</div>

<label for="exampleInputPassword4">Contact No.</label>

<input type="text" class="form-control" name="contact" value="<?php echo $sqlData['contact'];?>" id="exampleInputPassword4" placeholder="Contact No.">

</div>

<label for="exampleInputPassword4">Email</label>

<input type="text" class="form-control" name="email" value="<?php echo $sqlData['email'];?>"  id="exampleInputPassword4" placeholder="Email">

</div>

<label for="exampleInputCity1">Address</label>

</div>

<label for="exampleInputCity1">Map Location ( Embed A Map )</label>

</div>

<img src="../logo/<?php echo $sqlData['fav_icon'];?>" height="50" width="50">

</div>

<label for="exampleInputPassword4">Meta Keyword</label>

<input type="text" class="form-control" name="meta_keyword" value="<?php echo $sqlData['meta_keyword'];?>"  id="exampleInputPassword4" placeholder="Meta Keyword">

</div>

<label for="exampleInputCity1">Meta Description</label>

</div>

<h3 class="heading-title">SHOP MENU BANNER</h3><br>

<label for="exampleInputPassword4">Menu Banner 1</label>

<img src="../home_setting/<?php echo $sqlData['gallery1'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Category Link To Banner 1</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<label for="exampleInputPassword4">Menu Banner 2</label>

<img src="../home_setting/<?php echo $sqlData['gallery1'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Category Link To Banner 2</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<h3 class="heading-title">HOME TRENDING CATEGORY</h3><br>

<label for="exampleInputPassword4">Category 1</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<label for="exampleInputPassword4">Category Image</label>

<img src="../home_setting/<?php echo $sqlData['gallery1'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Title</label>

<input type="text" class="form-control" name="title1" value="<?php echo $sqlData['title1'];?>" placeholder="Title">

</div>

<label for="exampleInputPassword4">Sub Title</label>

<input type="text" class="form-control" name="subtitle1" value="<?php echo $sqlData['subtitle1'];?>" placeholder="Sub Title">

</div>

<label for="exampleInputPassword4">Category 2</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<label for="exampleInputPassword4">Category Image</label>

<img src="../home_setting/<?php echo $sqlData['gallery2'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Title</label>

<input type="text" class="form-control" name="title2" value="<?php echo $sqlData['title2'];?>" placeholder="Title">

</div>

<label for="exampleInputPassword4">Sub Title</label>

<input type="text" class="form-control" name="subtitle2" value="<?php echo $sqlData['subtitle2'];?>" placeholder="Sub Title">

</div>

<label for="exampleInputPassword4">Category 3</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<label for="exampleInputPassword4">Category Image</label>

<img src="../home_setting/<?php echo $sqlData['gallery3'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Title</label>

<input type="text" class="form-control" name="title3" value="<?php echo $sqlData['title3'];?>" placeholder="Title">

</div>

<label for="exampleInputPassword4">Sub Title</label>

<input type="text" class="form-control" name="subtitle3" value="<?php echo $sqlData['subtitle3'];?>" placeholder="Sub Title">

</div>

<label for="exampleInputPassword4">Category 4</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<label for="exampleInputPassword4">Category Image</label>

<img src="../home_setting/<?php echo $sqlData['gallery4'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Title</label>

<input type="text" class="form-control" name="title4" value="<?php echo $sqlData['title4'];?>" placeholder="Title">

</div>

<label for="exampleInputPassword4">Sub Title</label>

<input type="text" class="form-control" name="subtitle4" value="<?php echo $sqlData['subtitle4'];?>" placeholder="Sub Title">

</div>

<label for="exampleInputPassword4">Category 5</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<label for="exampleInputPassword4">Category Image</label>

<img src="../home_setting/<?php echo $sqlData['gallery5'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Title</label>

<input type="text" class="form-control" name="title5" value="<?php echo $sqlData['title5'];?>" placeholder="Title">

</div>

<label for="exampleInputPassword4">Sub Title</label>

<input type="text" class="form-control" name="subtitle5" value="<?php echo $sqlData['subtitle5'];?>" placeholder="Sub Title">

</div>

<label for="exampleInputPassword4">Category 6</label>

<option value="">Select Category</option>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<label for="exampleInputPassword4">Category Image</label>

<img src="../home_setting/<?php echo $sqlData['gallery6'];?>" height="100" width="200">

</div>

<label for="exampleInputPassword4">Title</label>

<input type="text" class="form-control" name="title6" value="<?php echo $sqlData['title6'];?>" placeholder="Title">

</div>

<label for="exampleInputPassword4">Sub Title</label>

<input type="text" class="form-control" name="subtitle6" value="<?php echo $sqlData['subtitle6'];?>" placeholder="Sub Title">

</div>

<h3 class="heading-title">HOME ABOUT SECTION</h3><br>

<label for="exampleInputPassword4">About Title</label>

<input type="text" class="form-control" name="about_title" value="<?php echo $sqlData['about_title'];?>" placeholder="About Title">

</div>

<label for="exampleInputCity1">About Description</label>

</div>

<h3 class="heading-title">HOME DISCOUNT SECTION</h3><br>

<label for="exampleInputPassword4">DISCOUNT TITLE</label>

<input type="text" class="form-control" name="discount_title" value="<?php echo $sqlData['discount_title'];?>" placeholder="DISCOUNT TITLE">

</div>

<label for="exampleInputCity1">DISCOUNT DESCRIPTION</label>

<?php

$oFCKeditor = new FCKeditor('discount_description');

$oFCKeditor->BasePath = 'fckeditor/';

//set the EnterMode to "br" (overwrites the default configuration from fckconfig.js)

$oFCKeditor->Config['EnterMode'] = 'br';

$oFCKeditor->Value = "";

$oFCKeditor->Value = $sqlData['discount_description'];

$oFCKeditor->Create() ;

</div>

<h3 class="heading-title">HOME OUR PRODUCT - CATEGORY SECTION</h3><br>

<label for="exampleInputPassword4">Title</label>

<input type="text" class="form-control" name="title7" value="<?php echo $sqlData['title7'];?>" placeholder="Title">

</div>

<label for="exampleInputPassword4">Sub Title</label>

<input type="text" class="form-control" name="subtitle7" value="<?php echo $sqlData['subtitle7'];?>" placeholder="Sub Title">

</div>

<label for="exampleInputPassword4">Product Count</label>

<input type="text" class="form-control" name="product_count" value="<?php echo $sqlData['product_count'];?>" placeholder="product Count">

</div>

<label for="exampleInputPassword4">Category Selector</label>

<?php $sqlCategory = mysqli_query($cn, "select * from `tbl_category` where `status` IN(0,1)");

while($sqlCategoryData = mysqli_fetch_array($sqlCategory)){?>

<?php }?>

</select>

</div>

<button type="submit" class="btn btn-success mr-2" name="submit">Submit</button>

</form>

</div>