Using Data from MySQL with ImageString() to create Image

Getting records from MySQL database

require 'config-pdo.php'; // Database connection object
/// collect data from student table ///
$sql="SELECT * FROM student";

foreach($dbo->query($sql) as $row){
	// generating certificates using each student record.
}

<?php
header("content-type: image/jpg");
$file_name='gd-template.jpg'; // file using standard template
require 'config-pdo.php'; // database connection details 
/// collect data from student table ///
$sql="SELECT * FROM student LIMIT 0,5 ";

foreach($dbo->query($sql) as $row){
$x=200; // Horizontal position to add name
$y=200; // vertical position to add name

$img_source=imagecreatefromjpeg($file_name);
/// adding name ////
$text_color=imagecolorallocate($img_source,0,0,255);
ImageString($img_source,5,$x,$y,$row[name],$text_color);

$y=230; // vertical position to add class 
ImageString($img_source,5,$x,$y,$row['class'],$text_color);

$y=260; // vertical position to add mark 
ImageString($img_source,5,$x,$y,$row['mark'],$text_color);

$y=290; // vertical position to add gender 
ImageString($img_source,5,$x,$y,$row['gender'],$text_color);

$x=60; // Horizontal position to add unique id
$y=399; // vertical position to add unique id
ImageString($img_source,5,$x,$y,"ID:".$row[id],$text_color);

// adding date and time ///
$x=421; // Horizontal position 
$y=399; // vertical   position 
$today=new DateTime; // date object 
$str_date=$today->format('d-m-Y H:i:s');
$text_color=imagecolorallocate($img_source,255,0,0);
ImageString($img_source,4,$x,$y,$str_date,$text_color);
// end ///
imagejpeg($img_source,"outputs/$row[id].jpg");
imagedestroy($img_source);
}
?>

Adding QR code to certificate