php 文章分页效果代码

/前台分页函数
function multi($num, $perpage, $curpage, $mpurl, $maxpages = 0, $page = 10, $autogoto = TRUE, $simple = FALSE) {
 //global $maxpage;
 $ajaxtarget = !empty($_GET['ajaxtarget']) ? " ajaxtarget="".htmlspecialchars($_GET['ajaxtarget'])."" " : '';

 $multipage = '';
 $mpurl .= strpos($mpurl, '?') ? '&' : '?';
 $realpages = 1;
 if($num > $perpage) {
  $offset = 2;

  $realpages = @ceil($num / $perpage);
  $pages = $maxpages && $maxpages < $realpages ? $maxpages : $realpages;
  //$curpage = $curpage < $realpages ? $curpage : $realpages;

  if($page > $pages) {
   $from = 1;
   $to = $pages;
  } else {
   $from = $curpage - $offset;
   $to = $from + $page - 1;
   if($from < 1) {
    $to = $curpage + 1 - $from;
    $from = 1;
    if($to - $from < $page) {
     $to = $page;
    }
   } elseif($to > $pages) {
    $from = $pages - $page + 1;
    $to = $pages;
   }
  }

  $multipage = ($curpage - $offset > 1 && $pages > $page ? '<a href="'.$mpurl.'page=1" class="first"'.$ajaxtarget.'>1 ...</a>' : '').
   ($curpage > 1 && !$simple ? '<a href="'.$mpurl.'page='.($curpage - 1).'" class="prev"'.$ajaxtarget.'>&lsaquo;&lsaquo;</a>' : '');
  for($i = $from; $i <= $to; $i++) {
   $multipage .= $i == $curpage ? '<strong>'.$i.'</strong>' :
    '<a href="'.$mpurl.'page='.$i.($ajaxtarget && $i == $pages && $autogoto ? '#' : '').'"'.$ajaxtarget.'>'.$i.'</a>';
  }

  $multipage .= ($curpage < $pages && !$simple ? '<a href="'.$mpurl.'page='.($curpage + 1).'" class="next"'.$ajaxtarget.'>&rsaquo;&rsaquo;</a>' : '').
   ($to < $pages ? '<a href="'.$mpurl.'page='.$pages.'" class="last"'.$ajaxtarget.'>... '.$realpages.'</a>' : '').
   (!$simple && $pages > $page && !$ajaxtarget ? '<kbd><input type="text" name="custompage" size="3" onkeydown="if(event.keyCode==13) {window.location=''.$mpurl.'page='+this.value; return false;}" /></kbd>' : '');

  $multipage = $multipage ? '<div class="pages">'.(!$simple ? '<em>&nbsp;'.$num.'&nbsp;</em>' : '').$multipage.'</div>' : '';
 }
 $maxpage = $realpages;
 return $multipage;
}

php+ajax 仿google 下拉框代码一,这里php代码

<?php
header('Content-Type:text/html;charset=utf-8');
require('../../admin/include/db_conf.php');
if($_POST['add']){
    $keyword = trim($_POST['keyword']);
    if(empty($keyword)){
        header("LOCATION: suggest.html");
        exit;
    }
    $db = db_connect();
    $db->query("set names 'gb2312'");
    $sql = "select*from suggest where keyword = '$keyword'";
    if($db->query($sql)->num_rows>0){
        header("LOCATION: suggest.html");
        exit;
    }
    $num = rand(15, 2008);
    $sql = "insert into suggest values(NULL, '$keyword', $num)";
    $db->query($sql);
    $db = NULL;
    header("LOCATION: suggest.html");
    exit;
}
$keyword = $_POST['keyword'];
if(empty($keyword)){
    echo 'null';
    exit;
}
$db = db_connect();
$db->query("set names 'utf8'");
$sql = "select *from suggest where keyword REGEXP '^$keyword'  order by id desc limit 0, 15";
$result = $db->query($sql);
if($result->num_rows<1){
    echo 'null';
    exit;
}
$arr = array();
while($rows=$result->fetch_object()){
    $keyword = $rows->keyword;
    $arr[]="['$keyword', '$rows->num ".iconv('gb2312','utf-8','结果')."']";
}
$arr = '['.implode(',',$arr).']';
echo $arr;
?>

unction cg_stripslashes($array) {
 if (is_array($array)) {
  foreach ($array as $k => $v) {
   $array[$k] = cg_stripslashes($v);
  }
 } else if (is_string($array)) {
  $array = stripslashes($array);
 }
 return $array;
}

// 添加转义
function cg_addslashes($string) {
 if(is_array($string)) {
  foreach($string as $key => $val) {
   $string[$key] = cg_daddslashes($val);
  }
 } else {
  $string = addslashes($string);
 }
 return $string;
}
?>

下面来看看php 如何导入.sql文件的代码

<?php
if(!defined('WEBROOT')) {
 die('Access Denied!');
}
class dbsql {
 var $dblink = NULL;
 var $queryCount = 0;
 
 function dbconnect($dbserver, $dbuser, $dbpwd, $dbname = '', $pconnect = 0, $charset = 'utf8') {
  if($pconnect) {
   if(!$this->dblink = @mysql_pconnect($dbserver, $dbuser, $dbpwd)) {
    $this->msghalt('Can not connect to MySQL server');
   }
  } else {
   if(!$this->dblink = @mysql_connect($dbserver, $dbuser, $dbpwd)) {
    $this->msghalt('Can not connect to MySQL server');
   }
  }

  /* if($this->version() > '4.1') {
   global $charset, $dbcharset;
   if(!$dbcharset && in_array(strtolower($charset), array('gbk', 'big5', 'utf-8'))) {
    $dbcharset = str_replace('-', '', $charset);
   }

   if($dbcharset) {
    @mysql_query("SET character_set_connection=$dbcharset, character_set_results=$dbcharset, character_set_client=binary", $this->dblink);
   }

   if($this->version() > '5.0.1') {
    @mysql_query("SET sql_mode=''", $this->dblink);
   }
  } */
  
  @mysql_query('set names "utf8"');

  if($dbname) {
   if(!mysql_select_db($dbname, $this->dblink)) {
    $this->msghalt('Can not connect to MySQL server');
   }
  }
 }
 
 function select_db($dbname) {
  return @mysql_select_db($dbname, $this->dblink);
 }
 
 function query($sql = '') {
  if($sql) {
   if(!($query = mysql_query($sql,$this->dblink))) {
    $this->msghalt("MYSQL Query Error!n $sql");
   } else {
    $this->queryCount++;
    return $query;
   }
  } else {
   return false;
  }
 }
 
 function unb_query($sql = '') {
  if($sql) {
   if(!($query = mysql_unbuffered_query($sql,$this->dblink))) {
    $this->msghalt('MYSQL Query Error!<br />'.$sql.'<br />');
   } else {
    $this->queryCount++;
    return $query;
   }
  } else {
   return false;
  }
 }
 
 function fetch_array($query, $result_type = MYSQL_ASSOC) {
  return mysql_fetch_array($query, $result_type);
 }
 
 function fetch_one($sql) {
  return $this->fetch_array($this->query($sql));
 }
 
 function affected_rows() {
  return mysql_affected_rows($this->dblink);
 }
 
 function num_rows($query, $q = 1)
 {
  if($q == 1) {
   return mysql_num_rows($query);
  } else {
   return mysql_num_rows($this->query($query));
  }
  //return $query;
 }
 
 function result($query, $row) {
  $query = @mysql_result($query, $row);
  return $query;
 }
 
 function num_row($query) {//暂时没用
  return mysql_num_rows($query);
 }
 
 function free_result($query) {
  return mysql_free_result($query);
 }
 
 function insert_id() {
  return ($id = mysql_insert_id($this->dblink)) >= 0 ? $id : $this->result($this->query("SELECT last_insert_id()"));
 }
 
 function num_fields($query) {
  return mysql_num_fields($query);
 }
 
 function version() {
  return mysql_get_server_info($this->dblink);
 }
 
 function close() {
  return mysql_close($this->dblink);
 }
 
 function insert_data($tname, $data) {
  $values = '';
  $filed = implode(',', array_keys($data));
  $filednum = count($data) - 1;
  //echo $filednum;
  $i = 0;
  
  foreach($data as $key => $val) {
   $values .= "'".$val."'";
   if($i < $filednum) {
    $i++;
    $values .= ',';
   }
  }
  $sql = "INSERT INTO ".$tname." (".$filed.") VALUES(".$values.")";
  return $this->unb_query($sql);
 }
 
 function update_data($tname, $fid, $data, $whereid = 'id') {
  $col = array();
  foreach($data as $key => $values)
  {
   $col[] = $key."='".$values."'";
   
  }
  $sql = "UPDATE ".$tname." SET ".implode(',', $col)." WHERE $whereid='$fid'";
  return $this->unb_query($sql);
 }
 
 function error() {
  return (($this->dblink) ? mysql_error($this->dblink) : mysql_error());
 }
 
 function errno() {
  return intval(($this->dblink) ? mysql_errno($this->dblink) : mysql_errno());
 }
 
 function msghalt($msg = '') {
  $message = "<html>n<head>n";
  $message .= "<meta content="text/html; charset=utf-8" http-equiv="Content-Type">n";
  $message .= "<style type="text/css">n";
  $message .=  "body,p,pre {n";
  $message .=  "font:12px Verdana;n";
  $message .=  "}n";
  $message .=  "</style>n";
  $message .= "</head>n";
  $message .= "<body bgcolor="#FFFFFF" text="#000000" link="#006699" vlink="#5493B4">n";

  $message .= "<p>Datebase Error:</p><pre><b>".htmlspecialchars($msg)."</b></pre>n";
  $message .= "<b>Mysql error number</b>: ".$this->errno()."n<br />";
  $message .= "<b>Mysql error description</b>: ".htmlspecialchars($this->error())."n<br />";
  $message .= "<b>Date</b>: ".date("Y-m-d @ H:i")."n<br />";
  $message .= "<b>Script</b>: http://".$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF'] .'?'.$_SERVER['QUERY_STRING']."n<br />";

  $message .= "</body>n</html>";
  echo $message;
  exit;
 }
}

/**********************
$sb = new dbsql();
$sb->dbconnect('localhost','root','','fdwp');
echo 'fdfd';
****************************/
?>