'; //cookie if (!isset($_COOKIE['id'])) { //DATABASE mysql $servername = "myservername"; $username ="myname"; $dbname = "mydb"; $password ="myp4ss"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); echo "something went wrong!"; } echo "Connected successfully"; // Create table $sql="CREATE TABLE USERS (ID int NOT NULL AUTO_INCREMENT, USER TEXT NOT NULL, CHARACT TEXT NOT NULL, COUNT INT NOT NULL, FIRST_CLICK TEXT NOT NULL, LAST_CLICK TEXT NOT NULL, PRIMARY KEY (ID)) "; if ($conn->query($sql) === TRUE) { echo "Table USERS created successfully"; } else { echo "Error creating table: " . $conn->error; } //select $user=$_COOKIE['id']; $sql = "SELECT * FROM USERS WHERE USER='$user'"; $result = $conn->query($sql); if ($result->num_rows > 0) { echo "there is this user!"; //update echo 'I will update!'; $user=$_COOKIE['id']; $ldate=date("Y-m-d"); $time=date("H:i:s"); $sql = "UPDATE USERS SET COUNT=COUNT+1, LAST_CLICK='$ldate $time' WHERE USER='$user'"; if ($conn->query($sql) === true) { echo "Record updated successfully"; } else { echo "Error updating record: " . $conn->error; } $conn->close(); } else { //insert $user=$_COOKIE['id']; $fdate=date("Y-m-d"); $time=date("H:i:s"); $sql = "INSERT INTO USERS (USER, CHARACT, COUNT, FIRST_CLICK, LAST_CLICK) VALUES ('$user', 'visitor', '1', '$fdate $time', '$fdate $time')"; if ($conn->query($sql) === true) { echo "New record created successfully"; } else { echo "Error: " . $sql . "
" . $conn->error; $conn->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_cookies2