Programėlės Spot-In statistika
<php>
echo “</p>”; validation issues login informacija include(“./spot-in/core/web_db_conf.php”);
try{ $DBH = new PDO(“mysql:host=$dbServer;dbname=$dbName”, $dbUser, $dbPass); } catch(PDOException $e){ echo $e→getMessage(); } $DBH→query(“SET NAMES 'utf8'”); $DBH→query(“SET lc_time_names = 'lt_LT'”);
$sql = “CALL get_Statistics('_Web_Online_')”; $STH = $DBH→prepare($sql); $STH→execute();
echo “<dl>”;
while($row = $STH→fetch(PDO::FETCH_ASSOC) ){ foreach($row as $k ⇒$v) { echo “<dt>$k</dt><dd>$v<dd> \n”; }
}
echo “<dl>”; </php>