Image Upload

Peer,
you can store files in database with their names. This will prevent file types from changing.
Select Database file option for your field in both "View as" and "Edit as" columns on the Formatting tab in PHPRunner. Then click in "View format" column and select a field to store filenames.

Do i add the extenstions, ie *.pdf or .pdf or pdf??

Thanks

Peer

I followed your directions and answered my own question...

sorry. please disregard previous post

peer

Hi, I'm new to PHPRunner and am trying to impress my Boss with it's merits, I am also new to SQL too, so bare with me!
I see the way to show an image as described above, but when I choose "View Format" the drop-down list is blank. I realise this is probably just my ignorance with such things but do I have to have a field prepared in MySQL already for this, if so what format should it take?
Thanks for your help.

Database: MySql: PHPRunner: Image: Upload: How to upload images in your database with PHPRunner?

http://www.faqts.com/knowledge_base/view.p.../35994/fid/1805

But if you only have to store a filename, I think, you could maybe use something like:
--- cut here: begin --------------------------------------------------
CREATE TABLE `table1` (

`PhotoFilename` VARCHAR(100) NOT NULL DEFAULT ''

);
--- cut here: end ----------------------------------------------------

Note:
Here the '' after DEFAULT, are actually 2 single quotes,

so better copy/paste if necessary:
`PhotoFilename` VARCHAR(100) NOT NULL DEFAULT ''

russ,
to store images in database you only need to select "View as" and "Edit as" types Database image on Formatting tab in PHPRunner.

Thanks to both of you for your prompt reply, I used the link to create the table and fields and then followed the instructions above for the PHPRunner bit and now have working images.

Sorry to be cheeky but, next question is how could I allow users to enlarge the image in a seperate window by clicking on it? If this is an extremely lengthy PHP script then don't worry about replying, I'll figure it out!

I realise this is slightly outside the job of PHPRunner and therefore not neccessarily the right place to post the question!
Thanks again for both your help <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=4452&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

What I think I would do in this case is............

Create two image uploads............

A thumbnail............... and a full size image
Then (outside of PHP runner I suspect) I would hand code the link on the thumbnail to open the full size image.....
Just a thought....
Peer

Thank-you for your help.

Due to the friendly and quick responses on the forum and being impressed with the program I have now purchased it to build our new database with.

So thanks to all for the customer service! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=4486&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />