Dateigrösse: 1.52 kb
1 <?php 2 3 if (stristr($_SERVER['HTTP_HOST'], 'localhost') || stristr($_SERVER['HTTP_HOST'], '127.0.0.1')) { 4 $link = mysqli_connect("localhost", "root", "", "cms"); 5 } else { 6 $link = mysqli_connect("localhost", "user_cms", "pass_cms", "klik_cms"); 7 mysqli_set_charset($link, "utf8"); 8 } 9 10 if (!$link) { 11 printf("dbConnect failed: %s\n", mysqli_connect_error()); 12 exit(); 13 } 14 15 /************************************************************************ 16 from: http://www.php-resource.de/handbuch/function.mysqli-fetch-array.htm 17 ************************************************************************/ 18 $back = ''; 19 $sql = "SELECT datum,fam_name,msg FROM msgdata ORDER by datum DESC LIMIT 100"; 20 $result = mysqli_query($link, $sql); 21 22 while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) // MYSQLI_BOTH resp. MYSQLI_NUM 23 { 24 if(preg_match("/pharm/i", $row["fam_name"]) || preg_match("/smith/i", $row["fam_name"])) 25 continue; 26 $datum = preg_split("/ /", $row["datum"]); 27 list($jahr, $monat, $tag) = preg_split("/-/", $datum[0]); 28 $datum = $tag.'.'.$monat.'.'.$jahr; 29 $end = '* * * * * * * * * * * * * * * * * * * * * * * * * || * * * * * * * * * * * * * * * * * * * * * * * * * <p></p>'; 30 $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; 31 } 32 33 mysqli_free_result($result); 34 35 mysqli_close($link); 36 37 $tpl->setVariable('messages', $back); 38 39 ?> 40