Sqlite-php reads remote images and saves them locally

{Code...} cannot be saved when the code above is inserted.

$ Handle = fopen ('HTTP: //... image address ', 'R'); $ content = ''; while (! Feof ($ handle) {$ content. = fread ($ handle, 8080);} fclose ($ handle); $ SQL = "INSERT INTO chat_msg (data) VALUES ('$ content ')";

The preceding Code cannot be saved during insert.

Reply content:

$ Handle = fopen ('HTTP: //... image address ', 'R'); $ content = ''; while (! Feof ($ handle) {$ content. = fread ($ handle, 8080);} fclose ($ handle); $ SQL = "INSERT INTO chat_msg (data) VALUES ('$ content ')";

The preceding Code cannot be saved during insert.

Are you sure you want to save it as base64 .....
A local folder should exist.
Directly use write

Why do we need to save images without addresses?

Binary Storage

Maybe you$contentThe size exceedsdataSize of field settings (or default)

Isn't all the images stored in the database store an image address ???

According to the code above, $ content is a binary file, and the strlen length is estimated to exceed 20 thousand. It is estimated that it exceeds the limit for inserting fields in your database.
I think you should first download and save the image to your local machine, and the database only needs to store the image path. At present, you have not seen the practice of directly storing the file in data.

I wiped it. I have to say that it is SB.
Please don't get angry. Let me hear it.

$ Data = file_get_contents ('image URL '); file_put_contents ('image storage path and filename'); // For example, file_put_contents ('. /download/test.jpg ', $ data); // then, the database can store the image storage address, for example: $ SQL = "INSERT INTO chat_msg (data) VALUES ('Download/test.jpg ')";

Of course, each file name stores a different file name. If you want to name it yourself, I will not explain it more.