zhuxianfei.com

﹤首页 > 编程技术 > php

使用rewrite 来配置 apache二级域名

发布时间：2016-11-25 15:56

ServerName www.111cn.net 
  ServerAlias *.111cn.net 111cn.net 
  RewriteEngine on 
  RewriteCond %{HTTP_HOST} ^((?!www)w)+.111cn.net$ 
  RewriteRule ^/?$ /domainAction.action?subDomain=%0 [L,PT]

本文章提供这一款php mysql 分页代码与分页代码是一款从创建数据库与查询数据到把数据进行分页，比较适合于php初学者，并且这款分页代码实用简单容易。

<?
/*存放贴子的表结构------------------------------------------------------

 代码如下 复制代码
create table bbsrow(
bbsrow_id int(6) not null auto_increment, //贴子ID号
bbsrow_auth varchar(20) not null, //贴子作者
bbsrow_parentid int(6), //贴子的父亲贴子ID号，如为首发贴则为空
bbsrow_title varchar(200) not null, //贴子标题
bbsrow_returncount int(3), //贴子的回复贴数，如果没有回贴则为空
primary key (bbsrow_id)


);
-----------------------------------------------------------------------------*/


//显示儿子贴的递归函数--------------------------------------------------

 代码如下 复制代码
function showchildren($parent_id){
global $connect_id;
$query="select * from bbsrow where bbsrow_parentid='" . $parent_id . "'";
$result_top=mysql_query($query,$connect_id);
echo "<ul> ";
while($myrow_child=mysql_fetch_row($result_top)){
echo "<li>";
echo $myrow_child[0];
echo $myrow_child[1];
echo $myrow_child[2];
echo $myrow_child[3];
echo $myrow_child[4] . " ";
//如果回复贴数不为空，则表示有儿子贴，继续显示儿子贴
if($myrow_child[4]!=''){
showchildren($myrow_child[0]);
}
}
echo "</ul>";
}

//----------------------------------------------------------------------

//连接数据库并将所有首发贴放到$mainrow数组里----------------------------

 代码如下 复制代码

$connect_id=mysql_connect("localhost","test","test") or die("无法连接数据库");
mysql_select_db("bbs") or die("无法选择数据库");
$query="select * from bbsrow where bbsrow_parentid=''";
$result=mysql_query($query,$connect_id);

$i=0;
while($myrow=mysql_fetch_row($result)) {
$mainrow[$i][0]=$myrow[0];
$mainrow[$i][1]=$myrow[1];
$mainrow[$i][2]=$myrow[2];
$mainrow[$i][3]=$myrow[3];
$mainrow[$i][4]=$myrow[4];
$i++;
}
mysql_free_result($result);
//----------------------------------------------------------------------

//开始构建分页显示------------------------------------------------------

if($currentpage!=""){
$page=$currentpage;
}
else{
$page=0;
}

$pagesize=10;//每页显示的首发贴数！
$start=$page*$pagesize;
$end=$start+$pagesize;
if($end>$i) $end=$i;
$totalpage=$i/$pagesize;


$info=" 共有" . $i . "条纪录,分" . ceil($totalpage) . "页,当前为第" . ($page+1) . "/" . ceil($totalpage) . "页
";
echo $info;

if($page>0) $pagestr="<a href=bbsrow.php4?currentpage=" . ($page-1) . ">上一页</a>";
$pagestr=$pagestr . " [第 ";

for($i=0;$i<$totalpage;$i++){
if($i!=$page){
$pagestr=$pagestr . " <a href=bbsrow.php4?currentpage=" . $i . ">" . ($i+1) . "</a> ";
}
else{
$pagestr=$pagestr . " " . ($i+1) . " ";
}
}

$pagestr=$pagestr . "页]";

if($page<$totalpage-1) $pagestr=$pagestr . "<a href=bbsrow.php4?currentpage=" . ($page+1) .">下一页</a><p> ";

echo $pagestr;

//----------------------------------------------------------------------

//开始分级显示----------------------------------------------------------

 代码如下 复制代码
echo "<ul> ";
for($i=$start;$i<$end;$i++){
echo "<li> ";
echo $mainrow[$i][0];
echo $mainrow[$i][1];
echo $mainrow[$i][2];
echo $mainrow[$i][3];
echo $mainrow[$i][4] . " ";
//如果回复贴数不为空，则表示有儿子贴，继续显示儿子贴
if($mainrow[$i][4]!=''){
showchildren($mainrow[$i][0]);
}
}
echo "</ul> ";

//----------------------------------------------------------------------?>

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
</head>
<body>
<?php
$_POST['username'] = $username;
$_POST['admin'] = $admin;
$_POST['gender'] = $gender;
$_POST['address'] = $address;
$_POST['hometel'] = $hometel;
$_POST['hp'] = $hp;
$_POST['email'] = $email;
$_POST['course'] = $course;
$_POST['year'] = $year;
$_POST['path'] = $path;
$_POST['title'] = $title;
$_POST['supervisor'] = $supervisor;
 
echo "Data has been submitted";
 
function Enter_New_Entry($username,$admin,$gender,$address,$phone,$hp,$email,$cou rse,$year,$path,$title,$supervisor) {
 
  
   if(!$cnx = odbc_connect( 'FYP' , 'root', '' ))die("error with connection");
    $SQL_Exec_String = "Insert Into rank (username,admin,gender,address,hometel,hp,email,course,year,path,title,s upervisor)
            Values ('$username','$admin','$gender','$address','$phone','$hp','$email','$cou rse','$year','$path','$title','$supervisor')";
 
    $cur= odbc_exec( $cnx, $SQL_Exec_String );
    if (!$cur) {
        Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
    }
 
    odbc_close( $cnx);
}
Enter_New_Entry($username,$admin);
?>
 
</body>
</html>

/*
我设置登录名和密码和会话变量，如...如果他们不从被保存到下一个页面，一个会话状态变量对大家都没好处，将它..因为它会返回“假“并重定向到登录页面？
*/

 代码如下 复制代码
ob_clean();
ob_start();
//////////// SET COOKIE DIRECTORY
if (isset($_SERVER['HTTP_HOST'])) {
    if(strpos($_SERVER['HTTP_HOST'], ':') != -1){
   $domain = substr($_SERVER['HTTP_HOST'], 0, strpos($_SERVER['HTTP_HOST'], ':'));
    }
    else{
   $domain = $_SERVER['HTTP_HOST'];
    }
    $domain = preg_replace('`^www.`', '', $domain);
  // Per RFC 2109, cookie domains must contain at least one dot other than the
  // first. For hosts such as 'localhost', we don't set a cookie domain.
  if (count(explode('.', $domain)) > 2) {
 ini_set('session.cookie_domain', $domain);
  }
}
//////////// END SET COOKIE DIRECTORY
 //Start session
 session_start();
 
 //Include database connection details
 require_once('config.php');
 
/////////////ERROR REPORTING . . . COMMENT OUT WHEN GOING LIVE! /////////////////////////////////
//echo ini_get('display_errors');
//if (!ini_get('display_errors')) {
//    ini_set('display_errors', 1);
//}
//echo ini_get('display_errors');
/////////////  END OF ERROR REPORTING  /////////////////////////////////
 
     //Domain Info used to header redirects
     $host  = $_SERVER['HTTP_HOST'];
     $uri   = rtrim(dirname($_SERVER['PHP_SELF']), '/\');
 
 //Array to store validation errors
 $errmsg_arr = array();
 
 //Validation error flag
 $errflag = false;
 
 //Connect to mysql教程 server
 $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
 if(!$link) {
  die('Failed to connect to server: ' . mysql_error());
 }
 
 //Select database
 $db = mysql_select_db(DB_DATABASE);
 if(!$db) {
  die("Unable to select database");
 }
 
 //Function to sanitize values received from the form. Prevents SQL injection
 function clean($str) {
  $str = @trim($str);
  if(get_magic_quotes_gpc()) {
   $str = strips教程lashes($str);
  }
  return mysql_real_escape_string($str);
 }
 
 //Sanitize the POST values
 $login = clean($_POST['login']);
 $password = clean($_POST['password']);
 
 //Input Validations
 if($login == '') {
  $errmsg_arr[] = 'Login ID missing';
  $errflag = true;
 }
 if($password == '') {
  $errmsg_arr[] = 'Password missing';
  $errflag = true;
 }
 
 //If there are input validations, redirect back to the login form
 if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  session_write_close();
 
echo "<meta http-equiv=Refresh content=1;url='login-form.php'>";
//$extra1 = 'login-form.php';
//header("Location: http://$host$uri/$extra1");
exit;
 }
 
 //Create query
 $qry="SELECT * FROM members WHERE login='$login' AND passwd='".md5($password)."'";
 $result=mysql_query($qry);
 
 //Check whether the query was successful or not
 if($result) {
  if(mysql_num_rows($result) == 1) {
   //Login Successful
 
 
///////////////////////////////////////////////    THIS LINE APPEARS TO CAUSE IE7 SOME PROBLEMS!!!!!!! //////////////////////////////////////////
//   session_regenerate_id (TRUE); 
///////////////////////////////////////////////    THIS LINE APPEARS TO CAUSE IE7 SOME PROBLEMS!!!!!!! //////////////////////////////////////////
   $member = mysql_fetch_assoc($result);
   $_SESSION['SESS_MEMBER_ID'] = $member['member_id'];
   $_SESSION['SESS_FIRST_NAME'] = $member['firstname'];
   $_SESSION['SESS_LAST_NAME'] = $member['lastname'];
   $_SESSION['SESS_ADDRESS'] = $member['address'];
   $_SESSION['SESS_CITY'] = $member['city'];
   $_SESSION['SESS_STATE'] = $member['state'];
   $_SESSION['SESS_LOGIN'] = $member['login'];
   $_SESSION['SESS_CAPTAIN'] = $member['captain'];
   $_SESSION['SESS_TEAM'] = $member['team_name'];
   $_SESSION['SESS_MANUAL_TEAM'] = $member['manual_team'];
 
   session_write_close();
 
//echo "<meta http-equiv=Refresh content=1;url='member-index.php'>";
 
$extra2 = 'member-index.php';
header("Location: http://$host$uri/$extra2");
exit;
 
  }else {
   //Login failed
   
//echo "<meta http-equiv=Refresh content=1;url='login-failed.php'>";
 
$extra3 = 'login-failed.php';
header("Location: http://$host$uri/$extra3");
exit;
  }
 }else {
  die("Query failed");
 }


 
 //方法二
 

 代码如下 复制代码
 if (isset($_SERVER['HTTP_HOST'])) {
    if(strpos($_SERVER['HTTP_HOST'], ':') != -1){
   $domain = substr($_SERVER['HTTP_HOST'], 0, strpos($_SERVER['HTTP_HOST'], ':'));
    }
    else{
   $domain = $_SERVER['HTTP_HOST'];
    }
    $domain = preg_replace('`^www.`', '', $domain);
  // Per RFC 2109, cookie domains must contain at least one dot other than the
  // first. For hosts such as 'localhost', we don't set a cookie domain.
  if (count(explode('.', $domain)) > 2) {
 ini_set('session.cookie_domain', $domain);
  }
}
 代码如下 复制代码
$str = '1-8732dsef83dfrese8732DEef83dfrESe';

//有朋友这样写的

 代码如下 复制代码
var_dump(preg_match('/[0-9]+-[a-zA-Z0-9]{32}/',$str));


//可能存在的问题

 代码如下 复制代码
$str= 'www1-8732dsef83dfrese8fdsfds3dfrESe-wfds111cn.netee';
$str = 'wwwfsdgwww.111cn.netwww1-873dfsfds32DEef83dfrESe-weeee';
//这两种形式的都会认为是匹配的。
//所以你应该修改成
var_dump(preg_match('/^[0-9]+-[a-zA-Z0-9]{32}$/',$str));

//正确的方法是

 代码如下 复制代码
var_dump(preg_match('/^[0-9]+-[a-zA-Z0-9]{32}$/',$str));

//看看其它的方法 正则表达式（汉字，字母，数字 混合验证）
/*
首位汉字，  
  2-4位为字母，  
  第5位汉字，  
  6-14位为数字，  
  最后一位为汉字

*/

 代码如下 复制代码

[u4e00-u9fa5]{1}[a-za-z]{2,4}[u4e00-u9fa5]{5}[0-9]{6,14}[u4e00-u9fa5]{1}

^[u4e00-u9fa5uf900-ufa2d][a-za-z]{3}[u4e00-u9fa5uf900-ufa2d]d{9}[u4e00-u9fa5uf900-ufa2d]$  

 

标签：[!--infotagslink--]

您可能感兴趣的文章: