InMotion Hosting Support Center

Uploading a png photo to mysql and maintaining transparency

Category: Databases

2013-03-14 11:13 am EST

Hits: 572
James sent me to some excellent code to upload photos. However, I also want to maintain the transparency of my png images upon upload.
Is this possible with Inmotion? If so, how would I do it.

You must login before you can ask a follow up question.

You must login before you can submit an answer.



5,889 Points
2013-03-14 1:32 pm EST
Thank you for your question Mam1606!

MySQL will store you image as a BLOB (Binary Large Object). When you upload the image to your database, the file format is retained in the Binary data. When the image is called using PHP, the image should load with the exact same file format, retaining the transparency. This should work on any LAMP (Linux, Apache, MySQL, PHP) server. All InMotion servers are LAMP servers so you should be ok to use .png's with transparencies in your BLOB data of your database at InMotion.

Best Regards,
James R

You must login before you can post a comment about this answer.

Like this Question?

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!