PHP - Fgetcsv" Sometimes Extra Comma

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 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 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 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.

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;
    }

Hey all,

I've run into a bit of a problem when trying to use fgetcsv to dump the contents of a csv file into an array, in as much as fgetcsv stops after a line break.
I've been using fputcsv to add content to the file and every time I use fputcsv it adds a line break, hense my problem.
As you might have guessed from the time of this post (I'm in the uk) I've been trying to come up with a solution for this for quite a while; I'm pretty new to php as you might have gathered.

Code:

<?php
$fname=data.csv
$file=fopen($fname,"r");
$data=fgetcsv($file);
echo "$data[0] $data[1] $data[2]";
?>

The csv looks something like this:
adam,19
alex,16
andrew,24
etc...
I'm able to access the first 2 values with $data[0] and $data[1], but when I try and access anything after the first line break, I get undefined ofset errors.

If anyone could point me in the right direction to a solution for this problem I would be extremely greatful since I can't seem to find anything!!

In the mean time, I'm off to catch up on some sleep.

Cheers.

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);

Hi,

bit stuck on how to find and replace "<" and ">" with "&lt;" and  "&gt;". I basically have a database record that outputs to screen and I need the code in the <code> tags to be rendered to the screen. I therefore need it to go through the whole array variable from the db and change the symbols just inside the code tags. Please be aware that the code tags might happen more than once

here's an example below

Code: [Select]
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>

the desired output would be:

<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>

help on this would be great

Cheers

Rob

I have ascript that loops through a directory of zip files, unzips to new directory and deletes the zip file and is supposed to import to mysql database. Everything works BUT writes empty records.
Here is my code if anyone can help would be great
Code: [Select]
<?php
include("sharons_dbinfo.inc.php");
$files = glob('gz/*.gz');
$texts = glob('*.txt');

foreach ($files as $in_file) {

$file=str_replace(".gz","",$in_file);
$file=str_replace("gz/","",$file);
$file2=fopen($file,"w");


$gz = gzopen($in_file, 'r');
while (!gzeof($gz)) {
$contents = gzread($gz, 10000);
fwrite($file2, $contents);

}
gzclose($gz);
unlink ($in_file);

foreach ($texts as $text) {
$handle = fopen("$text", "r");

     while (($data = fgetcsv($handle, 10000, ",")) !== FALSE)

     {
$data = str_replace("'", "", $data);
    
mysql_connect(localhost,$user,$password);
mysql_select_db($database) or die( "Unable to select database");

       $import="INSERT into new (`ID`,`PROGRAMNAME`,`PROGRAMURL`,`CATALOGNAME`,`LASTUPDATED`,`NAME`,`KEYWORDS`,`DESCRIPTION`,`SKU`,`MANUFACTURER`,`MANUFACTURERID`,`UPC`,`ISBN`,`CURRENCY`,`SALEPRICE`,`PRICE`,`RETAILPRICE`,`FROMPRICE`,`BUYURL`,`IMPRESSIONURL`,`IMAGEURL`,`ADVERTISERCATEGORY`,`THIRDPARTYID`,`THIRDPARTYCATEGORY`,`AUTHOR`,`ARTIST`,`TITLE`,`PUBLISHER`,`LABEL`,`FORMAT`,`SPECIAL`,`GIFT`,`PROMOTIONALTEXT`,`STARTDATE`,`ENDDATE`,`OFFLINE`,`ONLINE`,`INSTOCK`,`CONDITION`,`WARRANTY`,`STANDARDSHIPPINGCOST`) values('','$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]','$data[17]','$data[18]','$data[19]','$data[20]','$data[21]','$data[22]','$data[23]','$data[24]','$data[25]','$data[26]','$data[27]','$data[28]','$data[29]','$data[30]','$data[31]','$data[32]','$data[33]','$data[34]','$data[35]','$data[36]','$data[37]','$data[38]','$data[39]')";

       mysql_query($import) or die(mysql_error());


     }

fclose($handle);


}
}
?>Thanks everyone

Hi guys

I am a newbie with PHP and I have been trying to solve this problem for 3 days..

Ive set up a booking form on my website to be sent directly to my email once the client clicked on the send button..
The problem I am having while checking these pages on wamp is that the booking form is ok but when I click on the send button the following message error appears
"Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\wamp\www\fluffy_paws\booking_form2.php on line 27"

When I check online I have this message "500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed."

Are my codes wrong???

My webhosting is Blacknight.com , Im on Windows Vista, my internet is a dongle with O2 ireland

Thanks for your help!

Hi guys

I'm struggling a bit, I need to replace a word that occurs multiple times in text with an array("up","down","forward","backwards") of words.


$find = "left";
$replace = array("up","down","forward","backwards");
$text = "left left left left";

echo str_replace($find,$replace,$text);


The Output is: array array array array

Did try this with a foreach statement as well, but no luck. Is there a better way of doing this? 

Thanks

cant work out this mysql syntax error
"operation":"medupdate","medid":"","name":"ibo","medyear":"5","medmonth":"21","medday":"1","recuser":1,"SuccFail":"fail","SuccFailMessage":"error occured You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''WHERE med_id=' at line 2","ResultData":""}

Code: [Select]
$sql="update metodology set med_description='".$req['name']."',
  med_year='".$req['medyear']."', med_month='".$req['medmonth']."', med_day='".$req['medday']."', med_recorddate= now(), med_recorduserid= 1'";
  $sql.= " WHERE med_id=".$req['medid'];

I am getting the following error when using composer: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Just started.  I am pretty sure composer.json wasn't changed.  journalctl doesn't show anything.  Maybe Doctrine related, however, nothing seems to help.

Any ideas?
 

[michael@devserver www]$ php -v
PHP 7.3.4 (cli) (built: Apr  2 2019 13:48:50) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.4, Copyright (c) 1998-2018 Zend Technologies
    with DBG v9.1.9, (C) 2000,2018, by Dmitri Dmitrienko
[michael@devserver www]$ composer -V
Composer version 1.4.2 2017-05-17 08:17:52
[michael@devserver www]$ yum info composer
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror.us.oneandone.net
 * epel: mirror.rnet.missouri.edu
 * extras: mirror.us.oneandone.net
 * remi-php73: mirror.bebout.net
 * remi-safe: mirror.bebout.net
 * updates: mirror.us.oneandone.net
Installed Packages
Name        : composer
Arch        : noarch
Version     : 1.8.4
Release     : 1.el7
Size        : 1.8 M
Repo        : installed
From repo   : epel
Summary     : Dependency Manager for PHP
URL         : https://getcomposer.org/
License     : MIT
Description : Composer helps you declare, manage and install dependencies of PHP projects,
            : ensuring you have the right stack everywhere.
            :
            : Documentation: https://getcomposer.org/doc/

[michael@devserver www]$ composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)


  [ErrorException]
  "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?


update [--prefer-source] [--prefer-dist] [--dry-run] [--dev] [--no-dev] [--lock] [--no-custom-installers] [--no-autoloader] [--no-scripts] [--no-progress] [--no-suggest] [--with-dependencies] [-v|vv|vvv|--verbose] [-o|--optimize-autoloader] [-a|--classmap-authoritative] [--apcu-autoloader] [--ignore-platform-reqs] [--prefer-stable] [--prefer-lowest] [-i|--interactive] [--root-reqs] [--] [<packages>]...

[michael@devserver www]$

 

This topic has been moved to Linux.

http://www.phpfreaks.com/forums/index.php?topic=318175.0

This topic has been moved to PHP Installation & Configuration.

http://www.phpfreaks.com/forums/index.php?topic=347922.0