PHP: Writing To A Text File

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Hi,

I have some code below, that when I include in one of my pages, it messes the rest of the PHP up, and gives some odd results. Which breaks my news system.

What I wanted to know, is, is there a way that I can get this code to execute, and write the output to a text file, and then include it that way, so it eliminates this problem?

Thanks

Code:

<center>
<img src="news.png" border="0"></A>
</center>

<?
$tempdir="admin/";
require("admin/connect.php");
$date=date("Y-m-d");
$time=date("H:i:s");
$pathimages=substr($pathimages,3,999);
$articlenumber=10; // Set to number of articles you need to display
@$outcome=mysql_query("SELECT * FROM articles WHERE adate<='$date' ORDER BY adate DESC, atime DESC LIMIT $articlenumber");
if ($sectionID) @$outcome=mysql_query("SELECT * FROM articles WHERE sectionID='$sectionID' AND adate<='$date' ORDER BY adate DESC, atime DESC LIMIT $articlenumber");
require("admin/failure.php");
while ($access=mysql_fetch_array($outcome))
{
$articleID=$access["ID"];
$title=$access["title"];
$beginning=$access["beginning"];
$authorID=$access["authorID"];
$year=strval(substr($access["adate"],0,4));
$month=strval(substr($access["adate"],5,2));
$day=strval(substr($access["adate"],8,2));
$adate="$day.$month.$year";
$atime=strval(substr($access["atime"],0,5));
$imagesetID=$access["imagesetID"];
$outcome2=$outcome;
@$outcome=mysql_query("SELECT fullname FROM users WHERE ID='$authorID'");
require("admin/failure.php");
$access=mysql_fetch_array($outcome);
$author=$access["fullname"];
unset($file1); unset($thumb1);
if ($imagesetID)
{
@$outcome=mysql_query("SELECT * FROM images WHERE ID='$imagesetID'");
require("admin/failure.php");
$access=mysql_fetch_array($outcome);
$file1=$access["file1"];
$thumb1=substr($file1,0,-4)."a".substr($file1,-4,4);
}
@$outcome=mysql_query("SELECT views FROM stats WHERE articleID='$articleID'");
require("admin/failure.php");
$access=mysql_fetch_array($outcome);
$views=$access["views"];
$outcome=$outcome2;
echo '<a href="http://www.bluesweb.co.uk/news/showarticle.php?articleID=',$articleID,'">';
echo ' ';

echo $title;
echo '</a>';
echo ' ';

}
?>

<center>
<a href="http://www.newsnow.co.uk"><img src="newsnowfeatured.gif" border="0"></A>

In other words, I want to execute the code, and then include it, rather than including it then executing it.

Team Member Joined: 06 Jan 2002 Posts: 2564

I'm really not sure what you want, but this code will enable you to include a file and then output it later (usually it outputs straight away):

Code:

ob_start();
include($DOCUMENT_ROOT.'/file.php');
$variable = ob_get_contents();
ob_end_clean();

Then use

Code:

echo $variable;

to output.

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Thats not good enough, the PHP code in the include is stopping the PHP Code in the main page working properly, I need the output from the included file written to another file in HTML form, then include it.

Posted: Thu Feb 06, 2003 6:45 pm (21 years, 2 months ago)

how about you put your code into a function, then pass the output of the function to fwrite()?

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

adam wrote:

how about you put your code into a function, then pass the output of the function to fwrite()?

Tried that, doesn't work still, only solution is to write to a text file and then include, there MUST be a way of doing this.

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

This is the code that it is included with

Code:

<? require ("../includes/meta.html"); ?>

<title><?
$tempdir="admin/";
require("admin/connect.php");
@$outcome=mysql_query("SELECT * FROM articles WHERE ID='$articleID'");
require("admin/failure.php");
$access=mysql_fetch_array($outcome);
$title=$access["title"];
echo 'BluesWeb.co.uk -> Latest News -> ',$title,'';
?></title>

<? require ("../includes/newsheader.html"); ?>
<? require ("showtitles.php"); ?>

<td width="671" align="left" valign="top" height="14">






<html>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<?
$tempdir="admin/";
require("admin/connect.php");
@$outcome=mysql_query("SELECT * FROM articles WHERE ID='$articleID'");
require("admin/failure.php");
$access=mysql_fetch_array($outcome);
$title=$access["title"];
$beginning=$access["beginning"];
$text=$access["text"];
$beginning=nl2br($beginning);
$text=nl2br($text);
$authorID=$access["authorID"];
$imagesetID=$access["imagesetID"];
$filesetID=$access["filesetID"];
$year=strval(substr($access["adate"],0,4));
$month=strval(substr($access["adate"],5,2));
$day=strval(substr($access["adate"],8,2));
$adate=$day.'.'.$month.'.'.$year;
$atime=strval(substr($access["atime"],0,5));
if (!$access["ID"]) { echo $textwarning[16]; exit; }
@$outcome=mysql_query("SELECT fullname FROM users WHERE ID='$authorID'");
require("admin/failure.php");
$access=mysql_fetch_array($outcome);
$author=$access["fullname"];
@$outcome=mysql_query("SELECT views FROM stats WHERE articleID='$articleID'");
require("admin/failure.php");
$access=mysql_fetch_array($outcome);
$views=$access["views"];
echo '',$title,' ';
echo '',$adate,' ',$atime,' | ',$author,'';
echo '',$beginning,'';
echo '',$text,'';
@$outcome=mysql_query("UPDATE stats SET views=views+1 WHERE articleID='$articleID'");
require("admin/failure.php");
@$outcome=mysql_query("SELECT * FROM images WHERE ID='$imagesetID'");
while ($access=mysql_fetch_array($outcome))
{
$file1=$access["file1"]; $file2=$access["file2"];
$file3=$access["file3"]; $file4=$access["file4"];
$file5=$access["file5"]; $file6=$access["file6"];
$file7=$access["file7"]; $file8=$access["file8"];
$file9=$access["file9"]; $file10=$access["file10"];
$thumb1=substr($file1,0,-4)."a".substr($file1,-4,4);
$thumb2=substr($file2,0,-4)."a".substr($file2,-4,4);
$thumb3=substr($file3,0,-4)."a".substr($file3,-4,4);
$thumb4=substr($file4,0,-4)."a".substr($file4,-4,4);
$thumb5=substr($file5,0,-4)."a".substr($file5,-4,4);
$thumb6=substr($file6,0,-4)."a".substr($file6,-4,4);
$thumb7=substr($file7,0,-4)."a".substr($file7,-4,4);
$thumb8=substr($file8,0,-4)."a".substr($file8,-4,4);
$thumb9=substr($file9,0,-4)."a".substr($file9,-4,4);
$thumb10=substr($file10,0,-4)."a".substr($file10,-4,4);
$pathimages=substr($pathimages,3,999);
if ($file1) echo '<a href="',$pathimages,$file1,'"><img src="',$pathimages,$thumb1,'" border="0"></a>';
if ($file2) echo '<a href="',$pathimages,$file2,'"><img src="',$pathimages,$thumb2,'" border="0"></a>';
if ($file3) echo '<a href="',$pathimages,$file3,'"><img src="',$pathimages,$thumb3,'" border="0"></a>';
if ($file4) echo '<a href="',$pathimages,$file4,'"><img src="',$pathimages,$thumb4,'" border="0"></a>';
if ($file5) echo '<a href="',$pathimages,$file5,'"><img src="',$pathimages,$thumb5,'" border="0"></a> ';
if ($file6) echo '<a href="',$pathimages,$file6,'"><img src="',$pathimages,$thumb6,'" border="0"></a>';
if ($file7) echo '<a href="',$pathimages,$file7,'"><img src="',$pathimages,$thumb7,'" border="0"></a> ';
if ($file8) echo '<a href="',$pathimages,$file8,'"><img src="',$pathimages,$thumb8,'" border="0"></a>';
if ($file9) echo '<a href="',$pathimages,$file9,'"><img src="',$pathimages,$thumb9,'" border="0"></a>';
if ($file10) echo '<a href="',$pathimages,$file10,'"><img src="',$pathimages,$thumb10,'" border="0"></a>';
}
@$outcome=mysql_query("SELECT * FROM files WHERE ID='$filesetID'");
while ($access=mysql_fetch_array($outcome))
{
$file1=$access["file1"]; $file2=$access["file2"];
$file3=$access["file3"]; $description=$access["description"];
$pathfiles=substr($pathfiles,3,999);
if ($file1) echo '',$description,' ';
if ($file1) echo '<a href="',$pathfiles,$file1,'">',$file1,'</a> ';
if ($file2) echo '<a href="',$pathfiles,$file2,'">',$file2,'</a> ';
if ($file3) echo '<a href="',$pathfiles,$file3,'">',$file3,'</a> ';
}
?>
<? echo $textbasic[20] ?> 
<a href="addcomment.php?articleID=<? echo $articleID ?>"><? echo $textbasic[21] ?></a><hr>
<?
@$outcome=mysql_query("SELECT * FROM discussions WHERE articleID='$articleID' ORDER BY adate DESC, atime DESC");
require("admin/failure.php");
while ($access=mysql_fetch_array($outcome))
{
$atime=$access["atime"];
$comment=$access["comment"];
$name=$access["name"];
$email=$access["email"];
echo '';
if ($email<>"") echo '<a href="mailto:',$email,'">';
echo $name;
if ($email<>"") echo '</a>';
$year=strval(substr($access["adate"],0,4));
$month=strval(substr($access["adate"],5,2));
$day=strval(substr($access["adate"],8,2));
$adate=$day.'.'.$month.'.'.$year;
echo ' ',$textbasic[22],' ',$adate,' ',$textbasic[23],' ',$atime,': ';
echo (nl2br(htmlspecialchars($comment)));
echo "<hr>";
}
?>
</td>
</tr>
</table>
</body>
</html>

<? require ("../includes/footer.html"); ?>

Output : http://www.bluesweb.co.uk/news/showarticle.php?articleID=1

showtitles.php is the file that I showed the code for above, when showtitles is included, the same article gets displayed on the right hand side, whichever article is selected

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

when the showtitles.php file is not included, it works fine.

Posted: Thu Feb 06, 2003 7:22 pm (21 years, 2 months ago)

what if you opened showtitles.php by calling fopen('http://www.bluesweb.co.uk/news/showtitles.php','r')...wouldn't that make php open the file through a http connection? this would mean the code is executed by apache separately, then given to showarticle.php

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

I replaced :

<? require ("showtitles.php"); ?>

with

<? 'http://www.bluesweb.co.uk/news/showtitles.php','r'); ?>

Now it doesn't appear at all, though it stops the problem, but I don't get the list of articles down the left hand side!

Posted: Thu Feb 06, 2003 7:30 pm (21 years, 2 months ago)

hmm...are you sure that showtitles.php actually returns the list of articles?

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Yep :

http://www.bluesweb.co.uk/news/showtitles.php

And before you say, the text is white I know, but highlight it and you'll find it

Posted: Thu Feb 06, 2003 7:37 pm (21 years, 2 months ago)

hmm...this is very odd...sad to say, I have no idea

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Yeah, same here, just doing my head in, as I was going to put the script live today, it was all working fine, and I thought, well nothing can go wrong, all I need to do is to include the headlines on the left hand side, shouldn't be too hard I thought to myself.

How Wrong I was!

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Tried taking the first DB Connection String out of the showarticle.php file so there is only one in there, still the same result

4WebHelp Addict Joined: 07 Jan 2002 Posts: 1060

Strange thing is, it displays titlebar correctly for each article, but it doesn't display the rest correctly - strange