Guest User

Untitled

a guest
Feb 18th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.58 KB | None | 0 0
  1. foreach($_POST['land'] as $landkode){
  2.  
  3.  
  4.  
  5.  
  6.  
  7. $query = "SELECT Code, tcpdf_Country.Name as CName, Description, SurfaceArea, GovernmentForm, tcpdf_Country.Population as CPopulation, tcpdf_City.Name as CityName, tcpdf_CountryLanguage.Language, LifeExpectancy
  8. FROM tcpdf_Country
  9. INNER JOIN tcpdf_City
  10. ON tcpdf_Country.Code = tcpdf_City.CountryCode
  11. INNER JOIN tcpdf_CountryLanguage
  12. ON tcpdf_Country.Code = tcpdf_CountryLanguage.CountryCode
  13. WHERE tcpdf_Country.Code = '$landkode'
  14. LIMIT 1";
  15. $result = $conn->query($query) or die($conn->error);
  16.  
  17. $row = $result->fetch_object();
  18. $SurfaceArea = number_format($row->SurfaceArea, 0, '.', '');
  19. $data .= '<tr>
  20. <td><img src="../../flag/'.$row->Code.'.png" width="250px" height="170px"/></td>
  21. <td><h1>'.$row->CName.'</h1></td>
  22. </tr>
  23. <tr><td><u><h1>Beskrivelse:</h1></u></td></tr>
  24. <tr><td>'.$row->Description.'</td></tr><br />
  25. <tr><td><b>Areal:</b></td><td>'.$SurfaceArea.' m2</td></tr>
  26. <tr><td><b>Styreform:</b></td><td>'.$row->GovernmentForm.'</td></tr>
  27. <tr><td><b>Indbyggertal:</b></td><td>'.$row->CPopulation.'</td></tr>
  28. <tr><td><b>Gms. levetid:</b></td><td>'.$row->LifeExpectancy.' år</td></tr>
  29. <tr><td><b>Hovedstad:</b></td><td>'.$row->CityName.'</td></tr>
  30. <tr><td><b>Sprog:</b></td><td>'.$row->Language.'</td></tr>';
  31.  
  32.  
  33.  
  34. $pdf->addPage();
  35. }
  36. $tbl = <<<EOD
  37.  
  38. <table cellspacing="0" cellpadding="1" border="0">
  39. $data
  40.  
  41.  
  42. </table>
  43.  
  44. EOD;
  45.  
  46.  
  47.  
  48.  
  49. $pdf->writeHTML($tbl, true, false, false, false, '');
Add Comment
Please, Sign In to add comment