thomas heckmann

Hi everybody,

I'm not shure if this is the right place, so directions to another newsgroup
are welcome.

I run a website that offers audioclips for download (http://port5.de if
you're interested) and would like to create a 'charts' database. Obviously,
it is important to capture whether a download has been completed ´(as
opposed to canceled), because this means the user liked the clip well enough
to listen to the end.

I found a way to make a db entry when the download starts via PHP, but PHP
cannot handle events (like document loaded). Javascript could do this, but
this cannot access a database. I could write a java class for the db access
and trigger that via javascript, but this would require the jdbc driver on
the client side, and I cannot assume my users have one and I don't want to
confuse them with download messages for .jar-files.

So what would the enlighted round of experts suggest as the appropriate tool
for this task (that I considered trivial two days ago) ?

Thanks

Tommi

P.S.: I usually write C++ for embedded systems so maybe this question *is*
silly for you ;o)

thomas heckmann

Hi everybody,

I'm not shure if this is the right place, so directions to another newsgroup
are welcome.

I run a website that offers audioclips for download (http://port5.de if
you're interested) and would like to create a 'charts' database. Obviously,
it is important to capture whether a download has been completed ´(as
opposed to canceled), because this means the user liked the clip well enough
to listen to the end.

I found a way to make a db entry when the download starts via PHP, but PHP
cannot handle events (like document loaded). Javascript could do this, but
this cannot access a database. I could write a java class for the db access
and trigger that via javascript, but this would require the jdbc driver on
the client side, and I cannot assume my users have one and I don't want to
confuse them with download messages for .jar-files.

So what would the enlighted round of experts suggest as the appropriate tool
for this task (that I considered trivial two days ago) ?

Thanks

Tommi

P.S.: I usually write C++ for embedded systems so maybe this question *is*
silly for you ;o)

nathanz

I don't know now you can trigger Javascript once a file is downloaded,
but assuming you can, you can just make an http call to a Java servlet
or PHP (*shudder*) script. That servlet can update your database,
then redirect to... what ever you want.

Personally, I wouldn't bother with all this. Just update your
database when they start the download. If the download fails or the
user cancels it, who cares? They obviously _wanted_ to listen to the
song, so it makes sense that it counts on your charts.

//Nathan

thomas heckmann

Thanks!
I'l try to follow your advice and see where it takes me. I hope I find a way
without much screen change.
For triggering I thought about the "onload" handler of the document (or
window).
But I think it is necessary to count only the completed downloads, because
when the user starts the download he doesn't know anything about the song.
So when he listens and cancels after a few seconds because he doesn't like
it, this sure doesn't deserve points for the charts ;o)
.... not that it was that important!

Tommi

"Nathan Zumwalt" <nathanz@hotmail.com> schrieb im Newsbeitrag
news:521673fd.0405030813.a1fc72@posting.google.com ...


*is*

nathanz

I don't know now you can trigger Javascript once a file is downloaded,
but assuming you can, you can just make an http call to a Java servlet
or PHP (*shudder*) script. That servlet can update your database,
then redirect to... what ever you want.

Personally, I wouldn't bother with all this. Just update your
database when they start the download. If the download fails or the
user cancels it, who cares? They obviously _wanted_ to listen to the
song, so it makes sense that it counts on your charts.

//Nathan

thomas heckmann

Thanks!
I'l try to follow your advice and see where it takes me. I hope I find a way
without much screen change.
For triggering I thought about the "onload" handler of the document (or
window).
But I think it is necessary to count only the completed downloads, because
when the user starts the download he doesn't know anything about the song.
So when he listens and cancels after a few seconds because he doesn't like
it, this sure doesn't deserve points for the charts ;o)
.... not that it was that important!

Tommi

"Nathan Zumwalt" <nathanz@hotmail.com> schrieb im Newsbeitrag
news:521673fd.0405030813.a1fc72@posting.google.com ...


*is*