how to convert the picture into a byte stream so that you don"t have to worry about the space taken up by the file to store the picture
how to convert the picture into a byte stream so that you don"t have to worry about the space taken up by the file to store the picture
base64 encode
it seems to me that no one has answered this question properly. I also had this doubt when I was a beginner. Let me answer it.
first of all, do not save pictures in the database. If the field of the data stored in the database is set too large, the database data query will be very slow.
in addition, picture data, you can directly use PHP file_get_contents to get picture information, but if you want to put the picture back, you need to use file_put_contents . In addition, if you put it back, you must name the picture name. You also have to store a lot of picture-related information when you take the picture. I don't think it's necessary to do this.
of course, for images, there is also base64_encode for base64 conversion. In fact, I can tell you that the image storage space will be larger after conversion.
said the above points. Let me tell you what consideration we usually take to store pictures. Usually, we upload images to a path, such as / var/www/statics/test.jpg . What I show here is the absolute path. Generally speaking, we use the relative path or upload the image to the cloud server. If the image is uploaded to a cloud server, the image you may get is in the form of https://img.codeshelper.com/1.jpg.
that is to say, what we store is the path of the picture, whether it's the network path or the absolute path or the relative path, as long as we take the picture path out of the library and find the picture according to the path where the picture is stored, and the path data itself is very small, so we don't need to think too much about getting the original picture through the path, so no one will convert the picture data into bytes and store it in the database.
in addition, I have also seen you say that you do not need to consider the problem of taking up too much space for pictures, but I can tell you clearly here that on the one hand, we write programs to consider convenience and quickly implement certain functions, and at the same time, we also consider performance issues. The ultimate goal of our programs is to serve users, regardless of whether the user is ourselves or the real user who can bring us benefits. So, after the program can be implemented, there is another problem to consider, that is, the performance problem.
so, generally speaking, we want the data stored in the database to be as small as possible.
the database has a heavy load and also takes up server space. How do you save space?
dfdfdfds
Previous: How to create the effect of opening and closing doors by changing the details of the properties
Next: Why a bunch of HTML tags appear in the value of the $_ post superglobal variable
in order to facilitate development, we plan to create a LNMP environment based on docker, which makes it much more convenient to change computers or unify the team s development environment. choreographed a docker-compose.yaml file with nginx, php-fp...
external network access domain name: https: api.baidu.com internal network domain name: http: local.baidu.com this domain name is inaccessible outside the network! It is 127.0.0.1 pointed to by a private network address. I use nginx reverse proxy ...
description: a regular match is given to the content of an input box, and the matching content is the product activation code. looks like this: "0C31-0B81-BB32-3094-0C31-0B81-BB32-3094 " Code: $( -sharplicenseCode ).keyup(function () { le...
I configured the MIME type of the file with the amr suffix in the apache configuration as application ms-download, Why it is a garbled page when opening a file in amr format using window.open in chrome, while a file in amr format can be successfully dow...
what does the code circled in the following picture mean? ...
rewrite rules: RewriteRule (.*) (.*) (.*) index .html index.php?p=$1&c=$2&a=$3 [QSA] access Home Blog blog index.html?page=2 can access index.php?p=Home&c=Blog&c=blog&page=2 normally but when the original link is index.php?p=Home&c=Blog&a...
$selectTip = $pdo->query("SELECT * FROM `tips_rate` WHERE `tip_id` = ".$row[ id ]." " ); $selecttotal = mysqli_num_rows($selectTip); $rate = $pdo->query("SELEC...
the following is the back-end code I think $username= is a randomly generated string in the output, so write $username=$number; like this, but this is an execution error, how to do it? For advice, thank you <?php $username=$_POST[ username ]; $nu...
adopt a reward of 10 yuan, 1045 Access denied for user root @ localhost (using password:NO) recently, when I was at the front end of my self-study, I came into contact with a little bit of database. This happened when I made a new connection on ...
the original domain name of our company s website has expired. I want to change it to another domain name. How can I change it? The website is developed using Aliyun s Yunmeng. ...
post table is the article table, the primary key is id tag table is the tag table, the primary key is id post_tag is the intermediate mapping table, and the field is post_id,tag_id now I want to select tag 1 to find out that all the tags and article...
what happens when you get a list of followers through access_token after getting access_token and show that this operation cannot be performed? $url = "https: api.weixin.qq.com cgi-bin token?grant_type=client_credential&appid=$appid&secre...
In apache,event mode, 8 processes are started. Set to perform 10000 automatic recreations. On the next day, there were only two hundred and three processes. is this the number of processes that apache thinks there are not enough tasks and automaticall...
$first is the data read by the database as shown in figure : read through the database can not change the line, directly written in the code can break the line, solve =! ...
as shown in the figure, the generated url does not have a domain name. Where do I need to configure it? ...
there is an h5 page embedded in the encapsulated APP. After the function of issuing an order, how can I get the user s id to add the address and place the order ...
1. Background of the problem: recently, it has been almost exclusively said on php7, that only php7 compiled with GCC 4.8 will open Global Register for opline and execute_data . 2. Question description: Q: what is 1Global Register for opline and e...
the query data is printed to see that _ id is objectID,. If it is directly converted to json,_id, it will be empty. Can you change objectID to string, and then to json? ...
$result= array(); foreach ($infos as $key => $info) { $result[$info[ time ]][] = $info;}; $results=array_slice($result,0,255); in this code, I want to use array_slice to remove the key value of $result, but I don t use . ...
stateful fields are often saved in the database, which are represented by numbers: 0-> fail reject 1-> success pass and so on, I want to convert 0 or 1 into Chinese characters in the obtained results, is there any good way to quickly complete t...