basic content management system

[lindajames]

does anyone know of any basic php based content management system that uses text files to store data and works on windows IIS servers?

I need something very basic that will let me easily edit my content rather than having to edit html files manually.

I've tried hotscripts.com and could seem to find anything.

Any suggestions would be appreciated.

Cheers
Linda

[jatar_k]

did you look through the whole category? They must have something that fits the bill, there are 278 in there.

www.hotscripts.com/PHP/Scripts_and_Programs/Content_Management/

Was there a particular functionality that those were lacking?

[lindajames]

i couldnt find any that either works on Windows or if it did then it runs of MySQL but i want it to use text files

[vincevincevince]

you can run MySQL with IIS

search for linux in msn (http://search.msn.com/results.asp?RS=CHECKED&FORM=MSNH&v=1&q=linux) and try the 3rd result for instructions on MySQL installaton for IIS

[lindajames]

My host does have mySQL but i dont want to utilize that as they charge extra for that, i would rather use text file databases

[jatar_k]

I did a few searches and couldn't find any free ones.

I did a search for
php based cms for windows flatfile

there were some options but I didn't look too deeply

another possibilty
php.resourceindex.com

[cayleyv]

I have used this program on several sites and it works great. If you dont speak german use an online translator to understand the documentation.

[sourceforge.net...]

The best part is it creates search engine friendly URL's

[bilalak]

I suggest having a look at
[phpnuke.org...]
[postnuke.com...]
[e-xoops.com...]

They are all based on mySQL but it is easy to install it on Windows system and PHP can be added as a ISAPI to IIS

Luck

[vincevincevince]

it would be a crude approach but you could write basic equivalents of those mySQL statements it needs to use text files: eg for the INSERT use something like...

{totally untested code for illustrating concept only - but it was fun to write!}

<?php
function my_file_query($sql)
{
$s=explode(" ",$sql);
switch $s[0]
{
case "INSERT" :
{
if ($s[1]!="INTO") return "INSERT must be followed by INTO";
$file=str_replace("`","",$s[3]).".txt";
if (!($handle=fopen($file),"a") return "INVALID 'table' $s[3]";
$a=2;
while($s[$a]!="VALUES") $fields.=$s[$a++];
$a++;
while(($b+$a)!=(sizeof($s)+1)) $values.=$s[$b++];
$fields=explode(",",str_replace("`","",$fields));
$values=explode(",",str_replace("'","",$fields));
$a=0;
fwrite($handle,"¦¦¦");
while($a<sizeof($fields)) $writerecord.="¦$fields[$a]=$values[$a]";
fwrite($handle,$writerecord."¦¦¦");
fclose($handle);
}
break;
//add more select clauses
}
}
?>

SELECT:

<?php
//into the my_file_query
case "SELECT" :
{
global $myremaining;
global $myqueries;
$a=1;
while($s[$a]!="FROM") $fields.=$s[$a++];
$a++;
$file=str_replace("`","",$s[$a]).".txt";
if (!($handle=fopen($file),"a") return "INVALID 'table' $s[$a]";
$resourceid=sizeof(myqueries);
$myremaining[$resourceid]=fread($file,sizeof($file));
$myqueries[$resourceid]=implode(" ",$s);
return $resourceid;
break;
}
 
//for eg a my_file_fetch_row
function my_file_fetch_row($resourceid)
{
global $myqueries;
global $myremaining;
preg_match("/^"./*parse the query string ($myqueries[$resourceid]) for the WHERE clause*/."$/",$myremaining[$resourceid],$match);
//parse $match[0] for the field=result¦ from the fields list
$myremaining[$resourceid]=substr($myremaining[$resourceid],strlen($match[0]));
return /*the results from the parsing for field names*/
}
?>

[cayleyv]

i forgot to mention, the main question was a CMS that uses flat files. this one does, including caching, search, and web based editing.

[edited by: jatar_k at 9:35 pm (utc) on July 10, 2003]
[edit reason] see link in msg 7 [/edit]

[choster]

I think Bloxsom (www.raelity.org/apps/blosxom/ ) uses flat files and Perl, though it is definitely geared to the blog world.