🤑 Join the Treehouse affiliate program and earn 25% commission!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Preview

Start a free Courses trial
to watch this video

Sign up for Treehouse

Reading CSV

7:40 with Alena Holligan

CSV is a very popular format for importing and exporting data to and from databases and spreadsheets. We will be using some built in PHP functions that lets us read and write CSV data as arrays.

Teacher's Notes
Questions?
Video Transcript
Downloads
Workspaces

Other Formats for CSV

It is not required that CSV files have a header line, although the SHOULD. Also, any character can be used as a delimiter to separate columns. Other common delimiters include pipe (|) and tab (\t). If your CSV file uses a different delimiter, make sure you specify the delimiter in the options of fgetcsv.

Additional fgetcsv Options

Besides passing the file handler, you can also specify

length Must be greater than the longest line (in characters) to be found in the CSV file (allowing for trailing line-end characters). Otherwise the line is split in chunks of length characters, unless the split would occur inside an enclosure.

Omitting this parameter (or setting it to 0 in PHP 5.1.0 and later) the maximum line length is not limited, which is slightly slower.

delimiter The optional delimiter parameter sets the field delimiter (one character only).

enclosure The optional enclosure parameter sets the field enclosure character (one character only, like a single or double quote).

escape The optional escape parameter sets the escape character (one character only).

Read the Documentation: fgetcsv

Checking if File is Open

I have shown two ways to check if a file is open

if ($fh = fopen(FILE, MODE)) {

Is the same as

if (($fh = fopen(FILE, MODE)) !== false) {

because the if statement is checking for a "truthy" (meaning positive) value. If the file is open the value is "truthy", and if the $fh !== false, this is also a positive value.

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

CSV is very popular format for importing and exporting data to and 0:00

from databases and spreadsheets. 0:05

These files usually have a header row and then multiple rows below them 0:08

with each column of values separated by the previous column by a comma. 0:13

We'll be using some built in PHP functions that let us read and 0:19

write CSV data as an array. 0:22

I have included a contact list in a CSV file 0:25

that will be using to generate the page of suggested people to follow. 0:29

Let's get started. 0:33

Let's open the people.php file where I have started 0:35

by showing the contents of the CSV file and also a sample contact. 0:38

Let's preview this in a browser, As you can 0:44

see this is a comma separated file with a header row and here's the sample contact. 0:50

Let's go back to work spaces and remove the file display, and 0:56

replace the sample contact with the data from the CSV. 0:59

We'll start by commenting out these lines. 1:02

Now, we need to open a file for reading like we did in the first section. 1:11

We're going to wrap this in an if statement. 1:16

Fopen 'data/csv/people.csv' and 1:24

we will open it to read. 1:30

And fclose. 1:44

Instead of fgets, to get each line as a string, we'll use fget csv. 1:48

This will read each line as a row of columns in a CSV file. 1:56

This will return an array of columns. 2:01

There are a number of optional parameters including the ability to 2:08

specify the delimiter. 2:12

By default, it uses a comma but you can read tab delimited files as well. 2:14

We won’t be using any of the optional parameters right now but 2:20

make sure you check the notes associated with this video. 2:24

The first time that we use the fgetcsv function, it should return our headers and 2:27

move the pointer to the next line. 2:31

Let's check out the headers. 2:36

Let's preview this in a browser. 2:43

I'm going to use those headers to make my code more readable. 2:47

First, I'm going to flip the array so that the key is a value and 2:51

the value is the key. 2:55

I then use extract to put each of those keys into its own variable. 3:02

Now I can echo first and this should give me the number associated with that column. 3:12

Great, now we're going to loop through each of the additional lines to 3:21

display each contact. 3:25

Let's comment out this line and this line. 3:29

While contact = fgetcsv and 3:36

the file handler. 3:42

While it's not equal to false. 3:48

This will loop through the file until there are no more lines to read. 3:53

I'm going to wrap this around my sample contact. 3:57

I want the loop to be on the inside of the row div. 4:11

Then I'll always have at least one row. 4:15

Then I want to create a new row for every four contacts, so 4:28

I'll need to count which number I'm on. 4:32

I already have my first row, 4:42

so I don't want to add another row if this is the first contact. 4:44

If count is greater than zero, and 4:49

count, and the modulus operator. 4:56

This will give me the remainder. 4:59

And I want to divide this by 4. 5:01

If that has no remainder, 5:03

then I know that it's divisible by 4. 5:06

Then I can close my div. 5:13

And start a new row. 5:19

And then increase my count. 5:32

Now we can use the contact array with the header variables we created 5:35

to fill in the details for each contact. 5:39

Make sure we put 5:52

a space between 5:57

the first, and 6:03

last name. 6:09

Okay, let's take a look at our page in the browser now. 7:13

My images aren't showing up right let's go check that. 7:19

The image actually has the full length to the source, so let's remove this. 7:23

Great, each of the contacts from the CSV file is 7:32

displayed with links to their website and Twitter account. 7:35

You need to sign up for Treehouse in order to download course files.

Sign up

You need to sign up for Treehouse in order to set up Workspace

Sign up