Querying links stored in database

[kjspear]

I set up a page to store links in a database rather than storing the image. This way I can
save space on the database since the limit is 4GB.

This is what I get as a record in the myimage table;

ID Imagefilepath
2 CHPuploadtempphp36.tmp


Whatdoes CHPuploadtempphph36.tmp mean?

Can this be read? Is this a code to tell php/mysql that the file is located in

$uploaddir = 'c:/mysql/data/mylogin/upimages/'?

What I'm trying to do here is have php read the link in the $uploaddir string and
load the picture on a webpage.

Uploading the image file to the directory stated above works fine.


Any assistance will be helpful.

Thanks
Kyle

 

[sleipnir214]

You can better answer the question of what " CHPuploadtempphph36.tmp" means. Your code put that value there.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[skiflyer]

I agree with sleipnir... but can probably offer you a hint to decode it...

\'s are escape characters... if you only have one they disappear... so that likely means something like

c:\php\upload\temp\php36.tmp

which would imply to me you uploaded a file, but never saved it out to the file system.

-Rob

 

[sleipnir214]

skiflyer:
<sarcasm>
Just so you won't feel all alone while hypothesizing...
</sarcasm>

kjspear:
Judging by the filename you're storing, it may also be possible that instead of storing $_FILES['userfile']['name'] in the database, you're storing $_FILES['userfile']['tmp_name'].

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[kjspear]

O.K., perhaps I wasn't really clear on what I am trying to do, sorry.

Basically, I would like to know how to store a link as described above in a database and retrieve it so that it will point to a directory, which holds the image files. This way I will be able to display the results from the link to a web page.

Any help would be appreciated.

Thanks
Kyle

 

[sleipnir214]

Let's say, for the sake of argument, that the document root of your web site is D:\sites\mysite, and that you're storing your images in one directory, &quot;D:\sites\mysite\images&quot;.

In the database, I'd just store the filename.

In my web script, I would fetch the filename from the database, prepend the necessary path information (in this case, &quot;/images/&quot to the filename, then output that filename as the value of a &quot;SRC&quot; attribute of an &quot;<IMG>&quot; tag.


If instead of storing all the images in one directory, suppose you have three directories, d:\mysite\images\aircraft, d:\mysite\images\boats, and d:\mysite\images\landcraft.

I would store the filename and subdirectory name in the database. For example, to store the filename of a motorcycle, I'd store &quot;landcraft/mycyle.jpg&quot; in the database.

Then in my web script, I would fetch the filename from the database, prepend the necessary path information (in this case, &quot;/images/&quot to the filename, then output that filename as the value of a &quot;SRC&quot; attribute of an &quot;<IMG>&quot; tag.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!