answersLogoWhite

0

How do you store and retrieve pictures in MySQL database?

Updated: 8/18/2019
User Avatar

Ajtambalo

Lvl 1
14y ago

Best Answer

The best thing to do is store them in a longblob field in your MySQL table.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you store and retrieve pictures in MySQL database?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is an API Is MySQL an API?

MySQL is not an API MySQL is a database where you store data. An API is how you request information from another website.


How do you retrieve an image from a database using PHP?

It depends what Database you are using. I personally use MySQL so will explain how you would do it using MySQL. You would have to create the MySQL database. I would store the image URL rather than the actual image. Then call it using PHP and a MySQL query. For Example: $sql = "SELECT * FROM Images WHERE Img_Name = 'img1'"; $query = mysql_query($sql); $array = mysql_fetch_array(query); then you would call it into HTML like so:


How do you store Unicode chars in a MySQL database and then display them back with PHP?

Set up the database as a UTF-8-encoded database. You can do this easily with PHPMyAdmin.


How do you store and retrieve images from ms access or MySQL database using JSP source code required?

Retrieve sql data you may with the help of programming way. You need to software working with sql databases of any version SQL Server. I would recommend you to try tool below.


How do you store pdf file to database using PHP?

Files cannot be directly stored in a MySQL database. However, a path to the file or the contents of the file can.


What is database all about?

HiDatabase like Mysql or access are for store dataExample anwsers.com have database who store all question and answer and user login and password with this when you login the webpage look if your information are correct and webpage get question and answer from database and display it


How can you overcome the problems of a flat-file database?

Store it in MySQL or use more then one flat-file DB...


What allows you to store retrieve analyze and print information stored in a database?

A database management system (DBMS) is used to store, retrieve, analyze, and print information stored in a database. It provides functionalities to efficiently manage data, ensure data integrity, and support various operations such as querying and reporting on the data stored in the database.


Data base system?

System that store data that is related to each other are known as database system. Example of database system : mysql, sql+, oracle etc.


What can you do in database?

A database is a program in which to store information. Such information can be sorted and manipulated to create reports, and aid an advertising mail-merge, and so on.


What is the Primary goal of DBMS?

provides way to store and retrieve database information which is both convenient and efficient.


What is macrosoft access?

It's a database application which allows you to store, organise and retrieve information in a structured way.