Image storage - php mysql stores base64 images
In the HTML5 canvas, I used a third-party control for making emoticon packages, and now I want to upload the completed emoticon package to the mysql database. Whether you upload it to a local server and then store the file address in the database, or use it in blob form, you can do it. Please tell me how to do it. I use canvas.todataurl to convert the image into base64 encoding, then use ajax to send the encoding to the stored page, and use $_POST["image"] to obtain the base64 encoding. I don't want to directly input the base64 encoding into the database because it is too big, but I don't know how to use PHP to convert the BASE64 encoding of the image into a BLOB. Can I convert the encoding into an image and then upload the image directly to the database? But I remember that file_get_content seems to be only available locally and not on the server. The following is the base64 encoding code I currently use to get the image
$data = $_POST["image"];
$data = str_replace('data:image/png;base64,', '', $data);
$data = str_replace(' ' ,' ',$data);
$data = base64_decode($data);
No matter what method is used, as long as the base64-encoded image can be entered into the database
