Posted by Rik on 12/12/06 01:52

applegreenss@gmail.com wrote:
> Is it possible to take the contents of a MySQL DB Table, and somehow
> put the data into a syntax-correct data file format like a delimited
> .txt file, and using PHP parse it as a local c:\ file assuming it was
> sitting in C:\data.txt ..... so I want to read its contents in a
> similar method as you would query a DB table .... can you do this the
> same with a blob of data stored in a .TXT file?
>
> If so, how to format .txt & php code -- I would very much like to
> emulate this scenario against a c:\ stored .txt file:
>
> <?
> $sql_query = "SELECT * FROM localfile WHERE value = '$somevalue'";
> $result = @mysql_query($sql_query,$db);
>
> // now put all the data into arrays
> $a = 0;
> while ($row = mysql_fetch_row($result)) {
>
> $somearray1[$a] = $row[0];
> $somearray2[$a] = $row[1];
>
> $a++;
> }


Not really an answer to your question, but maybe an answer to your actual
problem/reason for wanting this:
SQLite uses only files, hardly any administration needed, check it out:
http://www.php.net/manual/en/ref.sqlite.php
http://sqlite.org/

Offcourse it's totally possible to dump a mysql database in sqlite, with
most of the major normal sql functionality intact.
--
Rik Wasmus

[Back to original message]