Else's blog

<script language="JavaScript" type="text/javascript" src="jquery.js"></script>
<script language="javascript" type="text/javascript" >
function text()
{
  $.ajax({
   type: "POST",
   url: "some.php",
   data:   "name="+$("#name").attr("value")+"&content="+$("#content").attr("value") ,
   success: function(msg){ alert( "Data Saved: " +   msg );msg.innerHTML="OK"+msg; }
  });
}
</script>

$bookSQL=sprintf("UPDATE book SET pass=%s WHERE id=%d",
                              GetSQLValueString($_POST['list'], "text"),
                              GetSQLValueString($_GET['id'],"int"));

$Result = $db->query($bookSQL) or die(mysql_error());

function WindowPrint()
{
    if(document.all)
    {
        if(parseFloat(window.navigator.appVersion.substr(window.navigator.appVersion.indexOf("MSIE")+5, 3)) < 5.5)
        {
            var str  = '<object id=meizzMax classid="clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11">'
                str += '<param name="Command" value="print"></object>';
            document.body.insertAdjacentHTML("beforeEnd", str);
            document.all.meizzClose.Click();
        }
        else
        {
            window.opener = "meizz";
            window.print();
        }
    }
    else    window.print();;
}
</SCRIPT>

#全站热点文章
$site_hot_query=$db->query("SELECT id,title FROM ruby WHERE view=1  order by countruby desc LIMIT 0,12");
    $site_hot_list = array();  
    while($qs = $db->fetch_array($site_hot_query)){
      $qs['tte']    =$qs['title'];
      $qs['title']  = cnSubStr($qs['title'],34);
    $site_hot_list[] = $qs;
    }

<?php
#这个页要分页模板化
#如果是apache的话，做好分页的优化

require_once("./template.php");
require_once('./data/conn.php');
require_once('./mysql.php');
require_once('./data/function.php');
//声明类

//声明数据库  
$db = new Dirver();  
$db->DBLink($db_server,$db_username,$db_password,$db_name);
#以上是mysql数据库文件的设置  

#设模板的目录
$tl    = new template();
  $tl->template(
     array(
       'TplType'=>'html',
     'TemplateDir'=>'template/blue'
    )
);

$datetime   = "&nbsp;日期:".date("Y年 m月 d日 星期:l");

#显示网站大类

  function ShowMenu(){
    $sql="SELECT link,text,menu,opennew FROM menu WHERE `view` = 1 ORDER BY list ASC ";
    $rs=mysql_query($sql);
  do {
  if ($row_rs['opennew']==1)
     {
     $blank="target=\"_blank\"";
     }
   $mymenus.= "<a href=\"".$row_rs['link']."\" class=\"White\" ".$blank."title=\"".$row_rs['text']."\" >" .$row_rs['menu']."</a> \n";
  } while ($row_rs = mysql_fetch_assoc($rs));

    echo $mymenus;
    
  }

#显示留言

$maxRows_list = 5;      //每页显示留言数
$pageNum_list = 0;
if (isset($_GET['pageNum_list'])) {
  $pageNum_list = $_GET['pageNum_list'];
}


#分页优化
$Php2Html_FileUrl = $_SERVER["REQUEST_URI"];
$Php2Html_UrlString = str_replace("/", "", strrchr($Php2Html_FileUrl, "/"));
$pageNum_list=intval(intval($Php2Html_UrlString));//Integer type variable conversion
  if (!intval($pageNum_list))
  {
    $sid=intval($_GET['pageNum_list']);
    if(!intval($pageNum_list))
    {
      $pageNum_list=0;
    }
  }
  
  
$startRow_list = $pageNum_list * $maxRows_list;
$query_list = "select * from book order by id desc";
$query_limit_list = sprintf("%s LIMIT %d, %d", $query_list, $startRow_list, $maxRows_list);

  $query = $db->query($query_limit_list); //这里要修改


//----------------------------------------------------------------------
if (isset($_GET['totalRows_list'])) {
  $totalRows_list = $_GET['totalRows_list'];
} else {
  $all_list = mysql_query($query_list);
  $totalRows_list = mysql_num_rows($all_list);
}
$totalPages_list = ceil($totalRows_list/$maxRows_list)-1;

//------------------------------------------------------
$pageinfo="共 ".($totalPages_list + 1)." 页 $totalRows_list 条记录 当前第".($pageNum_list +1)."页 <a href=book.php/0>首页</a> <a href=book.php/".max(0, $pageNum_list - 1).">上一页</a> <a href=book.php/".min($totalPages_list, $pageNum_list + 1).">下一页</a> <a href=book.php/$totalPages_list>未页</a>";
//------------------------------------------------------



#全站热点文章
$site_hot_query=$db->query("SELECT id,title FROM ruby WHERE view=1  order by countruby desc LIMIT 0,15");

#本站推荐文章
$site_commend_query=$db->query("SELECT id,title FROM ruby WHERE view=1 order by commend=1,id desc LIMIT 0,15");
  //连载
$tl->set_file('book');
$tl->n();
$tl->p('book');
$db->close();
?>

<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">

</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
            BackColor="White" BorderColor="#336666" BorderStyle="Double" BorderWidth="3px"
            CellPadding="4" DataSourceID="AccessDataSource1" EmptyDataText="没有可显示的数据记录。"
            GridLines="Horizontal">
            <FooterStyle BackColor="White" ForeColor="#333333" />
            <Columns>
                <asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
                <asp:BoundField DataField="time" HeaderText="time" SortExpression="time" />
            </Columns>
            <RowStyle BackColor="White" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
        </asp:GridView>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="App_Data\data.mdb"
            SelectCommand="SELECT `title`, `time` FROM `ruby`"></asp:AccessDataSource>
    
    </div>
    </form>
</body>
</html>

$SiteUrl="http://{base}";

if (stristr($SiteUrl,"{base}")){
  $SiteUrl="http://".$_SERVER['SERVER_NAME'];
}