经典全面的php取得url参数与域名代码

经典全面的php取得url参数与域名代码

if(!isset($_SERVER['REQUEST_URI'])) {
  $_SERVER['REQUEST_URI'] = substr($_SERVER['argv'][0],strpos($_SERVER['argv'][0],';') + 1);
 }

 /*
 +-------------------------------------------
 + Fix: Success
 +-------------------------------------------
 */
 if ($_SERVER['REQUEST_URI']){

  /*
  +---------------------------------------
  + Check true string
  +---------------------------------------
  */
  if (strpos(strtolower($urlconf['domains']),'http://') === false){
   $URI_CONFIG_LENGTH = strlen($urlconf['domains'].$urlconf['default']) + 1;
   $URI_QUESTED_LENGTH = strlen($_SERVER['REQUEST_URI']);
   $_SERVER['REQUEST_URI'] = substr($_SERVER['REQUEST_URI'],$URI_CONFIG_LENGTH,($URI_QUESTED_LENGTH - $URI_CONFIG_LENGTH));
  }else{
   $URI_CONFIG_LENGTH = $urlconf['domains'].$urlconf['default'].'/';
   $URI_QUESTED_LENGTH = 'http://'.($_SERVER['HTTP_HOST'] ? $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME']).$_SERVER['REQUEST_URI'];
   $_SERVER['REQUEST_URI'] = str_replace($URI_CONFIG_LENGTH,'',$URI_QUESTED_LENGTH);
  }
  $_SERVER['REQUEST_URI'] = str_replace($urlconf['extents'],'',$_SERVER['REQUEST_URI']);

  /*
  +---------------------------------------
  + Rewrite uri variables
  +---------------------------------------
  */
  $URI_REQUESTED_VARIABLES = explode('/',$_SERVER['REQUEST_URI']);
  if ($URI_REQUESTED_VARIABLES['0']){
   $action = $URI_REQUESTED_VARIABLES['0'];
   if ($URI_REQUESTED_VARIABLES['1']){
    $option = $URI_REQUESTED_VARIABLES['1'];
    if ($URI_REQUESTED_VARIABLES['2']){
     $extent = $URI_REQUESTED_VARIABLES['2'];
     //if ($action == 'display'){
      $info = $extent;
     //}
     if ($URI_REQUESTED_VARIABLES['3']){
      $info = $URI_REQUESTED_VARIABLES['3'];
     }
    }else{
     $extent = $info = '';
    }
   }else{
    $option = $extent = $info = '';
   }
  }else{
   $action = $option = $extent = $info = '';
  }
 }

我们来看看关于php 导入mysql数据到access方法 哦,下面是一个简单的实例哦,如果你正在把mysql的数据导入到access的话看到这肯定肯定可以实例了.

mysql数据库表sqltable
字段id，name，sex，email

access数据库表accesstable
id，name，sex，email

<?
$connect = mysql_connect("localhost","","");
mysql_select_db("mydatabase");
$sql = "select * from sqltable;
$result = mysql_query($sql};
$connectodbc=odbc_connect("DSN","USERNAME","PASSWORD");
while($row = mysql_fetch_row($result))
{
$sql="insert into accesstable

values($row["id",$row["name",$row["sex"],$row["email"])";
odbc_do($connectodbc,$sql);
}
odbc_close($connectodbc);
mysql_close($conect);
?>

php 分页程序代码

<?php
    $tempquery = mysql_query("select dpb,facejtype from zgy_member_p_d_basic where  dpb = '$city' and      facejtype like '%$keyword%' ");
  $count = mysql_num_rows( $tempquery );
  if( $count )
  {
   $page=isset($_GET['page'])?$_GET['page']:1;
   $pagesize=20;  
   $pagecount=($count % $pagesize)?(int)($count / $pagesize) +1:$count / $pagesize;  
   $page=($page>$pagecount || $page<1)?$page=1:$page;  
   $start=$pagesize*($page-1);
     $sql = "Select
     dpb,     
     truename,
     uid,
     sex,
     birth,
     education,
     experience,
     facejkind,
     facejtype,
     id
    from 
     zgy_member_p_d_basic
    where
     dpb = '$city' and
     facejtype like '%$keyword%' group by uid order by id desc limit $start,$pagesize";
     
   $query = mysql_query( $sql ) or die( mysql_error() );  
      
   while( $rs = mysql_fetch_array( $query ) )
   {
   ?>
    <tr>
   <td><a href="/index.php/display/resume/<?=$rs['id']?>.html" class="col-blu" target="_blank"><?=$rs['truename']?></a></td>
   <td>
   <?
    $date = date("Y-m-d");
    $date1 = $rs['birth'];    
    echo sdate($date,$date1);
    
   ?>   </td>
   <td><?= $rs['sex'] ? '男' : '女' ;?></td>
   <td><?= $rs['education']?> </td>
   <td><?= $rs['experience']?></td>
   <td><?= $rs['facejkind']?></td>
    </tr>
   <?php
     }
    
  ?>
  <tr>
        <td colspan="6">
  <div class="listPage"><form action="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>" method="get" enctype="application/x-www-form-urlencoded" >总数：<span class="f-red"><?=$count?>/条</span> 每页<?=$pagesize?>条 当前第<span class="f-red"><?=$page?>/<?=$pagecount?></span>页 <a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=1?>" class="col-blu"> 首页 </a><a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$page-1;?>" class="col-blu">上一页 </a><span class="col-blu"> <a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$page+1;?>" class="col-blu">下一页 </a></span><a href="#" class="col-blu"><a href="jobs.php?keyword=<?=$keyword?>&city=<?= $city?>&page=<?=$count;?>" class="col-blu">尾页 </a>转到 第
   
 <input name="page" type="text" id="page" size="3" />
 <input name="city" type="hidden" value="<?=$city;?>" />
 <input name="keyword" type="hidden" value="<?=$keyword;?>" />
  页
   <input type="submit" name="Submit" value="确定" />
 </form>
   </div>
 </div>
 </td>
  </tr>
  <?
  }
  else
  {
   ?>
      <tr>
        <td colspan="6">对不起，您要查找内容暂时不存在!</td>
      </tr>
   <?php
    }
   ?>
    </table>
  </div>

php 计算中英文混合字符串的长度

echo ccStrLen($str),'<hr>';
echo ccStrLeft($str,3);
function ccStrLeft($str,$len) #从左边截取中英文混合字符串
{
$ascLen=strlen($str);   if($ascLen<=$len) return $str;
$hasCC=ereg("[xA1-xFE]",$str); #同上
$hasAsc=ereg("[x01-xA0]",$str);
if(!$hasCC) return substr($str,0,$len);
if(!$hasAsc)
if($len & 0x01) #如果长度是奇数
return substr($str,0,$len+$len-2);
else
return substr($str,0,$len+$len);
$cind=0;$flag=0;
while($cind<$ascLen)
{
if(ord(substr($str,$cind,1))<0xA1) $flag++;
$cind++;
}
if($flag & 0x01)
return substr($str,0,$len);
else
return substr($str,0,$len-1);
}

function ccStrLen($str) #计算中英文混合字符串的长度
{
$ccLen=0;
$ascLen=strlen($str);
$ind=0;
$hasCC=ereg("[xA1-xFE]",$str); #判断是否有汉字
$hasAsc=ereg("[x01-xA0]",$str); #判断是否有ASCII字符
if($hasCC && !$hasAsc) #只有汉字的情况
return strlen($str)/2;
if(!$hasCC && $hasAsc) #只有Ascii字符的情况
return strlen($str);
for($ind=0;$ind<$ascLen;$ind++)
{
if(ord(substr($str,$ind,1))>0xa0)
{
$ccLen++;
$ind++;
}
else
{
$ccLen++;
}
}
return $ccLen;
}

function cs($str) 
{
    $ccLen=0;
    $ascLen=strlen($str);
    $ind=0;
    for($ind=0;$ind<$ascLen;$ind++)
    {
        if(ord(substr($str,$ind,1))>0xa0)
        {
            $ccLen++;
            $ind++;
        }
        else
        {
            $ccLen++;
        }
    }
    return $ccLen;
}

php+js实现省市[select下拉列表]二级关联菜单效果

<head>
<meta http-equiv="Content-Type" ontent="text/html; charset=gb2312" />
<title>表单元素[select下拉列表]制作二级联动菜单</title>
<?php
$link = mysql_connect('localhost','root','root') or die( mysql_error());
  mysql_select_db('cshouse',$link) or die('db error');
  mysql_query("set Names'gbk'");
  /*$sql = "Select * from zgy_classplace where upid=0 order by id asc";
  $result = mysql_query( $sql );
  $i =1;
  $count = mysql_num_rows( $result );
  $b=',';
  while( $rs = mysql_fetch_array( $result  ) )
  {
   if( $i==$count ){ $b =''; }
   echo " new Array("$rs[id]","$rs[cntitle]")$b nt";
   $i++;
  }
  echo ");";
  */
  
  ?>
<script language="javascript">
//下面函数是演示二，联动菜单的处理代码
function makeplace_a(x){
    var form2=document.wane_search.one.options.length;//这句解释同上
    var wane_searchl=new Array(form2)//新建一个数组，项数为第一个下拉列表的项数
    for(i=0;i<form2;i++)//循环第一个下拉列表的项数那么多次
        wane_searchl[i]=new Array();//子循环
        //下面是给每个循环赋值 
    var place_a=document.wane_search.place_a;//方便引用

 <?php
  $sql = "Select * from zgy_classplace where upid=0 ";
  $result = mysql_query( $sql );
  $j =1;
  while( $rs = mysql_fetch_array( $result ) )
  {
   
   $sql = mysql_query("Select * from zgy_classplace where upid='$rs[id]' and upid<>0") ;
   $i =0;
  
   while( $p =mysql_fetch_array( $sql ) )   {
    
     echo "wane_searchl[$j][$i] = new Option("$p[cntitle]","$p[id]"); nt";
     $i++;
     
    
   }
   $j++;
  }
 ?>
    for(m=place_a.options.length-1;m>0;m--)
    //这个要看清楚,因为要重新填充下拉列表的话必须先清除里面原有的项,清除和增加当然是有区别的了,所以用递减
        place_a.options[m]=null;//将该项设置为空,也就等于清除了
    for(j=0;j<wane_searchl[x].length;j++){//这个循环是填充下拉列表
        place_a.options[j]=new Option(wane_searchl[x][j].text,wane_searchl[x][j].value)
        //注意上面这据,列表的当前项等于 新项(数组对象的x,j项的文本为文本，)
    }
    place_a.options[0].selected=true;//设置被选中的初始值
}
</script>
</head>
<body>
<form id="form20" name="wane_search" method="post" action="">
  <select name="one" size="1" onchange="makeplace_a(options.selectedIndex)">
  <option value="">---请选择省份---</option>
  <?php
    $sql_pr = "Select * from zgy_classplace where upid=0";
  $result_pr = mysql_query( $sql_pr );
  while( $rs_pr = mysql_fetch_array( $result_pr ) )
  {
   echo "<option value=$rs_pr[id]>$rs_pr[cntitle]</option> nt";
  }
  ?>  
  </select>
  <select name="place_a">
  <option value="">---请选择城市---</option>
   
  </select>
  <label>
  <input type="submit" name="Submit" value="提交">
  </label>
</form>
<?php
if($_POST)
{
 print_r($_POST);
}

?>
</body>
</html>