/*
------------------------------------------------------------------------------------
| Front List v 1.0 alpha
| Code By SinoPower
| CopyRight (c) 2007
| Http://www.sditi.com
------------------------------------------------------------------------------------
*/
class MSSQL
{
var $db = array ( "db_user" => "sa", "db_pass" => "", "db_host" => "127.0.0.1", "db_name" => "", );
var $conn = "";
var $query_id = "";
var $insert_id="";
function connect()
{
$this->conn = @mssql_connect($this->db['db_host'], $this->db['db_user'], $this->db['db_pass'])
OR $this->halt("db connect failed,please check.");
@mssql_select_db($this->db['db_name'], $this->conn)
OR $this->halt("select db error,please check.");
}
function query($sql)
{
$this->query_id = @mssql_query($sql) OR $this->halt("SQL Query failed:".$sql);
$this->count++;
return $this->query_id;
}
function fetch_array($query)
{
$this->record = @mssql_fetch_array($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->record;
}
function fetch_assoc($query)
{
$this->record = @mssql_fetch_assoc($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->record;
}
function fetch_row($query)
{
$this->record = @mssql_fetch_row($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->record;
}
function num_rows($query)
{
$this->rows = @mssql_num_rows($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->rows;
}
function free_result()
{
@mssql_free_result($this->query_id);
}
function fetch_object($query)
{
$this->objects = mssql_fetch_object($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->objects;
}
function conn_close()
{
@mssql_close($this->conn);
}
function halt($msg)
{
$message = "Error:".htmlspecialchars($msg)."
";
$message .= "Time: ".date("Y-m-d @ H:i")."
";
$message .= "Script: http://".$_SERVER["HTTP_HOST"].getenv("REQUEST_URI")."
";
$message .= "Referer: ".getenv("HTTP_REFERER")."
";
echo $message;
exit;
}
}
?>
/*
------------------------------------------------------------------------------------
| Front List v 1.0 alpha
| Code By SinoPower
| CopyRight (c) 2007
| Http://www.sditi.com
------------------------------------------------------------------------------------
*/
//弹出警告提示
function show_message($str)
{
echo "";
}
//去除HTML标记符号
function clear_html($html){
return trim(preg_replace("/[><]/","",$html));
}
//后退
function back($str)
{
show_message($str);
echo "";
EXIT;
}
// 获取客户端IP
function getip()
{
if (isset($_SERVER))
{
if (isset($_SERVER['HTTP_X_FORWARDED_FOR']))
{
$realip = $_SERVER['HTTP_X_FORWARDED_FOR'];
}
elseif (isset($_SERVER['HTTP_CLIENT_IP']))
{
$realip = $_SERVER['HTTP_CLIENT_IP'];
}
else
{
$realip = $_SERVER['REMOTE_ADDR'];
}
}
else
{
if (getenv("HTTP_X_FORWARDED_FOR"))
{
$realip = getenv( "HTTP_X_FORWARDED_FOR");
} elseif (getenv("HTTP_CLIENT_IP"))
{
$realip = getenv("HTTP_CLIENT_IP");
} else
{
$realip = getenv("REMOTE_ADDR");
}
}
return $realip;
}
//写文件
function write_file($fdir,$fname,$str)
{
$fdir=makedir($fdir);
if($fp=@fopen($fdir."/".$fname,'w'))
{
fwrite($fp,$str);
fclose($fp);
return TRUE;
}else
{
return FALSE;
}
}
function makedir($mdir,$gdir="../")
{
$dir=explode("/",$mdir);
foreach($dir AS $tmp)
{
if(!empty($tmp))
{
if(!is_dir("$gdir/$tmp"))
{
mkdir("$gdir/$tmp",0777);
$gdir.="/".$tmp;
}else
{
$gdir.="/".$tmp;
}
}
}
return $gdir;
}
//创建目录 '根目录/2005+4/1'
function makedir_time($maindir,$time,$maindir)
{
$y=date("Y",$time);
$m=date("m",$time);
$d=date("d",$time);
$dir=$maindir."/".$y."+".$m."/".$d."/";
if(!file_exists($dir))
{
if(!is_dir($maindir."/".$y."+".$m))
{
@mkdir($maindir."/".$y."+".$m,0777);
}
if(!is_dir($maindir."/".$y."+".$m."/".$d))
{
@mkdir($maindir."/".$y."+".$m."/".$d,0777);
}
}
return $dir;
}
//截取字符串,考虑中文
function left_string($str,$strlen=10,$append=true)
{
$j = 0;
for($i=0;$i< $strlen;$i++)
if(ord(substr($str,$i,1))>0xa0) $j++;
if($j%2!=0) $strlen++;
$rstr=substr($str,0,$strlen);
if (strlen($str) > $strlen && $append) {$rstr.='...';}
return $rstr;
}
//除去数组中的slashes
function stripslashes_array(&$array)
{
while(list($key,$var) = each($array))
{
if ($key != 'argc' && $key != 'argv' && (strtoupper($key) != $key || ''.intval($key) == "$key"))
{
if (is_string($var))
{
$array[$key] = stripslashes($var);
}
if (is_array($var))
{
$array[$key] = stripslashes_array($var);
}
}
}
return $array;
}
//转换半角逗号
function change_comma(&$str)
{
if(is_array($str))
{
if(!empty($str))
{
foreach($str AS $v)
{
$v=change_comma($v);
}
}
}else
{
if(!empty($str))
{
$str=str_replace(",",",",$str);
}
}
return $str;
}
?>
=$channel_cache[$classid]['title']?> 济南 =$doctype_cache[$doc_type]?> 山东IT在线
$sql_handle = new MSSQL();
$sql_handle->db['db_host'] = $db_host;
$sql_handle->db['db_user'] = $db_user;
$sql_handle->db['db_pass'] = $db_pass;
$sql_handle->db['db_name'] = $db_name;
$sql_handle->connect();
?>
推荐产品 |
当前位置:=$navi_bar?> > =$doctype_cache[$doc_type]?>
|
最新行情 |
|
|
//存储过程说明 sp_pageview '表或视图','返回的列字段','排序字段',页尺寸,当前页码,是否返回总记录数total,降序1OR升序0,'查询条件no where'
$sql = "exec sp_pageview 'view_list','DocId','DocId',1,1,1,1,\"$str_where\"";
$query = $sql_handle->query($sql);
$row = $sql_handle->fetch_array($query);
$record = $row["Total"];//获取记录总数
$totalpage = ($record%25==0)?$record/25:floor($record/25)+1;
$sql = "exec sp_pageview 'view_list','DocTitle,CreateTime,Url','CreateTime',25,$page,0,1,\"$str_where\"";
$query = $sql_handle->query($sql);
?>
|
|
$loop = 0;
while($row = $sql_handle->fetch_array($query)){
$doctitle = $row["DocTitle"];
$datetime = date("(m月d日)",strtotime($row["CreateTime"]));
$url = $row["Url"];
?>
| ·=$doctitle?> |
=$datetime?> |
$loop++;
if($loop%5==0){
?>
|
}
}
$rewrite = false;
$link = "/list_1.php?channel=$classid&doctype=1";
if(strstr($_SERVER["REQUEST_URI"],".html")){
$link = "/news/index_{$classid}_{$doc_type}";
$rewrite = true;
}
$strPageView = pageview($totalpage,$page,$link,$rewrite);
?>
=$strPageView?>
|
$exp_time = 3600*24;
//加载频道最新行情
if (!file_exists("$cachepath/channel/$classid/lasttop10_hangqing.html") || (time() - @filemtime("$cachepath/channel/$classid/lasttop10_hangqing.html") >= $exp_time)){
$sql = "SELECT Top 10 DocTitle,SubTitle,Url FROM view_list WHERE ClassId=$classid And DocType='行情'";
$query = $sql_handle->query($sql);
$cachedata = "";
while($row = $sql_handle->fetch_array($query)){
$doctitle = ($row['SubTitle'] && strlen(strip_tags($row['SubTitle']))>10) ? $row['SubTitle'] : $row['DocTitle'];
$cachedata .= "| · | $doctitle | ";
}
$cachedir = makedir("cache/channel/$classid","./");
$fp = fopen("$cachepath/$classid/lasttop10_hangqing.html","w");
fwrite($fp,$cachedata);
fclose($fp);
}
@include_once("$cachepath/$classid/lasttop10_hangqing.html");
?>
|
|