1#@!#!123s

: / home / saravanabhavan / domains / hotelshrisaravanabhavan.com / public_html / admin /
Filename : com_edit.php
back
<?php  include ("session.php");?>
<?php include("connection.php"); ?>
<!DOCTYPE html>
<!--[if IE 8]> <html lang="en" class="ie8"> <![endif]-->
<!--[if IE 9]> <html lang="en" class="ie9"> <![endif]-->
<!--[if !IE]><!--> <html lang="en"> <!--<![endif]-->
<!-- BEGIN HEAD -->
<head>
   	<meta charset="utf-8" />
   	<title>Admin</title>
   	<meta content="width=device-width, initial-scale=1.0" name="viewport" />
   	<meta content="" name="description" />
   	<meta content="" name="author" />
   	<link rel="stylesheet" type="text/css" href="assets/chosen-bootstrap/chosen/chosen.css" />
   	<link href="assets/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
   	<link href="assets/bootstrap/css/bootstrap-responsive.min.css" rel="stylesheet" />
   	<link href="assets/bootstrap/css/bootstrap-fileupload.css" rel="stylesheet" />
   	<link href="assets/font-awesome/css/font-awesome.css" rel="stylesheet" />
   	<link href="css/style.css" rel="stylesheet" />
   	<link href="css/style_responsive.css" rel="stylesheet" />
   	<link href="css/style_default.css" rel="stylesheet" id="style_color" />
   	<link href="assets/fancybox/source/jquery.fancybox.css" rel="stylesheet" />
   	<link rel="stylesheet" type="text/css" href="assets/uniform/css/uniform.default.css" />
   	<link rel="stylesheet" type="text/css" href="assets/bootstrap-datepicker/css/datepicker.css" />
	<script type='text/javascript'>
	function removeParentOf(child) {
		tbody = child.parentNode.parentNode;
		if (tbody.rows.length > 1)
			tbody.removeChild(child.parentNode);
		renumberRows(tbody);
	}
	function cloneParentOf(child) {
		clone = child.parentNode.cloneNode( true );
		tbody = child.parentNode.parentNode;
		tbody.insertBefore( clone, child.parentNode );
		renumberRows(tbody);
	}
	function renumberRows(tbody) {
		var rowList = tbody.rows;
		for (i = 0; i < rowList.length; i++) {
			rowNumber = rowList.length - i;
			rowList.item(i).cells.item(0).firstChild.nodeValue = rowNumber;
			for (j = 0; j < rowList.item(i).cells.length; j++) {
				inputs = rowList.item(i).cells.item(j).getElementsByTagName('input');
				for (k = 0; k < inputs.length; k++) {
					if (inputs[k].name.match(/^\d+_/))
						inputs[k].name = inputs[k].name.replace(/^\d+_/, rowNumber + "_");
				}
			}
			var cell_count = rowList.item(i).cells.length;
			rowList.item(i).cells.item(cell_count - 1).firstChild.nodeValue = rowNumber;
		}
	}
</script>
</head>
	<script type="text/javascript">
		function validate(theform)
		{
			if(theform.wtitle.selectedIndex=="")
			{
				theform.wtitle.focus();
				return false;
			}
		}
	</script>
    <!-- TinyMCE -->
	<script language="javascript" type="text/javascript" src="../jscripts/tiny_mce/tiny_mce.js"></script>
	<script language="javascript" type="text/javascript" src="../jscripts/general.js"></script>
	<script language="javascript" type="text/javascript">
		tinyMCE.init({
			mode : "exact",
			elements : "area2",
			theme : "advanced",
			plugins : "advimage,advlink,media,contextmenu",
			theme_advanced_buttons1_add_before : "newdocument,separator",
			theme_advanced_buttons1_add : "fontselect,fontsizeselect",
			theme_advanced_buttons2_add : "separator,forecolor,backcolor,liststyle",
			theme_advanced_buttons2_add_before: "cut,copy,separator,",
			theme_advanced_buttons3_add_before : "",
			theme_advanced_buttons3_add : "media",
			theme_advanced_toolbar_location : "top",
			theme_advanced_toolbar_align : "left",
			extended_valid_elements : "hr[class|width|size|noshade]",
			file_browser_callback : "ajaxfilemanager",
			paste_use_dialog : false,
			theme_advanced_resizing : true,
			theme_advanced_resize_horizontal : true,
			apply_source_formatting : true,
			force_br_newlines : true,
			force_p_newlines : false,	
			relative_urls : true
		});
		function ajaxfilemanager(field_name, url, type, win) {
			var ajaxfilemanagerurl = "../../../../jscripts/tiny_mce/plugins/ajaxfilemanager/ajaxfilemanager.php";
			var view = 'detail';
			switch (type) {
				case "image":
				view = 'thumbnail';
					break;
				case "media":
					break;
				case "flash": 
					break;
				case "file":
					break;
				default:
					return false;
			}
            tinyMCE.activeEditor.windowManager.open({
                url: "../../../../jscripts/tiny_mce/plugins/ajaxfilemanager/ajaxfilemanager.php?view=" + view,
                width: 782,
                height: 440,
                inline : "yes",
                close_previous : "no"
            },{
                window : win,
                input : field_name
            });
/*            return false;			
			var fileBrowserWindow = new Array();
			fileBrowserWindow["file"] = ajaxfilemanagerurl;
			fileBrowserWindow["title"] = "Ajax File Manager";
			fileBrowserWindow["width"] = "782";
			fileBrowserWindow["height"] = "440";
			fileBrowserWindow["close_previous"] = "no";
			tinyMCE.openWindow(fileBrowserWindow, {
			  window : win,
			  input : field_name,
			  resizable : "yes",
			  inline : "yes",
			  editor_id : tinyMCE.getWindowArg("editor_id")
			});
			return false;*/
		}
	</script>
<!-- END HEAD -->
<!-- BEGIN BODY -->
<body class="fixed-top">
   <!-- BEGIN HEADER -->
   <?php include("header.php"); ?>
   <!-- END HEADER -->
   <!-- BEGIN CONTAINER -->
   <div id="container" class="row-fluid">
      <!-- BEGIN SIDEBAR -->
      <div id="sidebar" class="nav-collapse collapse">
         <div class="sidebar-toggler hidden-phone"></div>   
         <!-- BEGIN RESPONSIVE QUICK SEARCH FORM -->
         <div class="navbar-inverse">
            <form class="navbar-search visible-phone">
               <input type="text" class="search-query" placeholder="Search" />
            </form>
         </div>
         <!-- END RESPONSIVE QUICK SEARCH FORM -->
         <!-- BEGIN SIDEBAR MENU -->
          <?php include("sidemenu.php"); ?>
         <!-- END SIDEBAR MENU -->
      </div>
      <!-- END SIDEBAR -->
      <!-- BEGIN PAGE -->  
      <div id="main-content">
         <!-- BEGIN PAGE CONTAINER-->
         <div class="container-fluid">
            <!-- BEGIN PAGE HEADER-->   
            <div class="row-fluid">
               <div class="span12">
                   <!-- BEGIN THEME CUSTOMIZER-->
                   <div id="theme-change" class="hidden-phone">
                       <i class="icon-cogs"></i>
                        <span class="settings">
                            <span class="text">Theme:</span>
                            <span class="colors">
                                <span class="color-default" data-style="default"></span>
                                <span class="color-gray" data-style="gray"></span>
                                <span class="color-purple" data-style="purple"></span>
                                <span class="color-navy-blue" data-style="navy-blue"></span>
                            </span>
                        </span>
                   </div>
                   <!-- END THEME CUSTOMIZER-->
                  <!-- BEGIN PAGE TITLE & BREADCRUMB-->
                   <h3 class="page-title">
                     <small></small>
                  </h3>
                   <ul class="breadcrumb">
                       <li><a href="#"><i class="icon-home"></i></a><span class="divider">&nbsp;</span></li>
                       <li>Product<span class="divider">&nbsp;</span></li>
                       <li><a href="#">Edit Product </a><span class="divider-last">&nbsp;</span></li>
                   </ul>
                   <!-- END PAGE TITLE & BREADCRUMB-->
               </div>
            </div>
            <!-- END PAGE HEADER-->
            <!-- BEGIN PAGE CONTENT-->
            <div class="row-fluid">
               <div class="span12">
                  <div class="widget">
                        <div class="widget-title">
                           <h4><i class="icon-globe"></i>Blank Page</h4>
                           <span class="tools">
                           <a href="javascript:;" class="icon-chevron-down"></a>
                           <a href="javascript:;" class="icon-remove"></a>
                           </span>
                        </div>
                        <?php
							$sql="select * from  commercial where CommercialID =".$_REQUEST['id'];
							$result=mysql_query($sql,$conn);
							$row=@mysql_fetch_array($result);
						?>
                        <div class="widget-body form">
                         <div>
                            <h3>Edit Product </h3>
                          </div>
                        <!-- BEGIN FORM-->
                        <form action="<?php $PHP_SELF ?>" method="post" onSubmit="return validate(this);" enctype="multipart/form-data" class="form-horizontal" >
						<div class="control-group">
                              <label class="control-label" style="color:#000;">Main Title</label>
                              <div class="controls">
                                  <select name="name" data-rel="chosen" class="inputtext-footer" style="border:1px solid #000; color:#000;">
                                  	<option value="">Select Title</option>
									<?php
                                    	$sqlCountry = "SELECT * FROM product_title where ProductTitleID order by ProductTitle";
                                    	$resultCountry = mysql_query($sqlCountry, $conn);
                                    	if (@mysql_num_rows($resultCountry)!=0)
										{
                                    		while($rowCountry = mysql_fetch_array($resultCountry))
                                    		{
                                    ?>
                                    		<option value="<?php echo $rowCountry['ProductTitleID']?>"
                                    		<?php
                                    			if($row['ProductTitleID'] == $rowCountry['ProductTitleID'])
                                    			echo "selected";
                                    		?>
                                    		><?php echo $rowCountry['ProductTitle']?></option>
                                    		<?php
                                    		}
                                    	}				
                                    		?>
                                    </select>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Sub Title</label>
                           <div class="controls">
                                <input type="text" name="title" value="<?php echo $row['Title']; ?>"  onBlur="val(this.id)" style="border:1px solid #000; color:#000;" /><div id="errorfile"></div>
                           </div>
                           </div>
                           
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Image</label>
                           <div class="controls">
                                <input type="text" name="file" id="file" value="<?php echo $row['BuildingImage'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file" id="file" value="<?php echo $row['BuildingImage'] ?>" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Slider Image1</label>
                           <div class="controls">
                                <input type="text" name="file_1" id="file_1"  value="<?php echo $row['SliderImage1'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file_1" id="file_1" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Slider Image2</label>
                           <div class="controls">
                                <input type="text" name="file_2" id="file_2"  value="<?php echo $row['SliderImage2'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file_2" id="file_2" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Slider Image3</label>
                           <div class="controls">
                                <input type="text" name="file_3" id="file_3"  value="<?php echo $row['SliderImage3'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file_3" id="file_3" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Slider Image4</label>
                           <div class="controls">
                                <input type="text" name="file_4" id="file_4"  value="<?php echo $row['SliderImage4'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file_4" id="file_4" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Layout Image</label>
                           <div class="controls">
                                <input type="text" name="file_5" id="file_5"  value="<?php echo $row['Layout'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file_5" id="file_5" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Company Logo</label>
                           <div class="controls">
                                <input type="text" name="file_6" id="file_6"  value="<?php echo $row['CompanyLogo'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file_6" id="file_6" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Keyplan Image</label>
                           <div class="controls">
                                <input type="text" name="file_7" id="file_7"  value="<?php echo $row['KeyPlan'] ?>" class="input-xlarge" readonly="readonly"/>
                                <input type="file" name="file_7" id="file_7" class="input-xlarge" onBlur="val(this.id)" /><div id="errorfile"></div>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Content</label>
                           <div class="controls">
                               <textarea name="small_content" id="small_content"  style="width:650px; height:400px; border:1px solid #000;" onBlur="val(this.id)" ><?php echo $row['SmallContent'] ?></textarea>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Description</label>
                           <div class="controls">
                               <textarea name="area2" id="area2"  style="width:650px; height:400px; border:1px solid #000;" onBlur="val(this.id)" ><?php echo $row['BriefDescription'] ?></textarea>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Features</label>
                           <div class="controls">
                               <textarea name="features" id="features"  style="width:650px; height:400px; border:1px solid #000;" onBlur="val(this.id)" ><?php echo $row['Features'] ?></textarea>
                              </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Contact Person</label>
                           <div class="controls">
                                <input type="text" name="cperson" value="<?php echo $row['ContactPerson']; ?>"  onBlur="val(this.id)" style="border:1px solid #000; color:#000;"/><div id="errorfile"></div>
                           </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Contact Number</label>
                           <div class="controls">
                                <input type="text" name="cnumber" value="<?php echo $row['ContactNumber']; ?>"  onBlur="val(this.id)" style="border:1px solid #000; color:#000;"/><div id="errorfile"></div>
                           </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Site Map</label>
                           <div class="controls">
                                <input type="text" name="site_map" value="<?php echo $row['Sitemap']; ?>"  onBlur="val(this.id)" style="border:1px solid #000; color:#000;"/><div id="errorfile"></div>
                           </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Project Cost</label>
                           <div class="controls">
                                <input type="text" name="pro_cost" value="<?php echo $row['CommercialRate']; ?>"  onBlur="val(this.id)" style="border:1px solid #000; color:#000;"/><div id="errorfile"></div>
                           </div>
                           </div>
                           <div class="control-group">
                              <label class="control-label" style="color:#000;">Company Link</label>
                           <div class="controls">
                                <input type="text" name="comp_link" value="<?php echo $row['CompanyLink']; ?>"  onBlur="val(this.id)" style="border:1px solid #000; color:#000;"/><div id="errorfile"></div>
                           </div>
                           </div>
                          <div class="form-actions">
                           <input value="true" name="continue"  type="hidden" />
                           <input type="hidden" name="commercialid" value="<?php echo $row["CommercialID"]?>"/>
                           <input type="submit" class="btn btn-success" name="s1" id="submit" value="Submit" />
                           </div>
                        </form>
                        <!-- END FORM--> 
<?php
if(isset($_POST['s1'])){
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/png")
|| ($_FILES["file"]["type"] == "image/pjpeg")
|| ($_FILES["file"]["type"] == "application/pdf"))
&& ($_FILES["file"]["size"] < 900000000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br/>";
    }
  else
    {
    echo "Upload: " . $_FILES["file"]["name"] . "<br />";
    echo "Type: " . $_FILES["file"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file"]["name"]))
      {
      echo $_FILES["file"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file"]["tmp_name"],
      "images/commercial/" . $_FILES["file"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file"]["name"];
	  //require_once "resolution.php";
      }
    echo "Upload: " . $_FILES["file_1"]["name"] . "<br />";
    echo "Type: " . $_FILES["file_1"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file_1"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file_1"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file_1"]["name"]))
      {
      echo $_FILES["file_1"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file_1"]["tmp_name"],
      "images/commercial/" . $_FILES["file_1"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file_1"]["name"];
	  //require_once "resolution.php";
      }
    echo "Upload: " . $_FILES["file_2"]["name"] . "<br />";
    echo "Type: " . $_FILES["file_2"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file_2"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file_2"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file_2"]["name"]))
      {
      echo $_FILES["file_2"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file_2"]["tmp_name"],
      "images/commercial/" . $_FILES["file_2"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file_2"]["name"];
	  //require_once "resolution.php";
      }
    echo "Upload: " . $_FILES["file_3"]["name"] . "<br />";
    echo "Type: " . $_FILES["file_3"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file_3"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file_3"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file_3"]["name"]))
      {
      echo $_FILES["file_3"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file_3"]["tmp_name"],
      "images/commercial/" . $_FILES["file_3"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file_3"]["name"];
	  //require_once "resolution.php";
      }
    echo "Upload: " . $_FILES["file_4"]["name"] . "<br />";
    echo "Type: " . $_FILES["file_4"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file_4"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file_4"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file_4"]["name"]))
      {
      echo $_FILES["file_4"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file_4"]["tmp_name"],
      "images/commercial/" . $_FILES["file_4"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file_4"]["name"];
	  //require_once "resolution.php";
      }
    echo "Upload: " . $_FILES["file_5"]["name"] . "<br />";
    echo "Type: " . $_FILES["file_5"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file_5"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file_5"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file_5"]["name"]))
      {
      echo $_FILES["file_5"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file_5"]["tmp_name"],
      "images/commercial/" . $_FILES["file_5"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file_5"]["name"];
	  //require_once "resolution.php";
      }
    echo "Upload: " . $_FILES["file_6"]["name"] . "<br />";
    echo "Type: " . $_FILES["file_6"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file_6"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file_6"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file_6"]["name"]))
      {
      echo $_FILES["file_6"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file_6"]["tmp_name"],
      "images/commercial/" . $_FILES["file_6"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file_6"]["name"];
	  //require_once "resolution.php";
      }
    echo "Upload: " . $_FILES["file_7"]["name"] . "<br />";
    echo "Type: " . $_FILES["file_7"]["type"] . "<br />";
    echo "Size: " . ($_FILES["file_7"]["size"] / 1024) . " Kb<br />";
    echo "Temp file: " . $_FILES["file_7"]["tmp_name"] . "<br />";
    if (file_exists("images/commercial/" . $_FILES["file_7"]["name"]))
      {
      echo $_FILES["file_7"]["name"] . " already exists. ";
      }
    else
      {
      move_uploaded_file($_FILES["file_7"]["tmp_name"],
      "images/commercial/" . $_FILES["file_7"]["name"]);
      echo "Stored in: " . "images/commercial/" . $_FILES["file_7"]["name"];
	  //require_once "resolution.php";
      }
    }
	echo $name=$_FILES["file"]["name"];
	echo $name=$_FILES["file_1"]["name"];
	echo $name=$_FILES["file_2"]["name"];
	echo $name=$_FILES["file_3"]["name"];
	echo $name=$_FILES["file_4"]["name"];
	echo $name=$_FILES["file_5"]["name"];
	echo $name=$_FILES["file_6"]["name"];
	echo $name=$_FILES["file_7"]["name"];
  }
else
  {
  echo "Invalid file";
  }
   if(($_FILES["file"]["name"]).($_FILES["file_1"]["name"]).($_FILES["file_2"]["name"]).($_FILES["file_3"]["name"]).($_FILES["file_4"]["name"]).($_FILES["file_5"]["name"]).($_FILES["file_6"]["name"]).($_FILES["file_7"]["name"]))
  {
unlink('images/commercial/'.$_REQUEST['file'] .$_REQUEST['file_1'] .$_REQUEST['file_2'] .$_REQUEST['file_3'] .$_REQUEST['file_4'] .$_REQUEST['file_5'] .$_REQUEST['file_6'] .$_REQUEST['file_7'].'');
$con=$_POST['area2'];
$content=str_replace("../uploaded","../uploaded","uploaded");
$abc =  $_REQUEST['area2'];
$new_string = str_replace("\&quot;", '', $abc);
$insert = "update commercial set 
	Title='".mysql_escape_string($_REQUEST['title'])."',
	SmallContent='".mysql_escape_string($_REQUEST['small_content'])."',
	BriefDescription='".mysql_escape_string($new_string)."',
	Features='".mysql_escape_string($_REQUEST['features'])."',
	ContactPerson='".mysql_escape_string($_REQUEST['cperson'])."',
	ContactNumber='".mysql_escape_string($_REQUEST['cnumber'])."',
	Sitemap='".mysql_escape_string($_REQUEST['site_map'])."',
	CommercialRate='".mysql_escape_string($_REQUEST['pro_cost'])."',
	CompanyLink='".mysql_escape_string($_REQUEST['comp_link'])."',
	SliderImage1='".mysql_escape_string($_FILES["file_1"]["name"])."',
	SliderImage2='".mysql_escape_string($_FILES["file_2"]["name"])."',
	SliderImage3='".mysql_escape_string($_FILES["file_3"]["name"])."',
	SliderImage4='".mysql_escape_string($_FILES["file_4"]["name"])."',
	Layout='".mysql_escape_string($_FILES["file_5"]["name"])."',
	CompanyLogo='".mysql_escape_string($_FILES["file_6"]["name"])."',
	KeyPlan='".mysql_escape_string($_FILES["file_7"]["name"])."',
	BuildingImage='".mysql_escape_string($_FILES["file"]["name"])."'where CommercialID='".mysql_escape_string($_REQUEST['commercialid'])."'";
	$resultt = mysql_query($insert);
	echo "<meta http-equiv=\"refresh\" content=\"0;URL=commercial_list.php\">";
  }
  else
  {
   {
$con=$_POST['area2'];
$content=str_replace("../uploaded","../uploaded","uploaded");
$abc =  $_REQUEST['area2'];
$new_string = str_replace("\&quot;", '', $abc);
$insert = "update commercial set 
	Title='".mysql_escape_string($_REQUEST['title'])."',
	SmallContent='".mysql_escape_string($_REQUEST['small_content'])."',
	BriefDescription='".mysql_escape_string($new_string)."',
	Features='".mysql_escape_string($_REQUEST['features'])."',
	ContactPerson='".mysql_escape_string($_REQUEST['cperson'])."',
	ContactNumber='".mysql_escape_string($_REQUEST['cnumber'])."',
	Sitemap='".mysql_escape_string($_REQUEST['site_map'])."',
	CommercialRate='".mysql_escape_string($_REQUEST['pro_cost'])."',
	CompanyLink='".mysql_escape_string($_REQUEST['comp_link'])."',
	SliderImage1='".mysql_escape_string($_FILES["file_1"]["name"])."',
	SliderImage2='".mysql_escape_string($_FILES["file_2"]["name"])."',
	SliderImage3='".mysql_escape_string($_FILES["file_3"]["name"])."',
	SliderImage4='".mysql_escape_string($_FILES["file_4"]["name"])."',
	Layout='".mysql_escape_string($_FILES["file_5"]["name"])."',
	CompanyLogo='".mysql_escape_string($_FILES["file_6"]["name"])."',
	KeyPlan='".mysql_escape_string($_FILES["file_7"]["name"])."',
	BuildingImage='".mysql_escape_string($_FILES["file"]["name"])."'where CommercialID='".mysql_escape_string($_REQUEST['commercialid'])."'";
	$resultt = mysql_query($insert);
	echo "<meta http-equiv=\"refresh\" content=\"0;URL=commercial_list.php\">";
  }
  }
  }
?>    
                     </div>
                  </div>
               </div>
            </div>
            <!-- END PAGE CONTENT-->         
         </div>
         <!-- END PAGE CONTAINER-->
      </div>
      <!-- END PAGE -->  
   </div>
   <!-- END CONTAINER -->
   <!-- BEGIN FOOTER -->
   <div id="footer">
       2013 &copy; Admin Lab Dashboard.
      <div class="span pull-right">
         <span class="go-top"><i class="icon-arrow-up"></i></span>
      </div>
   </div>
   <!-- END FOOTER -->
   <!-- BEGIN JAVASCRIPTS -->    
   <!-- Load javascripts at bottom, this will reduce page load time -->
   <script src="js/jquery-1.8.3.min.js"></script>
   <script src="assets/bootstrap/js/bootstrap.min.js"></script>
   <script src="js/jquery.blockui.js"></script>
   <!-- ie8 fixes -->
   <!--[if lt IE 9]>
   <script src="js/excanvas.js"></script>
   <script src="js/respond.js"></script>
   <![endif]-->
   <script type="text/javascript" src="assets/chosen-bootstrap/chosen/chosen.jquery.min.js"></script>
   <script type="text/javascript" src="assets/uniform/jquery.uniform.min.js"></script>
   <script src="js/scripts.js"></script>
   <script>
      jQuery(document).ready(function() {       
         // initiate layout and plugins
         App.init();
      });
   </script>
   <!-- END JAVASCRIPTS -->   
</body>
<!-- END BODY -->
</html>