易截截图软件、单文件、免安装、纯绿色、仅160KB

asp和mysql分页代码

 <!--#include file="zheboconn.asp"-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>asp和mysql分页代码</title>
<style type="text/css">
<!--
.STYLE3 {
 font-size: 15px;
 font-family: "宋体";
 color: #000000;
}
img{border:none}
.STYLE1 {
 font-family: "文鼎CS中黑";
 color: #ffffff;
 font-size: 18px;
}
-->
</style>
</head>
<body scroll="no"> //去掉滚动条
  <table width="97%" border="0" align="center" scroll="no">
    <tr>
      <td height="35" valign="top"><%
'asp+mysql分页
Dim strSql,Rs
Dim intRecordNum,intCurrentPage,intRowcount
Dim intPageCount:intPageCount = 5  '每页5条记录
intRowcount = 0
'获得总记录
Set Rs = Conn.Execute("SELECT COUNT(*) As intcounts from  表名")               
If Rs.Eof And Rs.Bof Then
 intRecordNum = 0
Else
 intRecordNum = Cint(Rs("intcounts"))
End If
Dim intTotalPages
If (intRecordNum mod intPageCount)>0 Then
 intTotalPages = Int(intRecordNum/intPageCount) + 1
Else
 intTotalPages = intRecordNum/intPageCount
End If
intCurrentPage = 1
If IsEmpty(Request("intCurrentPage")) Or IsNull(Request("intCurrentPage")) Or Trim(Request("intCurrentPage"))="" Or (Not IsNumeric(Request("intCurrentPage"))) Or Len(Request("intCurrentPage"))>8 Then
 intCurrentPage = 1
ElseIf Clng(Request("intCurrentPage")) < 1 Then
 intCurrentPage = 1
ElseIf Clng(Request("intCurrentPage")) > intTotalPages Then
 intCurrentPage = intTotalPages
Else
 intCurrentPage = Clng(Request("intCurrentPage"))
End If
Set Rs = Nothing
Set Rs = Server.CreateObject("ADODB.RecordSet")
strSql = "SELECT * from  表名  Order By id DESC LIMIT " & (i


相关文档:

Asp全选代码


<script language="javascript">
function CheckAll(form)
{ ///定义函数checkall,参数为form
for (var i=0;i<form.elements.length;i++)
///循环,form.elements.length得到表单里的控件个数
{
///把表单里的内容依依付给e这个变量
var e = form.elements[i];
if (e.name != 'chkall')
e.checked = for ......

如何更改MySQL数据库存储位置

$sudo nano /etc/apparmor.d/usr.sbin.mysqld
在gedit中找到/var/lib/mysql/这两行,注释掉这两行,在这两行前分别添加一个符号“#”即可注释,在这两行之前或
之后加上下面内容:
/home/mysql/ r,
/home/mysql/** rwk,
保存后退出,执行命令:
$sudo /etc/init.d/apparmor reload
返回Reloading AppArmo ......

mysql远程权限设置

 1、进入mysql,创建一个新用户xuys:
格式:grant 权限 on 数据库名.表名 用户@登录主机 identified by "用户密码";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
   查看结果,执行:
   use mysql;
   select host,user,p ......

CentOS下Mysql实现数据库主从同步

CentOS下Mysql实现数据库主从同步
一、环境
  A服务器: 192.168.10.42    主服务器master  CentOS 5  Mysql 5.1.34
  B服务器: 192.168.10.68    副服务器slave   CentOS 5  Mysql 5.0.56
二、设置Master服务器
  1、编辑Master上的/etc/my.cnf文件
    ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号