Update image path in MySQL php
<p>Can someone please help me ? How can I update an image path ?</p>

<p>I have successfully store the image path  and text into MySQL, and image in the folder.</p>

<p>This is the <code>php</code> code I use to upload image path and text.</p>

<p><a href="https://i.stack.imgur.com/20b0n.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/20b0n.png" alt="enter image description here"></a></p>

<pre><code> &lt;?php
        if( $_SERVER['REQUEST_METHOD']=='POST' ){
            if( !empty( $_POST['listItems'] ) ){
                $listItems = json_decode( $_POST['listItems'], true ); 
                $mysqli = new mysqli("127.0.0.1:3307", "root", "", "androiddb");
                if( $mysqli-&gt;connect_errno ) echo "Failed to connect to MySQL";
                $sql="INSERT INTO `staff_benefit` 
                     ( `type`, `amount`, `description`, `image`, `ts_id` ) 
                      VALUES ( ?, ?, ?, ?, ? )";
                if($stmt=$mysqli-&gt;prepare($sql )){
                    $url="http://192.168.1.7:80/Android/CRUD/PhotoUpload/";
                    foreach( $listItems as $item ){ 
                        $id = uniqid();
                        $image_name = $id.".png";
                        $save_path = 'PhotoUpload/'.$image_name;
                        $image_url = $url.$image_name;
                        $bytes=file_put_contents($save_path, base64_decode($item['image']));
                        if( !$bytes ){
                            echo 'Error saving image';  
                        }else{
                            $stmt-&gt;bind_param('sssss', 
                            $item['type'], 
                            $item['amount'], 
                            $item['description'], 
                            $image_url, 
                            $item['ts_id'] );
                            if( !$res=$stmt-&gt;execute()){ 
                                echo 'Query failed with code: '.$stmt-&gt;errno;
                            }
                        }
                    } 
                }
                $mysqli-&gt;close();
            }
        }
    ?&gt;
</code></pre>

<p>But when I tried to update the row in android, the image path will change from <code>http://</code> to <code>/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAEBAQEBAQEBAQEBAQ..</code> as image below.</p>

<p><a href="https://i.stack.imgur.com/HVFA4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HVFA4.png" alt="enter image description here"></a></p>

<p>This is my update <code>php</code></p>

<pre><code>  &lt;?php 
    if($_SERVER['REQUEST_METHOD']=='POST'){
        //Getting values 

        $id = $_POST['id'];
        $type = $_POST['type'];
        $amount = $_POST['amount'];
        $description = $_POST['description'];

        //importing database connection script 
        require_once('dbConnect.php');

        if(isset($_POST['image']))
        {
            $image=$_POST['image'];
            $id = uniqid();
            $url="http://192.168.1.7:80/Android/CRUD/PhotoUpload/";
            $image_name = $id.".png";
            $save_path = 'PhotoUpload/'.$image_name;
            $image_url = $url.$image_name;
            $bytes =file_put_contents($save_path, base64_decode($_POST['image']));
              $sql = "UPDATE staff_benefit SET type = '$type', amount = '$amount', description='$description', image='$image' 
                WHERE id = '$id'";
        }
        else{

             $sql = "UPDATE staff_benefit SET type = '$type', amount = '$amount', description='$description'
                  WHERE id = '$id'";

        }

        //Updating database table 
        if(mysqli_query($con,$sql)){
            echo ' Updated Successfully';
        }else{

            echo mysqli_error($con);
            exit;
        }

        //closing connection 
        mysqli_close($con);
    }
?&gt;
</code></pre>

<p><strong>Update code</strong></p>

<pre><code>     public void update( final String claimType,  final String Amount, final String Description, final Uri imageUri)
        {
               class updateImageAndText extends AsyncTask&lt;Void,Void,String&gt;{
                  // ProgressDialog loading;
                   @Override
                   protected void onPreExecute() {
                       super.onPreExecute();
                      // loading = ProgressDialog.show(Edit_Staff.this,"Updating...","Wait...",false,false);
                   }

                   @Override
                   protected void onPostExecute(String s) {
                       super.onPostExecute(s);
                      // loading.dismiss();
                       Toast.makeText(getApplicationContext(), s, Toast.LENGTH_LONG).show();
                       try {
                           Intent returnIntent = new Intent();
                           returnIntent.putExtra("ClaimType", claimType);
                           returnIntent.putExtra("Amount", Amount);
                           returnIntent.putExtra("Description", Description);
                           returnIntent.putExtra("photo", imageUri.toString());
                           setResult(Activity.RESULT_OK, returnIntent);
                           finish();
                       }catch(Exception e)
                       {

                       }
                   }

                   @Override
                   protected String doInBackground(Void... params) {
                       HashMap&lt;String,String&gt; hashMap = new HashMap&lt;&gt;();
                       hashMap.put(Configs.KEY_ID, String.valueOf(ID));
                       Log.e("ID", ID + "");
                       hashMap.put(Configs.KEY_TYPE, claimType);
                       hashMap.put(Configs.KEY_AMOUNT, Amount);
                       hashMap.put(Configs.KEY_DESCRIPTION, Description);
                       if(imageUri != null){
                           Log.d("log", "photo " + imageUri);
                           hashMap.put(Configs.KEY_IMAGE,getStringImage(imageUri));
                       }else{
                           Log.d("log", "photo is null " );
                       }
                       RequestHandler rh = new RequestHandler();
                       String s = rh.sendPostRequest(Configs.URL_UPDATEDE_IMAGE_TEXT,hashMap);
                       return s;
                   }
               }

            updateImageAndText ue = new updateImageAndText();
            ue.execute();
        }


  public String getStringImage(Uri imgUri) {

        try {
            Bitmap bitmap = MediaStore.Images.Media.getBitmap(getContentResolver(), imgUri);
            ByteArrayOutputStream baos = new ByteArrayOutputStream();
            bitmap.compress(Bitmap.CompressFormat.JPEG, 100, baos);
            byte[] imageBytes = baos.toByteArray();
            String encodedImage = Base64.encodeToString(imageBytes, Base64.DEFAULT);
            return encodedImage;
        } catch (Exception e) {
        }

        return "";
    }
</code></pre>

<p>How can I update the image path ? Thanks a lot !  </p>

<p><strong>Error</strong></p>

<p><a href="https://i.stack.imgur.com/BmRNW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BmRNW.png" alt="enter image description here"></a></p>