EOTT; $mein_text_footer = <<< EOTTT
EOTTT; header("Content-Type: text/html; charset=UTF-8"); header("Expires: on, 01 Jan 1970 00:00:00 GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: no-store, no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); echo $mein_text_header; //later: geo ip und spracheinstellungen //error_reporting(E_ALL); ini_set('display_errors', '0'); /* ** Connect to database: */ // connect to the database $con = mysql_connect('localhost','root','###########99') or die('Could not connect to the server!'); // select a database: mysql_select_db('onetipp') or die('Could not select a database.'); // escape bad chars: //$username = mysql_real_escape_string($username); // build query: $sql = "SELECT * FROM trendcrawler_v11 WHERE 1=1 ORDER BY UNIX_TIMESTAMP(datetime) DESC, trendrank ASC LIMIT 350;"; // execute query: $result = mysql_query($sql) or die('A error occured: ' . mysql_error()); // get result count: $count = mysql_num_rows($result); // fetch results: while ($row = mysql_fetch_assoc($result)) { $trendrank = $row['trendrank']; $source = $row['source']; $url = $row['url']; $title = $row['title']; $content = $row['content']; $time = $row['datetime']; if (strlen($title) >= 3){ $mytitle = "
  • Title: $title
    • "; } $mein_text = <<< EOT
      $mytitle
    1. Content: $content
    2. URL: $url
    3. TrendRank: $trendrank
    4. Source: $source
    5. Time: $time

    EOT; echo $mein_text; } // while ($row = mysql_fetch_assoc($result)) { echo $mein_text_footer; $logs->logQuerys("OneTOPP Trends [Internal]"); exit(0); ?>