| Server IP : 210.245.233.93 / Your IP : 216.73.216.226 Web Server : Apache/2.2.15 (CentOS) System : Linux webserver2.onesolution.com.hk 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : apache ( 48) PHP Version : 5.3.3 Disable Function : exec, shell_exec, system, passthru, popen, proc_open, pcntl_exec MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/hkosl.com/dirsignage/html/ |
Upload File : |
<?php
include_once ("webadmin/configure.php");
$lastupdate_string = $_GET["lastupdate_string"];
$sql = "select * from rolling_text where status = ? and deleted = ? order by sort ASC";
$parameters = array("1", "0");
if (!($sth = $dbh->prepare($sql))) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
if (!$sth->execute($parameters)) {
throw new Exception('[' . $sth->errorCode() . ']: ' . print_r($sth->errorInfo()));
}
$all_rolling_text_info = $sth->fetchAll();
$real_lastupdate_string = "";
foreach($all_rolling_text_info as $rolling_text_info){
$real_lastupdate_string .= $rolling_text_info{"lastupdate"}." ";
}
if($lastupdate_string != $real_lastupdate_string){
$new_rolling_text = "";
foreach($all_rolling_text_info as $rolling_text_info){
$new_rolling_text .= "<li>".$rolling_text_info{"content_en"}."</li>";
}
echo $new_rolling_text;
}else{
echo "2";
}
?>