php初级面试题之编程题（二）

strftime(“%Y-%m-%d %T”, strtotime(“-1 day”));
date(“Y-m-d H:i:s”, strtotime(“-1 day”));

function dir_recurse($dir) {
    $i = 1;
    if($handle = opendir($dir)) {
        while(false !== ($file = readdir($handle))) {
            if($file != "." && $file != ".." ) {
                if(is_dir($dir."/".$file) == true) {
                    $fullpath = $dir."/".$file;
                    dir_recurse($fullpath);
                    echo "$fullpath\n";
                    $i++;
                }else {
                    $fullpath = $dir."/".$file;
                    echo "$fullpath\n";
                    $i++;
                }
            }
        }
        closedir($handle);
    }
}

touch exer1
chmod 644  exer1
增加权限
chmod a+x  exer1
chmod g+w  exer1
或者
chmod 775 exer1

Php实现： echo strtoupper(‘to upper case’)

Shell实现：echo "to upper case" | tr 'a-z' 'A-Z'

<script language="javascript">
var stmp1 = " to upper case ";
alert(stmp1.toLocaleUpperCase());//转换成大写
alert(stmp1.toUpperCase())//转换成大写
</script>

CREATE DATABASE IF NOT EXISTS mydb;
grant all on mydb.* to root@’ 192.168.1.1’ identified by '' ;

SELECT
M.`id`, M.`title`, M.`hits`, COUNT(C.`comment_id`) AS CNT
FROM
    `message` AS M LEFT JOIN `comment` AS C ON M.`id` = C.`id`
GROUP BY M.`id`
ORDER BY CNT DESC;