$datab = new MYSQLDB('localhost', 'siriusdb010', 'hNIsdf5RUX3', 'siriusdb010');
class MYSQLDB{
var $dbhost;
var $dbuser;
var $dbpass;
var $dbname;
var $connection;
function MYSQLDB($dbhost,$dbuser,$dbpass,$dbname){
$this->dbhost = $dbhost;
$this->dbuser = $dbuser;
$this->dbpass = $dbpass;
$this->dbname = $dbname;
$this->connect();
}
function connect(){
$this->connection = mysql_pconnect($this->dbhost,$this->dbuser,$this->dbpass)
or die("Nem lehet csatlakozni a \"$this->dbhost\" szerverhez!");
mysql_select_db($this->dbname,$this->connection)
or die("Nem lehet a \"$this->dbname\" adatbázist kiválasztani!");
mysql_query('SET NAMES UTF8');
mysql_query('SET CHARACTER SET UTF8');
mysql_query("SET CHARACTER_SET_CLIENT=utf8");
mysql_query("SET CHARACTER_SET_RESULTS=utf8");
}
}
?>
$ma = date("Y-m-d",time());
if(file_exists($_SERVER['DOCUMENT_ROOT']."/kiskunfelegyhaza/admin/videolist/" . $ma . ".txt")){
$videoid=file_get_contents("admin/videolist/" . $ma . ".txt", true);
?>
}
else
{
?>

}
?>
function szovegrovidites ($string, $maxLength=30, $template='%1$s')
{
if (!is_string($string)) return '';
$string = strip_tags($string);
if (mb_strlen($string, "UTF-8") > $maxLength)
{
$result=array();
if (preg_match(sprintf('/\A(.{0,%d})[\s]\b/siu', $maxLength), $string, $result)){
$template .= "...";
$string = mb_substr($string, 0, $maxLength-3, "UTF-8");
$vissza = sprintf($template, rtrim($result[0]));
}else $vissza = '';
}else $vissza = $string;
return trim($vissza);
}
$hirek_db=mysql_query("SELECT * from hirek WHERE regio IN(1,0) AND aktiv = '1' ORDER by datum DESC LIMIT 14");
while($hirek=mysql_fetch_array($hirek_db)){
echo '· '.szovegrovidites($hirek["cim"]).'
';
}
?>
$hirek_db=mysql_query("SELECT * from hirek WHERE regio IN(1,0) AND aktiv = '1' ORDER by olvasva DESC LIMIT 14");
while($hirek=mysql_fetch_array($hirek_db)){
echo '· '.szovegrovidites($hirek["cim"]).'
';
}
?>
$elozo=strtotime ("-2 weeks");
$kethet=date("Y-m-d h:i:s",$elozo);
$hirek_db=mysql_query("SELECT * from hirek WHERE regio IN(1,0) AND aktiv = '1' AND datum < '".$kethet."' ORDER by datum DESC LIMIT 14");
while($hirek=mysql_fetch_array($hirek_db)){
echo '· '.szovegrovidites($hirek["cim"]).'
';
}
?>