Hei, jeg lurer på hva slags språk man bruker og hvordan man kan lage et script/kode som kan vise mest leste artikler på en nettside jeg driver.
Anyone?
Anyone?
13
2066
|
SELECT * FROM artikler ORDER BY visninger DESC LIMIT 1
<?php $lest++; $query = "UPDATE Nyheter SET Lest='$lest' WHERE NyhetsID='$nyhetsID'"; mysql_query($query) or die(mysql_error()); ?>
<?php $query = "SELECT * FROM Nyheter ORDER BY Lest DESC Limit 1" mysql_query($query) or die(mysql_error()); ?>
if ($mysqli->query("UPDATE `nyheter` SET `lest` = `lest` +1 WHERE `id` = '$id' LIMIT 1") === false) { printf("Warning: %s\n", $mysqli->error) }
<?php // Check if article has been read if (isset($_COOKIE['tracking-articles-read')) { $ids = explode(',', $_COOKIE['tracking-articles-read']); $update_read_counter = !in_array("$id", $ids); } else { $update_read_counter = true; } // Update read count of aricle if ($update_read_counter) { $q = "UPDATE `nyheter` SET `lest` = `lest` +1 WHERE `id` = '$id' LIMIT 1"; if ($mysqli->query($q)) { if (isset($ids)) { $ids[] = "$id"; setcookie('tracking-articles-read', implode(',', $ids), time()+60*60*24*30) } else { setcookie('tracking-articles-read', "$ids", time()+60*60*24*30) } } else { printf("Warning: %s\n", $mysqli->error); } } ?>
<?php // Check if article has been read $update_read_counter = true; if (isset($_COOKIE['tracking-articles-read')) { $ids = gzinflate($_COOKIE['tracking-articles-read']); if ($ids) { $tmp_ids = explode(',', $ids); $time = time(); // Remove article reads that have expired $ids = array(); foreach ($tmp_ids as $value) { $value = explode('=', $value); if (count($value > 1)) { $tmp_id = $value[0]; $expire = intval($value[1]); } else { $expire = 0; } if ($expire < $time){ $ids[$tmp_id] = $expire; } } unset($tmp_ids, $tmp_id, $value, $time, $expire); $update_read_counter = !isset($ids[strval($id)]); } else { unset($ids); } } // Update read count of aricle if ($update_read_counter) { $q = "UPDATE `nyheter` SET `lest` = `lest` +1 WHERE `id` = '$id' LIMIT 1"; if ($mysqli->query($q)) { $expire_time = time()+60*60*24*30; if (isset($ids)) { $value = ""; foreach ($ids as $ids_id => $ids_expire) { $value .= sprintf("%s=%s,", $ids_id, $ids_expire); } $value .= sprintf("%s=%s", $id, $expire_time); } else { $value = sprintf("%s=%s", $id, $expire_time); } setcookie('tracking-articles-read', gzdeflate($value), $expire_time) } else { printf("Warning: %s\n", $mysqli->error); } } ?>
|