My MySQL DB table holds a BLOB image with image_id as key. I am trying to do the following.
1.HttpPost("http://example.com/RetrieveImage.php") from Android App with the image_id in name value pairs.
The PHP Script is as follows:
<?php
mysql_connect("host","userid","password");
mysql_select_db("database");
$q=mysql_query("SELECT image FROM testblob WHERE image_id =".$_REQUEST['image_id']."");
$e=mysql_fetch_assoc($q);
print($e);
mysql_close();
?>
httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); InputStream is = entity.getContent(); response = httpclient.execute(httppost); HttpEntity entity = response.getEntity(); is = entity.getContent();
Store the BLOB data in Inputstream object is to byte array
ByteArrayOutputStream baos = new ByteArrayOutputStream();
byte[] buf = new byte[10240];
int n = 0;
try {
while ((n=is.read(buf))>=0)
{
baos.write(buf, 0, n);
}
is.close();
byte[] bytes = baos.toByteArray();
- Convert the byte array to bitmap and set ImageView of the Android widget to the Image
Bitmap bitmap;
RemoteViews updateViews = null;
bitmap = BitmapFactory.decodeByteArray(bytes, 0, bytes.length);
updateViews = new RemoteViews(context.getPackageName(), R.layout.tuwidget);
updateViews.setImageViewBitmap(R.id.tuwidget_img_btn, bitmap);
return updateViews;
Once this is run, I dont know why the widget does not even show up on the emulator and cannot even add the widget anymore to the screen. What am I doing wrong? Any help is much appreciated.
Oh and here is my widget layout.
<?xml version="1.0" encoding="utf-8"?>
<AbsoluteLayout
xmlns:android="http://schemas.android.com/apk/res/android"
android:id="@+id/tuwidget"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
>
<ImageView
android:id="@+id/tuwidget_img_btn"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
>
</ImageView>
</AbsoluteLayout>