Insert data if cookie is set ?

[MichaelHe]

I want to put some data in my database when a cookie is set the first time.
It works fine by typing.

if( isset( $_COOKIE[$cookiename] ) ){$temp = $_COOKIE[$cookiename];}
else {
setcookie( $cookiename, $temp, time()[phone]);
mysql_query ("INSERT INTO CountUser (Dato) VALUES (now())")
;}

BUT, this way it puts the data in the database even though the cookie is set or not.

How do I get it to only INSERT the data if the setcookie is succeeded.
So if people have disabled cookies so the cookie can't be set, the data won't be inserted ?

Michael

[Najjar]

Try to check for the cookie one more time:

 if( isset( $_COOKIE[$cookiename] ) )
    {
     $temp = $_COOKIE[$cookiename];
     } else { 
        if(isset( $_COOKIE[$cookiename] ) ) {
        setcookie( $cookiename, $temp, time()[phone]); 
        mysql_query ("INSERT INTO CountUser (Dato) VALUES (now())") ;
    }
} 

[homchz]

Or compare to what is not set first

 if( !isset( $_COOKIE[$cookiename] ) )
    {
         setcookie( $cookiename, $temp, time()[phone]);
          mysql_query ("INSERT INTO CountUser (Dato) VALUES (now())")
    }
else 
   {
$temp = $_COOKIE[$cookiename];
   }

[MichaelHe]

But won't these two examples INSERT the data in the mysql_query even though the setcookie doesn't succeed.

I Mean if someone has disabled cookies, it will try to set the cookie, and then, matter if the cookie is succeeded or not, insert the mysql_query ??

[homchz]

The only issue there is you cannot check to see if a cookie is set unless you load a new page. So you can set the cookie then redirect to a new page check for the cookie on that new page and if it exists insert, if not then redirect back to an error page, or what ever the next step is

[MichaelHe]

That was very smart.. :o)

Actually I don't have to send an error if the cookie isn't set. As long as it doesn't insert data in my database if the cookie isn't set, and only inserts data if the cookie IS set..

Your idea might work for me. :o)

[MichaelHe]

OK...

Now I got it.

My menu links to this file in an IMG command.

<?php
$cookiename = 'CookieCounter';

if( isset( $_COOKIE[$cookiename] ) ){$value = $_COOKIE[$cookiename];}

else {
$temp='temp';
setcookie( $cookiename, $temp, time()[phone]);
header("Location: CookieSet.php");
;}
?>

Now the cookie is set, and it opens this file.

<?php
require("CounterSetup.php");
$conn = mysql_connect("$dbhost", "$dbuser", "$dbpass");
mysql_select_db("$dbname");
$cookiename = 'CookieCounter';

if( isset( $_COOKIE[$cookiename] ) ){
  mysql_query ("INSERT INTO CountUser (Dato) VALUES (now())");
  $id = mysql_insert_id();
  setcookie( $cookiename, $id, time()[phone]);
;}

else {}
?>

If the cookie was set on the computer, it puts the data in my database, if the cookie for some reason wasn't set, it doesn't put data in the base.

So now it only count visiters that successfully sets a cookie, and it only counts them one time in the 10 years the cookie is on their computer.

It works :o))

thanks alot

Michael