[phpToPDF] phpToPDF + HTML

**jessimvcrew** · 01/12/2014, 17h33

Bonjour à tous,

Je rencontre un problème concernant l'export PDF d'une page web dynamique.

Le fichier PHP qui suit construit l'export avec une image d'en tête et le corps de la page en question

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
 
<?php
	header( 'content-type: text/html; charset=utf-8' );
    include_once('phpToPDF.php') ;
    // Assign html code into php variable:
 
	$html="
	<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'[]>
<html xmlns='http://www.w3.org/1999/xhtml' dir='ltr' lang='en-US' xml:lang='en'>
	<head>
		<title>Observatoire de l'habitat Audeso</title>
		<meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
	   <style type='text/css'>
			.table1, .table2
			{font-family: Arial ;
			   font-style: normal;
			   font-size: 12px;}      
			.pdfsup
			{display:none;}
			.border
			{border: none;}
			
	   </style>
	</head>
<div>
<img src='http://dataceso.audeso.org/images/bandeau_pdf_habitat.jpg'></img>
</div>
<body>".$_POST["invisible"]."
</body>
</html>";
 
phptopdf_html($html,'pdf/', 'Export_observatoire.pdf');
echo "<a href='pdf/Export_observatoire.pdf' target=_blank>Download PDF</a><br>";
  header('Location: ./pdf/Export_observatoire.pdf'); 
?>

Le contenu de la page quant à lui est construit de cette manière :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
 
<?php
$territoire=$_POST['territoire'];
 
	if(isset($territoire)){
 
	include("./../../fonctions.connect_2.php");	
		if($territoire=="commune"){
 
		$commune=$_POST['comm'];
 
		$req_com= pg_query($base,"SELECT * FROM commune_ceso WHERE insee='".$commune."'");
		$rep_com = pg_fetch_assoc($req_com);
		$epci=$rep_com['code_epci'];
 
	$req_var= pg_query($base,"SELECT libgeo as nom, c10_men as men, c10_menpseul/c10_men*100 as menp, c10_mensfam/c10_men*100 as mens, 
	c10_menfam/c10_men*100 as menf, c10_mencoupsenf/c10_menfam*100 as mencs, c10_mencoupaenf/c10_menfam*100 as menca,  c10_fam as fam,
	c10_menfammono/c10_menfam*100 as menfm, p10_pmen/p10_men as mena, c10_ne24f0/c10_fam*100 as f0, c10_ne24f1/c10_fam*100 as f1, c10_ne24f2/c10_fam*100 as f2, 
	c10_ne24f3/c10_fam*100 as f3, c10_ne24f4p/c10_fam*100 as f4	FROM btx_cc_fam_2010  WHERE codgeo='".$commune."'");
 
	$req_vor= pg_query($base,"SELECT sum(c10_men) as men, sum(c10_menpseul)/sum(c10_men)*100 as menp, sum(c10_mensfam)/sum(c10_men)*100 as mens,
	sum(c10_menfam)/sum(c10_men)*100 as menf, sum(c10_mencoupsenf)/sum(c10_menfam)*100 as mencs, sum(c10_mencoupaenf)/sum(c10_menfam)*100 as menca, 
	sum(c10_menfammono)/sum(c10_menfam)*100 as menfm, sum(c10_fam) as fam, sum(p10_pmen)/sum(p10_men) as mena, sum(c10_ne24f0)/sum(c10_fam)*100 as f0, 
	sum(c10_ne24f1)/sum(c10_fam)*100 as f1,	sum(c10_ne24f2)/sum(c10_fam)*100 as f2, sum(c10_ne24f3)/sum(c10_fam)*100 as f3, 
	sum(c10_ne24f4p)/sum(c10_fam)*100 as f4	FROM btx_cc_fam_2010 WHERE codgeo IN (SELECT insee FROM commune_ceso WHERE code_epci='".$epci."')");	
 
	$req_vir= pg_query($base,"SELECT sum(c10_men) as men, sum(c10_menpseul)/sum(c10_men)*100 as menp, sum(c10_mensfam)/sum(c10_men)*100 as mens,
	sum(c10_menfam)/sum(c10_men)*100 as menf, sum(c10_mencoupsenf)/sum(c10_menfam)*100 as mencs, sum(c10_mencoupaenf)/sum(c10_menfam)*100 as menca, 
	sum(c10_menfammono)/sum(c10_menfam)*100 as menfm, sum(p10_pmen)/sum(p10_men) as mena, sum(c10_fam) as fam, sum(c10_ne24f0)/sum(c10_fam)*100 as f0, 
	sum(c10_ne24f1)/sum(c10_fam)*100 as f1,	sum(c10_ne24f2)/sum(c10_fam)*100 as f2, sum(c10_ne24f3)/sum(c10_fam)*100 as f3, 
	sum(c10_ne24f4p)/sum(c10_fam)*100 as f4	FROM btx_cc_fam_2010 
	WHERE codgeo IN (SELECT insee FROM commune_ceso WHERE code_epci!='17' GROUP BY insee)");	
 
	$req_ver= pg_query($base,"SELECT sum(c10_men) as men, sum(c10_menpseul)/sum(c10_men)*100 as menp, sum(c10_mensfam)/sum(c10_men)*100 as mens,
	sum(c10_menfam)/sum(c10_men)*100 as menf, sum(c10_mencoupsenf)/sum(c10_menfam)*100 as mencs, sum(c10_mencoupaenf)/sum(c10_menfam)*100 as menca, 
	sum(c10_menfammono)/sum(c10_menfam)*100 as menfm, sum(p10_pmen)/sum(p10_men) as mena, sum(c10_fam) as fam, sum(c10_ne24f0)/sum(c10_fam)*100 as f0, 
	sum(c10_ne24f1)/sum(c10_fam)*100 as f1,	sum(c10_ne24f2)/sum(c10_fam)*100 as f2, sum(c10_ne24f3)/sum(c10_fam)*100 as f3, 
	sum(c10_ne24f4p)/sum(c10_fam)*100 as f4	FROM btx_cc_fam_2010 WHERE dep='91'");		
 
		$rep_va = pg_fetch_assoc($req_var);
		$rep_vo = pg_fetch_assoc($req_vor);
		$rep_vi = pg_fetch_assoc($req_vir);
		$rep_ve = pg_fetch_assoc($req_ver);
 
		$tt1='"'.$rep_va['nom'].'"';
 
		$p1=number_format($rep_va['mencs'],0,',',' ');		$p2=number_format($rep_vo['mencs'],0,',',' ');
		$p3=number_format($rep_vi['mencs'],0,',',' ');		$p4=number_format($rep_ve['mencs'],0,',',' ');
		$sf1=number_format($rep_va['menca'],0,',',' ');		$sf2=number_format($rep_vo['menca'],0,',',' ');
		$sf3=number_format($rep_vi['menca'],0,',',' ');		$sf4=number_format($rep_ve['menca'],0,',',' ');
		$af1=number_format($rep_va['menfm'],0,',',' ');		$af2=number_format($rep_vo['menfm'],0,',',' ');
		$af3=number_format($rep_vi['menfm'],0,',',' ');		$af4=number_format($rep_ve['menfm'],0,',',' ');
 
		$fa0=number_format($rep_va['f0'],0,',',' '); $fo0=number_format($rep_vo['f0'],0,',',' '); $fi2=number_format($rep_vi['f2'],0,',',' ');
		$fi0=number_format($rep_vi['f0'],0,',',' '); $fe0=number_format($rep_ve['f0'],0,',',' '); $fa2=number_format($rep_va['f2'],0,',',' ');		
		$fa1=number_format($rep_va['f1'],0,',',' '); $fo1=number_format($rep_vo['f1'],0,',',' '); $fo2=number_format($rep_vo['f2'],0,',',' ');
		$fi1=number_format($rep_vi['f1'],0,',',' '); $fe1=number_format($rep_ve['f1'],0,',',' '); $fe2=number_format($rep_ve['f2'],0,',',' ');		
		$fi3=number_format($rep_vi['f3'],0,',',' '); $fe3=number_format($rep_ve['f3'],0,',',' '); $fi4=number_format($rep_vi['f4'],0,',',' ');		
		$fa3=number_format($rep_va['f3'],0,',',' '); $fo3=number_format($rep_vo['f3'],0,',',' '); $fo4=number_format($rep_vo['f4'],0,',',' ');
		$fe4=number_format($rep_ve['f4'],0,',',' '); $fa4=number_format($rep_va['f4'],0,',',' ');		
 
		echo "<br class='pdfsup'><br class='pdfsup'><h2>MÉNAGES :&nbsp; <b>".$rep_va['nom']."</b></h2><br class='pdfsup'><br class='pdfsup'><br>
		<img src='./../../images/pix.jpg' class='pdfsup' onload='
		grafmen(".$tt1.",".$p1.",".$p2.",".$p3.",".$p4.",".$sf1.",".$sf2.",".$sf3.",".$sf4.",".$af1.",".$af2.",".$af3.",".$af4.");
		graffam(".$tt1.",".$fa0.",".$fa1.",".$fa2.",".$fa3.",".$fa4.",".$fe0.",".$fe1.",".$fe2.",".$fe3.",".$fe4.",
		".$fi0.",".$fi1.",".$fi2.",".$fi3.",".$fi4.",".$fo0.",".$fo1.",".$fo2.",".$fo3.",".$fo4.");'>
		
		<b>Ménages selon la structure familiale en 2010</b><br><br>
		
		<center>
		<table width='100%' id=table1>
		
		<tr> <td class='border' width='40%'></td>
				<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>".$rep_va['nom']."</h5></td>
				<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>".$rep_com['epci']."</h5></td>
				<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>CESO (7 EPCI)</h5></td>
				<td class='defaut' width='15%' bgcolor='#FBBA00'><h5>Essonne</h5></td>
		</tr>
		<tr >
				<td class='defaut' id='border' bgcolor='#FBBA00'><h4>Nombre de ménages en 2010</h4></td>
				<td class='defaut'><h3><b>".number_format($rep_va['men'],0,',',' ')."&nbsp;</b></h3></td>
				<td class='defaut'><h3><b>".number_format($rep_vo['men'],0,',',' ')."&nbsp;</b></h3></td>
				<td class='defaut'><h3><b>".number_format($rep_vi['men'],0,',',' ')."&nbsp;</b></h3></td>
				<td class='defaut'><h3><b>".number_format($rep_ve['men'],0,',',' ')."&nbsp;</b></h3></td>
		</tr>
		<tr >
				<td class='defaut' id='border' bgcolor='#FBFA50'><h4>Dont ménages d'une personne</h4></td>
				<td class='defaut'><h3>".number_format($rep_va['menp'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vo['menp'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vi['menp'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_ve['menp'],1,',',' ')." %&nbsp;</h3></td>
		</tr>
		<tr >
				<td class='defaut' id='border' bgcolor='#FBFA50'><h4>Dont ménages sans famille</h4></td>
				<td class='defaut'><h3>".number_format($rep_va['mens'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vo['mens'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vi['mens'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_ve['mens'],1,',',' ')." %&nbsp;</h3></td>
		</tr>
				<tr >
				<td class='defaut' id='border' bgcolor='#FBFA50'><h4>Dont ménages avec famille(s) dont la famille principale est :</h4></td>
				<td class='defaut'><h3>".number_format($rep_va['menf'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vo['menf'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vi['menf'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_ve['menf'],1,',',' ')." %&nbsp;</h3></td>
		</tr>
		<tr >
				<td class='defaut' id='border' bgcolor='#FFFEC3'><h4>un couple sans enfant</h4></td>
				<td class='defaut'><h3>".number_format($rep_va['mencs'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vo['mencs'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vi['mencs'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_ve['mencs'],1,',',' ')." %&nbsp;</h3></td>
		</tr>
		<tr >
				<td class='defaut' id='border' bgcolor='#FFFEC3'><h4>un couple avec enfant(s)</h4></td>
				<td class='defaut'><h3>".number_format($rep_va['menca'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vo['menca'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vi['menca'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_ve['menca'],1,',',' ')." %&nbsp;</h3></td>
		</tr>
		<tr >
				<td class='defaut' id='border' bgcolor='#FFFEC3'><h4>une famille monoparentale</h4></td>
				<td class='defaut'><h3>".number_format($rep_va['menfm'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vo['menfm'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_vi['menfm'],1,',',' ')." %&nbsp;</h3></td>
				<td class='defaut'><h3>".number_format($rep_ve['menfm'],1,',',' ')." %&nbsp;</h3></td>
		</tr>
		</table>
		<table width='100%' id=table1 style='padding-top: 10px;'>
		<tr >
				<td class='defaut' bgcolor='#FBBA00' width='40%'><h4>Taille moyenne des ménages</h4></td>
				<td class='defaut' width='15%'><h3>".number_format($rep_va['mena'],1,',',' ')."&nbsp;</h3></td>
				<td class='defaut' width='15%'><h3>".number_format($rep_vo['mena'],1,',',' ')."&nbsp;</h3></td>
				<td class='defaut' width='15%'><h3>".number_format($rep_vi['mena'],1,',',' ')."&nbsp;</h3></td>
				<td class='defaut' width='15%'><h3>".number_format($rep_ve['mena'],1,',',' ')."&nbsp;</h3></td>
		</tr>
		</table></center>
		<h4>Source : Insee RP 2010</h4><br><br>
		
<center class='pdfsup'>	
<div><b>Taille moyenne des ménages par communes du CESO en 2010</b><br><br>
<IFRAME src='carte_menage.html' width='805' height='550' scrolling='no' frameborder='0'></IFRAME></div><br>
</center>
?>

Lorsque la page ne contient pas l'IFRAME, qui appel un fichier html, l'export fonctionne très bien.
Dans le cas contraire, l'export mouline à l'infini.
C 'est donc l'appel du fichier HTML qui bloque.

Ce n'est pas la taille du fichier, ni son emplacement a priori...
Peut-être une question de droit et/ou d'encodage ???

Merci pour votre aide

PS : Cela fonctionnait très bien il y a encore peu de temps

**jcdarocha** · 06/09/2016, 15h46

Hello,

phptopdf fonctionne chez vous ?

Car il me dit que je suis out of tokens, j'en ai racheté, mais ça ne me réactive pas pour autant ma création de pdf...

Merci
A+
Jean-Charles

[phpToPDF] phpToPDF + HTML

Bibliothèques et frameworks PHP

Discussions similaires

Partager

Partager