what am i reading at the moment? i guess everyone's got some kind of a list of books one currently reads or is interested in reading; the same goes for music, which albums to listen to or crave for, and also what movies one has seen and which ones one might consider to collect as DVD issues. here's my recent reading list:
Thomas Pynchon: Inherent Vice
Alex Halberstadt: Lonely Avenue: The Unlikely Life and Times of Doc Pomus
this title reminded my of the song i first heard on a Van Morrison record and only later on a Ray Charles album. touchingly written!
Mark Twain: The Complete Interviews (Studies in American Literary Realism and Naturalism)
very interesting reading; i didn't know that Mark Twain at his own time was popularly known as a humorist. in my youth i'd never consider his Adventures of Tom Sawyer and Huckleberry Finn as humorous literature.
Mark Twain: Bummel durch Deutschland
Mark Twain: Bummel durch Europe
i'm considering getting these about Mark Twain's travels through Germany and Europe. they will certainly make facinating reading about Europe at the time.
Mark Twain: Die Schreckliche Deutsche Sprache (the awful german language)
i haven't seen this one at local bookstores, but it definitely sounds like an inviting title after what i've read so far about Mark Twain.
J. R. Moehringer: The Tender Bar: A Memoir (Audio Book)
i'm not a big fan of audiobooks, i'd rather read; but this one i find interesting since it's being read by the author 'n' i guess he'd put the pronounciations appropriately there where he'd 've wished to highlight or obscure in this tender memoir.
tom.paine
Tuesday, December 15, 2009
PHP: list all files of a local directory
... i haven't written an article since march ... here's a short script.
the issue: i wanted to save a list of a music albums i'd converted from CD to mp3 format. to avoid typing it all out i got myself a little script to do the work for me at mouse click:
<pre>
<?php
define('DEFAULT_DIR','D(rive):\\MyFolder\\');
$dir = (isset($_GET['dir'])) ? $_GET['dir'] : DEFAULT_DIR;
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
echo $file . "\n";
}
closedir($dh);
}
}
?>
</pre>
this code simply lists all files and folders of the MyFolder directory.
there was another code snippet i worked on: i wanted a list of the songtitles of a particular album without the .mp3 file extension; the code looks like this:
<?php
define('DEFAULT_DIR','D(rive):/MyFolder');
$dir = (isset($_GET['dir'])) ? $_GET['dir'] : DEFAULT_DIR;
?>
<html>
<head>
<title>List-All-Files : <?=$dir;?></title>
<script language="JavaScript" type="text/javascript">
<!--
function copyit(theField) {
var tempval=eval("document.linktable.list_table");
tempval.focus();
tempval.select();
therange=tempval.createTextRange();
therange.execCommand("Copy");
}
//-->
</script>
<style type="text/css">
<!--
body {font-family:'Trebuchet MS'; color:#AB0000;}
form {font-family:'Courier New', Courier; font-size: 12px;}
.button {font-family: Verdana, Helvetica, sans-serif; font-size: 11px; font-weight: bold; cursor: hand; color: #AB0000; margin-top: 3mm; border: 2px; border-color: #DDDDDD; border-style: outset; background-color: #FFFFFF; width: 150;}
.button1 {font-family: Verdana, Helvetica, sans-serif; font-size: 11px; font-weight: bold; cursor: hand; color: #AB0000; margin-top: 3mm; border: 2px; border-color: #DDDDDD; border-style: outset; background-color: #FFFFFF; width: 150;}
.button2 {font-family: Verdana, Helvetica, sans-serif; font-size: 11px; font-weight: bold; cursor: hand; color: #FFFFFF; margin-top: 3mm; border: 2px; border-color: #DDDDDD; border-style: outset; background-color: #AB0000; width: 150;}
-->
</style>
</head>
<body topmargin="0">
<center><h3><u><i>List-All-Files</i></u> : <?=$dir?></h3></center>
<form name="linktable">
<div><input class="button" type="button" value="COPY & PASTE" onclick="copyit();" onmouseover="this.className='button2'" onmouseout="this.className='button1'"></div><br>
<textarea style="width:875px; height:1000px; color:#FFFFFF; background-color:#AB0000;" name="list_table" readonly="readonly">
<?php
filesInDir($dir);
function filesInDir($tdir)
{
$dirs = scandir($tdir);
foreach($dirs as $file) {
if (($file == '.') || ($file == '..')) { }
elseif (is_dir($tdir.'/'.$file)) { filesInDir($tdir.'/'.$file); }
else { echo substr($file,0,strlen($file)-4)."\n"; } }
}
?>
</textarea>
</form>
</body>
</html>
this will list all files of the directory MyFolder minus the last 4 digits of the complete filename. of course if the file-extension would be .html it would still include the . (dot) in the filename; furthermore, this code displays the list in an easy to use copy and paste form field.
well, at least it's something, isn't it?
tom.paine
the issue: i wanted to save a list of a music albums i'd converted from CD to mp3 format. to avoid typing it all out i got myself a little script to do the work for me at mouse click:
<pre>
<?php
define('DEFAULT_DIR','D(rive):\\MyFolder\\');
$dir = (isset($_GET['dir'])) ? $_GET['dir'] : DEFAULT_DIR;
if (is_dir($dir)) {
if ($dh = opendir($dir)) {
while (($file = readdir($dh)) !== false) {
echo $file . "\n";
}
closedir($dh);
}
}
?>
</pre>
this code simply lists all files and folders of the MyFolder directory.
there was another code snippet i worked on: i wanted a list of the songtitles of a particular album without the .mp3 file extension; the code looks like this:
<?php
define('DEFAULT_DIR','D(rive):/MyFolder');
$dir = (isset($_GET['dir'])) ? $_GET['dir'] : DEFAULT_DIR;
?>
<html>
<head>
<title>List-All-Files : <?=$dir;?></title>
<script language="JavaScript" type="text/javascript">
<!--
function copyit(theField) {
var tempval=eval("document.linktable.list_table");
tempval.focus();
tempval.select();
therange=tempval.createTextRange();
therange.execCommand("Copy");
}
//-->
</script>
<style type="text/css">
<!--
body {font-family:'Trebuchet MS'; color:#AB0000;}
form {font-family:'Courier New', Courier; font-size: 12px;}
.button {font-family: Verdana, Helvetica, sans-serif; font-size: 11px; font-weight: bold; cursor: hand; color: #AB0000; margin-top: 3mm; border: 2px; border-color: #DDDDDD; border-style: outset; background-color: #FFFFFF; width: 150;}
.button1 {font-family: Verdana, Helvetica, sans-serif; font-size: 11px; font-weight: bold; cursor: hand; color: #AB0000; margin-top: 3mm; border: 2px; border-color: #DDDDDD; border-style: outset; background-color: #FFFFFF; width: 150;}
.button2 {font-family: Verdana, Helvetica, sans-serif; font-size: 11px; font-weight: bold; cursor: hand; color: #FFFFFF; margin-top: 3mm; border: 2px; border-color: #DDDDDD; border-style: outset; background-color: #AB0000; width: 150;}
-->
</style>
</head>
<body topmargin="0">
<center><h3><u><i>List-All-Files</i></u> : <?=$dir?></h3></center>
<form name="linktable">
<div><input class="button" type="button" value="COPY & PASTE" onclick="copyit();" onmouseover="this.className='button2'" onmouseout="this.className='button1'"></div><br>
<textarea style="width:875px; height:1000px; color:#FFFFFF; background-color:#AB0000;" name="list_table" readonly="readonly">
<?php
filesInDir($dir);
function filesInDir($tdir)
{
$dirs = scandir($tdir);
foreach($dirs as $file) {
if (($file == '.') || ($file == '..')) { }
elseif (is_dir($tdir.'/'.$file)) { filesInDir($tdir.'/'.$file); }
else { echo substr($file,0,strlen($file)-4)."\n"; } }
}
?>
</textarea>
</form>
</body>
</html>
this will list all files of the directory MyFolder minus the last 4 digits of the complete filename. of course if the file-extension would be .html it would still include the . (dot) in the filename; furthermore, this code displays the list in an easy to use copy and paste form field.
well, at least it's something, isn't it?
tom.paine
Monday, March 09, 2009
PHP: how to rename a bunch of files / Windows XP
last weekend i was looking for a solution to rename a bunch of .mp3 files that had underscores and small letters as filenames while i prefered spaces instead of the underscores and capital letters for the individual words of the filename.
fortunately PHP has some built in functions to replace one character with another as well as renaming files altogether. i assumed that someone had already done something like it, so i went looking for a code-snippet on the internet again.
i came across this link.
this person was struggling with the renaming of some image files. i started to try the examples and various explanations as given when i stumbled across the problem that Windows XP is a bit fuzzy about renaming files. just search this document for Permission Denied and you'll know what i mean.
here's one solution:
function rename_win($oldfile,$newfile) {
if (!rename($oldfile,$newfile)) {
if (copy ($oldfile,$newfile)) {
unlink($oldfile);
return TRUE;
}
return FALSE;
}
return TRUE;
}
but that one didn't work for me either. another problem i had was defining the directory that contained the files to be renamed. after a number of struggles i came up with this solution:
first i placed all the .mp3 files into one folder together with the following code-snippet i saved to a file that i named rename-a-file.php.
<?php
// source: http://forum.de.selfhtml.org/archiv/2004/11/t95097/
$handle = opendir ('.');
while ( $file = readdir ( $handle ) ) {
if ( $file == "." or $file == ".." ) {
} else {
if ( rename( $file, (ucwords(str_replace('_',' ',$file).$new)) ) ) {
echo "File $file found <br>";
} else {
echo "File $file not found <br>";
}
}
} closedir( $handle );
?>
running the script at first i didn't see the changes in the folder until i pressed the refresh button. now all the files had no more underscores and capital letters, even the rename-a-file.php which is now called Rename-a-file.php :-)
i keep the Rename-a-file.php file now in a separate folder named rename that i may not accidentally run the script and rename the files in the folder where i kept the copy originally, with all my other .php files.
here is another example, in this case i didn't need to replace any characters; i only needed to change the lowercase to uppercase characters:
<?php
// source: http://forum.de.selfhtml.org/archiv/2004/11/t95097/
$handle = opendir ('.');
while ( $file = readdir ( $handle ) ) {
if ( $file == "." or $file == ".." ) {
} else {
if ( rename( $file, (ucwords($file).$new) ) ) {
echo "File $file found <br>";
} else {
echo "File $file not found <br>";
}
}
} closedir( $handle );
?>
in these examples i have used the following PHP functions:
opendir
readdir
rename
ucwords
str_replace
closedir
Hopefully this may prove helpful to other users, too. Don't overdo it!
tom.paine
fortunately PHP has some built in functions to replace one character with another as well as renaming files altogether. i assumed that someone had already done something like it, so i went looking for a code-snippet on the internet again.
i came across this link.
this person was struggling with the renaming of some image files. i started to try the examples and various explanations as given when i stumbled across the problem that Windows XP is a bit fuzzy about renaming files. just search this document for Permission Denied and you'll know what i mean.
here's one solution:
function rename_win($oldfile,$newfile) {
if (!rename($oldfile,$newfile)) {
if (copy ($oldfile,$newfile)) {
unlink($oldfile);
return TRUE;
}
return FALSE;
}
return TRUE;
}
but that one didn't work for me either. another problem i had was defining the directory that contained the files to be renamed. after a number of struggles i came up with this solution:
first i placed all the .mp3 files into one folder together with the following code-snippet i saved to a file that i named rename-a-file.php.
<?php
// source: http://forum.de.selfhtml.org/archiv/2004/11/t95097/
$handle = opendir ('.');
while ( $file = readdir ( $handle ) ) {
if ( $file == "." or $file == ".." ) {
} else {
if ( rename( $file, (ucwords(str_replace('_',' ',$file).$new)) ) ) {
echo "File $file found <br>";
} else {
echo "File $file not found <br>";
}
}
} closedir( $handle );
?>
running the script at first i didn't see the changes in the folder until i pressed the refresh button. now all the files had no more underscores and capital letters, even the rename-a-file.php which is now called Rename-a-file.php :-)
i keep the Rename-a-file.php file now in a separate folder named rename that i may not accidentally run the script and rename the files in the folder where i kept the copy originally, with all my other .php files.
here is another example, in this case i didn't need to replace any characters; i only needed to change the lowercase to uppercase characters:
<?php
// source: http://forum.de.selfhtml.org/archiv/2004/11/t95097/
$handle = opendir ('.');
while ( $file = readdir ( $handle ) ) {
if ( $file == "." or $file == ".." ) {
} else {
if ( rename( $file, (ucwords($file).$new) ) ) {
echo "File $file found <br>";
} else {
echo "File $file not found <br>";
}
}
} closedir( $handle );
?>
in these examples i have used the following PHP functions:
opendir
readdir
rename
ucwords
str_replace
closedir
Hopefully this may prove helpful to other users, too. Don't overdo it!
tom.paine
A Strange Way To Search
in my previous article i mentioned a link i came across while searching for a solution to my CSV problem.
i merely entered php csv if in the form field of the Google Search Engine and grabbed the first link on the list.
here's my original search for php csv if.
Have Fun!
tom.paine
i merely entered php csv if in the form field of the Google Search Engine and grabbed the first link on the list.
here's my original search for php csv if.
Have Fun!
tom.paine
Saturday, February 21, 2009
PHP: how to make amendments to a CSV file
in my third article for today i want to write about a problem i had with a massive csv file the other night:
i got this big CSV file which contains over 3300 lines of entries. those entries include a date, but i can't use that date for sorting. first of all it's written among a string of other details; it's written as 20 February 2000 or February 20, 2000 or February 20 2000. that's 3 different ways. i decided that i needed another column in my CSV file where i'd store the date as a sortable value. i found that a leading id-number was followed by 3 whitespaces, and that those 3 whitespaces were otherwise not used in the document. so i decided to open my CSV file with WordPad and change the 3 whitespaces to 2 pipes thus: ||. inbetween those pipes i would store the date value i want to use for sorting. i spent about 2 nights entering the date by copying and pasting it right there when on the second night my screen got stuck again and i had to re-start my computer. i was just paging down the document when it happened; and i thought that i had just saved the document.
after re-starting my laptop i found out that the document had been in the process of saving when the screen got stuck. only a third of this document was still available to me. of course i had some kind of a backup copy, but that was the copy without the pipes. now i had to decide: do i start from scratch or am i going to look around for a script that could maybe do it with PHP which i wanted to do all the while anyway?.
i was a bit upset about all this since it was such a boring job to do and i knew i would be glad once i'd reached the end of the file.
alright, let me search the internet for some kind of a solution that may come close to what i want to achieve. now, what am i going to search for? how about php amend csv file?
in a german forum i found someone who tried to search for results in a CSV document: http://forum.de.selfhtml.org/archiv/2008/5/t171322/.
i started playing with that one. the person couldn't get his script to work.
here's my version of the script:
<pre style="font-family:'Courier New', Courier; font-size:11px; color:blue;">
<?php
define('SEARCH', '1961');
$s = (isset($_GET['s'])) ? $_GET['s'] : SEARCH;
$csv_file_open = fopen("worksheet.csv", "r");
$row = 1;
while ($data = fgetcsv ($csv_file_open, 1000, "|")) {
if (stristr ( $data[2], $s )) {
echo $data[0] . "|" . $s . "-";
echo $data[1] . "|";
echo $data[2] . "\n";
}
$row++;
}
fclose($csv_file_open);
?>
</pre>
this code snippet lets me search my document for the date 1961 (as a default value) and squeezes it between the id number and the other string devided by the pipe symbol, provided it finds the date value i've given. if i want another search result i could add ?s=1980, for instance, as a url parameter after the file name. the problem is, if i search for New York City, it would enter New York City, where found, between those 2 pipe symbols ... hm ... not exactly what i had in mind.
i gave the idea some more thought and came up with a solution that uses $y as a variable for the year, $m as a variable for the month and $d as a variable for the day. hm, that looks pretty good for starters.
as usual, i made a copy of my first example for keepsake and decided to work with a new php file i named csv-add-date.php.
i kept some of the old code, but for the moment i wouldn't need the $s variable.
here's my code in the csv-add-date.php file:
<pre style="font-family:'Courier New', Courier; font-size:11px; color:blue;">
<?php
define('SEARCH', '1961');
$s = (isset($_GET['s'])) ? $_GET['s'] : SEARCH;
$csv_file_open = fopen("clean_sheet.csv", "r");
$row = 1;
while ($data = fgetcsv ($csv_file_open, 1000, "|")) {
include ( 'csv-calculate-year.php' );
include ( 'csv-calculate-01-jan-day.php' );
include ( 'csv-calculate-02-feb-day.php' );
include ( 'csv-calculate-03-mar-day.php' );
include ( 'csv-calculate-04-apr-day.php' );
include ( 'csv-calculate-05-may-day.php' );
include ( 'csv-calculate-06-jun-day.php' );
include ( 'csv-calculate-07-jul-day.php' );
include ( 'csv-calculate-08-aug-day.php' );
include ( 'csv-calculate-09-sep-day.php' );
include ( 'csv-calculate-10-oct-day.php' );
include ( 'csv-calculate-11-nov-day.php' );
include ( 'csv-calculate-12-dec-day.php' );
echo $data[0] . "|" . $y . "-" . $m . "-" . $d;
echo $data[1] . "|";
echo $data[2] . "\n";
$row++;
}
fclose($csv_file_open);
?>
</pre>
i'm also using a new CSV file which i named clean_sheet.csv.
... and here is an excerpt from my csv-calculate-year.php:
<?php
if (stristr ( $data[2], '1958' )) { $y = '1958'; }
elseif (stristr ( $data[2], '1960' )) { $y = '1960'; }
elseif (stristr ( $data[2], '1961' )) { $y = '1961'; }
elseif (stristr ( $data[2], '1962' )) { $y = '1962'; }
elseif (stristr ( $data[2], '1963' )) { $y = '1963'; }
elseif (stristr ( $data[2], '1964' )) { $y = '1964'; }
elseif (stristr ( $data[2], '1965' )) { $y = '1965'; }
elseif (stristr ( $data[2], '1966' )) { $y = '1966'; }
elseif (stristr ( $data[2], '1967' )) { $y = '1967'; }
elseif (stristr ( $data[2], '1968' )) { $y = '1968'; }
elseif (stristr ( $data[2], '1969' )) { $y = '1969'; }
elseif (stristr ( $data[2], '1970' )) { $y = '1970'; }
...
?>
another example from one of the files that calculate the month and day:
<?php
if ( (stristr ( $data[2], ' 1 January ' )) || (stristr ( $data[2], ' January 1 ' )) || (stristr ( $data[2], ' January 1,' )) ) { $m = '01'; $d = '01'; }
elseif ( (stristr ( $data[2], ' 2 January ' )) || (stristr ( $data[2], ' January 2 ' )) || (stristr ( $data[2], ' January 2,' )) ) { $m = '01'; $d = '02'; }
elseif ( (stristr ( $data[2], ' 3 January ' )) || (stristr ( $data[2], ' January 3 ' )) || (stristr ( $data[2], ' January 3,' )) ) { $m = '01'; $d = '03'; }
elseif ( (stristr ( $data[2], ' 4 January ' )) || (stristr ( $data[2], ' January 4 ' )) || (stristr ( $data[2], ' January 4,' )) ) { $m = '01'; $d = '04'; }
elseif ( (stristr ( $data[2], ' 5 January ' )) || (stristr ( $data[2], ' January 5 ' )) || (stristr ( $data[2], ' January 5,' )) ) { $m = '01'; $d = '05'; }
elseif ( (stristr ( $data[2], ' 6 January ' )) || (stristr ( $data[2], ' January 6 ' )) || (stristr ( $data[2], ' January 6,' )) ) { $m = '01'; $d = '06'; }
elseif ( (stristr ( $data[2], ' 7 January ' )) || (stristr ( $data[2], ' January 7 ' )) || (stristr ( $data[2], ' January 7,' )) ) { $m = '01'; $d = '07'; }
elseif ( (stristr ( $data[2], ' 8 January ' )) || (stristr ( $data[2], ' January 8 ' )) || (stristr ( $data[2], ' January 8,' )) ) { $m = '01'; $d = '08'; }
elseif ( (stristr ( $data[2], ' 9 January ' )) || (stristr ( $data[2], ' January 9 ' )) || (stristr ( $data[2], ' January 9,' )) ) { $m = '01'; $d = '09'; }
elseif ( (stristr ( $data[2], ' 10 January ' )) || (stristr ( $data[2], ' January 10 ' )) || (stristr ( $data[2], ' January 10,' )) ) { $m = '01'; $d = '10'; }
...
?>
that last code is included in 12 files one for each month. in each one i had to replace the name of the month, say January with March for instance; and $m = '01 ought to be replaced with $m = '02 in the case of February.
those year and month/day files are included in the csv-add-date.php file using PHP's include function.
this csv-add-date.php file basically loads the clean_sheet.csv file and adds the year, month and day before it displays the content on the screen. it does not write the content to the clean_sheet.csv file. i think i'm going to get that done in another step to another new CSV file ... in case something should go wrong again.
now i can save myself a lot of time ... and boredom ... and repeat the process if necessary. this exercise has also taught me how to search through CSV files and display the results. that may be the topic of another article ...
i hope that this has been of some help to PHP coders.
Good Luck!
tom.paine
i got this big CSV file which contains over 3300 lines of entries. those entries include a date, but i can't use that date for sorting. first of all it's written among a string of other details; it's written as 20 February 2000 or February 20, 2000 or February 20 2000. that's 3 different ways. i decided that i needed another column in my CSV file where i'd store the date as a sortable value. i found that a leading id-number was followed by 3 whitespaces, and that those 3 whitespaces were otherwise not used in the document. so i decided to open my CSV file with WordPad and change the 3 whitespaces to 2 pipes thus: ||. inbetween those pipes i would store the date value i want to use for sorting. i spent about 2 nights entering the date by copying and pasting it right there when on the second night my screen got stuck again and i had to re-start my computer. i was just paging down the document when it happened; and i thought that i had just saved the document.
after re-starting my laptop i found out that the document had been in the process of saving when the screen got stuck. only a third of this document was still available to me. of course i had some kind of a backup copy, but that was the copy without the pipes. now i had to decide: do i start from scratch or am i going to look around for a script that could maybe do it with PHP which i wanted to do all the while anyway?.
i was a bit upset about all this since it was such a boring job to do and i knew i would be glad once i'd reached the end of the file.
alright, let me search the internet for some kind of a solution that may come close to what i want to achieve. now, what am i going to search for? how about php amend csv file?
in a german forum i found someone who tried to search for results in a CSV document: http://forum.de.selfhtml.org/archiv/2008/5/t171322/.
i started playing with that one. the person couldn't get his script to work.
here's my version of the script:
<pre style="font-family:'Courier New', Courier; font-size:11px; color:blue;">
<?php
define('SEARCH', '1961');
$s = (isset($_GET['s'])) ? $_GET['s'] : SEARCH;
$csv_file_open = fopen("worksheet.csv", "r");
$row = 1;
while ($data = fgetcsv ($csv_file_open, 1000, "|")) {
if (stristr ( $data[2], $s )) {
echo $data[0] . "|" . $s . "-";
echo $data[1] . "|";
echo $data[2] . "\n";
}
$row++;
}
fclose($csv_file_open);
?>
</pre>
this code snippet lets me search my document for the date 1961 (as a default value) and squeezes it between the id number and the other string devided by the pipe symbol, provided it finds the date value i've given. if i want another search result i could add ?s=1980, for instance, as a url parameter after the file name. the problem is, if i search for New York City, it would enter New York City, where found, between those 2 pipe symbols ... hm ... not exactly what i had in mind.
i gave the idea some more thought and came up with a solution that uses $y as a variable for the year, $m as a variable for the month and $d as a variable for the day. hm, that looks pretty good for starters.
as usual, i made a copy of my first example for keepsake and decided to work with a new php file i named csv-add-date.php.
i kept some of the old code, but for the moment i wouldn't need the $s variable.
here's my code in the csv-add-date.php file:
<pre style="font-family:'Courier New', Courier; font-size:11px; color:blue;">
<?php
define('SEARCH', '1961');
$s = (isset($_GET['s'])) ? $_GET['s'] : SEARCH;
$csv_file_open = fopen("clean_sheet.csv", "r");
$row = 1;
while ($data = fgetcsv ($csv_file_open, 1000, "|")) {
include ( 'csv-calculate-year.php' );
include ( 'csv-calculate-01-jan-day.php' );
include ( 'csv-calculate-02-feb-day.php' );
include ( 'csv-calculate-03-mar-day.php' );
include ( 'csv-calculate-04-apr-day.php' );
include ( 'csv-calculate-05-may-day.php' );
include ( 'csv-calculate-06-jun-day.php' );
include ( 'csv-calculate-07-jul-day.php' );
include ( 'csv-calculate-08-aug-day.php' );
include ( 'csv-calculate-09-sep-day.php' );
include ( 'csv-calculate-10-oct-day.php' );
include ( 'csv-calculate-11-nov-day.php' );
include ( 'csv-calculate-12-dec-day.php' );
echo $data[0] . "|" . $y . "-" . $m . "-" . $d;
echo $data[1] . "|";
echo $data[2] . "\n";
$row++;
}
fclose($csv_file_open);
?>
</pre>
i'm also using a new CSV file which i named clean_sheet.csv.
... and here is an excerpt from my csv-calculate-year.php:
<?php
if (stristr ( $data[2], '1958' )) { $y = '1958'; }
elseif (stristr ( $data[2], '1960' )) { $y = '1960'; }
elseif (stristr ( $data[2], '1961' )) { $y = '1961'; }
elseif (stristr ( $data[2], '1962' )) { $y = '1962'; }
elseif (stristr ( $data[2], '1963' )) { $y = '1963'; }
elseif (stristr ( $data[2], '1964' )) { $y = '1964'; }
elseif (stristr ( $data[2], '1965' )) { $y = '1965'; }
elseif (stristr ( $data[2], '1966' )) { $y = '1966'; }
elseif (stristr ( $data[2], '1967' )) { $y = '1967'; }
elseif (stristr ( $data[2], '1968' )) { $y = '1968'; }
elseif (stristr ( $data[2], '1969' )) { $y = '1969'; }
elseif (stristr ( $data[2], '1970' )) { $y = '1970'; }
...
?>
another example from one of the files that calculate the month and day:
<?php
if ( (stristr ( $data[2], ' 1 January ' )) || (stristr ( $data[2], ' January 1 ' )) || (stristr ( $data[2], ' January 1,' )) ) { $m = '01'; $d = '01'; }
elseif ( (stristr ( $data[2], ' 2 January ' )) || (stristr ( $data[2], ' January 2 ' )) || (stristr ( $data[2], ' January 2,' )) ) { $m = '01'; $d = '02'; }
elseif ( (stristr ( $data[2], ' 3 January ' )) || (stristr ( $data[2], ' January 3 ' )) || (stristr ( $data[2], ' January 3,' )) ) { $m = '01'; $d = '03'; }
elseif ( (stristr ( $data[2], ' 4 January ' )) || (stristr ( $data[2], ' January 4 ' )) || (stristr ( $data[2], ' January 4,' )) ) { $m = '01'; $d = '04'; }
elseif ( (stristr ( $data[2], ' 5 January ' )) || (stristr ( $data[2], ' January 5 ' )) || (stristr ( $data[2], ' January 5,' )) ) { $m = '01'; $d = '05'; }
elseif ( (stristr ( $data[2], ' 6 January ' )) || (stristr ( $data[2], ' January 6 ' )) || (stristr ( $data[2], ' January 6,' )) ) { $m = '01'; $d = '06'; }
elseif ( (stristr ( $data[2], ' 7 January ' )) || (stristr ( $data[2], ' January 7 ' )) || (stristr ( $data[2], ' January 7,' )) ) { $m = '01'; $d = '07'; }
elseif ( (stristr ( $data[2], ' 8 January ' )) || (stristr ( $data[2], ' January 8 ' )) || (stristr ( $data[2], ' January 8,' )) ) { $m = '01'; $d = '08'; }
elseif ( (stristr ( $data[2], ' 9 January ' )) || (stristr ( $data[2], ' January 9 ' )) || (stristr ( $data[2], ' January 9,' )) ) { $m = '01'; $d = '09'; }
elseif ( (stristr ( $data[2], ' 10 January ' )) || (stristr ( $data[2], ' January 10 ' )) || (stristr ( $data[2], ' January 10,' )) ) { $m = '01'; $d = '10'; }
...
?>
that last code is included in 12 files one for each month. in each one i had to replace the name of the month, say January with March for instance; and $m = '01 ought to be replaced with $m = '02 in the case of February.
those year and month/day files are included in the csv-add-date.php file using PHP's include function.
this csv-add-date.php file basically loads the clean_sheet.csv file and adds the year, month and day before it displays the content on the screen. it does not write the content to the clean_sheet.csv file. i think i'm going to get that done in another step to another new CSV file ... in case something should go wrong again.
now i can save myself a lot of time ... and boredom ... and repeat the process if necessary. this exercise has also taught me how to search through CSV files and display the results. that may be the topic of another article ...
i hope that this has been of some help to PHP coders.
Good Luck!
tom.paine
PHP: how to delete the last line of a file?
i'm a little friend of MySQL, but a big friend of writing content to files, text files or csv (comma-separated-value) files. one reason is that i haven't really worked that much with MySQL. i just know the basics and have usually worked with them when setting up a forum or webshop. those scripts are readily available all across the internet.
i was going to set up a table using either XML or PHP's array function with a script that would write either the XML file, or a PHP fie that i could include in another script which in turn could be used to create an XML file or simply HTML.
i looked at various examples and tutorials on the internet on how to manipulate XML files with PHP, but i wasn't too happy about where the new elements would be placed in the XML document eventually.
of course one of the problems would always be: how would i squeeze a new set of elements before the closing root element; or how would i get rid of the ?> at the end of the php file i wish to include somewhere else.
the basic idea i found here: http://bytes.com/groups/php/11847-how-delete-last-line-file.
below is the code snippet from that page that got me going:
$inp = file('yourfile.name');
$out = fopen('yourfile.name','w');
for ($i=0;$i<count($inp)-1;$i++)
fwrite($out,$inp[$i]);
fclose($out);
in this particular case the information of one file is written to another file. (not 100% what i was looking for).
in the end i started using this example:
$my_input = '$my_'.$_GET['my_number'].' = array ( $my_date => \''.$_GET['my_date'].'\', $my_city => \''.$_GET['my_city'].'\', $my_links => \''.$_GET['my_links'].'\', \'$my_update => \''.$_GET['my_update'].'\', );'."\n";
// load the data and delete the line from the array
$lines = file('#_MyIncludeFile.inc.php');
$last = sizeof($lines)-1;
unset($lines[$last]);
// write the new data to the file
$input = fopen('#_MyIncludeFile.inc.php','w');
fwrite($input, implode('', $lines));
fwrite($input, $my_input);
fwrite($input, "?>");
fclose($input);
the $_GET variables are submitted from a form:
<form method="GET" action="WriteToFile.php">
<table>
<tr><td>my my number:</td><td><input type="text" name="my_number" /></td></tr>
<tr><td>my my date:</td><td><input type="text" name="my_date" /></td></tr>
<tr><td>my my city:</td><td><input type="text" name="my_city" /></td></tr>
<tr><td>my my links:</td><td><input type="text" name="my_links" /></td></tr>
<tr><td><input type="hidden" name="my_update" value="<?=time();?>" /><br />
<br /><input type="submit" value="send" /></td></tr>
</table>
</form>
the WriteToFile.php file also contains this form for further input.
this script writes CSV data to a PHP file which can then be used elsewhere for further analyzes.
i think that says it all ... or are there any questions?
Good Luck again!
tom.paine
i was going to set up a table using either XML or PHP's array function with a script that would write either the XML file, or a PHP fie that i could include in another script which in turn could be used to create an XML file or simply HTML.
i looked at various examples and tutorials on the internet on how to manipulate XML files with PHP, but i wasn't too happy about where the new elements would be placed in the XML document eventually.
of course one of the problems would always be: how would i squeeze a new set of elements before the closing root element; or how would i get rid of the ?> at the end of the php file i wish to include somewhere else.
the basic idea i found here: http://bytes.com/groups/php/11847-how-delete-last-line-file.
below is the code snippet from that page that got me going:
$inp = file('yourfile.name');
$out = fopen('yourfile.name','w');
for ($i=0;$i<count($inp)-1;$i++)
fwrite($out,$inp[$i]);
fclose($out);
in this particular case the information of one file is written to another file. (not 100% what i was looking for).
in the end i started using this example:
$my_input = '$my_'.$_GET['my_number'].' = array ( $my_date => \''.$_GET['my_date'].'\', $my_city => \''.$_GET['my_city'].'\', $my_links => \''.$_GET['my_links'].'\', \'$my_update => \''.$_GET['my_update'].'\', );'."\n";
// load the data and delete the line from the array
$lines = file('#_MyIncludeFile.inc.php');
$last = sizeof($lines)-1;
unset($lines[$last]);
// write the new data to the file
$input = fopen('#_MyIncludeFile.inc.php','w');
fwrite($input, implode('', $lines));
fwrite($input, $my_input);
fwrite($input, "?>");
fclose($input);
the $_GET variables are submitted from a form:
<form method="GET" action="WriteToFile.php">
<table>
<tr><td>my my number:</td><td><input type="text" name="my_number" /></td></tr>
<tr><td>my my date:</td><td><input type="text" name="my_date" /></td></tr>
<tr><td>my my city:</td><td><input type="text" name="my_city" /></td></tr>
<tr><td>my my links:</td><td><input type="text" name="my_links" /></td></tr>
<tr><td><input type="hidden" name="my_update" value="<?=time();?>" /><br />
<br /><input type="submit" value="send" /></td></tr>
</table>
</form>
the WriteToFile.php file also contains this form for further input.
this script writes CSV data to a PHP file which can then be used elsewhere for further analyzes.
i think that says it all ... or are there any questions?
Good Luck again!
tom.paine
"Class 'XSLTProcessor' not found"
the other day i was trying an example from an xsl tutorial and couldn't get it to work, instead i got the error message "Class 'XSLTProcessor' not found".
here is how i solved it:
first i thought my php versions were not up to date. i'm running php4 and php5 with Apache 1.3 under OS Windows XP. i downloaded the Windows Binaries ZIP folders, unpacked them and placed the contents into my c:\php4 and c:\php5 directories respectively and re-started Apache. trying the example again i still got the same error message.
i thought that maybe something wasn't right in the php.ini files. therefore i made a copy of the php.ini-recommended and renamed it php.ini. i opened the php.ini file with WordPad and searched the document for xsl. the search went to the line that reads ;extension=php_xsl.dll. i uncommented that line by removing the semi-colon. now the line reads: extension=php_xsl.dll. After re-starting the server again i tried the script example once more and still got the same error message: "Class 'XSLTProcessor' not found".
alright ... i was wondering which php.ini file php was looking at and saved the following code snippet in a file named test.php:
<?php
phpinfo();
?>
after i ran this test.php file php displayed the current settings and i found that it was not looking for the php.ini file in the c:\php4 or c:\php5 directories at all, but in the c:\WINDOWS directory.
okay ... i looked for that php.ini file in the c:\WINDOWS directory, opend the file, searched for xsl again and made the change as described above.
after re-starting the server and running the script example again, believe it or not, it still gave me that error message. things like that can become quite frustrating, especially if one tests a script in the localhost environment where it won't and at the webhosting server, where it may work.
i'm not giving up so easily. i knew that the xsl extension under windows is a .dll file that can be found in the ext dirctory. and i also knew that this was a feature only introduced with php5. i checked to see if the php_xsl.dll file existed in the ext folder, which it did; then i went back to the php documentation to see how i would have to set up php under windows and came across this comment: http://de2.php.net/manual/de/book.xsl.php#65277.
alright, so i had to change the path to this ext directory.
i had the php.ini file still open (WordPad) and searched for extension_dir. the line read:
extension_dir = "./"
which i changed to read:
extension_dir = "./ext"
re-starting the Apache Server one more time and running the example script once more at last i saw the expected result on the screen and could go to rest happily after all.
so before someone else has to battle with this issue:
first: check to see if the php_xsl.dll file exists;
second: check to see which php.ini file you gotta change;
third: uncomment ;extension=php_xsl.dll and change the extension directory to extension_dir = "./ext" in the relevant php.ini file.
... and don't forget to re-start the Apache Server!
Good Luck!
tom.paine
here is how i solved it:
first i thought my php versions were not up to date. i'm running php4 and php5 with Apache 1.3 under OS Windows XP. i downloaded the Windows Binaries ZIP folders, unpacked them and placed the contents into my c:\php4 and c:\php5 directories respectively and re-started Apache. trying the example again i still got the same error message.
i thought that maybe something wasn't right in the php.ini files. therefore i made a copy of the php.ini-recommended and renamed it php.ini. i opened the php.ini file with WordPad and searched the document for xsl. the search went to the line that reads ;extension=php_xsl.dll. i uncommented that line by removing the semi-colon. now the line reads: extension=php_xsl.dll. After re-starting the server again i tried the script example once more and still got the same error message: "Class 'XSLTProcessor' not found".
alright ... i was wondering which php.ini file php was looking at and saved the following code snippet in a file named test.php:
<?php
phpinfo();
?>
after i ran this test.php file php displayed the current settings and i found that it was not looking for the php.ini file in the c:\php4 or c:\php5 directories at all, but in the c:\WINDOWS directory.
okay ... i looked for that php.ini file in the c:\WINDOWS directory, opend the file, searched for xsl again and made the change as described above.
after re-starting the server and running the script example again, believe it or not, it still gave me that error message. things like that can become quite frustrating, especially if one tests a script in the localhost environment where it won't and at the webhosting server, where it may work.
i'm not giving up so easily. i knew that the xsl extension under windows is a .dll file that can be found in the ext dirctory. and i also knew that this was a feature only introduced with php5. i checked to see if the php_xsl.dll file existed in the ext folder, which it did; then i went back to the php documentation to see how i would have to set up php under windows and came across this comment: http://de2.php.net/manual/de/book.xsl.php#65277.
alright, so i had to change the path to this ext directory.
i had the php.ini file still open (WordPad) and searched for extension_dir. the line read:
extension_dir = "./"
which i changed to read:
extension_dir = "./ext"
re-starting the Apache Server one more time and running the example script once more at last i saw the expected result on the screen and could go to rest happily after all.
so before someone else has to battle with this issue:
first: check to see if the php_xsl.dll file exists;
second: check to see which php.ini file you gotta change;
third: uncomment ;extension=php_xsl.dll and change the extension directory to extension_dir = "./ext" in the relevant php.ini file.
... and don't forget to re-start the Apache Server!
Good Luck!
tom.paine
Subscribe to:
Posts (Atom)
