placing uploaded photos in your site

dannysheps@hotmail.com · #1 04-01-2008, 12:19 PM

Hello
my site is running with information stored in DATABASE and is populated with PHP and MYSQL. http://www.brasilwebdesign.com/class...assifieds.html

is there a way with ABVFP to let the user upload a photo with the rest of the information and when it showing(quering ) the information back to the page it will quuer the uploaded photo as well ?

im asking that because i understand that the up loaded photo is going to a folder (uploaded) and not to the database

thanks alot

dannysheps@hotmail.com · #2 04-01-2008, 02:20 PM

a bit more....
now i understand that it IS better to store in the database only the "link" (the address) of the folder that contains the pictures.

how do i do that ? how can i add to the form php code the command to open a new colum (pic_location) that when i want to queir the users information it will automaticly show the pics in the page also

thanks again

Watdaflip · #3 04-01-2008, 03:51 PM

Actually if the file sizes are small you could also store them in a database, but thats too in depth to give instruction for that on the forum.

I can't really say how you will do this with ABVFP, I am not familiar with the inner workings of that script, but basically when you upload a file a function is called to move the file from the temporary location the upload is stored, to some location on your webspace to be saved for later use. You just have to save that file path in the database for it can later be retrieved.

I don't believe ABVFP has a feature to display the data from the database (although I could be wrong, as I said I have never used it). You may want to spend some time learning how to query a database for data and display it.
check out
http://w3schools.com
http://tizag.com

navaldesign · #4 04-01-2008, 04:23 PM

Since ABVFP was not planned to do what you want (the next version will have as User Options: Email the files, Email only the path to the files, Store the files in the Database, Store the Path to the files ) you should modify its code. Find this line:

for ($i = 0; $i < (count($ndfieldname) - count($upload_Name)); $i++) {

and make it:

for ($i = 0; $i < (count($ndfieldname)); $i++) {

This should be enough. The value stored in the database will be the full path (URL) of the uploaded files.

navaldesign · #5 04-01-2008, 04:27 PM

To display the images, you have two options:

1. Retrieve the data from the database as string, and simply echo the string. This will allow you to display the image excactly in it's original dimensions.

2. OR, use a resizing script to define allowable maximum dimensions, and have the script resize and display the pictures in the desired dimensions.

dannysheps@hotmail.com · #6 04-01-2008, 04:43 PM

wow...

thanks alot!!

dannysheps@hotmail.com · #7 04-01-2008, 05:06 PM

hi again
did what u said
and in the DB colum it still shows "NULL"
i named the upload box "upload" i see a colum named "uipload"
but now path to the file there

any help ?

navaldesign · #8 04-01-2008, 05:07 PM

Please note that the line to edit exists in two locations, you need to edit it in both. Change it and try again.

dannysheps@hotmail.com · #9 04-01-2008, 05:31 PM

found the two...
changed them

and nop it still show's NULL in the "upload" colum

the colum feild :
feild : upload
type :VARCHAR
lenght/value : 250
Null :null
Default :NULL

maybe we need to add/change other things ?

navaldesign · #10 04-01-2008, 05:36 PM

No. This is tested and works. Please wait 5 minutes and then download again the entire ABVFP zip. replace the file dbts_abvfp.php with the new one, and test again.

dannysheps@hotmail.com · #11 04-01-2008, 05:37 PM

browse button HTML :
<input type="file" id="FileUpload1" size="27" name="upload">

submit button HTML:
<input type="submit" id="Button2"" name="submit" value="submit">

MAYBE HERE IT WRONG ?

navaldesign · #12 04-01-2008, 06:21 PM

How you have named your fields is NOT important. ABVFP automatically recognizes the fields and creates the necessary DB columns.

Did you download the zip again, and replaced the file, as i suggested ?

dannysheps@hotmail.com · #13 04-01-2008, 07:41 PM

hi
yeap i did what u told me , ITS WORKING FINE now

just one questiuon ,

how come now i didnt see the two location that i neede dto change the line code ?

anyways , thanks alot !!

navaldesign · #14 04-01-2008, 07:45 PM

Because when i posted the above post, i edited the code myself and uploaded it, so the code you got was already edited.

dannysheps@hotmail.com · #15 04-01-2008, 08:00 PM

hi
i found a bug in your new code
it put in the DB the path but with out ":" after http

and when i echoing the image it doesnt work

can we fix it ?

navaldesign · #16 04-01-2008, 08:23 PM

What you are saying is not possible, as it does not depend on my code. Probably you have set (in the ABVFP control panel) the upload folder to be missing the : . It is not ABVFP, it is your settings. Check it.

dannysheps@hotmail.com · #17 04-01-2008, 08:29 PM

yeah you are right...again

but when im trying to add the ":" and save im getting an error :
The field Mail Subject is empty !

but with that , last time, you told me we can leave it empty

any help ?

dannysheps@hotmail.com · #18 04-01-2008, 08:34 PM

and can you remind me (cus i cant find that thread) how to get rid of the date day in the begining , that it will simply show me just numbers

instead of APRIL/1/2008

01/04/2008

thanks

navaldesign · #19 04-01-2008, 08:43 PM

Your needs are different than those of the normal users. So the script (which, in the man time has been updated more than 6 times!!) normally asks for an Emaill address and subject.I have told you to ONLY replace one file,you probably replaced all!! Among them the file dbts_ABVFP_formsetup.php . This is the file that performs input validation and will accept or not user (your) input. Obviously you replaced it with the uploaded version, so it gives you the error.

However, if the script is set NOT to send email 8because you have not provided an email address) just type ANYTHING there, it is not important since no mail is sent.