Android : Upload Image to mysql

Question

I want to upload an image file into mysql database on Android Mobile Programming, but I've some problem with it. Here's my code:

My code on Eclipse:

private void uploadFile() {
    // TODO Auto-generated method stub
    String nama = getIntent().getStringExtra("user");
    Bundle fieldresults = this.getIntent().getExtras();
    Filepath = fieldresults.getString("bitmap");

    Bitmap bitmapOrg= BitmapFactory.decodeFile(Filepath);
    ByteArrayOutputStream bao = new ByteArrayOutputStream();
    bitmapOrg.compress(Bitmap.CompressFormat.JPEG, 90, bao);
    byte [] ba = bao.toByteArray();
    String ba1=Base64.encodeBytes(ba);
    ArrayList nameValuePairs = new
    ArrayList();
    nameValuePairs.add(new BasicNameValuePair("image",ba1));
    nameValuePairs.add(new BasicNameValuePair("filename",Filepath));
    nameValuePairs.add(new BasicNameValuePair("username_user",nama));
    try{
    HttpClient httpclient = new DefaultHttpClient();
    HttpPost httppost = new
    HttpPost("http://10.0.2.2/BloodGlucose/uploadImage.php");
    httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
    HttpResponse response = httpclient.execute(httppost);
    HttpEntity entity = response.getEntity();
    is = entity.getContent();
    }catch(Exception e){
    Log.e("log_tag", "Error in http connection "+e.toString());
    }
}

and my PHP code:

    <?php
include_once("koneksi.php");

$username = $_REQUEST['username_user'];


$hasil = mysql_query("select * from login"); 

$base = $_REQUEST['image'];
$filename = $_ReQUEST['filename']
$buffer=base64_decode($base);
$path = "img/".$filename.".jpg";
$handle = fopen($path, 'wb');
$numbytes = fwrite($handle, $buffer);
fclose($handle);
$conn=mysql_connect("localhost","root","");
mysql_select_db("db_bloodglucose");

$sql = "UPDATE login SET file = '" . $path . "' Where username_user = $username;
$r=mysql_query($sql);

?>

The problem is the file didn't show in my database (mysql), anyone can help me? thanks before

best regards

$_ReQUEST['filename'] not a reason to fail but you have a lower case e here. It should be $_REQUEST['filename'] :-) — Nicholas King
– Nicholas King, Commented Jun 28, 2012 at 8:53
also what errors are you getting? Are you certain you have a db connection? also i cant see where you are executing your sql? — Nicholas King
– Nicholas King, Commented Jun 28, 2012 at 8:55
I've tried it, but the image still dind't show, i wonder if i've been missing somethings on my code, btw the file is in the device, pict library (emulator) — Handy Lukito
– Handy Lukito, Commented Jun 28, 2012 at 8:58
there's no error, it just that the file didn't show on mysql database — Handy Lukito
– Handy Lukito, Commented Jun 28, 2012 at 8:59

D-32 · Accepted Answer · 2012-06-28 08:59:44Z

1

Your $sql looks wrong, try:

$sql = "UPDATE login SET file = '$path' WHERE username_user = '$username'";
$r = mysql_query($sql);

answered Jun 28, 2012 at 8:59

D-32

3,2552 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Nicholas King Over a year ago

also just so you know the mysql_ functions are all now depricated php.net/manual/en/mysqlinfo.api.choosing.php

Handy Lukito Over a year ago

I've change the code, but the result is still the same, btw in mysql i put file as LONGBLOB type, i wonder if the error is on my android code?

Nicholas King Over a year ago

you need to work out if the sql query is even executing before anything

Handy Lukito Over a year ago

well, when i check on my foler "img" the file has been uploaded there, and the problem now is the database is not updated, is there something missing? :(

Nicholas King · Accepted Answer · 2012-06-28 08:56:38Z

0

this line

$sql = "UPDATE login SET file = '" . $path . "' Where username_user = $username; $r=mysql_query($sql);

should read

$sql = "UPDATE login SET file = '" . $path . "' Where username_user = " . $username; $r=mysql_query($sql);

answered Jun 28, 2012 at 8:56

Nicholas King

9387 silver badges22 bronze badges

1 Comment

Handy Lukito Over a year ago

it still didn't work, hmmm, i wonder is there's something missing on my android code?

Collectives™ on Stack Overflow

Android : Upload Image to mysql

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related