Solved

insert text to picture (text come from data base)

Posted on 2011-09-07
2
317 Views
Last Modified: 2012-05-12
look program that can insert text from mysql database then make it jpg file and send to  photoshop (shop that accept photo at size 6 * 4 inch)  in jpg format
0
Comment
Question by:teera
2 Comments
 
LVL 26

Expert Comment

by:David Brugge
Comment Utility
I have not been able to find any off the shelf programs that will do this for you. I suspect that you will need a custom script to be written. This should be any easy task.

Photoshop has the ability to build templates with text variables. You set some text on an image, then tell Photoshop to replace that text with the data in a text or CSV file and output the results.

I think you would need a script to poll your mysql db and generate a CSV, load your image on a background layer, and output as a jpg with an appropriate name.

I don't script very well myself, so I rely on services like ODesk, or elance.

Hope this helps.
0
 
LVL 1

Accepted Solution

by:
Gabo80 earned 500 total points
Comment Utility
Check this:
http://tuxtweaks.com/2009/06/create-text-images-with-imagemagick/

With imagemagic you can create more or less what you want with a "simple" command.
From php you can run imagemagick with an exec() or shell() command.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

This article shows how to convert a multi-page PDF file into multiple image files, with one image file created for each page of the PDF. It does this by utilizing an excellent, free software package called GraphicsMagick. The solution is amazingly s…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
The goal of the tutorial is to teach the user how to add a water mark to there photo. Once you have a photo you like you have to go into the water mark setting and add a water mark to the image. You can either choose a text watermark or an image…
The goal of the tutorial is to teach the user how to edit a basic portrait of someone. This tutorial shows how to edit two basic photographs, one of a car and one of a person.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now