Answered
Uploading/ Inserting image file URL
running on LAMP.
After finding out that it is best to 'store' images as an address url link rather than in binary in the database itself, I have re-configured the filed definition to VARCHAR and entered some test addresses.
The I have put in a 'logos' directory under the root which will hold all the image files themselves.
I have then managed to get the results php pages to take the url address and display it as an image..
Going great so far.... Here's the crunch..
For both insert and update pages, I have used a form file field which browses the location and inserts it into the field - this does return an address into the field but when it submits, it doesn't save the image data. (Everything else does update OK). In fact, it seems to overwrite with a null value.
I have checked the insert and update behaviours but cannot find where I'm going wrong.
Field code:
<input name="LOGO" type="file" id="LOGO">
Update/Insert code:
GetSQLValueString($HTTP_POST_VARS['LOGO'], "text"),
After finding out that it is best to 'store' images as an address url link rather than in binary in the database itself, I have re-configured the filed definition to VARCHAR and entered some test addresses.
The I have put in a 'logos' directory under the root which will hold all the image files themselves.
I have then managed to get the results php pages to take the url address and display it as an image..
Going great so far.... Here's the crunch..
For both insert and update pages, I have used a form file field which browses the location and inserts it into the field - this does return an address into the field but when it submits, it doesn't save the image data. (Everything else does update OK). In fact, it seems to overwrite with a null value.
I have checked the insert and update behaviours but cannot find where I'm going wrong.
Field code:
<input name="LOGO" type="file" id="LOGO">
Update/Insert code:
GetSQLValueString($HTTP_POST_VARS['LOGO'], "text"),
AdChoices