Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

Apache

System:

Linux 5.14.0-570.60.1.el9_6.x86_64

PHP Version:

8.1.34

User:

jivandharaoldage

Directory:

/home/jivandharaoldage/public_html/admin

Free Space:

19.16 GB

🔧 Quick Actions

✏️ Editing: excel-import.php

<?php 
error_reporting(0);
session_start();
if(!isset($_SESSION['admin']) || ($_SESSION['admin'] == "") )
{
	?>
    <script language="javascript">window.location.href="index.php";</script>
    <?php 
}
include '../connection.php';
?><!DOCTYPE html>


 <html lang="en"> 

<head>
   <meta charset="utf-8" />
   <title>CSV Import</title>
   <meta content="width=device-width, initial-scale=1.0" name="viewport" />
   <meta content="" name="description" />
   <meta content="" name="author" />
  <!-- <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" />

<br>
 
                  <div class="widget">
                     <div class="widget-title">
                     
                     <center>
                        <h4><i class="icon-reorder"></i>&nbsp;Import CSV File</h4>
                        </center>
                        
                     </div>
                     <div class="widget-body form">
                        
 <?php 
 
 
 	$csv_id = $_SESSION['csv_id']; 	 
	
	
  if(isset($_REQUEST['import']))
{

/*?>$trunc="truncate table investor_master";
mysqli_query($conn,$trunc);<?php */

$ured=mysqli_query($conn,"select * from csv_master where csv_id='$csv_id'");
		
		$rowd=mysqli_fetch_array($ured);
		
		$csvname=$rowd['csvname'];

$filename = $csvname;
if (($handle = fopen($filename, 'r')) !== FALSE)
     while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
     {
       ($data);
	   
	     $import="INSERT INTO property_master
		(post_by,property_cat,property_purpose,property_type,title,interested_in,price,bedroom,bathroom,amenities,additional_info,property_des,stateid,statename,cityid,cityname,location,zipcode,latitude,longitude,address,post_date,image1,image2,image3,image4,image5,mem_id,status,comments_count,comments_rating,property_sold) 
		VALUES 
       ('$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]','$data[22]','$data[23]','$data[24]','$data[25]','$data[26]','$data[27]','$data[28]','$data[29]','$data[30]','$data[31]','$data[32]')";
	   
	     mysqli_query($conn,$import) or die(mysqli_error($conn));
	
	 }
 fclose($handle);
   
$dusr="delete from  csv_master where csv_id= '$csv_id'";
		$dre=mysqli_query($conn,$dusr);
 		
?>
<script type="application/javascript">window.location.href="property_list.php";</script>
<?php 
}

?>
 <br />

</center>                      
                     </div>
                  </div>
                  
               </div>
            </div>
           
                     
         </div>
         
      </div>
        
   </div>
   
  
  <?php // include 'footer_admin.php' ?> 
  
  
      
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: excel-import.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation