Selecting part of an image and storing it in an ODBC data source

[Al Findlay]

Hello!

What I need to do is this:

"On the fly"....

1. Select part of an image provided by the user (i.e. define a
thumbnail)
2. Store this 'thumbnail' in an OLE field in an ODBC database (created
in Access 2000)
3. Be able to retrieve this thumbnail from the OLE field at a later
date and display it.

I realise that this is quite an involved problem but I would be very
grateful for any parts of the solution, if not all, as I am currently
new at php...

Thanks very much!

Al

[Jon Beckett]

Re: Selecting part of an image and storing it in an ODBC data source

On 20 Sep 2004 07:12:22 -0700, alistair.findla y@gmail.com (Al Findlay)
wrote:
[color=blue]
>What I need to do is this:
>
>"On the fly"....
>
>1. Select part of an image provided by the user (i.e. define a
>thumbnail)
>2. Store this 'thumbnail' in an OLE field in an ODBC database (created
>in Access 2000)
>3. Be able to retrieve this thumbnail from the OLE field at a later
>date and display it.
>
>I realise that this is quite an involved problem but I would be very
>grateful for any parts of the solution, if not all, as I am currently
>new at php...[/color]

I fear you may find you're not going to get very far asking for
solutions like this. Most people have spent a great deal of time
*learning* PHP for themselves, and get a bit annoyed when people turn
up and say "I want to do XYZ... how do I do it?"

The PHP website is very good for finding your way around the language,
and the O'Reilly PHP books are very good to get you started.



Jonathan Beckett (jonbeckett@plu ggedout.com)
working on : http://www.pluggedout.com/penpals

[Al Findlay]

Re: Selecting part of an image and storing it in an ODBC data source

Jon Beckett <jonbeckett73@y ahoo.co.uk> wrote in message news:<35fuk09ib 9ifhao0vpac7g3r dtbdsq8jbv@4ax. com>...[color=blue]
> On 20 Sep 2004 07:12:22 -0700, alistair.findla y@gmail.com (Al Findlay)
> wrote:
>[/color]
[color=blue]
> I fear you may find you're not going to get very far asking for
> solutions like this. Most people have spent a great deal of time
> *learning* PHP for themselves, and get a bit annoyed when people turn
> up and say "I want to do XYZ... how do I do it?"
>[/color]

True - this is why I said part of the solution would also be
appreciated. I've always found learning by an example that gets
striaght to the point a lot easier than trawling through books and
tutorials.

Maybe I'm just lazy ;)

Al

[Geoff Berrow]

Re: Selecting part of an image and storing it in an ODBC data source

I noticed that Message-ID:
<eefb8ab9.04092 00612.c2b9d03@p osting.google.c om> from Al Findlay
contained the following:
[color=blue]
>1. Select part of an image provided by the user (i.e. define a
>thumbnail)[/color]

Where will it be defined? Will it be the same for each one? Simple
resizing is quite easy.
[color=blue]
>2. Store this 'thumbnail' in an OLE field in an ODBC database (created
>in Access 2000)[/color]

No need. Save it as a file and simply put the file name in the
database.

Also...you'll find that the lack of a LIMIT command can make the SQL
more complicated. Consider MySql and phpMyadmin.


[color=blue]
>3. Be able to retrieve this thumbnail from the OLE field at a later
>date and display it.[/color]

Simply retrieve the filename as a variable, stick it into an <img> tag
and Robert is your mother's brother.

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/