Taking picture and writing to mysql database with blob format does not work

marcus_vinicius · August 31, 2021, 5:39pm

Hello friends, I’m trying to record an image taken from my cell phone camera in my mysql database, in blob format, unfortunately I followed the guidelines https://community.appinventor.mit.edu/t/mysqli-upload-and-save-image- file-as-blob-postfile-posttext/8302/2 worked perfectly for android v8, versions 10 and later does not record, only recording in the database is 10kb could someone help me to solve this problem?

follow the blocks of my code

ids 99-100-101 were recorded using android version 8

the other lines were tested with later androids

Rogerio_Rios · August 31, 2021, 7:30pm

It looks like you’re just sending the filename because you can’t find it in the right path

marcus_vinicius · August 31, 2021, 7:35pm

rs… to apanhando, eu segui essa orientação que vc tinha postado…

segui esse código em php também.

I followed this code in php too.

I’m kind of lost… “crazy” hahaha

Rogerio_Rios · August 31, 2021, 7:41pm

Please , Read PM And topics above.

It will guide you to find the solution.

marcus_vinicius · August 31, 2021, 7:43pm

This post was flagged by the community and is temporarily hidden.

marcus_vinicius · September 1, 2021, 7:24pm

Hello rogério , I think I managed to record the image in the camera after picture, I’m doing other tests with the backend module developed in C # so if it’s ok, I’ll pass it on. Thank you very much.

the data with 10 bytes were tests I performed with the empty image

Rogerio_Rios · September 1, 2021, 7:40pm

Note the folders that are saved on different android versions…

marcus_vinicius · September 1, 2021, 7:47pm

I used the filetools extension to create a folder after pressing the take photo button.
I’m going to finish testing the module in C# and I’ll let you know.

marcus_vinicius · September 2, 2021, 1:50am

Good night, one more detail for not recording the image in mysql. I performed the tests version 10 and earlier records perfectly, now I need to find out what permission I need for version 11. I’ll keep studying

version 11 writes 10 bytes… and version <=10 writes perfectly.

tks

marcus_vinicius · September 4, 2021, 11:21am

Good morning Chinmay Only, are you able to upload an image with the new asd ? I’m having some trouble inserting an image into my mysql using php, have you seen this?

Chinmmay_Samant · September 4, 2021, 11:21am

can you explain your issue @marcus_vinicius

Chinmmay_Samant · September 4, 2021, 11:26am

This post was flagged by the community and is temporarily hidden.

marcus_vinicius · September 4, 2021, 11:43am

thank you very much, i will upload my blocks for you to analyze …

Chinmmay_Samant · September 4, 2021, 11:44am

can you give an image

marcus_vinicius · September 4, 2021, 11:45am

I’m separating now.

marcus_vinicius · September 4, 2021, 11:47am

I really need it, this code works on versions 10 and earlier, only on version 11 does not write to the database.

[image]

Chinmmay_Samant · September 4, 2021, 11:49am

this seems correct the code

marcus_vinicius · September 4, 2021, 11:52am

the bytes are low, only when I run the application on android 11, versions smaller than 11 record perfectly.

I’m sorry I’m studying I’m still a beginner in kodular programming, I’m a c# developer

**

deanart2012 · September 4, 2021, 11:53am

In future if you ask a question please don’t start spamming the topic asking for a reply if no one has responded. I see you do this a lot in each of your topics. Just be patient, no one here is your slave.

marcus_vinicius · September 4, 2021, 11:53am

yes, that’s correct, when I run on android 11 it doesn’t record. exactly what I’m not understanding. I’m getting a little crazy from so much research