PHP - Help With Fgetcsv()

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 

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.

Hi I am trying to use this function to upload a CSV-format baseball schedule. I copied the example code from the manual website and it worked fine, printing out the contents, array style. I then added my code to the middle of this which just does a bit of analysis of dates and times for unix-style and then writes the stuff into a MySQL DB. It didn't work any more. As soon as I try to use fgetcsv it won't work. PLEASE HELP I have pulled all my remaining hair out! I checked my code with a magnifying glass but any hint of my code near fgetcsv stops the page loading.

I have data in a flat file that looks like the following:

Code: [Select]

#####  BEGIN PRODUCT LOOP #####

REF*19**OHIO VALLEY FLOORING
PID*F*TRN***SUPERINTENDENT
PID*F*MAC***CARINDR
MEA**LN*125.0*FT
MEA**WD*12.0*FT
MEA**SW*0.500*FP
CTP**PRICE1*9.790**SY****ST
CTP**PRICE2*11.190**SY****CT

####### BEGIN INTERNAL LOOP #######

G43*003**INVENTORY
SLN*1**O******SK*RKDA100AA591*****ST*A100A
PID*F*COLOR***SAGE TWEED
PID*F*35***A591

SLN*2**O******SK*RKDA100AA592*****ST*A100A
PID*F*COLOR***CREAMY TOFFEE
PID*F*35***A592

SLN*3**O******SK*RKDA100AA593*****ST*A100A
PID*F*COLOR***GALAXY GRAY
PID*F*35***A593

######## END INTERNAL LOOP ########

LIN**GS*A161*MF*ROOKWOOD CARPET*ST*A161
DTM*007*20110413

####### END PRODUCT LOOP #######


My problem is that the header information is on each line and not at the beginning of the file like most CSV formats.  Like the following:

Code: [Select]

REF*19 (Would be a column in the database)  --- I would need OHIO VALLEY FLOORING but for each Referenced SKU #
PID*F*TRN (Would be a column in the database)  --- I would need SUPERINTENDENT but for each Referenced SKU #
PID*F*MAC (Would be a column in the database)  --- I would need CARINDR but for each Referenced SKU #
and so on...




So the database output would look something like:

[/code]

SKU                           |  PRICE1           |   PRICE2    |  COLOR
---------------------------|-------------------|---------------|------------------
RKDA100AA591         |  9.790             |   11.190     |  SAGE TWEED
RKDA100AA592         |  9.790             |   11.190     |  CREAMY TOFFEE
RKDA100AA593         |  9.790             |   11.190     |  GALAXY GRAY

[/code]

How would I define each row in the data set and get the information for each row to stuff in the database?  Thanks for any help you can provide.  This is what I have at present:

Code: [Select]
print_r(buildStock('832x12Data.txt'));

function buildStock($File) {
        $handle = fopen($File, "r");
        $fields = fgetcsv($handle, 1000, ",");

        while($data = fgetcsv($handle, 1000, ",")) {
            $detail[] = $data;
        }

        $x = 0;
        $y = 0;

        foreach($detail as $i) {
            foreach($fields as $z) {
                $stock[$x][$z] = $i[$y];
                $y++;
            }
            $y = 0;
            $x++;
        }
        return $stock;
    }

Hello,
I have a page where the user uploads a CSV file and I want to read that CSV and update database fields accordingly.  It seems I have all the code correct but only the first row of the CSV is being imported.

If I echo my variables within the loop, the only output is the first row of the CSV - no subsequent rows.  I feel like I'm close but not sure what the issue is?  Thanks a million for any help!!

Jason


//START FILE OPERATION
$handle = fopen('uploads/testfile.csv', "r");

//LOOP CONTENTS OF CSV FILE
while (($data = fgetcsv($handle, 1000, ",")) !== false)
{
$importID = $data[0];
$companyName = $data[1];
$primaryPhone = $data[2];
$primaryEmail = $data[3];
$billingFirstName = $data[4];
$billingLastName = $data[5];

$query = 'SELECT importID FROM import';
if (!$result = mysql_query($query))
{
continue;
}

if ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
//UPDATE IF ENTRY EXISTS
$query = "UPDATE import SET companyName='$companyName', primaryPhone='$primaryPhone', primaryEmail='$primaryEmail', billingFirstName='$billingFirstName' WHERE importID=$importID";
mysql_query($query);

if (mysql_affected_rows() <= 0)
{
//NO RECORDS UPDATED
}
}
else
{
//ENTRY DOESN'T EXIST
}

mysql_free_result($result);
}

//CLOSE FILE OPERATION
fclose($handle);