File Manager

✏️ Edit File: /home/rla105zs937x/public_html/vikascas.com/admin/SpreadsheetReader_CSV.php

<?php
/**
 * Class for parsing CSV files
 *
 * @author Martins Pilsetnieks
 */
 	class SpreadsheetReader_CSV implements Iterator, Countable
	{
		/**
		 * @var array Options array, pre-populated with the default values.
		 */
		private $Options = array(
			'Delimiter' => ';',
			'Enclosure' => '"'
		);

private $Encoding = 'UTF-8';
		private $BOMLength = 0;

/**
		 * @var resource File handle
		 */
		private $Handle = false;

private $Filepath = '';

private $Index = 0;

private $CurrentRow = null;

/**
		 * @param string Path to file
		 * @param array Options:
		 *	Enclosure => string CSV enclosure
		 *	Separator => string CSV separator
		 */
		public function __construct($Filepath, array $Options = null)
		{
			$this -> Filepath = $Filepath;

if (!is_readable($Filepath))
			{
				throw new Exception('SpreadsheetReader_CSV: File not readable ('.$Filepath.')');
			}

// For safety's sake
			@ini_set('auto_detect_line_endings', true);

$this -> Options = array_merge($this -> Options, $Options);
			$this -> Handle = fopen($Filepath, 'r');

// Checking the file for byte-order mark to determine encoding
			$BOM16 = bin2hex(fread($this -> Handle, 2));
			if ($BOM16 == 'fffe')
			{
				$this -> Encoding = 'UTF-16LE';
				//$this -> Encoding = 'UTF-16';
				$this -> BOMLength = 2;
			}
			elseif ($BOM16 == 'feff')
			{
				$this -> Encoding = 'UTF-16BE';
				//$this -> Encoding = 'UTF-16';
				$this -> BOMLength = 2;
			}

if (!$this -> BOMLength)
			{			
				fseek($this -> Handle, 0);
				$BOM32 = bin2hex(fread($this -> Handle, 4));
				if ($BOM32 == '0000feff')
				{
					//$this -> Encoding = 'UTF-32BE';
					$this -> Encoding = 'UTF-32';
					$this -> BOMLength = 4;
				}
				elseif ($BOM32 == 'fffe0000')
				{
					//$this -> Encoding = 'UTF-32LE';
					$this -> Encoding = 'UTF-32';
					$this -> BOMLength = 4;
				}
			}

fseek($this -> Handle, 0);
			$BOM8 = bin2hex(fread($this -> Handle, 3));
			if ($BOM8 == 'efbbbf')
			{
				$this -> Encoding = 'UTF-8';
				$this -> BOMLength = 3;
			}

// Seeking the place right after BOM as the start of the real content
			if ($this -> BOMLength)
			{
				fseek($this -> Handle, $this -> BOMLength);
			}

// Checking for the delimiter if it should be determined automatically
			if (!$this -> Options['Delimiter'])
			{
				// fgetcsv needs single-byte separators
				$Semicolon = ';';
				$Tab = "\t";
				$Comma = ',';

// Reading the first row and checking if a specific separator character
				// has more columns than others (it means that most likely that is the delimiter).
				$SemicolonCount = count(fgetcsv($this -> Handle, null, $Semicolon));
				fseek($this -> Handle, $this -> BOMLength);
				$TabCount = count(fgetcsv($this -> Handle, null, $Tab));
				fseek($this -> Handle, $this -> BOMLength);
				$CommaCount = count(fgetcsv($this -> Handle, null, $Comma));
				fseek($this -> Handle, $this -> BOMLength);

$Delimiter = $Semicolon;
				if ($TabCount > $SemicolonCount || $CommaCount > $SemicolonCount)
				{
					$Delimiter = $CommaCount > $TabCount ? $Comma : $Tab;
				}

$this -> Options['Delimiter'] = $Delimiter;
			}
		}

/**
		 * Returns information about sheets in the file.
		 * Because CSV doesn't have any, it's just a single entry.
		 *
		 * @return array Sheet data
		 */
		public function Sheets()
		{
			return array(0 => basename($this -> Filepath));
		}

/**
		 * Changes sheet to another. Because CSV doesn't have any sheets
		 *	it just rewinds the file so the behaviour is compatible with other
		 *	sheet readers. (If an invalid index is given, it doesn't do anything.)
		 *
		 * @param bool Status
		 */
		public function ChangeSheet($Index)
		{
			if ($Index == 0)
			{
				$this -> rewind();
				return true;
			}
			return false;
		}

// !Iterator interface methods
		/** 
		 * Rewind the Iterator to the first element.
		 * Similar to the reset() function for arrays in PHP
		 */ 
		public function rewind()
		{
			fseek($this -> Handle, $this -> BOMLength);
			$this -> CurrentRow = null;
			$this -> Index = 0;
		}

/**
		 * Return the current element.
		 * Similar to the current() function for arrays in PHP
		 *
		 * @return mixed current element from the collection
		 */
		public function current()
		{
			if ($this -> Index == 0 && is_null($this -> CurrentRow))
			{
				$this -> next();
				$this -> Index--;
			}
			return $this -> CurrentRow;
		}

/** 
		 * Move forward to next element. 
		 * Similar to the next() function for arrays in PHP 
		 */ 
		public function next()
		{
			$this -> CurrentRow = array();

// Finding the place the next line starts for UTF-16 encoded files
			// Line breaks could be 0x0D 0x00 0x0A 0x00 and PHP could split lines on the
			//	first or the second linebreak leaving unnecessary \0 characters that mess up
			//	the output.
			if ($this -> Encoding == 'UTF-16LE' || $this -> Encoding == 'UTF-16BE')
			{
				while (!feof($this -> Handle))
				{
					// While bytes are insignificant whitespace, do nothing
					$Char = ord(fgetc($this -> Handle));
					if (!$Char || $Char == 10 || $Char == 13)
					{
						continue;
					}
					else
					{
						// When significant bytes are found, step back to the last place before them
						if ($this -> Encoding == 'UTF-16LE')
						{
							fseek($this -> Handle, ftell($this -> Handle) - 1);
						}
						else
						{
							fseek($this -> Handle, ftell($this -> Handle) - 2);
						}
						break;
					}
				}
			}

$this -> Index++;
			$this -> CurrentRow = fgetcsv($this -> Handle, null, $this -> Options['Delimiter'], $this -> Options['Enclosure']);

if ($this -> CurrentRow)
			{
				// Converting multi-byte unicode strings
				// and trimming enclosure symbols off of them because those aren't recognized
				// in the relevan encodings.
				if ($this -> Encoding != 'ASCII' && $this -> Encoding != 'UTF-8')
				{
					$Encoding = $this -> Encoding;
					foreach ($this -> CurrentRow as $Key => $Value)
					{
						$this -> CurrentRow[$Key] = trim(trim(
							mb_convert_encoding($Value, 'UTF-8', $this -> Encoding),
							$this -> Options['Enclosure']
						));
					}

}
			}

return $this -> CurrentRow;
		}

/** 
		 * Return the identifying key of the current element.
		 * Similar to the key() function for arrays in PHP
		 *
		 * @return mixed either an integer or a string
		 */ 
		public function key()
		{
			return $this -> Index;
		}

/** 
		 * Check if there is a current element after calls to rewind() or next().
		 * Used to check if we've iterated to the end of the collection
		 *
		 * @return boolean FALSE if there's nothing more to iterate over
		 */ 
		public function valid()
		{
			return ($this -> CurrentRow || !feof($this -> Handle));
		}

// !Countable interface method
		/**
		 * Ostensibly should return the count of the contained items but this just returns the number
		 * of rows read so far. It's not really correct but at least coherent.
		 */
		public function count()
		{
			return $this -> Index + 1;
		}
	}
?>

Batal

⬅ Naik ke vikascas.com 46 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁TCPDF-main	dir	—	2024-03-25 23:56	📂 Buka
📁css	dir	—	2024-04-22 03:08	📂 Buka
📁fonts	dir	—	2024-04-22 03:08	📂 Buka
📁images	dir	—	2024-04-22 03:08	📂 Buka
📁js	dir	—	2024-04-22 03:08	📂 Buka
📁php-excel-reader	dir	—	2024-04-22 03:08	📂 Buka
📁tcpdf	dir	—	2024-04-22 03:08	📂 Buka
📁uploads	dir	—	2024-04-22 03:08	📂 Buka
📝LICENSE.md	md	1.5 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader.php	php	8.4 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_CSV.php	php	6.9 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_ODS.php	php	8 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_XLS.php	php	5.8 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🐘SpreadsheetReader_XLSX.php	php	29 KB	2015-04-29 20:24	✏️ Edit 👁️ View
🗜️TCPDF-main (2).zip	zip	16 MB	2024-04-22 05:44	✏️ Edit 👁️ View
📜accordion.js	js	734 B	2018-01-15 07:25	✏️ Edit 👁️ View
🐘application_form.php	php	16.9 KB	2025-04-02 08:05	✏️ Edit 👁️ View
🐘application_form_old.php	php	16.1 KB	2022-06-09 09:54	✏️ Edit 👁️ View
🐘application_print.php	php	69 B	2026-07-23 09:19	✏️ Edit 👁️ View
🐘class.php	php	34.5 KB	2020-03-06 07:59	✏️ Edit 👁️ View
📋composer.json	json	652 B	2015-04-29 20:24	✏️ Edit 👁️ View
🎨defaults.css	css	45.3 KB	2018-01-17 13:46	✏️ Edit 👁️ View
🎨demo.css	css	1.7 KB	2018-01-18 07:15	✏️ Edit 👁️ View
📄error_log	file	1.2 MB	2026-06-19 06:13	✏️ Edit 👁️ View
🐘export_application_list.php	php	2.9 KB	2025-04-02 08:04	✏️ Edit 👁️ View
🐘export_application_list_old.php	php	1.5 KB	2025-04-01 12:40	✏️ Edit 👁️ View
🐘footer.php	php	1.4 KB	2020-05-05 11:30	✏️ Edit 👁️ View
🐘function.php	php	35.7 KB	2020-04-08 14:47	✏️ Edit 👁️ View
🐘function1.php	php	21.1 KB	2019-11-23 09:46	✏️ Edit 👁️ View
🐘function12.php	php	20.3 KB	2019-11-20 09:16	✏️ Edit 👁️ View
🐘head.php	php	4.5 KB	2020-04-01 02:16	✏️ Edit 👁️ View
🐘header.php	php	989 B	2020-07-21 09:25	✏️ Edit 👁️ View
🐘index.php	php	1.2 KB	2025-04-01 12:19	✏️ Edit 👁️ View
🐘info.php	php	19 B	2026-07-23 09:28	✏️ Edit 👁️ View
🐘insert.php	php	1.8 KB	2018-01-19 07:15	✏️ Edit 👁️ View
🐘logout.php	php	145 B	2018-01-15 07:25	✏️ Edit 👁️ View
🐘menu.php	php	1.4 KB	2020-05-05 07:56	✏️ Edit 👁️ View
📜nicEdit.js	js	31.6 KB	2019-07-17 12:48	✏️ Edit 👁️ View
🖼️nicEditorIcons.gif	gif	3.3 KB	2015-10-04 11:56	✏️ Edit 👁️ View
🐘profile.php	php	5.1 KB	2021-06-08 15:52	✏️ Edit 👁️ View
🐘session.php	php	264 B	2020-05-05 07:47	✏️ Edit 👁️ View
🗜️spreadsheet-reader-master.zip	zip	48.9 KB	2019-11-21 12:50	✏️ Edit 👁️ View
🐘userlist.php	php	6.6 KB	2025-04-18 08:39	✏️ Edit 👁️ View
🐘userlist1.php	php	3.3 KB	2025-04-01 13:00	✏️ Edit 👁️ View
🐘userlist_old.php	php	3.2 KB	2022-06-09 10:04	✏️ Edit 👁️ View
🐘userview.php	php	2 KB	2018-01-15 07:25	✏️ Edit 👁️ View