need to open a txt file

[itworks]

i have a database query that is supposed to show the results on the table and it does except the last one.

here's the part of the script i have for retrieving the results:

function ARImovel() {
				global $NOME_BD, $NOME_SERVIDOR;
                $this->bd = new BDMySQL();
                $this->bd->ligarBD($NOME_BD, "", "", $NOME_SERVIDOR);
        }

    function detalhesImovel($cod) {
        $sql = "SELECT * FROM imoveis WHERE cod=\"$cod\"";
        $rs=$this->bd->executarSQL($sql);

		mysql_fetch_row($rs);

		echo "<font size=+2><b>".mysql_result($rs, 0, "cod")."</b></font><br><br>";
		echo "<img src=\"imagens/".mysql_result($rs, 0, "fotografia")."\"><br>";
		echo "<b>Tipologia: </b>".mysql_result($rs, 0, "tipologia")."</b><br>";
		echo "<b>Zona: </b>".mysql_result($rs, 0, "zona")."</b><br>";
		echo "<b>Área: </b>".mysql_result($rs, 0, "area")."</b><br>";
		/* here i want to open a text file which the filename is stored in the descricao column in the table*/

how read a text file stored in the root folder knowing that the filename is stored in the database table.

thanks in advance.

[diego25]

$filename = mysql_result(...); // I recommend you use mysql_fetch_row, or the other fetch functions.

$fp = fopen($filename, 'r');

Diego

[itworks]

if you notice the script you'll see that i am usinf mysql_fetch_row.

yes i know how to do that but my problem is that i can't implement it into the script i have, just can't get the syntax right.

any help with this? please.

[feldon23]

First, echo the result of the database field. Make sure it's the complete filename.

Then, realise that fopen will only work if your php script is in the same directory as the text file you are trying to open unless you specify a path or relative path (../, etc.).

Can you tell us what error you are getting? If you are opening the text file to WRITE to, then it would be

$fp = fopen($filename, '+w');

in which case you must have write access (chmod) to the name of the file stored in $filename. In most cases, this means giving public write access to this file. It's been recommended on here that for security purposes, text files, etc. should be outside your \www directory.

[itworks]

i'm not really getting an error, either i get nothing or the files name which is what's in the database.

i'm not opening it for writing just for reading, it's a description of a product, and it's too long to be writing in command mode in Mysql, that's why i decided to put it in a text file and then point it's direction from the database.

[feldon23]

To quote advice from another thread (in response to my similar questions about using files vs mysql), put EVERYTHING in MySQL. Flat files are slower and you can have htaccess/permissions stuff to deal with. If someone guessed the filename that you are pulling the description from, they could read it even if this is supposed to be a "secure" area.

If the description is a lot to type, make a quick and dirty PHP page with a form to enter stuff into the MySQL dbase.

Just put input fields for which table, which column, etc. and then a big textarea for you to type the product description.