2. PHPRunner General questions
  3. Help on Thumbnails please
This topic is locked

Help on Thumbnails please

 		11/11/2006 9:53:16 AM
PHPRunner General questions
T
 thesofa author

Hi

Version 3.0
I have searcherd here and found articles and posts on thumbnails, I still cannot get it working properley.

My needs are to be able to upload one or more pictures in jpg format to the mysql server based database.

For each picture uploaded, I would like to be able to see a small (say 100pixel) thumbnail to give a rough idea of content.

I would like to be able to click on the thumbnail in the list view to see the big picture in a new auto sizing window.
To try to get this, I have a field in my database table called Pictures ( I am rarely stuck for an apt name for a field! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3826&image=1&table=forumtopics' class='bbc_emoticon' alt=':D' />)

I have the field set as a mediumblob field.

In PHPR project, I have the field format set as Vies As File based image and edit as Document upload.

The directory is stated for both as `damage` without the quotes.

I have rebuilt the project and altered the XXX_variables.php for the table to

// thumbnails
$thumbnail_fields = array("Pictures");

// $thumbnail_fields = array("Field1","Field2");

// field names are case-sensitive!

$thumbnail_prefixes = array("Pictures"=>"t_");

$thumbnail_maxsize =20;
$ColumnsCount = 1;


I have then uploaded an image through the Add page

On returning to the list page I can see the full size picture in the list page.

This is a little worrying and likel;y to cause screen problems for the users.

Please help me resolve this as it is really bugging me
Alexey admin 11/13/2006

Hi,
change the database field type to VARCHAR and make sure you have Document upload - File-base image Edit and View types for this field in PHPRunner.
If nothing helps you can zip and send to support@xlinesoft.com a full set of generated PHP files along with your database creation script and PHPRunner project file.

I'll find what's wrong with your project running it on my test box.
T
 		thesofa author 11/13/2006

Hi,

change the database field type to VARCHAR and make sure you have Document upload - File-base image Edit and View types for this field in PHPRunner.
If nothing helps you can zip and send tosupport@microsoft.coma full set of generated PHP files along with your database creation script and PHPRunner project file.

I'll find what's wrong with your project running it on my test box.



Are you working for microsoft now?

Please NOOOOOOOOOOOO
How big should the varchar be, is it just enough to hold the filename?
Alexey admin 11/14/2006

I'm sorry, of course I meant support@xlinesoft.com
Yes, it just should be long enough to keep a filename.
T
 		thesofa author 11/14/2006

that is a relief, the thought of you selling out would kill PHPRunner

Thanks for the support, yet again spot on the nose and it is working fine.