สมาชิกท่านใดมีซอร์สโค๊ตหรือสคริปเกียวกับการออกเกียรติบัตรออนไลน์รบกวนขอหน่อยครับ

<?php
/// id=65000&password=ABCDEF
/////////////////////////////////////////
$filename = $certificate_template.'.jpg';
list($width, $height) = getimagesize($filename);
$newwidth = $width;
$newheight = $height + 20;

// Load
$im = imagecreatetruecolor($newwidth, $newheight);
$source = imagecreatefromjpeg($filename);
// Resize
imagecopyresized($im, $source, 0, 0, 0, 0, $newwidth, $height, $width, $height);

$name=$_SESSION['name']; $id=$_SESSION['id'];
$text_color  = imagecolorallocate($im, 200, 255,   0);
$s_size = ImageFtBbox(10, 0, 'arial.ttf', $name, array("linespacing" => 1));
$s_width  = $s_size[4];
$s_height = $s_size[5];
imagettftext ( $im, 10, 0, ($width-$s_width)/2, $height-$s_height + 2, $text_color, 'arialbd.ttf', $name);
////////////////////////////////////////
$tmp='tmp_'.$id.'.jpg';
ImageJPEG($im, $tmp,100);
imagedestroy($im);
////////////////////////////////////////
$l=filesize ($tmp);
$contents = fread ($fd = fopen ($tmp, "rb"), $l); fclose ($fd);
//unlink($tmp); // open this line when complete
///////////////////////////////////////
header('Content-Description: File Transfer');
header('Content-Disposition: attachment; filename="'.$id.'.jpg"');
header("Pragma: no-cache");
header("Content-Type:image/jpeg\n");
header("Content-Transfer-Encoding: binary\n");
header("Content-length: ".$l. "\n");
echo($contents);
?>

<?php
require_once("../connectdb.php");
require_once("../function_number.php");
require('fpdf.php');
define('FPDF_FONTPATH','font/');  
$pdf=new FPDF( 'L' , 'mm' ,'A4');  
$pdf->AddFont('angsana','B','angsanab.php');  
$pdf->AddFont('angsana','','angsana.php');  

$t_id = "";

 $sql = "select ".students.".t_id AS t_id";
  $sql .= " ,".students.".t_name  AS t_name";
    $sql .= " ,".students.".t_schid  AS t_schid";
	  $sql .= " ,".students.".t_avid  AS t_avid";
  $sql .= " ,".schools.".sch_id  AS sch_id";
   $sql .= " ,".schools.".sch_name  AS sch_name";
   $sql .= " ,".activities.".av_id  AS av_id";
	 $sql .= " ,".activities.".av_subject  AS av_subject";
	  $sql .= " ,".activities.".av_detail  AS av_detail";
	 $sql .= " ,".certificates.".cc_id  AS cc_id";
	 $sql .= " ,".certificates.".cc_avid  AS cc_avid";
	 $sql .= " ,".certificates.".cc_year  AS cc_year";
	 $sql .= " ,".certificates.".cc_date  AS cc_date";
	 $sql .= " ,".certificates.".cc_no  AS cc_no";
	 $sql .= " ,".certificates.".cc_start  AS cc_start";
	 $sql .= " ,".certificates.".cc_end  AS cc_end";
  $sql .= " ,".certificates.".cc_text  AS cc_text";
  $sql .= " ,".certificates.".cc_pict  AS cc_pict";
  $sql .= " ,".certificates.".cc_dean  AS cc_dean";
  $sql .= " ,".certificates.".cc_dean1  AS cc_dean1";
  $sql .= " ,".certificates.".cc_kan  AS cc_kan";
  $sql .= " ,".certificates.".cc_ar  AS cc_ar";
   $sql .= " ,".certificates.".cc_ap  AS cc_ap";
   $sql .= " ,".points.".p_point  AS p_point";

$sql.= " from ".students." ,".schools.",".activities .",".certificates.",".points;
  $sql.= " where ".students.".t_avid=".$_GET[id];
   $sql.= " and ".students.".t_schid=".schools.".sch_id";
  $sql.= " and ".points.".p_st=".students.".t_id";
  $sql.= " and ".students.".t_avid=".activities.".av_id";
   $sql.= " and ".certificates.".cc_avid=".activities.".av_id";
  $sql.= " ORDER BY t_name  ASC";

$conn = mysql_connect($hostname, $dbuser, $dbpassword) or die("Error Connect to Database");
mysql_select_db($dbname,$conn);
mysql_query("SET NAMES TIS620"); 
mysql_query("SET character_set_results=tis620"); 
$result = mysql_query($sql) or die($sql . "<br>\n" . $mysql_error()) ;
while($row = mysql_fetch_array($result)){
$pdf->AddPage();
$pdf->Image("../".$row[cc_pict],0,0,300,0,'','');

/* เริ่มต้น พิมพ์รายละเอียด */
$pdf->SetXY(10,0);  
$pdf->SetFont('angsana','',16);
$pdf->Cell( 268  , 65 , "เลขที่  ".$row[cc_no]." " .thaiNumber("".$row[p_point])." / " .thaiNumber("".$row[cc_year])."             " , 0 , 1 , 'R' );
$pdf->SetXY(10,58);  
$pdf->SetFont('angsana','B',35);
$pdf->Cell( 0  , 55 ,$row[t_name], 0 , 1 , 'C' );
$pdf->SetXY(10,90);  
$pdf->SetFont('angsana','B',20);
$pdf->Cell( 0  , 15 ,"ครู ".$row[sch_name] , 0 , 1 , 'C' );
$pdf->SetFont('angsana','B',24);
$pdf->Cell( 0  , 10 , $row[cc_ap], 0 , 1 , 'C' );
$pdf->SetFont('angsana','B',24);
$pdf->Cell( 0  , 10 ,$row[av_subject], 0 , 1 , 'C' );
$pdf->SetFont('angsana','B',22);
$pdf->Cell( 0  , 10 , "ระหว่างวันที่  " .thaiNumber("".$row[cc_start])." " .$row[cc_kan]. " " .thaiNumber("".$row[cc_end])." เดือน "  .$row[cc_dean]." พ.ศ. "   .thaiNumber("".$row[cc_year]). "" , 0 , 1 , 'C' );
 $pdf->SetFont('angsana','B',22);
$pdf->Cell( 0  , 10 , "ณ  ".$row[cc_ar] , 0 , 1 , 'C' );
 $pdf->SetFont('angsana','B',22);
$pdf->Cell( 0  , 10 ,  $row[cc_text] , 0 , 1 , 'C' );
$pdf->SetFont('angsana','B',22);
$pdf->Cell( 0  , 10 , "ให้ไว้ ณ วันที่ " .thaiNumber("".$row[cc_date])." เดือน "  .$row[cc_dean1]." พ.ศ. "   .thaiNumber("".$row[cc_year]). "" , 0 , 1 , 'C' );

}
$pdf_file = "../BBL.AC.TH-ALL-(".$_GET[id].").pdf";
mysql_close($conn);
$pdf->Output("../TRAIN_ALL/TRAIN_ALL/".$pdf_file,"F");
?>