Step 01: First convert the image(logo) to base64 format using the below url

https://codebeautify.org/image-to-base64-converter

It will generate a large string value as above.

Step 02: Write the update query to add the image.

update ohrm_online_course_certificate_template set body = ’’;

Inside tag <img src= ‘data:image tag paste the large string value that was generated earlier on step 01

2.1: Adjust height and width of the logo according to the client requirement (this will be in the body property named as “height = px width = px”

2.2 Adjust alignment of the logo by tweaking the below style attributes this is also in the body property under img tag

style="display: block; margin: 0 auto;">

Note: margin: 0 auto will place the logo in the center and setting display: block will make alignment easy

Note: Sample query is also added for your reference. 

Verification steps (Front-end)

Go to Employee Management

Click an Employee

Go to the Qualifications tab as shown below

Scroll down to Certifications and download any one of the certificates.

This will open up in a another tab and check whether logo is correctly placed

If not edit the css part again according to your need and run the update query again (refresh the tab once you ran the update query to reflect the changes in OTM certificate)