MAINHACK

Viewing / Editing File: my_listing2.php

<?php
        include("header.php");
    ?>

<!-- <div class="inner-banner">
    <img src="images/inner-banner-2.png">
    <div class="container">
        <h1>Add Apartment Preference</h1>

</div>
</div> -->

<div class="apartment-preferences">
    <div class="container">
              
        <div class="list-apartment">
            <h2>My <span>Details</span></h2>
        <?php
$aid=$_SESSION['login_id'];
$stmt1=$show->readwithdata('apartment','apartment_id',$_SESSION['login_id']);
$num1=$stmt1->rowCount();
if($num1>0){
	while($row=$stmt1->fetch(PDO::FETCH_ASSOC)){

$category=$row['category'];
     $amen=array();$flat=array();$nearby=array();$tenant=array();
  $st_amn=$show->readwithdata_clause('apartment_amenity','apart_id',$row['apartment_id'],'order by id asc');
while ($row_amn = $st_amn->fetch(PDO::FETCH_ASSOC)){
 $amen .=":".$row_amn['amenity'];    
} 
   	 $amn=explode(':',$amen);

$st_flat=$show->readwithdata_clause('apartment_flatmate','apart_id',$row['apartment_id'],'order by id asc');
while ($row_flt = $st_flat->fetch(PDO::FETCH_ASSOC)){
 $flat .=":".$row_flt['amenity'];    
} 
   	 $flatment_profile=explode(':',$flat);

$st_near=$show->readwithdata_clause('apartment_nearby','apart_id',$row['apartment_id'],'order by id asc');
while ($row_near = $st_near->fetch(PDO::FETCH_ASSOC)){
 $nearby .=":".$row_near['amenity'];    
} 
   	 $near=explode(':',$nearby);

$st_tenant=$show->readwithdata_clause('apartment_tenant','apart_id',$row['apartment_id'],'order by id asc');
while ($row_tenant = $st_tenant->fetch(PDO::FETCH_ASSOC)){
 $tenant .=":".$row_tenant['amenity'];    
} 
   	 $tenant_profile=explode(':',$tenant);

?>   
            <form action="" method="post" enctype= "multipart/form-data">
                <div class="apartment-preferences-block">
                    <div class="apartment-preferences-box-content">
                        <input type="radio" value="flatmate-preference1" name="flatmate-preference" id="flatmate-preference1">
                        <label for="flatmate-preference1">
                            <img src="images/apartment-prefarence-1.png">
                            <h6><?=$row['category']?></h6>
                        </label>
                    </div>
                
                  
                </div>

<div class="apartment-location-block">
                    <p>Address : </p>
                    <input type="text" id="neat-freak" value="<?=$row['address']?>" name="address" placeholder="Neighborhood">
                         <select name="city" required>
                        <option value="">Choose City</option>
                     <?php
			
$stmt_city =$show->readwithdata_clause('city','status','ACTIVE','order by id asc');
$num = $stmt_city->rowCount();
     
     if($num>0){
 
        $count=1;
        while ($rowc = $stmt_city->fetch(PDO::FETCH_ASSOC)){
        extract($rowc);
     ?>                    <option value="<?=$rowc['city']?>" <?php if($rowc['city']==$row['city']) echo "selected"; ?>><?=$rowc['city']?></option>
     <?php } }?>  
 </select>
                    <input type="text" id="postal" value="<?=$row['pincode']?>"name="pincode" placeholder="Postal Code">
                    <input type="text" id="state" value="<?=$row['state']?>" name="state" placeholder="State">
                 
                </div>
                <div class="apartment-location-block">
                    <p>Property Type : </p>
                    <div class="apartment-location-box-content">
                        <input type="radio" value="Apartment" <?php if($row['property_type']=='Apartment') echo "checked";?> name="property_type" id="Apartment" >
                        <label for="Apartment1">
                            Apartment<span>Living space in building</span>
                        </label>
                    </div>
                    <div class="apartment-location-box-content">
                        <input type="radio" value="House"  <?php if($row['property_type']=='House') echo "checked";?> name="property_type" id="Apartment">
                        <label for="House1">
                            House<span>Residential Building</span>
                        </label>
                    </div>
                    <div class="apartment-location-box-content">
                        <input type="radio" value="PG"  <?php if($row['property_type']=='PG') echo "checked";?> name="property_type" id="Apartment" >
                        <label for="Condominium1">
                            PG<span>Paying Guests</span>
                        </label>
                    </div>
                    <div class="apartment-location-box-content">
                        <input type="radio" value="Shared Accommodation"  <?php if($row['property_type']=='Shared Accommodation') echo "checked";?> name="property_type" id="Apartment">
                        <label for="Accommodation1">
                            Shared Accommodation<span>Partially Occupied Property</span>
                        </label>
                    </div>
                    
                    
                </div>

<div class="apartment-rent-block">
                    <p>Rent/Month : </p>
                    <input type="text" id="messy" value="<?=$row['rent']?>" name="rent" placeholder="Rent/Month">
                    
                </div>
            
                <div class="apartment-rent-block">
                    <p>Total Bedrooms : </p>
                   
               <?php 
						     	$interests = array('1','2','3','4','5'); 
?>
						<select name="total_bedroom"  class="form-control">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['total_bedroom']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>   
                </div>

<div class="apartment-rent-block">
                    <p>Total Bathrooms : </p>
                   
                 <?php 
						     	$interests = array('1','2','3','4','5'); 
?>
						<select name="total_bathroom"  class="form-control">
<?php foreach( $interests as  $interest ): ?>
<option value="<?php echo $interest ?>"<?php if( $interest==$row['total_bathroom']): ?> selected="selected"<?php endif; ?>><?php echo $interest ?></option>
<?php endforeach; ?>
</select>   
                </div>

<div class="apartment-location-block">
                    <p>Furnishing : </p>
                    
                    <div class="apartment-location-box-content">
                        <input type="radio" value="Furnished" name="furnishing"  <?php if($row['furnishing']=='Furnished') echo "checked";?>  id="Furnished">
                        <label for="Furnished1">
                            
                            Furnished
                        </label>
                    </div>
                    <div class="apartment-location-box-content">
                        <input type="radio" value="Semi Furnished" name="furnishing"  <?php if($row['furnishing']=='Semi Furnished') echo "checked";?>  id="Furnished" >
                        <label for="Partially1">
                            
                            Semi Furnished
                        </label>
                    </div>
                    <div class="apartment-location-box-content">
                        <input type="radio" value="Unfurnished" name="furnishing"  <?php if($row['furnishing']=='Unfurnished') echo "checked";?>  id="Furnished">
                        <label for="Unfurnished1">
                            
                            Unfurnished
                        </label>
                    </div>
                   
                </div>

<div class="apartment-check-block">
                    <p>Amenities : </p>
                  <?php
			
$sr1='amenities';
$stmt1 =$show->readAll_clause($sr1,'order by id asc');
$num1 = $stmt1->rowCount();

$count=1;
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)){
        extract($row1);

if (in_array($row1['amenity'], $amn)) {?>
                    <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row1['amenity']?>"  checked="checked" name="amenities[]" id="flatmate-preference1">
                        <label for="flatmate-preference1">
                            <img src="<?=$pic_img?>/<?=$row1['image']?>">
                        <input type="hidden" value="<?=$row1['image']?>" name="img[]" >
                          <h6><?=$row1['amenity']?></h6>
                        </label>
                    </div>
              <?php   } else { ?>      
                    <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row1['amenity']?>"  name="amenities[]" id="flatmate-preference1">
                        <label for="flatmate-preference1">
                            <img src="<?=$pic_img?>/<?=$row1['image']?>">
                              <input type="hidden" value="<?=$row1['image']?>" name="img[]" >
         <h6><?=$row1['amenity']?></h6>
                        </label>
                    </div>
         <?php }  ?>
              
                   <?php } ?>             
                   
                    
                </div>

<div class="upload-photo-block">
                    <p>Add Apartment : </p>
                    <div class="upload-photo-box">
                    <?php if($row['image1']!=""){?>
                        <img src="<?=$pic_img?>/<?=$row['image1']?>">
                        <?php } ?>
                      
                        <input type="file" name="image1">
                        <br>
                       <?php if($row['image2']!=""){?>
                       <img src="<?=$pic_img?>/<?=$row['image2']?>">
                       <?php } ?>
                        <input type="file" name="image2">
                          <br>
                        <?php if($row['image3']!=""){?>   
                        <img src="<?=$pic_img?>/<?=$row['image3']?>">
                        <?php } ?>
                        <input type="file" name="image3">
                             <br>
                         <?php if($row['image4']!=""){?>
                            <img src="<?=$pic_img?>/<?=$row['image4']?>">
                        <?php } ?>
                            <input type="file" name="image4">
                        <br>
                         <?php if($row['image5']!=""){?>
                            <img src="<?=$pic_img?>/<?=$row['image5']?>">
                        <?php } ?>
                        <input type="file" name="image5">
                        <br>
                    </div>
                    <h6>You can upload images upto <strong>25 MB</strong></h6>
                </div>

<div class="apartment-check-block">
                    <p>Nearby Amenities : </p>
                <?php
			
$sr2='amenities_nearby';
$stmt2 =$show->readAll_clause($sr2,'order by id asc');
$num2 = $stmt2->rowCount();

$count=1;
        while ($row2 = $stmt2->fetch(PDO::FETCH_ASSOC)){
        extract($row2);
         if (in_array($row2['amenity'], $near)) {?>
                    <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row2['amenity']?>" name="nearby_amenity[]" id="flatmate-preference1" checked>
                        <label for="flatmate-preference1">
             <input type="hidden" value="<?=$row2['image']?>" name="img1[]" >
                          <img src="<?=$pic_img?>/<?=$row2['image']?>">
                            <h6><?=$row2['amenity']?></h6>
                        </label>
                    </div>
                  <?php   } else { ?>      
                    <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row2['nearby_amenity']?>"  name="nearby_amenity[]" id="flatmate-preference1">
                        <label for="flatmate-preference1">
             <input type="hidden" value="<?=$row2['image']?>" name="img1[]" >
                          <img src="<?=$pic_img?>/<?=$row2['image']?>">
                            <h6><?=$row2['nearby_amenity']?></h6>
                        </label>
                    </div>
         <?php } ?>
              
                   <?php } ?>               
                   
                    
                </div>

<div class="apartment-location-block">
                    <p>Do you want to make your mobile visible to other users?</p>
                    <div class="apartment-location-box-content">
                        <input type="radio"  <?php if($row['visible']=='Public') echo "checked";?> value="Public" name="visible" id="public" checked>
                        <label for="public1">
                            
                            Yes! make it public
                        </label>
                    </div>
                    <div class="apartment-location-box-content">
                        <input type="radio"  <?php if($row['visible']=='Private') echo "checked";?> value="Private" name="visible" id="public" >
                        <label for="private1">
                            
                            No! make it private
                        </label>
                    </div>
                    
                </div>
                                <div class="apartment-check-block">

<?php  if($category=='tenant'){?>
                    <p>Preferred Tenant Profile : </p>
               <?php
		//	print_r($tenant_profile);
$sr3='tenant_category';
$stmt3 =$show->readAll_clause($sr3,'order by id asc');
$num3 = $stmt3->rowCount();

$count=1;
        while ($row3 = $stmt3->fetch(PDO::FETCH_ASSOC)){
        extract($row3);
         if (in_array($row3['amenity'], $tenant_profile)) {?>
         
               <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row3['amenity']?>" name="tenant_profile[]" id="MarriedCouple" checked>
                        <label for="MarriedCouple">
            <input type="hidden" value="<?=$row3['image']?>" name="img2[]" >
                           <img src="<?=$pic_img?>/<?=$row3['image']?>">
                            <h6><?=$row3['amenity']?></h6>
                        </label>
                    </div>
                    <?php }else{ ?>
                         <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row3['amenity']?>" name="tenant_profile[]" id="MarriedCouple">
                        <label for="MarriedCouple">
            <input type="hidden" value="<?=$row3['image']?>" name="img2[]" >
                           <img src="<?=$pic_img?>/<?=$row3['image']?>">
                            <h6><?=$row3['amenity']?></h6>
                        </label>
                    </div>
          <?php } } ?>
                  
              
            <?php }else{ ?>
                     
            
      <?php
		//	echo "aaaaaaaaaa";
$sr4='flatmate_category';
$stmt4 =$show->readAll_clause($sr4,'order by id asc');
$num4 = $stmt4->rowCount();

$count=1;
        while ($row4 = $stmt4->fetch(PDO::FETCH_ASSOC)){
        extract($row4);
         if (in_array($row4['amenity'], $flatment_profile)) { ?>
         
                    <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row4['amenity']?>" name="flatment_profile[]" id="MarriedCouple" checked>
                        <label for="flatmate-preference1">
                 <input type="hidden" value="<?=$row4['image']?>" name="img3[]" >
                      <img src="<?=$pic_img?>/<?=$row4['image']?>">
                            <h6><?=$row4['amenity']?></h6>
                        </label>
                    </div>
                    <?php }else{ ?>
                    <div class="apartment-check-block-content">
                        <input type="checkbox" value="<?=$row4['amenity']?>" name="flatment_profile[]" id="MarriedCouple">
                        <label for="flatmate-preference1">
           <input type="hidden" value="<?=$row4['image']?>" name="img3[]" >
                            <img src="<?=$pic_img?>/<?=$row4['image']?>">
                            <h6><?=$row4['amenity']?></h6>
                        </label>
                    </div>
          <?php } }  } ?>               
              </div>

<div class="apartment-location-block">
                    <p>Description : </p>
                    <textarea placeholder="Description"><?=$row['description']?></textarea>
                    
                </div>
                <div class="apartment-supply-block apartment-btn">
                    <input type="submit" value="Update" name="update">
                </div>
            </form>
   <?php } } ?>
   <?php		
 
if(isset($_POST['update'])){
    $table="apartment";
$amenities="";$nearby_amenity="";$tenant_profile="";$flatment_profile="";
	
if(isset($_POST['amenities'])){

foreach($_POST['amenities'] as $key=>$value){
  
     $data=array(
    'apart_id'=>$aid,
    'amenity'=>$_POST['amenities'][$key],
    'img'=>$_POST['img'][$key],
	);
	$r1=$show->insert('apartment_amenity',$data);
     } 
     
	}
     foreach( $_POST['nearby_amenity'] as $key=>$value){
     //  $amenities .=$amn.":";
     $data=array(
    'apart_id'=>$aid,
    'amenity'=>$_POST['nearby_amenity'][$key],
    'img'=>$_POST['img1'][$key],
	);
	$r1=$show->insert('apartment_nearby',$data);
     } 
     
     foreach( $_POST['tenant_profile'] as $key=>$value){
     //  $amenities .=$amn.":";
       $data=array(
    'apart_id'=>$aid,
    'amenity'=>$_POST['tenant_profile'][$key],
    'img'=>$_POST['img2'][$key],
	);
	$r1=$show->insert('apartment_tenant',$data);
     } 
     
   foreach( $_POST['flatment_profile'] as $key=>$value){
     //  $amenities .=$amn.":";
       $data=array(
    'apart_id'=>$aid,
    'amenity'=>$_POST['flatment_profile'][$key],
    'img'=>$_POST['img3'][$key],
	);
	$r1=$show->insert('apartment_flatmate',$data);
     } 
 
       
          
$allowed = ["address","state","city","pincode","rent","total_bedroom","total_bathroom","furnishing","description","visible"];
$params = [];
$setStr = "";
foreach ($allowed as $key)
{
    if (isset($_POST[$key]) && $key != "uid")
    {
        $setStr .= "`$key` = :$key,";
        $params[$key] = htmlspecialchars(strip_tags($_POST[$key]));
    }
}
if(file_exists($_FILES['image1']['tmp_name']) || is_uploaded_file($_FILES['image1']['tmp_name'])) {   
 $setStr .= "`image1` = :image1,";
 $img=$show->imageEdit($_FILES['image1']['name']);  
 move_uploaded_file($_FILES['image1']['tmp_name'],"product_img/".$img);
 $params['image1'] =$img;

}
if(file_exists($_FILES['image2']['tmp_name']) || is_uploaded_file($_FILES['image2']['tmp_name'])) {   
 $setStr .= "`image2` = :image2,";
 $img=$show->imageEdit($_FILES['image2']['name']);  
 move_uploaded_file($_FILES['image2']['tmp_name'],"product_img/".$img);
 $params['image2'] =$img;

}
if(file_exists($_FILES['image3']['tmp_name']) || is_uploaded_file($_FILES['image3']['tmp_name'])) {   
 $setStr .= "`image3` = :image3,";
 $img=$show->imageEdit($_FILES['image3']['name']);  
 move_uploaded_file($_FILES['image3']['tmp_name'],"product_img/".$img);
 $params['image3'] =$img;

}
if(file_exists($_FILES['image4']['tmp_name']) || is_uploaded_file($_FILES['image4']['tmp_name'])) {   
 $setStr .= "`image4` = :image4,";
 $img=$show->imageEdit($_FILES['image4']['name']);  
 move_uploaded_file($_FILES['image4']['tmp_name'],"product_img/".$img);
 $params['image4'] =$img;

}
if(file_exists($_FILES['image5']['tmp_name']) || is_uploaded_file($_FILES['image5']['tmp_name'])) {   
 $setStr .= "`image5` = :image5,";
 $img=$show->imageEdit($_FILES['image5']['name']);  
 move_uploaded_file($_FILES['image5']['tmp_name'],"product_img/".$img);
 $params['image5'] =$img;

}
 $setStr .= "`amenities` = :amenities,`nearby_amenity` = :nearby_amenity,`tenant_profile` = :tenant_profile,`flatment_profile` = :flatment_profile,";

$setStr = rtrim($setStr, ",");
$params['apartment_id'] =$aid;
$params['amenities'] =$amenities;
$params['nearby_amenity'] =$nearby_amenity;
$params['tenant_profile'] =$tenant_profile;
$params['flatment_profile'] =$flatment_profile;
$show->table ='apartment';
$show->cols =$setStr;
$show->id_name ='apartment_id';
$show->params =$params;   
//print_r($params);

$r=$show->update_all();

if($r){
    
   echo '<script>
        setTimeout(function() {
        swal({
            title: "Thank You!",
            text: "Your details has been updated",
            type: "success"
        }, function() {
    window.location = "";
        });
    }, 1000);
</script>';

}else{ echo "<script>swal('aa')</script>";}

}
        
        
        ?>   
        </div>
            
    </div>
</div>

<?php
        include("footer.php");
    ?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: my_listing2.php

Server Info

System Features

User Info