How to delete rows in php csv

php csv deletion method: first convert the file into an array through the "explode("\n",file_get_contents("path/to/csv_file");" method; then use the unset function to delete the specified OK.

Recommended: "PHP Video Tutorial"

Use PHP to extract data from a CSV file Conditionally delete rows

Specific question:

I am downloading a csv report from an advertiser's doubleclick. My client needs to save the csv to a database table. Before saving the csv to the database, I need to delete a few rows from the top and total rows from the bottom. Is there any function in PHP that can delete the rows I specify from the csv file?

Solution :

No specific function, but there are several ways to achieve it.

If you have enough RAM to keep the entire file in memory at the same time, you can Convert to an array:

$data=explode("\n",file_get_contents("path/to/csv_file");

Then, to get rid of the total at the bottom, you can unset the last row with:

unset($data[sizeof($data)-1);

The way it works is that each row in the array is numbered, but from Zero-based. "sizeof" will be the number of rows, but since we start counting from zero, it will be one too many.

To remove some rows from the top, you can

unset($data[0]); and unset($data[1]);

then Use the foreach() function to iterate through rows and insert into the database:

foreach($data as $line){
/// parse your $line 
/// Insert row into database
}

The above is the detailed content of How to delete rows in php csv. For more information, please follow other related articles on the PHP Chinese website!