将Android中的Base64图像通过JSON发送到PHP Web服务，解码并保存到SQL

Question

描述中提到，我正在使用Android拍照。它被压缩并添加到一个byte[]中，然后进行了base64编码。它与JSON一起发送到我的webservice，在那里它“应该”被解码并保存在SQL表行中。我可以将编码字符串保存在单独的行中，以便知道它已经传输成功。

请问有人能够查看这个问题并指出我哪里做错了吗？*抱歉代码有点冗长，但是我不想错过任何帮助！ ANDROID端

@Override
    protected String doInBackground(String... args) {
        // TODO Auto-generated method stub
        // Check for success tag

        int success;
        stream = new ByteArrayOutputStream();
        picture.compress(Bitmap.CompressFormat.JPEG, 50, stream);
        image = stream.toByteArray();

        String ba1 = Base64.encodeToString(image, Base64.DEFAULT);

        SharedPreferences sp = PreferenceManager.getDefaultSharedPreferences(MainScreen.this);
        String post_username = sp.getString("username", "anon");

        try {
            ArrayList<NameValuePair> params = new ArrayList<NameValuePair>();
            params.add(new BasicNameValuePair("username", post_username));
            params.add(new BasicNameValuePair("picture", ba1));

           JSONObject json = jsonParser.makeHttpRequest(POST_COMMENT_URL,
                    "POST", params);


            success = json.getInt(TAG_SUCCESS);
            if (success == 1) {
                Log.d("Picture Added!", json.toString());
                //finish();
                return json.getString(TAG_MESSAGE);
            } else {
                Log.d("Upload Failure!", json.getString(TAG_MESSAGE));
                return json.getString(TAG_MESSAGE);

            }
        } catch (JSONException e) {
            e.printStackTrace();
        }

        return null;

    }

    protected void onPostExecute(String file_url) {
        // dismiss the dialog once product deleted
        pDialog.dismiss();
        if (file_url != null) {
            Toast.makeText(MainScreen.this, file_url, Toast.LENGTH_LONG)
                    .show();
        }

    }
}

}

PHP端

<?php
require("config.inc.php");
if (!empty($_POST)) {
    $user = $_POST['username'];
    $data = $_POST['picture'];
    $data = base64_decode($data);
    $im = imagecreatefromstring($data);
    header('Content-Type: image/jpeg', true);
    ob_start();
    imagejpeg($im);
    $imagevariable = ob_get_contents();
    ob_end_clean();

$query = "INSERT INTO pictures ( username, photo, rawdata ) VALUES ( :user, :photo, :raw ) ";

$query_params = array(
    ':user' => $user,
    ':photo' => $imagevariable,
    ':raw' => $_POST['picture']
);

try {
    $stmt   = $db->prepare($query);
    $result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
    $response["success"] = 0;
    $response["message"] = "Database Error. Couldn't add post!";
    die(json_encode($response));
}
$response["success"] = 1;
$response["message"] = "Picture Successfully Added!";
echo json_encode($response);

} else {
}
?>

- JeffK

---

rawdata 在 MySQL 中被设置为什么类型的值？是 Blob 还是其他类型？ - Pitchinnate

我正在使用原始数据来确认它从应用程序一直到数据库。rawdata只是一个文本行，并存储了base64数据。在我解码和存储图像之后，我不再需要它。这只是为了测试。 - JeffK

如果有人能够指导我，我也很乐意使用MultipartEntity。我原以为解码这个base64会更容易些。 - JeffK

请确保如果您在实时环境中使用它，它非常不安全，基本上可以将所有内容注入到图像字符串的base64版本中。 - Feras

Answer 1

我想发布我的解决方案，以防其他人在处理此问题时遇到困难。我总是来S.O.寻找答案，现在轮到我帮助别人了。我在使用位图时遇到内存不足的问题。我将其更改为多部分上传，将图片作为文件和字符串上传，例如他们的名称，但您可以添加任何字符串。第一部分是Android端，下面是用于数据库的PHP代码。图片被添加到目录中的文件中，使用移动文件方法。数据库存储该图片的路径。我花了两天时间从Stack Overflow的文章中拼凑出来。

public void onClick(View v) {
    if (v.getId() == R.id.capture_btn) {
        try {

            Intent intent = new Intent(MediaStore.ACTION_IMAGE_CAPTURE);
            startActivityForResult(intent, CAMERA_IMAGE_CAPTURE);

        } catch (ActivityNotFoundException anfe) {

            String errorMessage = "Whoops - your device doesn't support capturing images!";
            Toast toast = Toast.makeText(this, errorMessage,
                    Toast.LENGTH_SHORT);
            toast.show();

        }

    }
}

@Override
protected void onActivityResult(int requestCode, int resultCode, Intent data) {
    super.onActivityResult(requestCode, resultCode, data);
    if (requestCode == CAMERA_IMAGE_CAPTURE
            && resultCode == Activity.RESULT_OK) {
        getLastImageId();

        new PostPicture().execute();
    }
}

private int getLastImageId() {
    // TODO Auto-generated method stub
    final String[] imageColumns = { MediaStore.Images.Media._ID,
            MediaStore.Images.Media.DATA };
    final String imageOrderBy = MediaStore.Images.Media._ID + " DESC";
    Cursor imageCursor = managedQuery(
            MediaStore.Images.Media.EXTERNAL_CONTENT_URI, imageColumns,
            null, null, imageOrderBy);
    if (imageCursor.moveToFirst()) {
        int id = imageCursor.getInt(imageCursor
                .getColumnIndexOrThrow(MediaStore.Images.Media._ID));
        fullPath = imageCursor.getString(imageCursor
                .getColumnIndex(MediaStore.Images.Media.DATA));
        Log.d("pff", "getLastImageId: :id " + id);
        Log.d("pff", "getLastImageId: :path " + fullPath);
        return id;

    } else {
        return 0;
    }
}

class PostPicture extends AsyncTask<String, String, String> {

    @Override
    protected void onPreExecute() {
        super.onPreExecute();
        pDialog = new ProgressDialog(MainScreen.this);
        pDialog.setMessage("Uploading Picture");
        pDialog.setIndeterminate(false);
        pDialog.setCancelable(true);
        pDialog.show();

    }

    @Override
    protected String doInBackground(String... args) {
        // TODO Auto-generated method stub
        // Check for success tag

        HttpClient client = new DefaultHttpClient();
        HttpPost post = new HttpPost("http://www.your-php-page.php");

        try {

            MultipartEntity entity = new MultipartEntity(
                    HttpMultipartMode.BROWSER_COMPATIBLE);
            File file = new File(fullPath);
            cbFile = new FileBody(file, "image/jpeg");
            Log.d("sending picture", "guest name is " + guest_name);
            Log.d("Sending picture", "guest code is " + guest_code);
            entity.addPart("name",
                    new StringBody(guest_name, Charset.forName("UTF-8")));
            entity.addPart("code",
                    new StringBody(guest_code, Charset.forName("UTF-8")));
            entity.addPart("picture", cbFile);
            post.setEntity(entity);

            HttpResponse response1 = client.execute(post);
            HttpEntity resEntity = response1.getEntity();
            String Response = EntityUtils.toString(resEntity);
            Log.d("Response", Response);

        } catch (IOException e) {
            Log.e("asdf", e.getMessage(), e);

        }
        return null;

    }

    protected void onPostExecute(String file_url) {
        // dismiss the dialog once product deleted
        pDialog.dismiss();
        if (file_url != null) {
            Toast.makeText(MainScreen.this, file_url, Toast.LENGTH_LONG)
                    .show();
        }

    }
}

这是关于PHP的内容。同时请注意，我包含了我的数据库登录页面。你可以在这里输入你的数据库密码并登录，但我选择不这样做。

<?php
require("config.inc.php");
if (!empty($_POST)) {

if (empty($_POST['name'])) {
    $response["success"] = 0;
    $response["message"] = "Did not receive a name";
    die(json_encode($response));        
} else {
    $name = $_POST['name'];
}


if (empty($_FILES['picture'])) {
    $response["success"] = 0;
    $response["message"] = "Did not receive a picture";
    die(json_encode($response));        
} else {
    $file = $_FILES['picture'];
}


    $target_path = "uploads/whatever-you-want-it-to-be/";
            // It could be any string value above

    /* Add the original filename to our target path.  
    Result is "uploads/filename.extension" */
    $target_path = $target_path . basename( $_FILES['picture']['name']); 

    if(move_uploaded_file($_FILES['picture']['tmp_name'], $target_path)) {
        echo "The file ".  basename( $_FILES['picture']['name']). 
        " has been uploaded";
    } else{
        $response["success"] = 0;
        $response["message"] = "Database Error. Couldn't upload file.";
        die(json_encode($response));
    }

} else {
    $response["success"] = 0;
    $response["message"] = "You have entered an incorrect code. Please try again.";
    die(json_encode($response));
}

$query = "INSERT INTO name-of-table ( directory, name, photo ) VALUES ( directory, :name, :photo ) ";

$query_params = array(
    ':directory' => $directory,
    ':name' => $name,
    ':photo' => $_FILES['picture']['name']
        );

try {
    $stmt   = $db->prepare($query);
    $result = $stmt->execute($query_params);
}
catch (PDOException $ex) {
    $response["success"] = 0;
    $response["message"] = "Database Error. Couldn't add path to picture";
    die(json_encode($response));
}
$response["success"] = 1;
$response["message"] = "Picture Successfully Added!";
die (json_encode($response));


}

?>

- JeffK

---

你能展示一下你的代码剩余部分吗？MultipartEntity和FileBody是什么，这些都出错了吗？谢谢！ - Lion789

@Lion789 你可能没有传递正确的文件。上面的代码已经完整，除了定义文件和字符串之外。你能否在一个新问题中发布你的代码并将链接发送给我？我会尽力帮助！ - JeffK

这是我正在犹豫的问题，尝试使用异步与图像上传到Web服务器Android的不同方式：http://stackoverflow.com/questions/21192778/trying-to-use-async-with-image-upload-to-webserver-android - Lion789

谢谢你的回答。 - SteveTz