include 'config/main.php'; ?> $slug = basename($url); $sql = "SELECT * FROM news WHERE slug LIKE :slug"; $result = $conn->prepare($sql); $result -> execute(array('slug'=>$slug)); $rows = $result->fetchAll(); $notificati = 0; $id = $rows[0]['id']; $data = $rows[0]['data']; $timestamp = strtotime($data); $data = date("d/m/Y", $timestamp); $titolo = $rows[0]['titolo']; $abstract = $rows[0]['abstract']; $testo = $rows[0]['testo']; $autore = $rows[0]['autore']; $secondi = round(strlen($testo)/50); $minuti = floor($secondi / 60); $secondi_rimanenti = $secondi % 60; $tempo = $minuti . ":" . $secondi_rimanenti; ?> $meta_title = "Alpha Pharma | " . strip_tags($titolo); $meta_description = strip_tags($abstract); $og_title = $meta_title; $og_description = $meta_description; $og_url = $url; $og_image = $base_url . "news/$id/og.png"; ?> include 'header.php'?>
include 'top.php'?>Autore
Tempo di lettura
Data