Viewing file: product_update.php (28.37 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<? include 'index_IncludeAdmin.php'; $_SESSION['page'] = 'product.php';
if (isset($_GET[product_id])){ $_SESSION[product_id] = $_GET[product_id]; }
$product_SL = " SELECT * FROM product WHERE product_id = '$_SESSION[product_id];'"; $product_QR = mysqli_query($con,$product_SL); $product = mysqli_fetch_array($product_QR);
if ($_POST['product_update']) {
$salesteam_id = htmlspecialchars($_POST['salesteam_id'], ENT_QUOTES ); $product_name = htmlspecialchars($_POST['product_name'], ENT_QUOTES ); $product_owner = htmlspecialchars($_POST['product_owner'], ENT_QUOTES ); $product_condition = htmlspecialchars($_POST['product_condition'], ENT_QUOTES ); $product_price = trim($_POST['product_price']); $product_rebate = trim($_POST['product_rebate']); $product_charges = trim($_POST['product_charges']); $product_detail = htmlspecialchars($_POST['product_detail'], ENT_QUOTES ); $product_link = function_link($_POST['product_link']); $product_review = function_review($_POST['product_review']); $product_code = $_POST['product_code']; $product_bedroom = trim($_POST['product_bedroom']); $product_bathroom = trim($_POST['product_bathroom']); $product_area = trim($_POST['product_area']); $product_estate = trim($_POST['product_estate']); $product_estate_rai = trim($_POST['product_estate_rai']); $product_estate_ngan = trim($_POST['product_estate_ngan']); $product_estate_wa = trim($_POST['product_estate_wa']); $market_id = trim($_POST['market_id']); $product_status_id = trim($_POST['product_status_id']); $catalog_id = trim($_POST['catalog_id']); $floor_id = trim($_POST['floor_id']); $trainstation_id = trim($_POST['trainstation_id']); $province_id = trim($_POST['province_id']); $amphure_id = trim($_POST['amphure_id']); $district_id = trim($_POST['district_id']); $product_web_id = trim($_POST['product_web_id']); $product_page = rand();
$stationbts_id = trim($_POST['stationbts_id']); $stationmrt_id = trim($_POST['stationmrt_id']); $stationairport_id = trim($_POST['stationairport_id']);
$product_googlemaps = trim($_POST['product_googlemaps']); $product_zone = trim($_POST['product_zone']); $neighborhood_name = trim($_POST['neighborhood_name']); $plot_name = " "; for($i=0;$i<count($_POST["plot_name"]);$i++){ if(trim($_POST["plot_name"][$i]) != ""){ $plot_name .= $_POST["plot_name"][$i]; if ($i<count($_POST["plot_name"])-1) { $plot_name .= " , "; } } } $features_name = " "; for($i=0;$i<count($_POST["features_name"]);$i++){ if(trim($_POST["features_name"][$i]) != ""){ $features_name .= $_POST["features_name"][$i]; if ($i<count($_POST["features_name"])-1) { $features_name .= " , "; } } }
$product_search = " "; $product_search .= $product_datetime; $product_search .= $product_owner; $product_search .= $product_condition; $product_search .= $product_code; $product_search .= $plot_name; $product_search .= $product_page; $product_search .= $features_name; $product_search .= $product_bedroom; $product_search .= $product_bathroom; $product_search .= $product_area; $product_search .= $product_estate; $product_search .= $product_estate_rai; $product_search .= $product_estate_ngan; $product_search .= $product_estate_wa; $product_search .= $product_name; $product_search .= $product_detail; $product_search .= $product_price; $product_search .= $product_zone; $product_search .= $product_charges; $product_search .= $product_link; $product_search .= $product_review; $search = str_replace(" ","",$product_search); $product_search .= $search;
$product_Update = "UPDATE `product` SET `product_datetime` = NOW(), `product_zone` = '$product_zone', `salesteam_id` = '$salesteam_id', `neighborhood_name` = '$neighborhood_name', `product_search` = '$product_search', `product_code` = '$product_code', `market_id` = '$market_id', `product_status_id` = '$product_status_id', `catalog_id` = '$catalog_id', `floor_id` = '$floor_id', `stationbts_id` = '$stationbts_id', `stationmrt_id` = '$stationmrt_id', `stationairport_id` = '$stationairport_id', `product_googlemaps` = '$product_googlemaps', `trainstation_id` = '$trainstation_id', `province_id` = '$province_id', `amphure_id` = '$amphure_id', `district_id` = '$district_id', `product_web_id` = '$product_web_id', `plot_name` = '$plot_name', `product_page` = '$product_page', `features_name` = '$features_name', `product_bedroom` = '$product_bedroom', `product_bathroom` = '$product_bathroom', `product_owner` = '$product_owner', `product_condition` = '$product_condition', `product_area` = '$product_area', `product_estate` = '$product_estate', `product_estate_rai` = '$product_estate_rai', `product_estate_ngan` = '$product_estate_ngan', `product_estate_wa` = '$product_estate_wa', `product_name` = '$product_name', `product_detail` = '$product_detail', `product_rebate` = '$product_rebate', `product_price` = '$product_price', `product_charges` = '$product_charges', `product_link` = '$product_link', `product_review` = '$product_review' WHERE `product_id` = '$_SESSION[product_id]'"; $product_Reult = mysqli_query($con,$product_Update);
if (!$product_Reult) { echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>"; } if($_FILES['product_photo']['name']!=''){ @unlink("../Files/product_photo/".$product['product_photo']); @unlink("../Files/product_photo/".photo_min($product['product_photo'])); $suffix = strrchr($_FILES["product_photo"]["name"],"."); $product_photo = rand()."".$suffix; $upload = move_uploaded_file($_FILES["product_photo"]["tmp_name"],"../Files/product_photo/".$product_photo); $product_photo_Update = "UPDATE `product` SET `product_photo` = '$product_photo' WHERE `product_id` = '$_SESSION[product_id]'"; $product_photo_Reult = mysqli_query($con,$product_photo_Update); $foldername = 'product_photo'; min_resize($product_photo,$foldername);
if (!$product_photo_Reult) { echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>"; } } if ($product_Reult) { echo"<script> window.location='product_one.php?UPDATE'; </script>"; } }
?>
<!DOCTYPE html> <html> <head> <? include 'index_Head.php'; ?> </head> <body> <? include 'index_Navbar.php'; ?> <div class="container-fluid"> <div class="row"> <div class="col-md-2" id="main-left"> <div class="row"> <div class="col-md-12"> <? include 'index_AdminMenu.php'; ?> </div> </div> </div> <div class="col-md-10"> <div class="row"> <div class="col-md-12"> <h3> แก้ไข อสังหาริมทรัพย์ : <span class="text-primary bold"> <?php echo $product[product_name]; ?> </span> </h3> <hr> </div> </div> <div class="row"> <div class="col-md-12 br-margin2"> <a href="product_one.php" class="btn btn-primary"><span class="glyphicon glyphicon-step-backward"></span> กลับ </a> </div> <div class="col-md-12"> <form class="form-horizontal" method="post" enctype="multipart/form-data"> <div class="panel panel-default"> <div class="panel-heading"> กรอกรายละเอียด "อสังหาริมทรัพย์" ที่ต้องการแก้ไข </div> <div class="panel-body"> <div class="form-group"> <label class="control-label col-md-3" > สำหรับ (สมาชิก , คนนอก) <span class="text-red"> * </span> </label> <div class="col-md-6"> <select class="form-control" name="product_web_id" > <? $product_web_SL = " SELECT * FROM product_web WHERE product_web_id = '$product[product_web_id]'"; $product_web_QR = mysqli_query($con,$product_web_SL); $product_web = mysqli_fetch_array($product_web_QR);
if (!isset($product_web[product_web_id])||$product_web[product_web_id]=='') { ?> <option value="">--</option> <? } else{ ?> <option value="<?php echo $product_web[product_web_id]; ?>"><? echo $product_web[product_web_name]; ?></option> <? }
$product_web_SL = " SELECT * FROM product_web WHERE product_web_id != '$product[product_web_id]' ORDER BY product_web_id ASC"; $product_web_QR = mysqli_query($con,$product_web_SL); while ($product_web = mysqli_fetch_array($product_web_QR)) { ?> <option value="<?php echo $product_web[product_web_id]; ?>"><?php echo $product_web[product_web_name]; ?></option> <? } ?> <option value="">นำออกจากรายการ</option> </select> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > รูปภาพปกสังหาริมทัพย์ </label> <div class="col-md-6"> <input type="file" class="form-control br2" name="product_photo" > </div> <label class="control-label col-md-3 text-left" > รูปใหม่ที่ต้องการเปลี่ยน </label> </div> <div class="form-group"> <label class="control-label col-md-3" > ชื่ออสังหาริมทัพย์ <span class="text-red"> * </span> </label> <div class="col-md-6"> <textarea id="product_name" class="form-control" rows="2" name="product_name" maxlength="250" placeholder="ชื่ออสังหาริมทัพย์ ความยาวไม่เกิน 250 ตัวอักษร"><? echo $product[product_name]; ?></textarea> </div> <label class="control-label col-md-2 text-left" > <span id="product_name_chars" class="text-muted"> </span> </label> <script type="text/javascript"> var product_name = 250; $('#product_name').keyup(function() { var length = $(this).val().length; var length = product_name-length; $('#product_name_chars').text(length); }); </script> </div> <div class="form-group"> <label class="control-label col-md-3" > รหัสทรัพย์ <span class="text-red"> * </span> </label> <div class="col-md-6"> <input required type="text" class="form-control" name="product_code" value="<? echo $product[product_code]; ?>" placeholder=" " > </div> </div> <div class="form-group"> <label class="control-label col-md-3" > ขาย & เช่า <span class="text-red"> * </span> </label> <div class="col-md-6"> <select class="form-control" name="market_id" > <? $market_SL = " SELECT * FROM market WHERE market_id = '$product[market_id]'"; $market_QR = mysqli_query($con,$market_SL); $market = mysqli_fetch_array($market_QR);
if (!isset($market[market_id])||$market[market_id]=='') { ?> <option value="">--</option> <? } else{ ?> <option value="<?php echo $market[market_id]; ?>"><? echo $market[market_name]; ?></option> <? }
$market_SL = " SELECT * FROM market WHERE market_id != '$product[market_id]' ORDER BY market_id ASC"; $market_QR = mysqli_query($con,$market_SL); while ($market = mysqli_fetch_array($market_QR)) { ?> <option value="<?php echo $market[market_id]; ?>"><?php echo $market[market_name]; ?></option> <? } ?> <option value="">นำออกจากรายการ</option> </select> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > สถานะ <span class="text-red"> * </span> </label> <div class="col-md-6"> <select class="form-control" name="product_status_id" > <? $product_status_SL = " SELECT * FROM product_status WHERE product_status_id = '$product[product_status_id]'"; $product_status_QR = mysqli_query($con,$product_status_SL); $product_status = mysqli_fetch_array($product_status_QR);
if (!isset($product_status[product_status_id])||$product_status[product_status_id]=='') { ?> <option value="">--</option> <? } else{ ?> <option value="<?php echo $product_status[product_status_id]; ?>"><? echo $product_status[product_status_name]; ?></option> <? }
$product_status_SL = " SELECT * FROM product_status WHERE product_status_id != '$product[product_status_id]' ORDER BY product_status_id ASC"; $product_status_QR = mysqli_query($con,$product_status_SL); while ($product_status = mysqli_fetch_array($product_status_QR)) { ?> <option value="<?php echo $product_status[product_status_id]; ?>"><?php echo $product_status[product_status_name]; ?></option> <? } ?> <option value="">นำออกจากรายการ</option> </select> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > ราคา <span class="text-red"> * </span> </label> <div class="col-md-3"> <input required type="number" class="form-control" name="product_price" value="<? echo $product[product_price]; ?>" placeholder="เฉพาะตัวเลข"> </div> <div class="col-md-3"> <input type="text" class="form-control" name="product_charges" value="<? echo $product[product_charges] ?>" placeholder="รายละเอียดราคาเพิ่มเติม (ไม่จำเป็น)"> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > ราคาที่ถูกขีด ราคาเดิม </label> <div class="col-md-3"> <input type="number" class="form-control" name="product_rebate" value="<? echo $product[product_rebate]; ?>" placeholder="เฉพาะตัวเลข"> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > ประเภทอสังหาฯ <span class="text-red"> * </span> </label> <div class="col-md-6"> <select required class="form-control" name="catalog_id" > <? $catalog_SL = " SELECT * FROM catalog WHERE catalog_id = '$product[catalog_id]'"; $catalog_QR = mysqli_query($con,$catalog_SL); $catalog = mysqli_fetch_array($catalog_QR);
if (!isset($catalog[catalog_id])||$catalog[catalog_id]=='') { ?> <option value="">--</option> <? } else{ ?> <option value="<?php echo $catalog[catalog_id]; ?>"><? echo $catalog[catalog_name]; ?></option> <? }
$catalog_SL = " SELECT * FROM catalog WHERE catalog_id != '$product[catalog_id]' ORDER BY catalog_id ASC"; $catalog_QR = mysqli_query($con,$catalog_SL); while ($catalog = mysqli_fetch_array($catalog_QR)) { ?> <option value="<?php echo $catalog[catalog_id]; ?>"><?php echo $catalog[catalog_name]; ?></option> <? } ?> <option value="">นำออกจากรายการ</option> </select> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > ชั้น <span class="text-red"> * </span> </label> <div class="col-md-6"> <select required class="form-control" name="floor_id" > <? $floor_SL = " SELECT * FROM floor WHERE floor_id = '$product[floor_id]'"; $floor_QR = mysqli_query($con,$floor_SL); $floor = mysqli_fetch_array($floor_QR);
if (!isset($floor[floor_id])||$floor[floor_id]=='') { ?> <option value="">--</option> <? } else{ ?> <option value="<?php echo $floor[floor_id]; ?>"><? echo $floor[floor_name]; ?></option> <? }
$floor_SL = " SELECT * FROM floor WHERE floor_id != '$product[floor_id]' ORDER BY floor_id ASC"; $floor_QR = mysqli_query($con,$floor_SL); while ($floor = mysqli_fetch_array($floor_QR)) { ?> <option value="<?php echo $floor[floor_id]; ?>"><?php echo $floor[floor_name]; ?></option> <? } ?> <option value="">นำออกจากรายการ</option> </select> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > โซนหรือถนน </label> <div class="col-md-6"> <input type="text" class="form-control" name="product_zone" value="<? echo $product[product_zone] ?>" placeholder="โซนหรือถนน"> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > บ้านเลขที่ </label> <div class="col-md-6"> <textarea id="product_detail" class="form-control" rows="4" name="product_detail" maxlength="150" placeholder="บ้านเลขที่"><? echo $product[product_detail]; ?></textarea> </div> <label class="control-label col-md-2 text-left" > <span id="product_detail_chars" class="text-muted"> </span> </label> <script type="text/javascript"> var product_detail = 150; $('#product_detail').keyup(function() { var length = $(this).val().length; var length = product_detail-length; $('#product_detail_chars').text(length); }); </script> </div> <div class="form-group"> <label class="control-label col-md-3" > </label> <label class="control-label col-md-3 text-left" > ห้องนอน </label> <label class="control-label col-md-3 text-left" > ห้องน้ำ </label> </div> <div class="form-group"> <label class="control-label col-md-3" > </label> <div class="col-md-3"> <input type="number" class="form-control" name="product_bedroom" value="<? echo $product[product_bedroom]; ?>" placeholder=" จำนวนห้องนอน "> </div> <div class="col-md-3"> <input type="number" class="form-control" name="product_bathroom" value="<? echo $product[product_bathroom]; ?>" placeholder=" จำนวนห้องน้ำ "> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > พื้นที่ใช้สอย </label> <div class="col-md-3"> <input type="text" class="form-control" name="product_area" value="<? echo $product[product_area]; ?>" placeholder=" 170 "> </div> <label class="control-label col-md-3 text-left" > ตารางวา </label> </div> <div class="form-group"> <label class="control-label col-md-3" >ทำเลที่ตั้ง <span class="text-red"> * </span> </label> <div class="col-md-2"> <select required name="province_id" class="selectpicker form-control" data-live-search="true" onChange ="Listamphure(this.value)"> <? $province_SL = " SELECT * FROM province WHERE province_id = '$product[province_id]'"; $province_QR = mysqli_query($con,$province_SL); $province = mysqli_fetch_array($province_QR); if (!isset($province[province_id])||$province[province_id]=='') { ?> <option value="">จังหวัด</option> <? } else{ ?> <option value="<?php echo $province[province_id]; ?>"><? echo $province[province_name]; ?></option> <? } $province_SL = " SELECT * FROM province WHERE province_id != '$product[province_id]' ORDER BY province_id ASC"; $province_QR = mysqli_query($con,$province_SL); while ($province = mysqli_fetch_array($province_QR)) { ?> <option value="<?php echo $province[province_id]; ?>"><?php echo $province[province_name]; ?></option> <? } ?> </select> </div> <div class="col-md-2"> <select class="form-control" id="ddlamphure" name="amphure_id" onChange ="Listdistrict(this.value)"> <? $amphure_SL = " SELECT * FROM amphure WHERE amphure_id = '$product[amphure_id]'"; $amphure_QR = mysqli_query($con,$amphure_SL); $amphure = mysqli_fetch_array($amphure_QR);
if (!isset($amphure[amphure_id])||$amphure[amphure_id]=='') { ?> <option value="">อำเภอ</option> <? } else{ ?> <option value="<?php echo $amphure[amphure_id]; ?>"><? echo $amphure[amphure_name]; ?></option> <? } $amphure_SL = " SELECT * FROM amphure WHERE amphure_id != '$product[amphure_id]' and province_id = '$product[province_id]' ORDER BY amphure_id ASC"; $amphure_QR = mysqli_query($con,$amphure_SL); while ($amphure = mysqli_fetch_array($amphure_QR)) { ?> <option value="<?php echo $amphure[amphure_id]; ?>"><?php echo $amphure[amphure_name]; ?></option> <? } ?> </select> </div> <div class="col-md-2"> <select class="form-control" id="ddldistrict" name="district_id" > <? $district_SL = " SELECT * FROM district WHERE district_id = '$product[district_id]'"; $district_QR = mysqli_query($con,$district_SL); $district = mysqli_fetch_array($district_QR);
if (!isset($district[district_id])||$district[district_id]=='') { ?> <option value="">อำเภอ</option> <? } else{ ?> <option value="<?php echo $district[district_id]; ?>"><? echo $district[district_name]; ?></option> <? } $district_SL = " SELECT * FROM district WHERE district_id != '$product[district_id]' and province_id = '$product[province_id]' ORDER BY district_id ASC"; $district_QR = mysqli_query($con,$district_SL); while ($district = mysqli_fetch_array($district_QR)) { ?> <option value="<?php echo $district[district_id]; ?>"><?php echo $district[district_name]; ?></option> <? } ?> </select> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > รายการแสดง </label> <div class="col-md-6"> <? $plot_SL = " SELECT * FROM plot"; $plot_QR = mysqli_query($con,$plot_SL); while ($plot = mysqli_fetch_array($plot_QR)) { $Searchplot = "SELECT * FROM product WHERE plot_name LIKE '%$plot[plot_name]%' AND product_id = $product[product_id]"; $plot_Reult = mysqli_query($con,$Searchplot); $RowSearchplot = mysqli_num_rows($plot_Reult); if ($RowSearchplot != 0) { ?> <label class="checkbox-inline"> <input name="plot_name[]" checked value="<?php echo $plot['plot_name'];?>" type="checkbox"> <?php echo $plot[plot_name]; ?> </label> <? } else{ ?> <label class="checkbox-inline"> <input name="plot_name[]" value="<?php echo $plot['plot_name'];?>" type="checkbox"> <?php echo $plot[plot_name]; ?> </label> <? } } ?> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > คุณสมบัติ </label> <div class="col-md-6"> <? $features_SL = " SELECT * FROM features"; $features_QR = mysqli_query($con,$features_SL); while ($features = mysqli_fetch_array($features_QR)) { $Searchfeatures = "SELECT * FROM product WHERE features_name LIKE '%$features[features_name]%' AND product_id = $product[product_id]"; $features_Reult = mysqli_query($con,$Searchfeatures); $RowSearchfeatures = mysqli_num_rows($features_Reult); if ($RowSearchfeatures != 0) { ?> <label class="checkbox-inline"> <input name="features_name[]" checked value="<?php echo $features['features_name'];?>" type="checkbox"> <?php echo $features[features_name]; ?> </label> <? } else{ ?> <label class="checkbox-inline"> <input name="features_name[]" value="<?php echo $features['features_name'];?>" type="checkbox"> <?php echo $features[features_name]; ?> </label> <? } } ?> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > เดินทางไปบ้านหลังนี้ </label> <div class="col-md-6"> <input type="text" class="form-control" name="product_link" value="<? echo $product[product_link]; ?>" placeholder=" เดินทางไปบ้านหลังนี้ "> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > Google Maps </label> <div class="col-md-6"> <textarea class="form-control" rows="5" id="comment" name="product_googlemaps" placeholder=" Embed a map "><? echo $product[product_googlemaps]; ?></textarea> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > เจ้าของทรัพย์ </label> <div class="col-md-6"> <textarea id="product_owner" class="form-control" rows="4" name="product_owner" ><? echo $product[product_owner]; ?></textarea> </div> </div> <div class="form-group"> <label class="control-label col-md-3" > ผู้ขาย </label> <div class="col-md-6"> <textarea id="product_condition" class="form-control" rows="4" name="product_condition" ><? echo $product[product_condition]; ?></textarea> </div> </div> <div class="form-group"> <div class="col-md-offset-3 col-md-9"> <button onclick="return confirm('ยืนยันการแก้ไข ? ')" type="submit" class="btn btn-info"> <span class="glyphicon glyphicon-floppy-disk"></span> บันทึกการแก้ไข </button> <input type="hidden" name="product_update" value="x"> </div> </div> </div> </div> <div class="panel panel-default"> <div class="panel-heading"> ข้อมูลทั้งหมด </div> <div class="panel-body"> <textarea class="ckeditor" name="product_review"> <? echo $product[product_review]; ?> </textarea> </div> <div class="panel-footer"> แก้ไขล่าสุด : <?php echo $product[product_datetime]; ?> </div> </div> <button onclick="return confirm('ยืนยันการแก้ไข ? ')" type="submit" class="btn btn-info"> <span class="glyphicon glyphicon-floppy-disk"></span> บันทึกการแก้ไข </button> <br><br> </form> </div> <!-- 12 --> </div> <!-- row --> </div> <!-- 10 --> </div> <!-- row --> </div> <!-- container --> </body> </html>
|