使用JSON從Android發(fā)送Base64圖像到php webservice,解碼,保存到SQL

印度阿三17 2019-05-20

展開全文

就像描述中說的那樣,我正在Android中拍照.它被壓縮并添加到byte []然后base64encoded.它使用JSON發(fā)送到我的webservice,在那里它“被認為”被解碼并保存在SQL表行中.我可以將編碼的字符串保存在一個單獨的行中,所以我知道它已經(jīng)到了那里.

誰能看到這個并告訴我我做錯了什么？ *抱歉冗長的代碼.如果得到幫助,我不想錯過任何東西！

ANDROID SIDE

@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 SIDE

<?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 {
}
?>

解決方法:

我想發(fā)布我的解決方案,以防其他人遇到麻煩.我總是來到S.O.為了答案所以現(xiàn)在輪到我?guī)椭鷦e人了.使用位圖我遇到了內(nèi)存不足錯誤的問題.我將其更改為多部分帖子,將圖片作為文件和字符串上傳,但您可以添加任何字符串.第一部分是android端,下面是數(shù)據(jù)庫的php.使用移動文件方法將圖片添加到目錄中的文件中.數(shù)據(jù)庫存儲該圖片的路徑.我搜索了兩天,將它們從堆棧溢出的帖子中拼湊起來.

ANDROID

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.p");

        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.另請注意,我正在包含我的數(shù)據(jù)庫登錄頁面.你可以輸入你的d.b.密碼并在這里登錄,但我選擇不這樣做.

<?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));


}

?>

來源：http://www./content-2-199051.html