Adding Image to Sqlite -android-

Question

How can i add image to sqlite database and then retrieve ? using Content Provider

*i want to get this image that i loaded from gallery of taken by camera to be stored in the database to use it in another activities *

Hi Mohamed, You have to use Blobs. See answer below http://stackoverflow.com/questions/11790104/how-to-storebitmap-image-and-retrieve-image-from-sqlite-database-in-android http://stackoverflow.com/questions/9357668/how-to-store-image-in-sqlite-database — Ruchira Randana, Oct 17 '16 at 17:05

HelloSadness · Accepted Answer · 2016-10-17T22:07:33.217

-1

You could save the path to the image in the databse. Then in next activity, retrieve it and if the file exists display it...

When user selected image from gallery, i guess you get the URI from onActivityResult(). You just need to get the path to it using a code like this one :

private String getRealPathFromURI(Uri contentUri) {
    String[] store = { MediaStore.Images.Media.DATA };
    CursorLoader loader = new CursorLoader(mContext, contentUri, store, null, null, null);
    Cursor cursor = loader.loadInBackground();
    int column_index = cursor.getColumnIndexOrThrow(MediaStore.Images.Media.DATA);
    cursor.moveToFirst();
    String result = cursor.getString(column_index);
    if (cursor != null ) {
    cursor.close();
    }
    return result;
}

Just save the path in your database the way you want.

Later on, try to get the file. If file exists, update your ImageView

File file = new File(savedPath);
if(file.exists){
  // load image in your imageView
  Bitmap mBitmap = BitmapFactory.decodeFile(file.getAbsolutePath());
  yourImageView.setImageBitmap(mBitmap);
}

edited Oct 17 '16 at 22:07

answered Oct 17 '16 at 16:38

HelloSadness

945
7
17

Or use some encoding like Base64, but Anto's answer is much better. – Andrii Omelchenko Oct 17 '16 at 16:40
1

@AndriyOmelchenko is not a good idea to keep the base64 code of an image, imagine 5000 characters for a single image? – sioesi Oct 17 '16 at 16:44
@sioesi I just wanted to say that any data can be saved as text (and, for example, zipped before encoding). And yes - this is not good solution. – Andrii Omelchenko Oct 17 '16 at 16:52
Although a doubt arises me would happen if for example the user take the picture with the camera and would like to save the image momentarily and then manipulate it? – sioesi Oct 17 '16 at 16:53
do you have any example to do that ? – Mohamed Farahat Oct 17 '16 at 21:45
Also this could help [How to get the Full file path from URI](http://stackoverflow.com/questions/13209494/how-to-get-the-full-file-path-from-uri) – HelloSadness Oct 17 '16 at 22:05

score -2 · Answer 2 · answered Oct 17 '16 at 22:15

Images are stored as BLOB's in Sqlitedatabase.

For saving an image in to Database

ContentValues values = new ContentValues();
    values.put(KEY_NAME, contact.getItemname());
    values.put(KEY_DESCRIPTION, contact.getDescription());
     Log.i("","Adding image of Type Bitmap"+contact.getImage());
     if(contact.getImage()!=null) {
       values.put(KEY_IMAGE, Utility.getBytes(contact.getImage()));
     }

Where getBytes(Bitmap) would be :

public static byte[] getBytes(Bitmap bitmap) {
    ByteArrayOutputStream stream = new ByteArrayOutputStream();
    bitmap.compress(CompressFormat.PNG, 0, stream);
    return stream.toByteArray();
}

While fetching an Image from the Database :

    if(cursor.getBlob(3)!=null)
    {
          contact.setImage(Utility.getPhoto(cursor.getBlob(3));
    }
    else
    {
         contact.setImage(null);
     }

And getPhoto(BLOB) would be:

// convert from byte array to bitmap
public static Bitmap getPhoto(byte[] image) {
    return BitmapFactory.decodeByteArray(image, 0, image.length);
}

atleast give a valid reason before down voting someone. – Iram Bukhari Oct 18 '16 at 22:37 — Iram Bukhari, Oct 18 '16 at 22:37

Adding Image to Sqlite -android-

2 Answers2