Insert into DB on page exit

Pages: 1

Index » Programming Talk & More (Javascript, PHP, Perl, RSS, etc) » Insert into DB on page exit

#1 2006-11-09 20:20:10Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

Hi

I need to insert some data into my DB when the user leaves the page through a link.

Im unable to make any changes to the links or create a redirect for this. (third party, semi encrypted script)

I can however append the links with some inline javascript, so perhaps i could use a javascript OnClick() to fire something, but Im not sure how I can get a javascript to fire php.

Anyone got any ideas?

Donna and Andy

#2 2006-11-10 07:48:28 Re: Insert into DB on page exit

mobtex
Member

From: Loughborough, United Kingdom
Registered: 2006-04-14
Posts: 805
I've been thanked 13 times.
Offline

if i understand this right you can't change the value of the URL in the link yet you can code something to alter the structure of the html in the link?

onclick="location.href='http://www.yoursite.com/trackingscript.php?url=$urlvalue';"

your tracking script would then have to take the query sting (minus ?url=) as the value to store, otherwise your get value for url could contain a url with get values itself so it would treat these as separate variables.
then you just 301 away and you're done.

Andy Moore .mobi certified developer, web host and mobile media geek
NoSting Hosting - Brightside Hosting Ltd: Member of Nominet / eNom ETP
^^^ Now with over 400 free templates, ShoutCast, LAME + FFMPeg
Ringtones - Palace Marketing Ltd: D2C and B2B mobile content since 2002

#3 2006-11-10 08:06:52 Re: Insert into DB on page exit

Northie
Moderator

From: Yorkshire, UK
Registered: 2006-08-19
Posts: 2860
I've been thanked 85 times.
Offline

Code: javascript

<script type='text/javascript'>

function UpdateDatabase() {

     var update = new Image();

     update.src = "name of php database updating script";

     return true;

}

</script>

Code: html

<body onUnload=UpdateDatabase();>

Last edited by Northie (2006-11-10 08:10:02)

Dynamic Drive CMS
Promote yourself on Site Reference

#4 2006-11-10 08:31:04 Re: Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

Thanks guys!

Donna and Andy

#5 2006-12-14 10:31:23 Re: Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

hello again, im back to this.

I was using a redirect script, but I think its causing more problems than it solves.

Haven't tried Northies above idea yet, but I think it may well be the key to this.

Just got a few questions about it.

The JS function that points to a php script. Will executing this function open the php script or will it just execute it in the background while the user goes to the links target?

the <body OnUnLoad()> execution. Might sound like a stupid question, but would it still work ok with an OnClick() in the links anchour tag?

Cheers guys, really appreciate the help here.

Donna and Andy

#6 2006-12-14 11:04:08 Re: Insert into DB on page exit

Northie
Moderator

From: Yorkshire, UK
Registered: 2006-08-19
Posts: 2860
I've been thanked 85 times.
Offline

griffinsbridge wrote:
hello again, im back to this.

I was using a redirect script, but I think its causing more problems than it solves.

Haven't tried Northies above idea yet, but I think it may well be the key to this.

Just got a few questions about it.

The JS function that points to a php script. Will executing this function open the php script or will it just execute it in the background while the user goes to the links target?

the <body OnUnLoad()> execution. Might sound like a stupid question, but would it still work ok with an OnClick() in the links anchour tag?

Cheers guys, really appreciate the help here.

it runs silently in the background

function can be called however you like

Dynamic Drive CMS
Promote yourself on Site Reference

#7 2006-12-14 11:27:47 Re: Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

Cool, cheers Northie

Donna and Andy

#8 2006-12-14 18:58:10 Re: Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

Lol, hello again

Slightly off topic, but its for the same thing

I need to dynamically get the directory name that the php file is in.

Ive tried
dirname($_SERVER["REQUEST_URI"]);
which gets everything from the base directory right upto the directory BEFORE the one the file is in

and Ive tried

$_SERVER['DOCUMENT_ROOT'];

Which just gets directories from where the php.ini is to the base directory.

Looked all over for this, but I know northie will have this ingrained in his mind.

Whats the function im looking for please?

Oh btw, your above javascript works perfectly mate, cheers for that!!

Donna and Andy

#9 2006-12-14 19:27:27 Re: Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

Nevermind, sussed it

I used this code:

Code: php

$directory = substr(dirname($_SERVER['PHP_SELF']),1);

$directory = explode("/", $directory);

$directory = $directory[1];

It seems abit of a long way round, but it works

Donna and Andy

#10 2006-12-15 04:08:43 Re: Insert into DB on page exit

Northie
Moderator

From: Yorkshire, UK
Registered: 2006-08-19
Posts: 2860
I've been thanked 85 times.
Offline

I would recommend something similar

Code: php

$path = explode("/", $_SERVER['DOCUMENT_ROOT']);

$directory = $path[count($path)-1];

you can change the -1 to various other (negative) numbers to get the various levels in your directory structure

I was hoping to have found a __DIR__ on this page, but it doesn't exist

http://uk.php.net/manual/en/language.co … efined.php

Last edited by Northie (2006-12-15 04:09:09)

Dynamic Drive CMS
Promote yourself on Site Reference

#11 2006-12-15 19:07:23 Re: Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

looks good northie, but i need it to be in multiple files in different folders at different depths and always get the right name. Think i might stick with my long way round unless it implodes.

Im doing a quick double back to that javascript.

Would I be able to but some other perameters in the call for the function, that could add a GET string to the php file in the JS function?

I really dont get JS enough to know where to start tbh.

Donna and Andy

#12 2006-12-16 05:14:15 Re: Insert into DB on page exit

Northie
Moderator

From: Yorkshire, UK
Registered: 2006-08-19
Posts: 2860
I've been thanked 85 times.
Offline

griffinsbridge wrote:
looks good northie, but i need it to be in multiple files in different folders at different depths and always get the right name. Think i might stick with my long way round unless it implodes.

There is such a function called implode(), and usues the same syntax - delimiter,array

I use a class called deep_dir - it recursively list all the files and folders in at a given path with full names:

class

Code: php

<?php



class DeepDir{



  var $dir;

  var $files;



  function DeepDir(){

    $this->dir = '';

    $this->files = array();

    $this->dirFILO = new FILO();

  }



  function setDir( $dir ){

    $this->dir = $dir;

    $this->files = array();

    $this->dirFILO->zero();

    $this->dirFILO->push( $this->dir );

  }





  function load(){

    while( $this->curDir = $this->dirFILO->pop() ){

      $this->loadFromCurDir();

    }

  }



  function loadFromCurDir(){

    if ( $handle = @opendir( $this->curDir ) ){

      while ( false !== ( $file = readdir( $handle ) ) ){

        if ( $file == "." || $file == ".." ) continue;

        $filePath = $this->curDir . '/' . $file;

        $fileType = filetype( $filePath );

        if ( $fileType == 'dir' ){

          $this->dirFILO->push( $filePath );

          continue;

        }

        $this->files[] = $filePath;

      }

      closedir( $handle );

    }

    else{

      echo 'error open dir "'.$this->curDir.'"';

    }

  }



} 



class FILO{



  var $elements;

  

  function FILO(){

    $this->zero();

  }



  function push( $elm ){

    array_push( $this->elements, $elm );

  }



  function pop(){

    return array_pop( $this->elements );

  }



  function zero(){

    $this->elements = array();

  }



}



?>

call:

Code: php

<?

$dirName = 'where/to/look';

$dir = new DeepDir();

$dir->setDir( $dirName );

$dir->load();



foreach($dir->files as $n => $pathToFile) {



}



?>

griffinsbridge wrote:
Im doing a quick double back to that javascript.

Would I be able to but some other perameters in the call for the function, that could add a GET string to the php file in the JS function?

I really dont get JS enough to know where to start tbh.

You can call it how you like, but you will have to include the whole url, eg

[http://wwww.domain.tld/file.php?var=val&var2=val2] without the [ and ]

that way it gets treated as a page call and gets put through the php parser

glad

Last edited by Northie (2006-12-16 05:14:55)

Dynamic Drive CMS
Promote yourself on Site Reference

#13 2006-12-16 15:34:58 Re: Insert into DB on page exit

griffinsbridge
Member

From: York, England
Registered: 2005-11-04
Posts: 608
I've been thanked 11 times.
Offline

Hey That class is, err... class!
Had a play n got fairly good results.

Archived it too, think i might get some use out of that

The JS thing, Im already putting a get string in with the file url anyway, but theres 1 variable thats getting created per link.

Ive got the onclick="UpdateDatabase();" in each link, but is there anyway i can extend that to include the new variable so it gets passed to the url in the function, which inturn would be passed to the file?

Not absolutely nessecary that I can do it tbh, Ive got a fairly reliable script running (with your help northie!) but Im thinking extra admin features.

Donna and Andy

#14 2006-12-16 15:56:01 Re: Insert into DB on page exit

Northie
Moderator

From: Yorkshire, UK
Registered: 2006-08-19
Posts: 2860
I've been thanked 85 times.
Offline

griffinsbridge wrote:
Ive got the onclick="UpdateDatabase();" in each link, but is there anyway i can extend that to include the new variable so it gets passed to the url in the function, which inturn would be passed to the file?

I don't think I understand....... butter

extend to include new var....?

Code: javascript

<script type='text/javascript'>

function UpdateDatabase() {

     var update = new Image();

     update.src = "name of php database updating script";

     return true;

}

</script>

the line update.src = "name of php database updating script"; could be

Code: javascript

update.src = "http://www.domian.com/file.php?var=<?= $php_val ?>&var2=" + js_val + "&var3=val3";

If this isn't what you're looking for, get back to me

Last edited by Northie (2006-12-16 15:57:54)

Dynamic Drive CMS
Promote yourself on Site Reference

#15 2006-12-17 16:48:55 Re: Insert into DB on page exit

drachnid
Member

From: Vancouver, BC
Registered: 2006-05-01
Posts: 30
I've been thanked 0 times.
Offline

griffinsbridge wrote:
Ive got the onclick="UpdateDatabase();" in each link, but is there anyway i can extend that to include the new variable so it gets passed to the url in the function, which inturn would be passed to the file?

Another alternative is to include a var in the function call itself

Code:

<script type='text/javascript'>

function UpdateDatabase(myVar) {

     var update = new Image();

     update.src = "http://www.mydomain.com/file.php?var=" + myVar;

     return true;

}

</script>

then use

Code:

... onclick="UpdateDatabase('myVar1');" ...

... onclick="UpdateDatabase('myVar2');" ...

... onclick="UpdateDatabase('myVar3');" ...

also, if you don't wish to use the onClick event handler you can use

Code:

... href="javascript:UpdateDatabase('myVar1');" ...

... href="javascript:UpdateDatabase('myVar2');" ...

... href="javascript:UpdateDatabase('myVar3');" ...

Digital Diamond Web Media - What's YOUR preference? Cyber-coal or a Digital Diamond?