PHP - Using Fgetcsv On Multiple Line Csv

My .csv file has 3 columns and 10 rows
However, the following only returns one row:

$file = fopen('document.csv', 'r');
while (($data = fgetcsv($file)) !== FALSE) {
$string .= $data[0].','.$data[1].','.$data[2]."\n";
}
print $string;

If I open the original .csv file in a text editor and replace all the invisible end-of-line "\r" with "\n" then the above code works fine.

There must be an efficient way to implement this in my script, without having to remember to modify the original .csv file first....

Thank you in advance 😀

I am trying to display rows starting with a specific tag when using fgetcsv() like rows starting with tag SY or AP where the first element of each such rows would have SY or AP has prefix example SY-Atlanta, SY-Texas, AP-Atlanta, AP-texas. The next columns in that row would have some data. I want to display only rows with above said prefix. What is the best way to do it? Use preg_match for each row and display it only if it has a match or is there any easier way?

Sample data in csv:

SY-Atlanta,0,0,0,5,9,9,0
SY-Texas,0,5,8,0,0,8.4
AP-Atlanta,9,4,8,9,0,0,0
AP-Texas,8,0,9,0,0,0,0
DF-Atlanta,8,4,9,3,0,0,0,0
DF-Texas,8,4,9,0,0,0,0,0

Hi

I am uploading a csv file in the datbase. and i want to show an error message if the columns are more than 5.

I am counting the rows in the below script but it always prints row 1. I have spent lot of time to figure out and google it. all the examples in google looks similar to mine.

Can anyone find any issue with the below script and correct me pls

Thanks in advance


$row=1;
        $error = 'No'; //////////initialise the error flag
        
        while (($data = fgetcsv($handle, 1000, ",",'"')) !== FALSE) {
            if( count($data) > 5 ){
                    //print_r($data);
                    $error = 'Yes' ; ///////////set the error flag to yes and break the loop . validation failed
                    $errorMess = 'There are more than 5 columns in row # '.$row ;
                    break ;
            }
        ///////////////insert the data into stagging table if the column ==5///////////////////
        //print_r($data);
          $sqlLoad = "INSERT INTO  ratecodes_stagging ( package_name,package_table,plan_name,plan_code,package_hierachy  )
                      VALUES ('".addslashes($data[0])."','".addslashes($data[1])."','".addslashes($data[2])."','".addslashes($data[3])."',
                      '".addslashes($data[4])."')";
          $resultSqlLoad = es_query($sqlLoad);
        $row++;
        //echo $i."<br>";
        }//END while fgetcsv 

Anyone can help me with plotting of multiple line graph in php.

I have researched on multiple line graph online and  I would like to plot the graph by taking data from my database but the example below is inserting the graph data manually.
Anyone can teach me how to use a for loop inside an array?

Code: [Select]
<?php
//Include the code
require_once 'phplot.php';

//Define the object
$plot = new PHPlot(800,600);

//Set titles
$plot->SetTitle("A 3-Line Plot\nMade with PHPlot");
$plot->SetXTitle('X Data');
$plot->SetYTitle('Y Data');

//Define some data
$example_data = array(
     array('a',3,4,2),
     array('b',5,3,1),  
     array('c',7,2,6),
     array('d',8,1,4),
     array('e',2,4,6),
     array('f',6,4,5),
     array('g',7,2,3)
);
$plot->SetDataValues($example_data);

//Turn off X axis ticks and labels because they get in the way:
$plot->SetXTickLabelPos('none');
$plot->SetXTickPos('none');

//Draw it
$plot->DrawGraph();
?>

I am a web designer/PHP hack trying to solve a problem for our HR department. We have a quarterly newsletter in a Wordpress site I developed and they want to have a dynamically updated service anniversary page updated through excel. The solution to this problem is clearly fgetcsv, but I'm having trouble understanding how to implement it within the wordpress page.

Here is a really nice function from the php manual page

Code: [Select]
<?php
function csv_file_to_mysql_table($source_file, $target_table, $max_line_length=10000) {
    if (($handle = fopen("$source_file", "r")) !== FALSE) {
        $columns = fgetcsv($handle, $max_line_length, ",");
        foreach ($columns as &$column) {
            $column = str_replace(".","",$column);
        }
        $insert_query_prefix = "INSERT INTO $target_table (".join(",",$columns).")\nVALUES";
        while (($data = fgetcsv($handle, $max_line_length, ",")) !== FALSE) {
            while (count($data)<count($columns))
                array_push($data, NULL);
            $query = "$insert_query_prefix (".join(",",quote_all_array($data)).");";
            mysql_query($query);
        }
        fclose($handle);
    }
}

function quote_all_array($values) {
    foreach ($values as $key=>$value)
        if (is_array($value))
            $values[$key] = quote_all_array($value);
        else
            $values[$key] = quote_all($value);
    return $values;
}

function quote_all($value) {
    if (is_null($value))
        return "NULL";

    $value = "'" . mysql_real_escape_string($value) . "'";
    return $value;
}
?>
But this leaves me with a few questions:
1. is this both function AND query? or do i need extra code to run the function and spit out the results?
2. where do i input my actual values?
3. does this have to mirror a mysql table somewhere else? i feel like i'm missing a crucial piece of info here.

the path to the csv file needs to be absolute, due to HR needing to manage the file themselves without the help of yours truly. the intended output will look like this:

5 YEARS
FirstName1 LastName1, FirstName2 LastName2, FirstName3 LastName3, etc

6 YEARS
FirstName1 LastName1, FirstName2 LastName2, FirstName3 LastName3, etc

and so on. so in addition to the FirstName, LastName and Year columns, the loop will need to include a conditional statement. something like:

Code: [Select]
<h1>5 YEAR</h1>
<ul>
<?php 
     if (quote_all_array(5) ) : ?>
          echo "<li>(FirstName, LastName),&nbsp;</li>";
<?php endif; ?>
</ul>

<h1>6 YEAR</h1>
<ul>
<?php 
     if (quote_all_array(6) ) : ?>
          echo "<li>(FirstName, LastName),&nbsp;</li>";
<?php endif; ?>
</ul>

I'm sure my syntax is horribly wrong because I have virtually no idea what I'm doing. Which is why I'm asking you all for help

to help my understanding i'll supply a set of variables:

CSV Source: http://resource.mysite.com/anny.csv
Table Columns: FirstName, LastName, Year
External MySql database (should it apply): AnnySql

Thanks in advance for any help. I'm over my pay grade on this one.