'; //cookie if (!isset($_COOKIE['id'])) { $cookie_id='id'; $fdate=date("Y-m-d"); $thisDate=date_parse("$fdate")['year'].date_parse("$fdate")['month'].date_parse("$fdate")['day']; $thisMonth=date_parse("$fdate")['month']; $time=date("H:i:s"); $thisTime=date_parse("$time")['hour'].date_parse("$time")['minute'].date_parse("$time")['second']; $user='user'.$thisDate.$thisTime; //DATABASE //test db class MyDB extends SQLite3 { function __construct() { $this->open('./test.db'); } } $db = new MyDB(); if(!$db) { echo $db->lastErrorMsg(); } else { echo "Opened database successfully\n"; } $sql =<<exec($sql); if(!$ret){ echo $db->lastErrorMsg(); } else { echo "Table created successfully\n"; } //insert records $sql =<<exec($sql); if(!$ret) { echo $db->lastErrorMsg(); } else { echo "Records created successfully\n"; } //close db $db->close(); setcookie($cookie_id, $user, time() + (86400), "/"); // 86400 = 1 day } //------------------------- //update cookie else{ $cookie_value=$_COOKIE['id']; $ldate=date("Y-m-d"); $time=date("H:i:s"); class MyDB extends SQLite3 { function __construct() { $this->open('./test.db'); } } $db = new MyDB(); if(!$db) { echo $db->lastErrorMsg(); } else { echo "Opened database successfully\n"; } $sql =<<exec($sql); if(!$ret) { echo $db->lastErrorMsg(); } else { echo $db->changes(), " Record updated successfully\n"; } $sql =<<query($sql); $row = $ret->fetchArray(SQLITE3_ASSOC); $char= $row['CHARACTER']; $clicks=$row['COUNT']; if($clicks>10 && $char=='visitor'){ $char='interested'; } echo $char; $sql =<<exec($sql); if(!$ret) { echo $db->lastErrorMsg(); } else { echo $db->changes(), " Record updated successfully\n"; } echo "Operation done successfully\n"; $db->close(); } echo' Sil Cookie Page!

Sil Page!

This is a cookie page!

'; //cookie if(!isset($_COOKIE['id'])) { echo "Cookie is not set!"; } else { echo "Cookie is: " . $_COOKIE['id']."
"; } echo '

'; ?>

php_cookies