<div>
Try:<br />
<br />
while($data = fgetcsv($csv, filesize(&quot;./trial_imports/<wbr />&quot;.$file), &quot;,&quot;)) {<br />
<br />
//perform actions<br />
}<br />
<br />
<br />
because the manual says fgetscsv returns false on error or EOF so maybe the !== FALSE doesnt match up with the EOF mark properly?
</div>


Try:

while($data = fgetcsv($csv, filesize("./trial_imports/".$file), ",")) {

//perform actions
}


because the manual says fgetscsv returns false on error or EOF so maybe the !== FALSE doesnt match up with the EOF mark properly?

<div>
<div class="content wysiwyg-content">
I have been using this loop that I pulled from the php.net website:<br />
<br />
do (($data = fgetcsv($csv, filesize(&quot;./trial_imports/<wbr />&quot;.$file), &quot;,&quot;)) !== FALSE) {<br />
<br />
//perform actions<br />
}<br />
<br />
But each time it runs, it always runs through one row too many, inserting a blank row into the database.<br />
<br />
I tried making it a do/while but got the same results.<br />
<br />
I would change it to loop through based on a count I keep up with, but I don't see a countrows function for the csv file. I've been up working on this for a long time, so I'm probably missing something simple. &nbsp;Maybe someone can think about it while I sleep ;)
</div>
</div>


I have been using this loop that I pulled from the php.net website:

do (($data = fgetcsv($csv, filesize("./trial_imports/".$file), ",")) !== FALSE) {

//perform actions
}

But each time it runs, it always runs through one row too many, inserting a blank row into the database.

I tried making it a do/while but got the same results.

I would change it to loop through based on a count I keep up with, but I don't see a countrows function for the csv file. I've been up working on this for a long time, so I'm probably missing something simple.  Maybe someone can think about it while I sleep ;)

fgetcsv loop returns 1 row to many

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.