如何将图像上传到离子4中的数据库MYSQL?
问题描述:
I hope you can help me I want to insert the name of the image in my database as well as upload the file to my server PHP but I have no idea how to do it.
我希望你能帮助我我想在我的数据库中插入图像的名称以及上传文件 到我的服务器PHP,但我不知道该怎么做。 p> div>
答
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);