! Help Writing to File !

phence

I am tring to take data from a mysql database and write the data to an html file
Is there a reason why changes are not being made to the news.html file??

	// Pull news_html from mysql database
	$result = mysql_query("SELECT content FROM news WHERE keyId = 1");

// if there is data in the mysql database, Pull it out!
if($row = mysql_fetch_array($result))
{
	$news_html = $row["content"];

	// write changes to file
	$filename = 'http://www.rostraverleo.org/news.html';
	$handle = fopen($filename, 'w');
	fwrite($handle, $news_html);
	fclose($handle);
}	
else
{
	echo "No data was pulled from the database! Cannot write file!";
}

the rest of the script executes but the changes are never made to the HTML document. PLEASE HELP!

ALL help Is greatly appreciated!! Thanks!

eoghain

Well your select statement looks to be pulling in only 1 row. The row with KeyID = 1.

phence

that is where the data is located, all the data is in that one row.

eoghain

The I'd check the permissions on the file you are trying to write. If the Web Server user doesn't have permission to wirte that file then you'd never get an update.

diego25

You can only write to files on your host machine. You cannot write to files on another server. Right now, your $filename is pointing to a file on another server (because it starts with [url]http://[/url]).

Diego

phence

THANKS!!

drag0n

i didnt know you were able to write to a html file, i guess im too much of a newbie, so your able to use a php script and get data from a db and generate a html out of it? thats cool! for example, the news.html file u have, what do you have to put in it, or do you just leave it blank and generate tables with php also? Thanks in advanced for any kind of help you could offer.

phence

well in my case, i needed to get the HTML source so that i could edit the data later.

	// get contents of news html file into a string
	$filename = "/home/username/www/news.html";
	$handle = fopen($filename, "r");
	$news_html = fread($handle, filesize($filename));
	fclose ($handle);

// Prepare $news_html variable for mysql enty
$news_html = addslashes($news_html);

then you just build a query string and enter the $news_html into the Mysql database.

After the Data is entered into the database, you now have the HTML source data, ready to edit!

After You edit the data and save it back to the Mysql database you have to Pull it back out and Save it to the Actual HTML File

	// Pull news_html from mysql database
	$result = mysql_query("SELECT content FROM news WHERE keyId = 1");

// if there is data in the mysql database, Pull it out!
if($row = mysql_fetch_array($result))
{
	$news_html = $row["content"];

	// write changes to file
	$filename = '/home/username/www/news.html';
	$handle = fopen($filename, 'w');
	fwrite($handle, $news_html);
	fclose($handle);
}	
else
{
	echo "No data was pulled from the database! Cannot write file!";
}

Now You Just Wrote all the data from the database to the "news.html" file.

MAKE SURE YOU CHANGE THE PERMISSIONS OF THE 'news.html' TO 777

Or else you won't be able to write to the file!!

Hope that was helpful!

[EDIT]
for more information, check out php.net. lookup the fopen, fread, fwrite, and fclose functions [/EDIT]

drag0n

thanks for taking the time to respond!

zzzreyes

I was trying to do a very similar thing, but for some reason it only works from my PC. I am sure that I checked the cache on the clients machine before... but will re check tomorrow.

http://www.phpbuilder.com/board/showthread.php?threadid=10229148