<?php
define('FPDF_FONTPATH','./font/');
require('./fpdf.php');

// ติดต่อฐานข้อมูล
$conn = mysqli_connect("localhost", "RungSitGPA+3322", "gpaklw+3322", "sport");
if (!$conn) {
    die('Error: ' . mysqli_error($conn));
}

$id=$_GET['id'];
$pdf = new FPDF();
$pdf->AddPage('L');
$pdf->AddFont('THSarabunNew','B','THSarabunNew.php');
$pdf->SetFont('THSarabunNew','B',35,'UTF-8');



$crsql="SELECT * FROM config where c_id='1'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report = $dcrd['c_report'];
$c_rl = $dcrd['c_rl'];
$c_ud = $dcrd['c_ud'];
$c_font = $dcrd['c_font'];


$crsql="SELECT * FROM config where c_id='2'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report2 = $dcrd['c_report'];
$c_rl2 = $dcrd['c_rl'];
$c_ud2 = $dcrd['c_ud'];
$c_font2 = $dcrd['c_font'];


$crsql="SELECT * FROM config where c_id='3'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report3 = $dcrd['c_report'];
$c_rl3 = $dcrd['c_rl'];
$c_ud3 = $dcrd['c_ud'];
$c_font3 = $dcrd['c_font'];


$crsql="SELECT * FROM config where c_id='4'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report4 = $dcrd['c_report'];
$c_rl4 = $dcrd['c_rl'];
$c_ud4 = $dcrd['c_ud'];
$c_font4 = $dcrd['c_font'];


$crsql="SELECT * FROM config where c_id='5'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report5 = $dcrd['c_report'];
$c_rl5 = $dcrd['c_rl'];
$c_ud5 = $dcrd['c_ud'];
$c_font5 = $dcrd['c_font'];


$crsql="SELECT * FROM config where c_id='6'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report6 = $dcrd['c_report'];
$c_rl6 = $dcrd['c_rl'];
$c_ud6 = $dcrd['c_ud'];
$c_font6 = $dcrd['c_font'];

$crsql="SELECT * FROM config where c_id='7'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report7 = $dcrd['c_report'];
$c_rl7 = $dcrd['c_rl'];
$c_ud7 = $dcrd['c_ud'];
$c_font7 = $dcrd['c_font'];


$crsql="SELECT * FROM config where c_id='8'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report8 = $dcrd['c_report'];
$c_rl8 = $dcrd['c_rl'];
$c_ud8 = $dcrd['c_ud'];
$c_font8 = $dcrd['c_font'];


$crsql="SELECT * FROM config where c_id='9'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$c_report9 = $dcrd['c_report'];
$c_rl9 = $dcrd['c_rl'];
$c_ud9 = $dcrd['c_ud'];
$c_font9 = $dcrd['c_font'];



$sql = "SELECT * FROM sportstudene where id_s='$id'";
$objQuery = mysqli_query($conn, $sql);
if (!$objQuery) {
    die('Error: ' . mysqli_error($conn));
}
$objResult = mysqli_fetch_array($objQuery);
if (!$objResult) {
    die('No data found');
}

$name = $objResult['id_name'];
$report = $objResult['id_report'];
$id_stpy = $objResult['id_stpy'];

$crsql="SELECT id_namesport FROM sportname2 where ids='$id_stpy'" ;
$slr=mysqli_query($conn,$crsql);
$dcrd = mysqli_fetch_array($slr);
$namesport=$dcrd['id_namesport'];

$pdf->Image('12.jpg',0,210,290);
$pdf->SetFont('THSarabunNew','B',$c_font,'UTF-8');
$pdf->Cell($c_rl,$c_ud, iconv('UTF-8', 'cp874', $c_report) , 0 , 1 , 'C' );
$pdf->Text($c_rl2,$c_ud2, iconv('UTF-8', 'cp874', $c_report2) , 0 , 1 , 'C' );
$pdf->Text($c_rl3,$c_ud3, iconv('UTF-8', 'cp874', $c_report3) , 0 , 1 , 'C' );
$pdf->SetFont('THSarabunNew','B',$c_font4,'UTF-8');
$pdf->Cell($c_rl4,$c_ud4, iconv('UTF-8', 'cp874', $name) , 0 , 1 , 'C' );

$pdf->SetFont('THSarabunNew','B',$c_font5,'UTF-8');
$pdf->Cell($c_rl5,$c_ud5, iconv('UTF-8', 'cp874', 'ได้รับรางวัล'.$report.'  '.$namesport ) , 0 , 1 , 'C' );
$pdf->Text($c_rl6,$c_ud6, iconv('UTF-8', 'cp874', $c_report6) , 0 , 1 , 'C' );
$pdf->Text($c_rl7,$c_ud7, iconv('UTF-8', 'cp874', $c_report7) , 0 , 1 , 'C' );
$pdf->Text($c_rl8,$c_ud8, iconv('UTF-8', 'cp874', $c_report8 ) , 0 , 1 , 'C' );

$pdf->SetFont('THSarabunNew','B',$c_font9,'UTF-8');
$pdf->Text($c_rl9,$c_ud9, iconv('UTF-8', 'cp874', $c_report9 ) , 0 , 1 , 'C' );

$pdf->Output();
?>