How to delete rows in php csv

藏色散人
Release: 2023-03-04 18:48:02
Original
1748 people have browsed it

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.

How to delete rows in php csv

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");
Copy after login

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

unset($data[sizeof($data)-1);
Copy after login

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]);
Copy after login

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 }
Copy after login

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!