Completed and understood!
It's a lot of fun to play with files and also very useful!!


Just a note of caution:
If you are using the "move on to next part" links at the bottom of the tutorial pages (on the CD), the link underneath page 2 and 3 takes you to section 13 (databases)!
Use the main contents page to go to the correct next section!

Thought so.. can someone help
I cant connect to the database.
can't find the right php.ini file.

please help......

Why the php.ini file?

The PHP.ini was for to enabling the magic quotes.

I cannot connect to the database. I get this when I run my code "Database NOT Found"

$user_name = "root";
$password = "";
$database = "addressbook";
$server = "127.0.0.1";

$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);

if ($db_found) {
$SQL = "INSERT INTO tb_address_book (First_Name, Surname, Address) VALUES ('bill', 'gates', 'Microsoft'";
$result = mysql_query($SQL);
mysql_close($db_handle);
print "Records added to the database";
}
else {
print "Database NOT Found ";
mysql_close($db_handle);
}

Use the formatted code button on the editor to post PHP code.

See this on magic quotes: http://www.tizag.com/phpT/php-magic-quotes.php

add an or die function like here under

Language: PHP
$result = mysql_query($SQL) or die(mysql_error());

It will provide more information

If it says Unknown database 'addressbook' then perhaps check the spelling of the db.

Hi,

This is a great lesson! Interesting reading many column arrays. Done, but will return to this section
to do further research on working with CSV files in PHP.

Section Complete

Regarding page two of section 10, did anyone else get the number "6143" printed at the end of their page when using readfile()? It's not in dictionary.txt and when I add file_get_contents() it goes away. My intuition tells me it's probably a character count. Anyone know for sure?

@Brad

You are right, it is the character count. The reason for this is that readfile() actually prints out the content AND returns the length.
So as I understand this, in the following code :

Language: PHP
$file_to_read = "dictionary.txt";
print readfile($file_to_read);

the "readfile()" is actually printing out the content of the document,
while "print" is actually printing the content length of the file (that was returned by "readfile()"

If you just use

Language: PHP
$file_to_read = "dictionary.txt";
readfile($file_to_read);

you'll see that the contents of the document is still printed!

I hope this makes sense!!!!

@78183472

You've done well, great feedback.
Thanks so much

Completed this section. Noticed that some of the "next page" links were not working correctly on my cd - not a problem.
Was wondering how to get a new text line when writing to the file - found \r\n using google - tested and it worked.
Can't wait to get to the mysql section, going to do the dates quickly and then start that one!

Section 10 - Working With Files In PHP: Completed , looking forward to applying this knowledge. !

Wait a minute... Am I missing something here? @78183472 when I use:
readfile() and also echo readfile() the results are the same to me - the contents of: "dictionary.txt" are printed on the screen. So I don't get the difference you've mentioned.

Done! Thanks to 78183472 for the warning, I was a bit confused there for a minute until I read your comment.
I quite like the CSV files, had a bit of introducing in excel a while back, so it was nice to see how it works together.
Next..

When using the fgetcsv() function; is it a must that one should include file size?

Optional. Specifying it increases the speed, but not so that anyone will notice

Re: Section 10 - Working With Files In PHP : Completed and understood.

I have finished chapter 10. My links were a incorrect too, but not a problem.

Section 10 completed.

Useful summary: http://www.w3schools.com/php/php_file.asp

Warren

Completed this section, but had the same issue as Tessa with some of the next page options jumping to Section 13. So completed some of those too I'm glad I thought to look back at the php.html file again to check why I was getting so confused.

Completed section. Found it pretty straight forward.

Also experienced the incorrect page links, for a second there I was so worried! Could not understand how the tutorial can claim we have done steps 1 and 2 and then I can't recall any of it!! Anyway, luckily realised the mistake quickly so did not get too confused.

Thank you Warren for the summary on w3schools. Found it helpful and will probably refer back to that if I ever need a reminder.

Section Complete

Completed this section no difficulty experienced.