<?php
class csvReader {
private $csv;
private $keys;
// SELECT AND OPEN THE CSV FILE
public function __construct($getCSV)
{
$this->csv = fopen($getCSV, 'r');
$this->keys = fgetcsv($this->csv);
rewind($this->csv);
}
// RETURN THE DATA BASED ON GIVEN LINE NUMBER AND COLUMN NAME
public function getData($num, $ind)
{
$row = 0;
while ($data = fgetcsv($this->csv))
{
if ($row == $num)
{
rewind($this->csv);
$data = array_combine($this->keys, $data);
return $data[$ind];
}
$row++;
}
}
public function __destruct()
{
fclose($this->csv);
}
}
?>
// Open the target csv file
$csv = new csvReader("targetFile.csv");
// Return the data based on the given line number and column name
$csv->getData(38, 'phone')
$csv = new csvReader("targetFile.csv");
// Return the data based on the given line number and column name
$csv->getData(38, 'phone')
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.