is this possible

[TiMeZeRo]

is it possible without using mysql

to have 2 text files laid out like for example

28/08/09
band1
29/08/09
band2

and a php file read from it and put them on a page as

for example

Wed 8th August - band 1 <-- i know date aint right just example

if that is possible how much harder is it to get when the php file loads it take off any dates taht have passed and move them onto the bottom of text file 2 setup exactly the same way for achive purposes

im not sure this is even possible but if u guys can give me a nudge in the right direction it would help

because of lack of mysql database i figure this is guna be alot harder than if i had one

[Dogers]

It's possible, but if you're going to have any number of visitors beyond a handful, you'll probably run into problems.

You need to parse the folder (http://codingforums.com/showthread.php?t=71882), opening each text file & read it in. You can (probably, I've never tried from the format you have) format the date with:

date_format(date_create($yourdatestring), "D jS F"); 

[TiMeZeRo]

this is what ive come up with so far but it seems to be trying to convert to date on both buffer and buffer2 how can i make it not try and convert for both lines of th text file

<?php
$fh = @fopen('data/1.txt', 'r');
if ($fh) {
while (!feof($fh)) { //loop for pointer to go to each line
$buffer = fgets($fh);//reading date line
$date1 = date_format(date_create($buffer), "D jS F"); // converting date to text
$buffer2 = fgets($fh);//reading event line
echo $date1," - ", $buffer2, "<br>"; //displaying line
$buffer1.=$buffer; //storing whole text of file in $buffer1 for any future use
}
fclose($fh);
}
?>

basically buffer2 var is plain text of who is playing that day e.g. not a date at all hence it throwing up errors but im not sure how to get round this

[cmd]

This seems to do everything you asked for, but I didn't test it very thoroughly:

<?php

$data1 = 'data/1.txt';
$data2 = 'data/2.txt';

$fh = fopen($data1,'r');

$writeData1 = "";
$writeData2 = "";

if ($fh) {
    while (!feof($fh)) {
        $currentDate = fgets($fh);
        $currentBand = fgets($fh);

        list($day, $month, $year) = explode('/', $currentDate);
        $currentDateToPHPTime = mktime(0, 0, 0, $month, $day, $year);
        
        if ($currentDateToPHPTime >= mktime(0, 0, 0, date('m'), date('d'), date('y'))) {
            $writeData1 .= $currentDate . $currentBand;
            echo date("D jS F", $currentDateToPHPTime) . ' - ' . $currentBand . '<br />';
        } else {
            $writeData2 .= $currentDate . $currentBand;
        }
    }
}
fclose($fh);

//echo '<br /><br />$data1: ' . $writeData1 . '<br />$data2: '. $writeData2; 

file_put_contents($data1, $writeData1);
file_put_contents($data2, $writeData2, FILE_APPEND);

?>

[Steve]

Are you limited because your host isn't providing mysql servers? Is SQLite support possible?

[cmd]

SQLite would be much nicer.

I just noticed that code I posted rewrites both text files every page load even if nothing has changed, which is inefficient.

[TheAnimus]

indeed, if your writing your own data persistence layer for something so pedestrian your doing it wrong.

[scaryjim]

Can't agree anywhere near enough that you need a database of some description for this, but if that *absolutely* isn't an option, you'd be better off using a delimited file format, reading one line at a time, then splitting that line around the delimiter (I assume PHP has a split function). So your file would look like:

28/08/09#Band 1
29/08/09#Band 2
01/09/09#Wayward Smile

and your script would read a line, split it around '#'. This should return a 2 element array with the date in the first element and the band name in the second, which you can use in your page.

You can do this using dbm and hashes in Perl (dbm is a pre-written module that handles retrieving and writing flat-file databases), but I'm afraid I've not played with php enough to know if it has something similar...