/    Sign up×
Community /Pin to ProfileBookmark

uploadin file to data base

Copy linkTweet thisAlerts:
Feb 09.2005

Hi all,

I am uploading a file which contains more than 1MB size..but iam unable to upload this one.. i came to know that we have to change the storage settings..but exactly iam not sure that where we can do all these things..iam using php page for uploading this file and using longblob as datatype..and mysql database..

remark: iam changedthe max_file _upload in php.ini to mor than 1M

can anybody help me in this issue..

Thank you very much

to post a comment
PHP

2 Comments(s) ↴

Copy linkTweet thisAlerts:
@phpnoviceFeb 09.2005 — What I have to say is not directly helpful to what you're trying to do, and it is definitely not exactly what you're wanting to hear, but...

The most efficient use of a database is not the storage of such large binary objects. Others besides myself can tell you to let the native OS file system do that -- as that is something the native OS file system does well. Instead, store just the file path, to the resulting large binary file, in the database. This uses the database for that which it was intended -- the catalogging and efficient organization of raw information.

In short, leave [u][i]file[/i][/u] catalogging and organization to the native OS file system. The datbase is excellent for catalogging and organizing information [u][i]about[/i][/u] that file.
Copy linkTweet thisAlerts:
@ShrineDesignsFeb 09.2005 — well said phpnovice,

database are for data, filesystems are for files, uploading and retrieving files from a database will quickly overload your sql engine resulting in denying connections and slow results
×

Success!

Help @binmadhi spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.18,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...