Forum Moderators: coopster
ex.
-------------
¦ 1 ¦ 2 ¦ 3 ¦
-------------
¦ 4 ¦ 5 ¦ 6 ¦
-------------
¦ 7 ¦ 8 ¦ 9 ¦
etc
Here comes the HUGE problem:
$a="valor1";
$b="Valor2";
$pdf->Cell(70.3, 26.5, $a , 1, 0, 'C');
I´d like to have in this cell 5 itens, one bellow the other (at the moment there are only one - $a)
I´ve tryied to use <br> ($a."<br>".$b) but $b did not go under $a, instead the pdf generated something
like this: "valor1<br>valor2"
It doesnt work with $pdf->Ln(); because it will just jump a line AFTER the whole cell´s been generated.
I´d like to improve itens 1 and 2 commented in the code:
//* ITEN 1 - WHAT I´D LIKE TO DO
//* ITEN 2 - IMPROVE: There must be a better way to have a break after 3 cell´s been generated
How can I do that?
I´ve been using fpdf: URL: fdpf [fpdf.org]
Bellow is my code.
[PHP]
<?//DB MYSQL
$server = "localhost";
$user = "root";
$pass = "";
$bd = "pdf";
//TITLE
$tit = "STICKERS";
//FPDF LIBRARY
$end_fpdf = "../fpdf";
//NUMBER OF RESULTS PER PAGE
$per_page = 30;
//WHERE PDF WILL BE SAVED
$end_final = "gera.pdf";
//F-> TO SAVE THE PDF
$tipo_pdf = "F";
//CONECTION
$conn = mysql_connect($server, $user, $pass);
$db = mysql_select_db($bd, $conn);
$sql = mysql_query("SELECT A.ID, A.NOME, A.ASSUNTO FROM colunistas A", $conn);
$row = mysql_num_rows($sql);
//SEE IF THERE IS ANY RECORD
if(!$row) { echo "There are no records"; die; }
//CALCULATES HOW MANY PAGES WILL BE NECESSARY
$pages = ceil($row/$per_page);
//PDF
define("FPDF_FONTPATH", "$end_fpdf/font/");
require_once("$end_fpdf/fpdf.php");
$pdf = new FPDF('P','mm','Letter');
$pdf->SetTopMargin(7.1);
$pdf->SetLeftMargin(0);
$pdf->SetRightMargin(0);
//START VARS
$actual_line = 0;
$beginning = 0;
//PAGES
for($x=1; $x<=$pages; $x++) {
//VERIFY
$beginning = $actual_line;
$end = $actual_line + $per_page;
if($end > $row) $end = $row;
$pdf->Open();
$pdf->AddPage();
$pdf->SetFont("Arial", "B", 10);
//SHOW RECORDS
for($i=$beginning; $i<$end; $i++) {
//* ITEN 1 - WHAT I´D LIKE TO DO
//$a =mysql_result($sql, $i, "ID") ;
$a="Valor1"; $b="Valor2";
$pdf->Cell(70.3, 26.5, ($i+1)." ".$a."<br>".$b , 1, 0, 'C');
//* ITEN 2 - IMPROVE: There must be a better way to have a break after 3 cell´s been generated
$ia=$i;
$id=$ia+3;
if( $ia==2 ¦¦ $ia==5 ¦¦ $ia==8 ¦¦ $ia==11 ¦¦ $ia==14 ¦¦ $ia==17 ¦¦ $ia==20 ¦¦ $ia==23 ¦¦ $ia==26 ¦¦ $ia==29 ¦¦
$ia==35 ¦¦ $ia==38 ¦¦ $ia==41 ¦¦ $ia==44 ¦¦ $ia==47 ¦¦ $ia==50 ¦¦ $ia==53 ¦¦ $ia==56 ¦¦ $ia==59 ¦¦
$ia==65 ¦¦ $ia==68 ¦¦ $ia==71 ¦¦ $ia==74 ¦¦ $ia==77 ¦¦ $ia==80 ¦¦ $ia==83 ¦¦ $ia==86 ¦¦ $ia==89 ¦¦
$ia==95 ¦¦ $ia==98 ¦¦ $ia==101 ¦¦ $ia==104 ¦¦ $ia==107 ¦¦ $ia==110 ¦¦ $ia==113 ¦¦ $ia==116 ¦¦ $ia==119 ¦¦
$ia==125 ¦¦ $ia==128 ¦¦ $ia==131 ¦¦ $ia==134 ¦¦ $ia==137 ¦¦ $ia==140 ¦¦ $ia==143 ¦¦ $ia==146 ¦¦ $ia==149 ¦¦
$ia==155 ¦¦ $ia==158 ¦¦ $ia==161 ¦¦ $ia==164 ¦¦ $ia==167 ¦¦ $ia==170 ¦¦ $ia==173 ¦¦ $ia==176 ¦¦ $ia==179
){
$pdf->ln();
}
//ITEN 2 ENDS
$actual_line++;
$pdf->SetAutoPageBreak('on','0.2');
}//END FOR(RECORDS - i)
}//END FOR(pages - x)
//PDF OUTPUT
$pdf->Output("$end_final", "$tipo_pdf");
?>
[/PHP]
Help me pleaseeeee. I´ve been looking for that for days but it seems that it doenst exist!
Thanks so much.
Roger.
[edited by: coopster at 4:40 pm (utc) on Mar. 9, 2005]
[edit reason] removed url per TOS [webmasterworld.com] [/edit]
Have a look at the "Scripts" link on the FPDF home page. There is a Tables with MultiCells [fpdf.org] option that seems to fit exactly what you are trying to accomplish.
