All pastes #899986 Raw Edit

Untitled

public text v1 · immutable
·published 2008-02-11 16:09 UTC
rendered paste body
nieuw
///////////
    $query2	= mysql_query("SELECT * FROM `makelaar` WHERE `OBJECTNUMMER`= '$ID'");
    $result2 	= mysql_fetch_assoc($query2);
    
    //Blok bovenaan met adres
    $pdf->SetY(10);
    $pdf->SetX(131);
    $pdf->SetTextColor(255,255,255);
    $pdf->SetFontSize(16);
    $pdf->Cell(250,10,$result2['ADRES'] ,0,2,'L',0);
        
    //Blok bovenaan met plaatsnaam	
    $pdf->SetY(17);
    $pdf->SetX(131);
    $pdf->SetTextColor(255,255,255);
    $pdf->SetFontSize(16);
    $pdf->Cell(250,10,$result2['PLAATSNAAM'],0,2,'L',0);
    
    //Blok bovenaan met prijs
    $pdf->SetTextColor(255,255,255);
    $pdf->SetY(50);
    $pdf->SetX(131);
    
	if ($result2['KOOPPRIJS']) { 
	   $pdf->Cell(100,25,"Vraagprijs  ".number_format($result2['KOOPPRIJS'], 0, ',', '.').',- k.k.' ,0,0,'',0);
	}
       if ($result2['HUURPRIJS']) { 
	   $pdf->Cell(100,25,"Huurprijs  ".number_format($result2['HUURPRIJS']),0,2,'L',0);
	}

    //Kenmerken
    

	
    $pdf->SetFontSize(12);
	$pdf->SetY(90);
	$pdf->SetX(5);
	$pdf->SetFillColor(167,175,190);
	$pdf->SetTextColor(0,0,0);
	$pdf->Cell(40,5,"Kenmerken:",0,0,'',0);

    $query2	= mysql_query("SELECT * FROM `makelaar` WHERE `OBJECTNUMMER`= '$ID'");
     $result2 	= mysql_fetch_assoc($query2);
     
     
     $result2 = mysql_fetch_assoc($query2); 
if (!empty($result2['AANTALKAMERS']))
{
         $pdf->SetY(100);
         $pdf->SetX(5);
         $pdf->SetFillColor(228,233,243);
         $pdf->Cell(40,5,"Aantalkamers",0,0,'',0);
         $pdf->Cell(40,5,$result2['AANTALKAMERS'],0,0,'',0);
}
        
if (!empty($result2['WOONHUISTYPE']))
{
         $pdf->SetY(105);
         $pdf->SetX(5);
         $pdf->SetFillColor(167,175,190);
         $pdf->Cell(40,5,"Woonhuistype",0,0,'',0);
         $pdf->Cell(40,5,$result2['WOONHUISTYPE'],0,0,'',0);
}

if (!empty($result2['WOONHOPPERVLAKTE']))
{

	    $pdf->SetY(110);
	    $pdf->SetX(5);
	    $pdf->SetFillColor(228,233,243);
	    $pdf->Cell(40,5,"Woonoppervlakte:",0,0,'',0);
	    $pdf->Cell(40,5,$result2['WOONOPPERVLAKTE'] . "m²",0,0,'',0);
}

if (!empty($result2['PERCEELOPPERVLAKTE']))
{

	    $pdf->SetY(115);
	    $pdf->SetX(5);
	    $pdf->SetFillColor(167,175,190);
	    $pdf->Cell(40,5,"Perceeloppervlakte:",0,0,'',0);
	    $pdf->Cell(40,5,$result2['PERCEELOPPERVLAKTE'],0,0,'',0);
}

if (!empty($result2['SOORTBOUW']))
{

	    $pdf->SetY(120);
	    $pdf->SetX(5);
	    $pdf->SetFillColor(228,233,243);
	    $pdf->Cell(40,5,"Soort bouw:",0,0,'',0);
	    $pdf->Cell(40,5,$result2['SOORTBOUW'],0,0,'',0);
}

if (!empty($result2['BOUWJAAR']))
{

	    $pdf->SetY(125);
	    $pdf->SetX(5);
	    $pdf->SetFillColor(167,175,190);
	    $pdf->Cell(40,5,"Bouwjaar:",0,0,'',0);
	    $pdf->Cell(40,5,$result2['BOUWJAAR'],0,0,'',0);
}
///////////////

$result2 = mysql_fetch_assoc($query2); 
if (!empty($result2['AANTALKAMERS']))
{
         $pdf->SetY(100);
         $pdf->SetX(5);
         $pdf->SetFillColor(228,233,243);
         $pdf->Cell(40,5,"Aantalkamers",0,0,'',0);
         $pdf->Cell(40,5,$result2['AANTALKAMERS'],0,0,'',0);
}
        
if (!empty($result2['WOONHUISTYPE']))
{
         $pdf->SetY(105);
         $pdf->SetX(5);
         $pdf->SetFillColor(167,175,190);
         $pdf->Cell(40,5,"Woonhuistype",0,0,'',0);
         $pdf->Cell(40,5,$result2['WOONHUISTYPE'],0,0,'',0);
}