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