php+mysql 面试题（全套-建议收藏）

echo date('Y-m-d H:i:s', strtotime('-1 days'));

function GBsubstr($string, $start, $length) {
    if(strlen($string)>$length){
         $str=null;
         $len=$start+$length;
     for($i=$start;$i<$len;$i++){
        if(ord(substr($string,$i,1))>0xa0){
             $str.=substr($string,$i,2);
             $i++;
        }else{
             $str.=substr($string,$i,1);
        }
    }
       return $str.'...';
    }else{
       return $string;
   }
}

打印客户端IP:echo $_SERVER[‘REMOTE_ADDR’]; 
或者: getenv('REMOTE_ADDR');
打印服务器IP:echo $_SERVER['SERVER_ADDR']

方法1:将php.ini中的session.gc_maxlifetime设置为9999重启apache
方法2:$savePath = "./session_save_dir/";
         $lifeTime = 小时 * 秒;
         session_save_path($savePath);
         session_set_cookie_params($lifeTime);
         session_start();
方法3:setcookie() and session_set_cookie_params($lifeTime);

//方法1(对于PHP5及更高版本):
$readcontents = fopen("http://www.phpres.com/index.html", "rb");
$contents = stream_get_contents($readcontents);
fclose($readcontents);
echo $contents;
//方法2:
echo file_get_contents("http://www.phpres.com/index.html");

$str = <<<SHOW
   my name is Jiang Qihui!
SHOW;

SELECT * FROM `members` ORDER BY posts DESC limit 0,10;

function checkEmail($email)　{
    $pregEmail = "/([a-z0-9]*[-_/.]?[a-z0-9]+)*@([a-z0-9]*[-_]?[a-z0-9]+)+[/.][a-z]{2,3}([/.][a-z]{2})?/i";
    return preg_match($pregEmail,$email);  
  }

$script_name = basename(__file__); print_r($script_name);

window.location.href,
<script type="text/JavaScript" src="js/js_function.js"></script>

class myclass{ }

new myclass()

$object = new myclass();
$newstr = $object->test;
$object->test = "info";

echo "<a href='index.php'>aaa</a>";

$num = 10;
function multiply(){
　 $num = $num * 10;
}
multiply();
echo $num;
?>
//输出:10

表名User
Name Tel Content Date
张三 13333663366 大专毕业 2006-10-11
张三 13612312331 本科毕业 2006-10-15
张四 021-55665566 中专毕业 2006-10-15
请根据上面的题目完成代码：
$mysql_db=mysql_connect("local","root","pass");
@mysql_select_db("DB",$mysql_db);
$result = mysql_query("SELECT * FROM `user` WHERE name='张三'");
while($rs = mysql_fetch_array($result)){
   echo $rs["tel"].$rs["content"].$rs["date"];
}

class test{
    function Get_test($num){
　　    $num=md5(md5($num)."En");
　　    return $num;
　  }
}

$testnum = "123";
$object = new test();
$encrypt = $object->Get_test($testnum);
echo $encrypt;
//类test里面包含Get_test方法,实例化类调用方法多字符串加密

mysql_query("INSERT INTO `user` (name,tel,content,date) VALUES 
('小王','13254748547','高中毕业','2007-05-06')")

$nowDate = date("Ymd");
mysql_query("UPDATE `user` SET date='".$nowDate."' WHERE name='张山'");

mysql_query("DELETE FROM `user` WHERE name='张四'");

<?php
$b=201;
$c=40;
$a=$b>$c?4:5;
echo $a;
?>

CREATE TABLE 'message'(
   'id' int(10) NOT NULL auto_increment,
   'title' varchar(200) default NULL,
   'content' text,
   'category_id' int(10) NOT NULL,
   'hits' int(20),
   PRIMARY KEY('id');
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

SELECT message.id id,message.title title,
IF(message.`hits` IS NULL,0,message.`hits`) hits,
IF(comment.`id` is NULL,0,count(*)) number FROM message 
LEFT JOIN comment ON message.id=comment.id GROUP BY message.`id`;

function categoryList(){
    $result=mysql_query("select category_id,categroy_name from category")
            or die("Invalid query: " . mysql_error());
    print("<select name='category' value=''>/n");
    while($rowArray=mysql_fetch_array($result)) {
       print("<option value='".$rowArray['category_id']."'>".$rowArray['categroy_name']."</option>/n");
    }
    print("</select>");
}

function getExt($url){
   $arr = parse_url($url);
   $file = basename($arr['path']);
   $ext = explode(".",$file);
   return $ext[1];
}

function getExt($url) {
    $url = basename($url);
    $pos1 = strpos($url,".");
    $pos2 = strpos($url,"?");
    if(strstr($url,"?")) {
         return substr($url,$pos1 + 1,$pos2 - $pos1 - 1);
    } else {
      return substr($url,$pos1);
    }
}

function getRelativePath($a, $b) {   
    $returnPath = array(dirname($b));   
    $arrA = explode('/', $a);   
    $arrB = explode('/', $returnPath[0]);   
    for ($n = 1, $len = count($arrB); $n < $len; $n++) {   
        if ($arrA[$n] != $arrB[$n]) {   
            break;   
        }    
    }   
    if ($len - $n > 0) {   
        $returnPath = array_merge($returnPath, array_fill(1, $len - $n, '..'));   
    }   
    $returnPath = array_merge($returnPath, array_slice($arrA, $n));   
    return implode('/', $returnPath);   
   }   
   echo getRelativePath($a, $b);

function my_scandir($dir) {
     $files = array();
     if ( $handle = opendir($dir) ) {
         while ( ($file = readdir($handle)) !== false ) {
             if ( $file != ".." && $file != "." ) {
                 if ( is_dir($dir . "/" . $file) ) {
                     $files[$file] = scandir($dir . "/" . $file);
                 }else {
                     $files[] = $file;
                 }
             }
         }
         closedir($handle);
         return $files;
     }
}

<?php
/*
数据表结构如下:
CREATE TABLE `category` (
 `categoryID` smallint(5) unsigned NOT NULL auto_increment,
 `categoryParentID` smallint(5) unsigned NOT NULL default '0',
 `categoryName` varchar(50) NOT NULL default '',
 PRIMARY KEY (`categoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;


INSERT INTO `category` ( `categoryParentID`, `categoryName`) VALUES 
(0, '一级类别'),
(1, '二级类别'),
(1, '二级类别'),
(1, '二级类别'),
(2, '三级类别'),
(2, '333332'),
(2, '234234'),
(3, 'aqqqqqd'),
(4, '哈哈'),
(5, '66333666');
*/
//指定分类id变量$category_id,然后返回该分类的所有子类
//$default_category为默认的选中的分类
function Get_Category($category_id = 0,$level = 0, $default_category = 0) {
  global $DB;
   $sql = "SELECT * FROM category ORDER BY categoryID DESC";
   $result = $DB->query( $sql );
 while ($rows = $DB->fetch_array($result)) {
   $category_array[$rows[categoryParentID]][$rows[categoryID]] = 
   array('id' => $rows[categoryID], 'parent' => 
   $rows[categoryParentID], 'name' => $rows [categoryName]);
 }
 if (!isset($category_array[$category_id])) {
    return "";
 }
 foreach($category_array[$category_id] AS $key => $category) { 
   if ($category['id'] == $default_category) {
     echo "<option selected value=".$category['id']."";
   }else {
       echo "<option value=".$category['id']."";
   }
   if ($level > 0) {
     echo ">" . str_repeat( " ", $level ) . " " . $category['name'] . "</option>/n";
   } else {
     echo ">" . $category['name'] . "</option>/n";
   } Get_Category($key, $level + 1, $default_category);
 }
 unset($category_array[$category_id]);
}
/*
函数返回的数组格式如下所示:
Array 
(
 [1] => Array ( [id] => 1 [name] => 一级类别 [level] => 0 [ParentID] => 0 )
 [4] => Array ( [id] => 4 [name] => 二级类别 [level] => 1 [ParentID] => 1 )
 [9] => Array ( [id] => 9 [name] => 哈哈 [level] => 2 [ParentID] => 4 )
 [3] => Array ( [id] => 3 [name] => 二级类别 [level] => 1 [ParentID] => 1 ) 
 [8] => Array ( [id] => 8 [name] => aqqqqqd [level] => 2 [ParentID] => 3 )
 [2] => Array ( [id] => 2 [name] => 二级类别 [level] => 1 [ParentID] => 1 )
 [7] => Array ( [id] => 7 [name] => 234234 [level] => 2 [ParentID] => 2 )
 [6] => Array ( [id] => 6 [name] => 333332 [level] => 2 [ParentID] => 2 ) 
 [5] => Array ( [id] => 5 [name] => 三级类别 [level] => 2 [ParentID] => 2 ) 
 [10] => Array ( [id] => 10 [name] => 66333666 [level] => 3 [ParentID] => 5 ) 
)
*/
//指定分类id,然后返回数组
function Category_array($category_id = 0,$level=0) {
   global $DB;
   $sql = "SELECT * FROM category ORDER BY categoryID DESC";
   $result = $DB->query($sql);
   while ($rows = $DB->fetch_array($result)) {
     $category_array[$rows['categoryParentID']][$rows['categoryID']] = $rows;
   }
   foreach ($category_array AS $key=>$val){
       if ($key == $category_id) {
         foreach ($val AS $k=> $v) {
           $options[$k] = array('id' => $v['categoryID'], 'name' => $v['categoryName'], 'level' => $level, 'ParentID'=>$v['categoryParentID']
         );
         $children = Category_array($k, $level+1);
       if (count($children) > 0) {
         $options = $options + $children;
       }
     }
   }
}
   unset($category_array[$category_id]);
   return $options;
}
?>




<?php
class cate {
   function Get_Category($category_id = 0,$level = 0, 
   $default_category = 0) {
           echo $category_id;
           $arr = array(
            '0' => array(
                 '1' => array('id' => 1, 'parent' => 0, 'name' => '1111'),
                 '2' => array('id' => 2, 'parent' => 0, 'name' => '2222'),
                 '4' => array('id' => 4, 'parent' => 0, 'name' => '4444')    
                  ),
            '1' => array(
                 '3' => array('id' => 3, 'parent' => 1, 'name' => '333333'),
                 '5' => array('id' => 5, 'parent' => 1, 'name' => '555555')     
                 ),
            '3' => array(
                 '6' => array('id' => 6, 'parent' => 3, 'name' => '66666'),
                 '7' => array('id' => 7, 'parent' => 3, 'name' => '77777')
                 ),
            '4' => array(
                 '8' => array('id' => 8, 'parent' => 4, 'name' => '8888'),
                 '9' => array('id' => 9, 'parent' => 4, 'name' => '9999')
                 )    
           );
             if (!isset($arr[$category_id])) {
                return "";
             }
             foreach($arr[$category_id] AS $key => $cate) {
                 if ($cate['id'] == $default_category) {
                     $txt = "<option selected value=".$cate['id']."";
                 }else{
                     $txt = "<option value=".$cate['id']."";
                 }
                 if ($level > 0) {
                    $txt1 = ">" . str_repeat( "-", $level ) . " " . $cate['name'] . "</option>/n";
                 }else{
                     $txt1 = ">" . $cate['name'] . "</option>/n";
                 }
                 $val = $txt.$txt1;
                 echo $val;
                 self::Get_Category($key, $level + 1, $default_category);
             }
        }        
        function getFlush($category_id = 0,$level = 0, $default_category = 0) {
            ob_start();
            self::Get_Category($category_id ,$level, $default_category);
            $out = ob_get_contents();
            ob_end_clean();
            return $out;
        }    
}
$id =$_GET['id'];
echo "<select>";
$c = new cate();
//$c->Get_Category();
$ttt =  $c->getFlush($id,'0','3');
echo $ttt;
echo "</select>";
?>

生活不可能一帆风顺，岁月不可能一尘不染，人生不可能一举成功。但我们相信，一切终将过去，一定会春暖花开。