Hi, 2005/8/22, Kane Wilson <[EMAIL PROTECTED]>: > Thanx , as i understood , i have to keet the raw data in folders and has to > be stored that relavent file path's into mysql database, > > so can u kindly tel me , how it is possible to get the file path ( absolute > ot realtive ) of that certain files which are uploaded in to the database > from PHP ? > what is the function i have to use ?
It depends on your application, but you usually choose yourself the location where to move the uploaded file. Usually uploaded file are stored in /tmp temporally : http://uk.php.net/manual/en/function.move-uploaded-file.php Your application move itself the file (hence know the path) and you insert the path in your DB. > > so that's meant i dont try to hard code file path in my program , > > This is not actually mysql question ...........sorry for asking such out of > list questions. > > > Thanx in advance , > Kane. > > Pooly <[EMAIL PROTECTED]> wrote: > 2005/8/20, Kane Wilson : > > > hi Friends, > > > > I have a WAP portal which is running based on mysql database. That's meant > that contents has been stored in the data base. > > wallpapers , themes, ringtones, games .......etc data type as BLOB. upto > now now problems with the content retrieving. WAP site hosted in REDHAT > Linux BOX. > > I will leave my question by point form , > > 1. http://www.zend.com/zend/trick/tricks-sept-2001.php > according to info of this link , it says there is performance issue when > using BLOB for data storing and retriving in mysql and he has recomended > some statndard file sharing / accessing methods to use . for instance samba > or NFS - in linux. > > is this happening in mysql ? does it has a solution in mysql ? what could > be the best way to use mysql to store / retrive my contents via the wap site > ? > > I'm using mysql bcause , keeping data in a database is very easy to do a > site search , rather than keeping contents in folders . > > The approach generally used is to store in your DB, information > concerning your file (its type : ringtones, themes, wallpaper), its > size, keywords and everything you find useful, and then keep the file > on disk (and having its path sotred in the DB as well). You move all > load from serving the files (ringtones, wallpaper) to the FS which > does it very well _and_ can be cached by proxies, browser (less load > for the server). So you an still do a site search since you keep all > the useful information in your DB, but raw data stay on disk. > For example if you need to send a ringtone which is in your DB, the > browsersend the request, Apache receive it, load PHP/Perl, which then > connect to the DB... > If the file is on disk, you remove the last 2 operations which > willmakethe whole operation faster. > > -- > Pooly > Webzine Rock : http://www.w-fenec.org/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]