require_once("Pagination.class.php");
//连接数据库
$dbconn = mssql_connect($webdbhost,$webdbuser,$webdbpwd) or die("服务器连接失败.");
mssql_select_db($webdbname) or die ("数据库连接失败");
$numrs = mssql_query($strQueryCount) or die("数据查询失败");
$numrow = mssql_fetch_row($numrs);
$num = $numrow[0]; //总记录
$result = mssql_query( $strQuery ) or die ("数据查询失败");
$p = new Pagination();
$p->setTotal($num);
$p->initialize();
$start = $p->getStartNumber();
$end = $p->getEndNumber();
for( $i = $start; $i < $end; $i++ ){
//echo "<tr><td>".$results[$i][0]."</td><td>".$results[$i]["3"]."</td><td>".$results[$i][5]." </td></tr>";
echo "<tr><td>".mssql_result($result,$i,"GeneralID")."</td><td>".mssql_result($result,$i,"Title")."</td><td>".mssql_result($result,$i,"InputTime")." </td></tr>";
echo "";
}
echo "<tr><td colspan='10'>";
echo $p->getFirstPage();
echo $p->getPreviousPage();
echo $p->getNumberBar();
echo $p->getNextPage();
echo $p->getLastPage();
echo $p->getJumpForm();
echo "</td></tr>";
mssql_free_result($result);
mssql_close($dbconn);

Pagination.class.php

PHP代码

class Pagination{
/**
* 总条目数
*/
private $total;
/**
* 每页显示条目数
*/
private $pageSize = 20;
/**
* 总页数
*/
private $sumPageNumber;
/**
* 当前页数
*/
private $currentlyPageNumber;
/**
* 结果集开始条目数
*/
private $startNumber;
/**
* 结果集结束条目数
*/
private $endNumber;
/**
* 翻页时的标识
*/
private $pageNumberFlag = "page";
/**
* 翻页时需要额外带的参数
*/
private $linksParameter;
/**
* 数字翻页条的数量
*/
private $numberBar = 6;
/**
* 首页翻页标识
*/
private $firstPageFlag = "[首页]";
/**
* 尾页翻页标识
*/
private $lastPageFlag = "[尾页]";
/**
* 上页翻页标识
*/
private $previousPageFlag = "[上页]";
/**
* 下页翻页标识
*/
private $nextPageFlag = "[下页]";
/**
* 初始化，在SET相关参数后执行，执行后才可以调用GET
* @name initialize
* @return void
*/
function initialize(){
$this->sumPageNumber = ceil( $this->total / $this->pageSize );
if( 0 == $this->sumPageNumber )$this->sumPageNumber++;
if (isset($_REQUEST[$this->pageNumberFlag]) && is_numeric($_REQUEST[$this->pageNumberFlag]))
{
$this->currentlyPageNumber = $_REQUEST[$this->pageNumberFlag];
}
else
{
$this->currentlyPageNumber = 1;
}
if ( ( $this->currentlyPageNumber == "" ) ||
( $this->currentlyPageNumber <= 0 ) ||
( $this->currentlyPageNumber > $this->sumPageNumber )
){
$this->currentlyPageNumber = 1;
}
$this->startNumber =
$this->currentlyPageNumber * $this->pageSize - $this->pageSize;
$this->endNumber = $this->currentlyPageNumber * $this->pageSize;
if( $this->total < $this->endNumber ){
$this->endNumber = $this->total;
}
}
/**
* 得到含有连接的首页翻页标识
* @return string
*/
function getFirstPage(){
if( 1 == $this->currentlyPageNumber){
return $this->firstPageFlag . " \n ";
}else{
return "<a href=\"?" . $this->pageNumberFlag . "=1". $this->linksParameter ."\">" . $this->firstPageFlag . "</a> \n";
}
}
/**
* 得到含有连接的尾页翻页标识
* @return string
*/
function getLastPage(){
if( $this->currentlyPageNumber != $this->sumPageNumber && 0 != $this->sumPageNumber ){
return "<a href=\"?" . $this->pageNumberFlag . "=" . $this->sumPageNumber . $this->linksParameter . "\">" . $this->lastPageFlag . "</a> \n";
}else{
return $this->lastPageFlag . " \n ";
}
}
/**
* 得到含有连接的上页翻页标识
* @return string
*/
function getPreviousPage(){
if( $this->currentlyPageNumber > 1 ){
return "<a href=\"?" . $this->pageNumberFlag . "=" . ( $this->currentlyPageNumber - 1 ) . $this->linksParameter ."\">" . $this->previousPageFlag . "</a> \n";
}else{
return $this->previousPageFlag . " \n";
}
}
/**
* 得到含有连接的下页翻页标识
* @return string
*/
function getNextPage(){
if( $this->currentlyPageNumber < $this->sumPageNumber && $this->sumPageNumber != 0){
return "<a href=\"?" . $this->pageNumberFlag . "=" . ( $this->currentlyPageNumber + 1 ) . $this->linksParameter ."\">" . $this->nextPageFlag . "</a> \n";
}else{
return $this->nextPageFlag . " \n";
}
}
/**
* 得到翻页的数字条
* @return string
*/
function getNumberBar(){
if( 0 == ( $this->numberBar % 2 ) ){
$this->numberBar++;
}
$scope = ( $this->numberBar - 1 )/2;
$start = $this->currentlyPageNumber - $scope;
$end = $this->currentlyPageNumber + $scope;
if( $start < 1 ){
$start = 1;
}
if( $end > $this->sumPageNumber ){
$end = $this->sumPageNumber;
if( $this->sumPageNumber > $this->numberBar ){
$start = $this->sumPageNumber - $this->numberBar + 1;
}
}
if( 1 == $start && $this->sumPageNumber > $this->numberBar ){
$end = $this->numberBar;
}
if( $start == $end ){
return "<font color=\"red\">[1]</font>\n";
}
$nb = "";
for( $i=$start; $i<=$end; $i++ ){
if( $i == $this->currentlyPageNumber ){
$nb .= "<font color=\"red\">[" . $i . "]</font> \n";
continue;
}
$nb .= "<a href=\"?" . $this->pageNumberFlag . "=" . $i . $this->linksParameter . "\">[" . $i . "]</a> \n";
}
return $nb;
}
/**
* 得到可以跳转的表单框，GET方式传递
* @return string
*/
function getJumpForm(){
$jf = "<script language=\"javascript\">\n";
$jf .= "function _checkForm(){\n";
$jf .= "var a = document.getElementById(\"" . $this->pageNumberFlag . "\").value;\n";
$jf .= "if( a > " . $this->sumPageNumber . " || a <1 || a == " . $this->currentlyPageNumber . " ){\n";
$jf .= "return false;}else{\n";
$jf .= "window.location.href=\"?" . $this->pageNumberFlag . "=\"+a+\"" . $this->linksParameter . "\";";
$jf .= "}\n}\n</script>\n";
$jf .= "<input class=\"selectButtonCss\" id=\"" . $this->pageNumberFlag . "\" name=\"" . $this->pageNumberFlag . "\" tpye=\"text\" size=\"3\" value=\"" . $this->currentlyPageNumber . "\">\n";
$jf .= "<input type=\"button\" name=\"button\" value=\"GO\" onClick=\"return _checkForm()\" class=\"ButtonCss\">\n";
return $jf;
}
/**
* 得到结果集的开始数
* @return int
*/
function getStartNumber(){
return $this->startNumber;
}
/**
* 得到结果集的结束数
* @return int
*/
function getEndNumber(){
return $this->endNumber;
}
/**
* 得到当前页数
* @return string
*/
function getCurrentlyPageNumber(){
return $this->currentlyPageNumber;
}
/**
* 得到总页数
* @return string
*/
function getSumPageNumber(){
return $this->sumPageNumber;
}
/**
* 得到翻页时需要的所有参数
* @return string
*/
function getAllLinksParameter(){
$page = emptyempty($_GET[$this->pageNumberFlag])?0:$_GET[$this->pageNumberFlag];
return $this->pageNumberFlag."=".$page.$this->linksParameter;
}
/**
* 设定总的结果集条目数
* @return void
*/
function setTotal( $total ){
$this->total = $total;
}
/**
* 设定每页需要显示的结果集条目数
* @return void
*/
function setPageSize( $pageSize ){
$this->pageSize = $pageSize;
}
/**
* 设定翻页时传递页数的变量名称
* @return void
*/
function setPageNumberFlag( $pageNumberFlag ){
$this->pageNumberFlag = $pageNumberFlag;
}
/**
* 设定翻页时需要额外传递的变量
* @return void
*/
function setLinksParameter( $linksParameter ){
$this->linksParameter = $linksParameter;
}
/**
* 设定首页翻页标识
* @return void
*/
function setFirstPageFlag( $firstPageFlag ){
$this->firstPageFlag = $firstPageFlag;
}
/**
* 设定尾页翻页标识
* @return void
*/
function setLastPageFlag( $lastPageFlag ){
$this->lastPageFlag = $lastPageFlag;
}
/**
* 设定上页翻页标识
* @return void
*/
function setPreviousPageFlag( $previousPageFlag ){
$this->previousPageFlag = $previousPageFlag;
}
/**
* 设定下页翻页标识
* @return void
*/
function setNextPageFlag( $nextPageFlag ){
$this->nextPageFlag = $nextPageFlag;
}
/**
* 设定翻页数字条所显示的数量
* @return void
*/
function setNumberBar( $numberBar ){
$this->numberBar = $numberBar;
}
function __set($name,$val){
echo "不能在Pagination.class.php中SET 属性 <font color=\"red\">" .$name. "</font>";
}
function __get($name){
echo "不能在Pagination.class.php中GET 属性 <font color=\"red\">" .$name. "</font>";
}
function __call($name,$arguments){
echo "Pagination.class.php中不存在 function <font color=\"red\">" .$name. "</font>";
}
}

标签: php

4
PHP编程
阅读:4457
评论:1

PHP读MSSQL日期问题

Calchas 发表于 2009, April 1, 11:21 AM

SELECT top 1 [InputTime] from ....

默认的 style 参数是 0 ，所以结果类似于 05 16 2006 10:57AM

可以修改该参数得到自己需要的数据。

Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06
Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16
Select CONVERT(varchar(100), GETDATE(), 3): 16/05/06
Select CONVERT(varchar(100), GETDATE(), 4): 16.05.06
Select CONVERT(varchar(100), GETDATE(), 5): 16-05-06
Select CONVERT(varchar(100), GETDATE(), 6): 16 05 06
Select CONVERT(varchar(100), GETDATE(), 7): 05 16, 06
Select CONVERT(varchar(100), GETDATE(), 8): 10:57:46
Select CONVERT(varchar(100), GETDATE(), 9): 05 16 2006 10:57:46:827AM
Select CONVERT(varchar(100), GETDATE(), 10): 05-16-06
Select CONVERT(varchar(100), GETDATE(), 11): 06/05/16
Select CONVERT(varchar(100), GETDATE(), 12): 060516
Select CONVERT(varchar(100), GETDATE(), 13): 16 05 2006 10:57:46:937
Select CONVERT(varchar(100), GETDATE(), 14): 10:57:46:967
Select CONVERT(varchar(100), GETDATE(), 20): 2006-05-16 10:57:47
Select CONVERT(varchar(100), GETDATE(), 21): 2006-05-16 10:57:47.157
Select CONVERT(varchar(100), GETDATE(), 22): 05/16/06 10:57:47 AM
Select CONVERT(varchar(100), GETDATE(), 23): 2006-05-16
Select CONVERT(varchar(100), GETDATE(), 24): 10:57:47
Select CONVERT(varchar(100), GETDATE(), 25): 2006-05-16 10:57:47.250
Select CONVERT(varchar(100), GETDATE(), 100): 05 16 2006 10:57AM
Select CONVERT(varchar(100), GETDATE(), 101): 05/16/2006
Select CONVERT(varchar(100), GETDATE(), 102): 2006.05.16
Select CONVERT(varchar(100), GETDATE(), 103): 16/05/2006
Select CONVERT(varchar(100), GETDATE(), 104): 16.05.2006
Select CONVERT(varchar(100), GETDATE(), 105): 16-05-2006
Select CONVERT(varchar(100), GETDATE(), 106): 16 05 2006
Select CONVERT(varchar(100), GETDATE(), 107): 05 16, 2006
Select CONVERT(varchar(100), GETDATE(), 108): 10:57:49
Select CONVERT(varchar(100), GETDATE(), 109): 05 16 2006 10:57:49:437AM
Select CONVERT(varchar(100), GETDATE(), 110): 05-16-2006
Select CONVERT(varchar(100), GETDATE(), 111): 2006/05/16
Select CONVERT(varchar(100), GETDATE(), 112): 20060516
Select CONVERT(varchar(100), GETDATE(), 113): 16 05 2006 10:57:49:513
Select CONVERT(varchar(100), GETDATE(), 114): 10:57:49:547
Select CONVERT(varchar(100), GETDATE(), 120): 2006-05-16 10:57:49
Select CONVERT(varchar(100), GETDATE(), 121): 2006-05-16 10:57:49.700
Select CONVERT(varchar(100), GETDATE(), 126): 2006-05-16T10:57:49.827
Select CONVERT(varchar(100), GETDATE(), 130): 18 ???? ?????? 1427 10:57:49:907AM
Select CONVERT(varchar(100), GETDATE(), 131): 18/04/1427 10:57:49:920AM

标签: php

5
PHP编程
阅读:3944
评论:0

Undefined index 错误

Calchas 发表于 2009, April 1, 9:37 AM

Notice: Undefined index: Content in E:\website\wwwroot\article.php on line 61

PHP代码

while($row = mssql_fetch_row($result))
//while($row = mssql_fetch_array($result))
{
echo "<br /><a href=\"/item/$row[0].aspx\" target=\"_blank\">$row[1]</a>";
echo $row["Content"];//出错的地方
}

mssql_fetch_row 用来将查询结果 result 之单列拆到数组变量中。数组的索引是数字索引，第一个的索引值是 0。若 result 没有资料，则返回 false 值。

SO：在使用 mssql_fetch_row 的时候，只能使用$row[数字索引]这样的模式，如果想使用 $row[文字索引]，必须使用 mssql_fetch_array 来读取数据。

本函数用来将查询结果 result 拆到数组变量中。若 result 没有资料，则返回 false 值。而本函数可以说是 mssql_fetch_row() 的加强函数，除可以将返回列及数字索引放入数组之外，还可以将文字索引放入数组中。

标签: php

6
PHP编程
阅读:4800
评论:1

php5 无法连接 mssql2005

Calchas 发表于 2009, March 31, 3:04 PM

1、修改php.ini，将extension=php_mssql.dll前面的分号去掉，

2、将ntwdblib.dll拷贝到C:\WINDOWS\system32下。

重启服务器后，PHP应该可以正确加载 php_mssql.dll 了，如果仍无法正常连接 MSSQL 数据库且提示如下：
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: ***

解决办法：
1、安装 SQL Client ，配置 TCP/IP 支持；
2、在注册表添加以下条目：
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ MSSQLServer\Client\ConnectTo]
DSQUERY=DBNETLIB

标签: php

7
ASP.NET
阅读:4670
评论:0

.NET 下的 JS 对 CheckBox 取值

Calchas 发表于 2009, March 6, 3:27 PM

x.aspx

XML/HTML代码

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
<script language="javascript" type="text/javascript">
function checkAll()
{
var ckelems = document.getElementById("CheckBoxList1").getElementsByTagName("input");
var spelems = document.getElementById("CheckBoxList1").getElementsByTagName("span");
for(var i=0;i<ckelems.length;i++)
{
if(ckelems[i].type=="checkbox")
{
if(ckelems[i].checked)
alert('文本是 "'+spelems[i].text+'" 值是：'+spelems[i].value1);
}
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<span text="11" value1="111"><span text="11" value1="111"><span text="11" value1="111"><span text="11" value1="111"><span text="11" value1="111"><span text="11" value1="111"><span text="11" value1="111">
<asp:CheckBoxList ID="CheckBoxList1" runat="server" RepeatColumns="4">
</asp:CheckBoxList><br />
<input id="Button1" type="button" value="button" onclick="checkAll()"/>
</form>
</body>
</html>