how to write data on next page???

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
raj86
Forum Commoner
Posts: 25
Joined: Tue Sep 29, 2009 12:28 am

how to write data on next page???

Post by raj86 »

Hello friends
i m stuck in a small problem. i have to generate a report for 3 categories. each category i want to show on the different page. Table is successfully generated but all 3 tables are coming on the same page. i have 3 different while loop to generate those table. it is not fixed that how many rows will come in the first table but i think single page will be enough for each table.
please help me to get the tables to 3 different pages. below is the code for first table(first while loop)

Code: Select all

$page=1;
$sno=1;
	$fp=fopen("groupleader.doc","a+");
	$groupleader2=mysql_query("SELECT * FROM groupleader WHERE PSRN='$psrn' AND LOCATION='$location'") or die("Query failed with error: ".mysql_error());
	while($data1=mysql_fetch_array($groupleader2,MYSQL_ASSOC)) //or die("Query failed with error: ".mysql_error());
	{
		$ip_phone=$data1['IP_PHONE'];
		$ip_o=$data1['IP_O'];
		$ip_r=$data1['IP_R'];
		$tab_2='<table width="600" border="1" align="center" cellpadding="3" style="border: solid 2px black;" >';
	
		$string1='<tr bgcolor="#99CCFF"><td colspan="4"><center>Detail of the VOIP Phone</center></td></tr>';
		
		$string2='<tr bgcolor="#99CCFF"><td><center>S.N.</center></td>'.'<td><center>VOIP MODEL </center></td>'.'<td><center>VOIP OFFICE NUMBER </center></td>'.'<td><center>VOIP RESIDENCE NUMBER</center></td></tr>';
		
		$data2='<tr><td><center>'.$sno.'</center></td>'.'<td NOWRAP><center>'.$ip_phone.'</center></td>'.'<td NOWRAP><center>'.$ip_o.'</center></td>'.'<td NOWRAP><center>'.$ip_r.'</center></td></tr>';
		
		if($page==1)
		{
			fwrite($fp,$str1);
			fwrite($fp,$str2);
			fwrite($fp,$str3);
			fwrite($fp,$str4);
			fwrite($fp,$str4."<br>");
			fwrite($fp,$head1);
		}
		
		if($sno==1)
		{	
			fwrite($fp,$tab_2);
			fwrite($fp,$string1);
			fwrite($fp,$string2);	
		}
		if($ip_phone<>"")
		{
			fwrite($fp,$data2);
			$sno++;
		}
		$page++;
	}
	$tab_22="</table><br><br>";
	fwrite($fp,$tab_22);
	$line2="<br><br><br><br><br><br><br>Issued By".str_repeat("&nbsp;",180)."Signature";
	$fp=fopen("groupleader.doc","a+");                                                        
	fwrite($fp,$line2);
	fclose($fp);
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

Re: how to write data on next page???

Post by JakeJ »

It looks to me like all your conditional statements are being met so they're all being written.

Try using switch/case instead.
Post Reply