query(" SELECT a.*, date(a.completed_at) as completed_date, q.title, q.language, s.full_name FROM attempts a JOIN quizzes q ON q.id=a.quiz_id JOIN students s ON s.id=a.student_id WHERE a.id=$attempt_id ")->fetch_assoc(); if(!$row || $row['status']!=='completed'){ die('Certificate unavailable.'); } $totalMarks = $mysqli->query(" SELECT SUM(b.marks) FROM questions a LEFT JOIN ( SELECT question_id, MAX(marks) as marks FROM options GROUP BY question_id ) b ON a.id=b.question_id WHERE a.quiz_id=".$row['quiz_id'] )->fetch_row()[0]; $percent = $totalMarks ? round($row['marksObtained']*100/$totalMarks) : 0; $title = $row['title']; $marksObtained = $row['marksObtained']; $certificateLang = $row['language']; if($certificateLang=='urdu'){ $name = urlencode($row['full_name']); $url = "https://inputtools.google.com/request?text=$name&itc=ur-t-i0-und&num=1"; $response = file_get_contents($url); $data = json_decode($response, true); if ($data[0] === "SUCCESS") { $stdNameInUrdu = $data[1][0][1][0]; } else { echo "Failed"; } } function sqlDateToUrduRTL($sqlDate) { $months = [ '01' => 'جنوری', '02' => 'فروری', '03' => 'مارچ', '04' => 'اپریل', '05' => 'مئی', '06' => 'جون', '07' => 'جولائی', '08' => 'اگست', '09' => 'ستمبر', '10' => 'اکتوبر', '11' => 'نومبر', '12' => 'دسمبر' ]; $date = DateTime::createFromFormat('Y-m-d', $sqlDate); if (!$date) return ''; // Convert digits to Urdu $en = ['0','1','2','3','4','5','6','7','8','9']; $ur = ['۰','۱','۲','۳','۴','۵','۶','۷','۸','۹']; $day = str_replace($en, $ur, $date->format('d')); $month = $months[$date->format('m')]; $year = str_replace($en, $ur, $date->format('Y')); return "$year $month $day"; } ?> Certificate • <?= htmlspecialchars($row['title']) ?>
This credential is awarded to
Mr./Ms.

Based on your answers to 50 questions,
you have scored /.

Hearty Congratulations.
Date:
وثوق نامہ
محترم / محترمہ

دیے گئے پچاس سوالات کے جوابات کی بنیاد پر,
آپ کو / نمبرات حاصل ہوئے ہیں

- دلی مبارکباد
: تاریخ


ڈائریکٹر