<?php

############################
# code im trying to add
############################
$target_path = "uploads/";

$target_path = $target_path . basename( $_FILES['excelFile']['tmp_name']); 

if(move_uploaded_file($_FILES['excelFile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['excelFile']['name']). 
    " has been uploaded";
} else{
    echo "There was an error uploading the file, please try again!";
}

#############################
# end additional code
#############################

  // Check to see if the form was submitted.
  if (!isset($_POST['submit']))
    {
      // Show the upload form if not.
      include_once 'excelUpload.tpl';
    }
  
  // If we get here the form was submitted.
  else
    {
      // Load the configuration file and the excel reader.
      $conf = parse_ini_file('config.ini');
      require_once 'excel/reader.php';
      
      // Check to see that the excel file was uploaded.
      if (!is_uploaded_file($_FILES['excelFile']['tmp_name']))
        {
          $reason = "Unable to upload file!";
          include_once 'uploadFailed.tpl';
        }
      
      // No error, proceed with importing the data.
      else
        {z
          // Get an instance of the excel file reader.
          $data = new Spreadsheet_Excel_Reader();
          
          // Set output Encoding.
          $data->setOutputEncoding('CP1251');
          
          // Read in the excel file.
          $data->read($_FILES['excelFile']['tmp_name']);
          
          // Create a connection to the database.
          $link = mysql_connect($conf['dbhost'], $conf['dbuser'], $conf['dbpass']);
          mysql_select_db($conf['dbname']);

          // Delete any listings already in there (this will prevent multiple instances!)
          $sql = 'DROP TABLE IF EXISTS `listings`';
          
          $sql2 = 'CREATE TABLE `listings` ( 
				   `id` int(11) NOT NULL auto_increment, 
				   `address` varchar(255) collate latin1_general_ci NOT NULL, 
				   `apt` varchar(5) collate latin1_general_ci NOT NULL, 
				   `bedrooms` tinyint(1) NOT NULL, 
				   `bath` tinyint(1) NOT NULL, 
				   `city` varchar(255) collate latin1_general_ci NOT NULL, 
				   `furnished` varchar(1) collate latin1_general_ci NOT NULL, 
				   `disposal` varchar(1) collate latin1_general_ci NOT NULL, 
				   `ac` varchar(1) collate latin1_general_ci NOT NULL, 
				   `dishw` varchar(1) collate latin1_general_ci NOT NULL, 
				   `balcony` varchar(1) collate latin1_general_ci NOT NULL, 
				   `patio` varchar(1) collate latin1_general_ci NOT NULL, 
				   `parking` varchar(1) collate latin1_general_ci NOT NULL, 
				   `available` varchar(1) collate latin1_general_ci NOT NULL, 
				   `path` varchar(255) collate latin1_general_ci NOT NULL,
				   PRIMARY KEY  (`id`) 
				 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1112 ';

          mysql_query($sql);
          mysql_query($sql2);

          echo 'Creating table: \'listings\'....';
          
          // Loop through the excel data to build the sql queries used to insert the data
          // into the database.
          for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++)
            {
              // Create a container for the data.
              $listingData = array();
              
              // Loop through the excel data.
              for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++)
                {
                  // Store the value of the current cell.
                  $temp = $data->sheets[0]['cells'][$i][$j];
                  if (is_null($temp))
                    {
                      // If the current cell is null set it to 'n'
                      $temp = 'n';
                    }
                  
                  // Store the value in the container.
                  $listingData[] = $temp;
                }
              
              // Create a sql statement to insert the current excel row.
              $sql = "insert into listings (address, apt, bedrooms, bath, city,
                                          furnished, disposal, ac, dishw, balcony,
                                          patio, parking, available, path)
                    values('$listingData[0]', '$listingData[1]', '$listingData[2]',
                           '$listingData[3]', '$listingData[4]', '$listingData[5]',
                          '$listingData[6]', '$listingData[7]', '$listingData[8]',
                           '$listingData[9]', '$listingData[10]', '$listingData[11]', '$listingData[12]', '$listingData[13]');";
              
              // Attempt to insert the data.
              $result = mysql_query($sql);
              
              // If there was an error display it.
              if (!$result)
                {
                  $reason = mysql_error() . "<br /><br />" . $sql;
                  include_once 'uploadFailed.tpl';
                  exit;
                }
            }
          
          // Show a successful upload.
          include_once 'uploadSuccessful.tpl';
        }
    }
?>