php - 如何在ionic 4中将图像上传到数据库MYSQL？

Question

我希望你能帮助我我想在我的数据库中插入图像的名称以及将文件上传到我的服务器 PHP 但我不知道该怎么做。

Answer 1

If you aware of things that we always write the images in folder and always keep the unique name of the images in database.This is not the good way to store images in Database. So convert the images in Base64 formate send it to server end(PHP).And see the code to upload images in folder and save unique name in database.

//Call this function after getting base64 by post

$imageBase64=$_POST['image_converted_base64'];//get base64 of image from client end

 $unique_name =uploadSingleImage($imageBase64);//function call

//function to upload image and get an unique name to store in db

    function uploadSingleImage($base64) {

        $uniname = uniqid() . date("Y-m-d-H-i-s") . ".jpg";
        $new_image_url = "../../image/" . $uniname;
        $base64 = 'data:image/jpeg;base64,' . $base64;
        $base64 = base64_decode(preg_replace('#^data:image/\w+;base64,#i', '', $base64));
        file_put_contents($new_image_url, $base64);
        return $uniname;
    }

$sql = "INSERT INTO `table1`(image_name) VALUES('$unique_name')";
$conn->query($sql);