Quelltext der Datei: http://www.michaelster.ch/lernen/getFeedback.php

Dateigrösse: 1.52 kb

[Anzeige mit Zeilennummern]

<?php

if (stristr($_SERVER['HTTP_HOST'], 'localhost') || stristr($_SERVER['HTTP_HOST'], '127.0.0.1')) {
    $link = mysqli_connect("localhost", "root", "", "cms");
} else {
    $link = mysqli_connect("localhost", "user_cms", "pass_cms", "klik_cms");
    mysqli_set_charset($link, "utf8");
}

if (!$link) {
    printf("dbConnect failed: %s\n", mysqli_connect_error());
    exit();
}

/************************************************************************
from: http://www.php-resource.de/handbuch/function.mysqli-fetch-array.htm
************************************************************************/
  $back     = '';
  $sql         = "SELECT datum,fam_name,msg FROM msgdata ORDER by datum DESC LIMIT 100";
  $result     = mysqli_query($link, $sql);

  while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) // MYSQLI_BOTH resp. MYSQLI_NUM
  {
    if(preg_match("/pharm/i", $row["fam_name"]) || preg_match("/smith/i", $row["fam_name"])) 
    continue;
    $datum = preg_split("/ /", $row["datum"]);
    list($jahr, $monat, $tag) = preg_split("/-/", $datum[0]);
    $datum = $tag.'.'.$monat.'.'.$jahr;
    $end   = '* * * * * * * * * * * * * * * * * * * * * * * * * || * * * * * * * * * * * * * * * * * * * * * * * * * <p></p>';
    $back .= '<b>'.utf8_decode($row["fam_name"]).'</b> schrieb am '.$datum.': <p style="margin:5px"></p>'.nl2br(utf8_decode($row["msg"])).'<p style="margin:5px"></p>'.$end;
  }
  
  mysqli_free_result($result);
  
  mysqli_close($link);
  
  $tpl->setVariable('messages', $back);

?>