PHP入门

<html>
<head>
<title>filemanage</title>
</head>
<body>
<center>
<p><h2>文件管理</h2></p><br>
<table border=1><tr size=18>
<td>文件ID</td><td>文件名称</td><td>文件大小</td><td>上传时间</td><td>下载</td><td>删除</td></tr>
<?php
include("conn.php");
//echo '<table border=1>';
$rs=$db->query("select * from filem order by f_id DESC");
$i=1;
while($row = $rs->fetch_assoc())
{
$size=$row['f_size']/1024;
echo "<tr><td>".$i++."</td><td>".$row['f_name']."</td><td>".number_format($size, 2, '.', '')."KB</td><td>".$row['f_date']."</td><td><a href=".$row['f_url']." target=_blank>下载</a></td><td><a href=del.php?id=".$row['f_id'].">删除</a></td></tr>";
}
echo '</table>';
unset($rs);
$db->close();
?>
</center>
<br><br><hr><br>
<b><h2>uploadfile</h2></b>
<br>
<form enctype="multipart/form-data" action="" method="post">
选择上传文件:<br><input name="userfile" type="file"><br>
<input type="submit" value="发送">
</form>
<?php
if(!$_FILES["userfile"]["name"]) exit;
//echo $_FILES['userfile']['type'];
if ($_FILES['userfile']['error'] > 0)
{
    echo 'Problem: ';
    switch ($_FILES['userfile']['error'])
    {
      case 1: echo 'File exceeded upload_max_filesize'; break;
      case 2: echo '不能超过800M'; break;
      case 3: echo 'File only partially uploaded'; break;
      case 4: echo 'No file uploaded'; break;
    }
    exit;
}
else
{ //检查上传文件是否在允许上传的类型
   $tp = array("gif","jpeg","png","txt","doc","rar","zip","xls","bmp","wmv","mp3","flv","rmvb","avi");
if (!in_array(strtolower(substr(strrchr($_FILES['userfile']['name'], '.'),1)), $tp))

阅读全文

smarty结合xajax检测用户名

作者: phper
时间: 2015-07-04
分类: php代码

先看htm文件吧

阅读全文

apache rewrite 讲解

作者: phper
时间: 2015-07-04
分类: php代码

Apache Rewrite实例2007-03-04 11:25<VirtualHost *:80> ServerAdmin host@discuz.com DocumentRoot D:/www ServerName www.xiaojia.com ServerAlias xiaojia.com xiaojia.net ErrorLog D:/www/logs/xiaojia.com-error_log CustomLo...

阅读全文

php分页函数 [经典]

作者: phper
时间: 2015-07-04
分类: php代码

<?php
/*
  分页类
  design by xqbar
  qq:174171262
  email:wxddong@163.com
  blog:http://www.xqbar.com
  考虑输入参数
  size(每页记录数目)
  url(http://pic1.phprm.com/2015/07/04/拥刂?jpg)
  style(分页样式)
  sql(运行语句)
*/
class page{
public  $sql='';//分页sql语句
public  $url='';//分页传递过来的下页地址，可以另外加参数用来搜索使用
public  $size=10;//默认每页显示数据10条
public  $style=1;//默认分页显示风格
private $totalsize=0;//数据总数
private $totalpage=0;//总页数
private $page=1;//当前页
private $link;//数据库连接点
private $flag=false;//初始化标志点
private $offset=0;//分页偏移值 limit $offset,$size;
//构造函数传递数据库连接点
function __construct($link){
   $this->page=(isset($_GET['page'])&&!empty($_GET['page'])&&(int)($_GET['page']))?(int)$_GET['page']:1;//获取当前page参数值，确定当前是第几分页
   $this->link=$link;
}
//析构函数
function __destruct(){
  @mysql_close($this->link);
  $this->link=NULL;
}
  //构造函数兼顾<php5
function page($link){
   $this->__construct($link);
}
//初始化
function init(){
   if(empty($this->sql)){$this->halt("错误警告：<font color='red'>sql语句不能为空！</font>");exit();}//判断sql是否存在
  $this->sql=str_replace(sql);//">'@_',DB_PREFIX,$this->sql);//替换sql中的表前缀
   $this->size=($this->size<=0)?10:$this->size;//初始每页显示数据条数
  $this->page=($this->page<1)?1:$this->page;//当前页码值
   #大于第一页后优化查询总记录数
  //这里我使用了第一次浏览分页时查询数据库得出数据库总数，点下页时传递并不再查询数据库，数据量多时可能会节省些（自己想的）
  if($this->page==1&&!isset($_GET['tsize'])){
   sql">$result=@mysql_query($this->sql);
   $this->totalsize=@mysql_num_rows($result);
   @mysql_free_result($result);
  }else{
   //上面的问题唯一缺点就是用户手动在地址栏更改了tsize值后分页将不再正确
   $this->totalsize=(int)$_GET['tsize'];
}
   $this->url=(empty($this->url))?$_SERVER['PHP_SELF'].'?tsize='.$this->totalsize:$this->url.'&tsize='.$this->totalsize;//传递totalsize给下一页
  $this->totalpage=ceil($this->totalsize/$this->size);//获取总页数
  $this->page=($this->page>$this->totalpage)?$this->totalpage:$this->page;
  $this->offset=($this->page-1)*$this->size;//获取偏移值
}
  //查询数据库返回结果给二维数组
function fetch_array($result_type=MYSQL_BOTH){
   if(!$this->flag){$this->init();$this->flag=true;}
   if($this->totalsize<=0){return NULL;}
  $this->sql.=" limit $this->offset,$this->size";
  sql,$this->link">$result=@mysql_query($this->sql,$this->link);
  while($row=mysql_fetch_array($result,$result_type)){$rows[]=$row;}
  @mysql_free_result($result);
  return $rows;
}
  //获取总数据数
function getsize(){
   if(!$this->flag){$this-init();$this->flag=true;}//判断是否已经在此之前初始化过，是则直接返回（下同）
   return $this->totalsize;
}
//获取总页数
function getpage(){
   if(!$this->flag){$this-init();$this->flag=true;}
   return $this->totalpage;
}
//根据传入参数输出分页链接
function outpage(){
   if(!$this->flag){$this-init();$this->flag=true;}
  switch($this->style){
#1 第x页共x页首页上一页下一页尾页 x条/页共x页
case 1:
         $pagehtml="<span class='page'>第<i>{$this->page}</i>页共<i>{$this->totalpage}</i>页";
   $pagehtml.=($this->page==1)?" 首页上一页":" <a href='{$this->url}&page=1'>首页</a> <a href='{$this->url}&page=".($this->page-1)."'>上一页</a>";
         $pagehtml.=($this->page==$this->totalpage)?" 下一页尾页":" <a href='{$this->url}&page=".($this->page+1)."'>下一页</a> <a href='{$this->url}&page={$this->totalpage}'>尾页</a>";
   $pagehtml.=" 共<i>{$this->totalsize}</i>条</span>";
         break;
#1 首页上一页下一页尾页 x条/页共x页
case 2:
         $pagehtml="<span class='page'>";
   $pagehtml.=($this->page==1)?" 首页上一页":" <a href='{$this->url}&page=1'>首页</a> <a href='{$this->url}&page=".($this->page-1)."'>上一页</a>";
         $pagehtml.=($this->page==$this->totalpage)?" 下一页尾页":" <a href='{$this->url}&page=".($this->page+1)."'>下一页</a> <a href='{$this->url}&page={$this->totalpage}'>尾页</a>";
   $pagehtml.=" 共<i>{$this->totalsize}</i>条</span>";
         break;
#2 1 2 3 4 5
case 3:
         $offset=(ceil($this->page/10)-1)*10;
   $pagehtml="<span class='page'>";
   if($offset!=0){$pagehtml.="<a href='{$this->url}&page=1'>|<<</a> <a href='{$this->url}&page=".($this->page-1)."'><<</a>";}
   for($i=1;$i<=10;$i++){
   $n=$i+$offset;
   if($n>$this->totalpage){break;}
   if($n==$this->page){$pagehtml.=" <a href='{$this->url}&page=$n'><i>$n</i></a> ";}
   else{$pagehtml.=" <a href='{$this->url}&page=$n'><b>$n</b></a> ";}
   }
   if($n<$this->totalpage){$pagehtml.=" <a href='{$this->url}&page=".($this->page+1)."'>>></a> <a href='{$this->url}&page=$this->totalsize'>>>|</a>";}
   unset($offset,$i,$n);
         break;
#1
default:
         $pagehtml="第{$this->page}页共{$this->totalpage}页";
   $pagehtml.=($this->page==1)?" 首页上一页":" <a href='{$this->url}&page=1'>首页</a> <a href='{$this->url}&page=".($this->page-1)."'>上一页</a>";
         $pagehtml.=($this->page==$this->totalpage)?" 下一页尾页":"  <a href='{$this->url}&page=".($this->page+1)."'>下一页</a> <a href='{$this->url}&page={$this->totalpage}'>尾页</a>";
         break;
  }
return $pagehtml;
}
//错误输出
function halt($msg){
  echo "<html>";
  echo "<head>";
  echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>rn";
  echo "<title>Error</title>";
  echo "</head>";
  echo "<body><p style='line-helght:150%;font-size:10pt'>";
  echo $msg;
  echo "</p></body>";
  echo "</html>";
}
}
?>