Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- foreach($_POST['land'] as $landkode){
- $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
- FROM tcpdf_Country
- INNER JOIN tcpdf_City
- ON tcpdf_Country.Code = tcpdf_City.CountryCode
- INNER JOIN tcpdf_CountryLanguage
- ON tcpdf_Country.Code = tcpdf_CountryLanguage.CountryCode
- WHERE tcpdf_Country.Code = '$landkode'
- LIMIT 1";
- $result = $conn->query($query) or die($conn->error);
- $row = $result->fetch_object();
- $SurfaceArea = number_format($row->SurfaceArea, 0, '.', '');
- $data .= '<tr>
- <td><img src="../../flag/'.$row->Code.'.png" width="250px" height="170px"/></td>
- <td><h1>'.$row->CName.'</h1></td>
- </tr>
- <tr><td><u><h1>Beskrivelse:</h1></u></td></tr>
- <tr><td>'.$row->Description.'</td></tr><br />
- <tr><td><b>Areal:</b></td><td>'.$SurfaceArea.' m2</td></tr>
- <tr><td><b>Styreform:</b></td><td>'.$row->GovernmentForm.'</td></tr>
- <tr><td><b>Indbyggertal:</b></td><td>'.$row->CPopulation.'</td></tr>
- <tr><td><b>Gms. levetid:</b></td><td>'.$row->LifeExpectancy.' år</td></tr>
- <tr><td><b>Hovedstad:</b></td><td>'.$row->CityName.'</td></tr>
- <tr><td><b>Sprog:</b></td><td>'.$row->Language.'</td></tr>';
- $pdf->addPage();
- }
- $tbl = <<<EOD
- <table cellspacing="0" cellpadding="1" border="0">
- $data
- </table>
- EOD;
- $pdf->writeHTML($tbl, true, false, false, false, '');
Add Comment
Please, Sign In to add comment