{"id":1277,"date":"2020-03-20T11:27:10","date_gmt":"2020-03-20T04:27:10","guid":{"rendered":"https:\/\/www.bagi2info.com\/?p=1277"},"modified":"2022-09-11T14:02:41","modified_gmt":"2022-09-11T07:02:41","slug":"php-mengenerate-certificate-dengan-library-mpdf","status":"publish","type":"post","link":"https:\/\/www.bagi2info.com\/en\/php-joomla-generate-certificates-with-the-mpdf-library\/","title":{"rendered":"PHP Joomla: Generate certificates with the mpdf library"},"content":{"rendered":"\r\n
\"certificate<\/a><\/figure>\r\n\r\n\r\n

The company I work for happens to have to issue various certificates to many users, it would be very tiring if I had to input user names one by one. <\/p>\r\n\r\n\r\n\r\n

By generating the certificate directly through programming, we can send the certificate directly to the user’s email, without having to print and share <\/p>\r\n\r\n\r\n\r\n

Here is an example of a script that generates a certificate:<\/p>\r\n\r\n\r\n\r\n

<?php\r\n\r\nerror_reporting(E_ALL);\r\n\r\ndefine('_JEXEC', 1);\r\ndefine('JPATH_BASE', dirname(__FILE__));   \/\/ should point to joomla root\r\ndefine('DS', DIRECTORY_SEPARATOR);\r\ndefined('_JEXEC') or die();\r\n\r\nrequire_once(JPATH_BASE . DS . 'includes' . DS . 'defines.php');\r\nrequire_once(JPATH_BASE . DS . 'includes' . DS . 'framework.php');\r\n\r\n\/*To use Joomla's database classs*\/\r\n\/\/ gunakan perintah dibawah untuk joomla ver 3.6 kebawah\r\n\/\/ disable jika versi di atas 3.6\r\nrequire_once(JPATH_BASE . DS . 'libraries' . DS . 'joomla' . DS . 'factory.php');\r\n\r\n\/\/ gunakan perintah dibawah untuk joomla ver 3.6 ke atas\r\n\/\/ enable jika versi di atas 3.6\r\n\/\/require_once (JPATH_BASE.DS.'libraries'.DS.'joomla'.DS.'platform.php');\r\n\r\n$mainframe = JFactory::getApplication('site');\r\n$mainframe->initialise();\r\n\r\n$user = JFactory::getUser(); \/\/ get user info\r\n\r\njimport('joomla.database.table');\r\njimport('joomla.database.table.table');\r\n\r\ninclude(\"libraries\/mpdf\/mpdf.php\");\r\n\r\n$db = JFactory::getDBO();\r\n\r\n$sql = \"SELECT nama, jurusan, ipk\r\n\t\t\tFROM mahasiswa \";\r\n\r\n$db->setQuery($sql);\r\n\r\necho $sql;\r\n\r\n$result = $db->query();\r\n$num_rows = $db->getNumRows();\r\n\r\necho \"Numrows : \" . $num_rows;\r\n\r\n\/\/ check result\r\nif ($num_rows > 0) {\r\n\r\n    $result = $db->loadAssocList();\r\n\r\n    foreach ($result as $row) {\r\n\r\n        $mpdf = new mPDF('', 'A4', 0, 0, 0, 0, 0, 0);\r\n        $mpdf->setHeader();    \/\/ Clear headers before adding page\r\n        $mpdf->AddPage('L', 0, 0, 0, 0, 0, 0);\r\n        $mpdf->ignore_invalid_utf8 = true;\r\n\r\n        $name = $row[\"nama\"];\r\n        $ipk = $row[\"ipk\"];\r\n        $images = \"template-image.jpg\";\r\n\r\n        $newtext = wordwrap($name, 30, \"<br>\");\r\n        $html = '\t\r\n\t\t\t<style>\r\n\t\t\t\tbody { \r\n\t\t\t\t\tfont-family: Arial;\r\n\t\t\t\t\tbackground-image: url(' . JURI::base() . 'images\/' . $images . ');\r\n\t\t\t\t\tcolor:#1F497D;}\t\r\n\t\t\t\th1 {font-family: Arial;font-size:40px;}\r\n\t\t\t\th2 {font-family: Arial;font-size:24px;}\r\n\t\t\t\t.myfixed {\t\t\t\t\t\r\n\t\t\t\t\tposition: absolute;\r\n\t\t\t\t\tfont-family: Arial;font-size:40px;\r\n\t\t\t\t\toverflow: visible;\r\n\t\t\t\t\tleft: 0;\r\n\t\t\t\t\tright: 0;\t\t\t\t\t\r\n\t\t\t\t\ttop: 53mm;\r\n\t\t\t\t\twidth: 250mm;   \/* you must specify a width *\/\r\n\t\t\t\t\tmargin-top: auto;\r\n\t\t\t\t\tmargin-bottom: auto;\r\n\t\t\t\t\tmargin-left: auto;\r\n\t\t\t\t\tmargin-right: auto;\r\n\t\t\t\t\tfont-weight:bold;\r\n\t\t\t\t}\r\n\t\t\t\t.bpmTopicC td, .bpmTopicC td p { text-align: center; }\r\n\t\t\t\t.bpmTopicC {\r\n\t\t\t\t\twidth:96%; \r\n\t\t\t\t\t\/*background-color: #e3ece4;*\/\r\n\t\t\t\t\tposition: absolute;\r\n\t\t\t\t\tfont-family: Arial;\r\n\t\t\t\t\tfont-size:40px;\r\n\t\t\t\t\toverflow: visible;\r\n\t\t\t\t\tleft: 0;\r\n\t\t\t\t\tright: 0;\r\n\t\t\t\t\ttop: 52;\r\n\t\t\t\t\twidth: 250mm;   \/* you must specify a width *\/\r\n\t\t\t\t\tmargin-top: auto;\r\n\t\t\t\t\tmargin-bottom: auto;\r\n\t\t\t\t\tmargin-left: auto;\r\n\t\t\t\t\tmargin-right: auto;\r\n\t\t\t\t\tfont-weight:bold;\r\n\t\t\t\t}\r\n\t\t\t<\/style><\/pre>\r\n\r\n    <div class=\"myfixed\">\r\n    <table class=\"bpmTopicC\">\r\n    <tbody>\r\n    <tr>\r\n    <td>' . $newtext . '<\/td>\r\n    <\/tr>\r\n    <\/tbody>\r\n    <\/table>\r\n    <\/div>';\r\n\r\n        $mpdf->WriteHTML($html);\r\n        $mpdf->WriteFixedPosHTML('<div style=\"font-weight: bold;\">' . $ipk . \"<\/div>\", 64, 74, 50, 100, 'auto');\r\n\r\n        $filename_replaced = str_replace('\/', '', $name);\r\n\r\n        $mpdf->Output(\"files\/$filename_replaced.pdf\", \"F\");\r\n\r\n        \/\/$mpdf->Output(\"files\/$name\".\".pdf\",\"I\");\r\n\r\n    }\r\n} else {\r\n    JFactory::getApplication()->enqueueMessage('No record found for this course', 'error');\r\n    \/\/header('Location: '.$_SERVER['REQUEST_URI']);\r\n    JError::raiseWarning(100, 'Warning');\r\n    \/\/header('Location: ' . $_SERVER[\"HTTP_REFERER\"] );\r\n    JError::raiseWarning(100, 'Warning');\r\n}\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n
Requirements:
1. Latest Joomla 
2. The MPDF library is installed in the library folder 
3. Student table<\/p>\r\n","protected":false},"excerpt":{"rendered":"
The company I work for happens to have to issue various certificates to many users, it would be very tiring if I had to input user names one by one. By generating the certificate...<\/p>\n","protected":false},"author":1,"featured_media":1279,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[11,71,82,62,7],"class_list":["post-1277","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-komputer","tag-database","tag-joomla","tag-mysql","tag-php","tag-sql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/posts\/1277","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/comments?post=1277"}],"version-history":[{"count":0,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/posts\/1277\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/media\/1279"}],"wp:attachment":[{"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/media?parent=1277"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/categories?post=1277"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bagi2info.com\/en\/wp-json\/wp\/v2\/tags?post=1277"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}