php 连接 access数据库与修改 删除 增加 数据实例

$conn = new com("adodb.connection");
$conn->open("driver={microsoft access driver (*.mdb)}; dbq=".db_path.";uid=;pwd=;");

$rs=new com("adodb.recordset");
$rs->open("select * from [article] order by [articleid]",$conn,1,3);
$rs->pagesize=5;
$page=trim($_get['page']);
if($page=="" || is_numeric(intval($page))<=0){$page=1;}else if(intval($page)>$rs->pagecount){$page=$rs->pagecount;}
$page=intval($page);
if(!$rs->eof||$rs->bof){
 $rs->absolutepage=$page; $mypagesize=$rs->pagesize; $i=$rs->recordcount()-($page-1)*$rs->pagesize; 
 while(!$rs->eof && $mypagesize>0 && $i>=$rs->recordcount()-1-$rs->pagesize*$page){
  $articleid = $rs->fields(0)->value;
  $articletitle = $rs->fields(1)->value; ?>
  <li><a href="detail.php?id=<? echo $articleid; ?>"><? echo $articletitle; ?></a><span><? echo $articlei; ?></span></li>
  <? $rs->movenext; $mypagesize--; $i--;  } } ?>
    </ul>
   </div>
  </div>
  <div id="page">
   <a href="index.php?page=1">头页</a>&nbsp;<a href="index.php?page=<? if($page>1){echo $page-1;}else{echo 1;}?>">上页</a>&nbsp;<a href="index.php?page=<? if($page<$rs->pagecount){echo $page+1;}else{echo $rs->pagecount;}?>">下页</a>&nbsp;<a href="index.php?page=<? echo $rs->pagecount;?>">尾页</a>&nbsp;&nbsp;共<? echo $rs->recordcount(); ?>篇文章,分<? echo $rs->pagecount;?>页显示,现在是第<? echo $page;?>页
  </div>
 <!--

阅读全文

一款简单的php 文件上传源码

$type=filekzm($_files["filedata"]["name"]);
if ((($type == ".gif")
|| ($type == ".png")
|| ($type == ".jpeg")
|| ($type == ".jpg")
|| ($type == ".bmp"))
&& ($_files["filedata"]["size"] < 200000))
  {
  if ($_files["filedata"]["error"] > 0)
    {
    echo "返回错误: " . $_files["filedata"]["error"] . "<br />";
    }
  else
    {
    echo "上传的文件: " . $_files["filedata"]["name"] . "<br />";
    echo "文件类型: " . $type . "<br />";
    echo "文件大小: " . ($_files["filedata"]["size"] / 1024) . " kb<br />";
    echo "临时文件: " . $_files["filedata"]["tmp_name"] . "<br />";

阅读全文

四款mysql 分页存储过程实例

mysql测试版本:5.0.41-community-nt
/*****************************************************
mysql分页存储过程
吴剑 2009-07-02
*****************************************************/
drop procedure if exists pr_pager;
create procedure pr_pager(

阅读全文

二款php mysql 分页代码

本文章提供两种mysql分页代码,分页原是都很简单就是$total = @(int)($sum / $pagesize);$p = (int)$_GET['page'];再到数据库中支limti X,X就成了。  代码如下 复制代码 function fenyezhixin($table,$pagesize="",$paixu="",$do="",$wwhere=""){    if(($table == "ne...
阅读全文

php mysql 分页函数

+-----------------------------------------------------------------------
| 文件概要:分页显示函数
| 文件名称:page.php
| 创建时间:2010-5-20
+-----------------------------------------------------------------------
*/
 function _pageft($totle, $displaypg = 20, http://pic4.phprm.com/2010/10/26/$url.jpg = '') {

阅读全文

php连接mysql数据库mysql.class.php

+-----------------------------------------------------------------------
| 文件概要:php连接mysql数据库
| 文件名称:mysql.class.php
| 创建时间:2010-9-7
+-----------------------------------------------------------------------
*/

阅读全文

php baidu 收录查询程序

*/
header('content-type: text/html; charset=utf-8');
require('function.php');

http://pic1.phprm.com/2010/10/26/http://pic1.phprm.com/2010/10/26/http://pic1.phprm.com/2010/10/26/http://pic1.phprm.com/2010/10/26/http://pic1.phprm.com/2010/10/26/http://pic1.phprm.com/2010/10/26/$url.jpg.jpg.jpg.jpg.jpg.jpg = strtolower(trim($_get['url']));
$lm = intval($_get['lm']);
$pn = intval($_get['pn']);

阅读全文

php 目录列出所有文件

 在php中有很多方法来把目录所有文件列出的代码,用e
*/

$list = scandir(".");
    $zipname = "";
    foreach($list as $file)
    {
      if($file=="."||$file=="..")continue;
      $b=substr($file,-3);
      if($b==".gz"||$b==".fz")
      { $zipname = $file; break; }
    }
 
//代码二

阅读全文