PHP 精典面试题(附答案)
<p><strong>1.输出Mozilla/4.0(compatible;MISIE5.01;Window NT 5.0)是,可能输出的语句是?</strong></p><p> A:$_SERVER['HTTP_USER_AGENT_TYPE'];</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: $_SERVER['HTTP_USER_AGENT'];</span></p>
<p> C: $_SERVER['USER_ACENT'];</p>
<p> D: $_SERVER['AGENT'];</p>
<p><strong>2.下面功能php无法实现的是?</strong></p>
<p> A: 服务端脚本运行;</p>
<p> B: 命令行脚本运行;</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: 客户端图形界面(GUI)程序;</span></p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">D: 浏览器执行DOM操作</span></p>
<p><strong>3.下面说法不正确的是?</strong></p>
<p> A: PHP有四种标量类型:布尔型,整型,浮点型,字符串;</p>
<p> B: 浮点型与双精度是同一种类型</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: 复合类型包括:数组,对象,资源;</span></p>
<p> D: 伪类型:混合型,数字型,回调;</p>
<p><strong>4.执行代码后</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(0, 128, 128, 1)">function_exists</span>('print'<span style="color: rgba(0, 0, 0, 1)">);
</span><strong>?></strong></pre>
</div>
<p><strong>输出的结果是?</strong></p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">A: 空</span></p>
<p> B: true</p>
<p> C: false</p>
<p> D: FALSE</p>
<p><strong>5.下面不是PHP语法的组成部分的函数是?</strong></p>
<p> A: array</p>
<p> B: eval</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: each</span></p>
<p> D: list</p>
<p><strong>6.执行下面代码的结果是什么?</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$bool</span> = <span style="color: rgba(0, 0, 255, 1)">true</span><span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(0, 128, 128, 1)">gettype</span>(<span style="color: rgba(128, 0, 128, 1)">$bool</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(0, 128, 128, 1)">is_string</span>(<span style="color: rgba(128, 0, 128, 1)">$bool</span><span style="color: rgba(0, 0, 0, 1)">);
</span>?></pre>
</div>
<p> <span style="background-color: rgba(255, 0, 0, 1)">A: boolean </span></p>
<p> B: boolean0</p>
<p> C: booleanFalse</p>
<p> D: booleanfalse</p>
<p><strong>7.写出下面程序代码执行结果</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$a</span> = 12<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = 012<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$c</span> = 0x12<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>,"\n",<span style="color: rgba(128, 0, 128, 1)">$b</span>,"\n",<span style="color: rgba(128, 0, 128, 1)">$c</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?></pre>
</div>
<p> A: 22</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: 10</span></p>
<p> C: 6</p>
<p> D: 12</p>
<p><strong>8下面代码的执行结果是?</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> 1+2+"3+5+6"<span style="color: rgba(0, 0, 0, 1)">;
</span>?></pre>
</div>
<p> A: 0</p>
<p> B: 3</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: 6</span></p>
<p> D: "33+4+5"</p>
<p><strong>9.下面代码加入下面那个函数后返回true?</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">return</span> ? == 'A';</pre>
</div>
<p> A: ord(65)</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: chr(65)</span></p>
<p> C: 65+"</p>
<p> D: "65+</p>
<p><strong>10.下面代码输出正确的是?</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$a</span> = <span style="color: rgba(0, 0, 255, 1)">array</span>(1=>5,5=>8,22,2=>'8',81<span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>;
</span>?></pre>
</div>
<p> A: 空 22 81</p>
<p> B: 空 81 22</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: 81 22 空</span></p>
<p> D: 空 空 空</p>
<p><strong>11.下面代码的输出结果是?</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$a</span> = 'hello'<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span><span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>['bar'<span style="color: rgba(0, 0, 0, 1)">];
</span>?></pre>
</div>
<p> A: hello</p>
<p> B: 空空</p>
<p> C: 报错</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">D: hello hello</span></p>
<p><strong>12.写出下面代码的结果:</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> 1>>0<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> 2>>1<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> 3<<2<span style="color: rgba(0, 0, 0, 1)">;
</span>?></pre>
</div>
<p> A: 012</p>
<p> B: 106</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: 1112</span></p>
<p> D: 123</p>
<p><strong>13.下面代码执行结果?</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(0, 0, 255, 1)">for</span>(<span style="color: rgba(128, 0, 128, 1)">$i</span>=1;<span style="color: rgba(128, 0, 128, 1)">$i</span><10;<span style="color: rgba(128, 0, 128, 1)">$i</span>++<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">print</span> <span style="color: rgba(128, 0, 128, 1)">$i</span><span style="color: rgba(0, 0, 0, 1)">;
}
</span>?></pre>
</div>
<p> A: 0123456789</p>
<p> B: 01234567890</p>
<p> C: 无输出</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">D: 死循环</span></p>
<p><strong>14.下面对于echo,print 的描述正确的是?</strong></p>
<p> A: echo,print都可以打印多个参数</p>
<p> B: print 可以打印多个参数,echo不可以</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: echo可以打印多个参数,print不可以</span></p>
<p> D: echo,print 都不可以打印多个参数</p>
<p><strong>15.对于以下的代码</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$fruits</span> = <span style="color: rgba(0, 0, 255, 1)">array</span>('strawberry'=>'red','banana'=>'yellow'<span style="color: rgba(0, 0, 0, 1)">);
</span>?></pre>
</div>
<p> 能够正确得到结果'yellow' 的代码是?</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">A: echo "A banana is {$fruits['banana']}";</span></p>
<p> B: echo "A banana is $fruits['banana']";</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: echo "A banana is {$fruits}";</span></p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">D: echo "A banana is $fruits";</span></p>
<p><strong>16.下面代码执行结果是?</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(0, 0, 255, 1)">function</span><span style="color: rgba(0, 0, 0, 1)"> change(){
</span><span style="color: rgba(0, 0, 255, 1)">static</span> <span style="color: rgba(128, 0, 128, 1)">$i</span> = 0<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$i</span>++<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">return</span> <span style="color: rgba(128, 0, 128, 1)">$i</span><span style="color: rgba(0, 0, 0, 1)">;
}
</span><span style="color: rgba(0, 0, 255, 1)">print</span><span style="color: rgba(0, 0, 0, 1)"> change();
</span><span style="color: rgba(0, 0, 255, 1)">print</span><span style="color: rgba(0, 0, 0, 1)"> change();
</span>?><br>正确答案:1,2</pre>
</div>
<p><strong>17.</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$foo</span> = 'test'<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$bar</span> = <<<<span style="color: rgba(0, 0, 0, 1)">EOT
</span><span style="color: rgba(128, 0, 128, 1)">$foo</span><span style="color: rgba(0, 0, 0, 1)"> bar
EOT;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$bar</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?></pre>
</div>
<p><strong>上面语句输出的结果是?</strong></p>
<p> A: $foo bar;</p>
<p> B: 'EOT' $foo bar EOT</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: test bar</span></p>
<p> D: 'EOT' test bar EOT</p>
<p><strong>18.</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$a</span> = 3<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = 4<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">if</span>(<span style="color: rgba(128, 0, 128, 1)">$a</span> || <span style="color: rgba(128, 0, 128, 1)">$b</span> = 5<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> 'tudou'<span style="color: rgba(0, 0, 0, 1)">;
}
</span></pre>
</div>
<p> <strong> $b的值是?</strong></p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">A: 4;</span></p>
<p> B: 5</p>
<p> C: 3;</p>
<p> D: false;</p>
<p><strong>19.下面那个表达式不能将两个字符串$s1和$s2串联成一个单独的字符串?</strong></p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">A: $s1+$s2</span></p>
<p> B: "{$s1}{$s2}"</p>
<p> C: $s1.$s2</p>
<p> D: implode(",array($s1,$s2))</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)"> E: 以上方法都能实现</span></p>
<p><strong>20.下面的脚本运行以后,$array数组所包含的值是什么?</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$array</span> = <span style="color: rgba(0, 0, 255, 1)">array</span>('1','1'<span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">foreach</span>(<span style="color: rgba(128, 0, 128, 1)">$array</span> <span style="color: rgba(0, 0, 255, 1)">as</span> <span style="color: rgba(128, 0, 128, 1)">$k</span> => <span style="color: rgba(128, 0, 128, 1)">$v</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$v</span> = 2<span style="color: rgba(0, 0, 0, 1)">;
}
</span>?></pre>
</div>
<p> A: array('2','2')</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: array('1','1')</span></p>
<p> C: array(2,2)</p>
<p> D: array(Null,Null)</p>
<p><strong>21.cron后台常驻程序(daemon)用于?</strong></p>
<p> A: 负责文件在网络中共享</p>
<p> B: 管理打印子系统Manages theprinting subsystem</p>
<p> C: 跟踪管理系统信息和错误</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">D: 管理系统日常任务的调度(scheduing)</span></p>
<p><strong>22.怎么了解您在当前的目录下还有多大空间?</strong></p>
<p> A: Use df</p>
<p> B: Use du /</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: Use du .</span></p>
<p> D: Use df .</p>
<p><strong>23.有一个备份程序mybackup,需要在周一至周五下午一点和晚上八点各运行次,下面那一条crontab的项可以完成工作?</strong></p>
<p> A: 0 13,20 * * 1,5 mybackup</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: 0 13,20 * * 1,2,3,4,5 mybackup</span></p>
<p> C: *13,20 * * 1,2,3,4,5, mybackup</p>
<p> D: 0 13,20 1,5 * * mybackup</p>
<p><strong>24.下面那条命令可以吧f1.txt复制为f2.txt ?</strong></p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">A: cp f1.txt f2.txt</span></p>
<p> B: cat f1.txt|f2.txt</p>
<p> C: cat f1.txt||f2.txt</p>
<p> D: copy f1.txt|f2.txt</p>
<p><strong>25.使用命令可以查看linux的启动信息?</strong></p>
<p> A: mesg -d</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: dmesg</span></p>
<p> C: cat /etc/mesg</p>
<p> D: cat /var/mesg</p>
<p><strong>26.在vi 中退出不保存的命令是?</strong></p>
<p> A: :qt</p>
<p> B: :r</p>
<p> C: :wq</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">D: :q!</span></p>
<p><strong>27.下面那个选项没有将john添加到users数组中?</strong></p>
<p> A: $users[] = 'john';</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: array_add($users,'john');</span></p>
<p> C: array_push($users,'john');</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">D: $users ||= 'john';</span></p>
<p><strong>28.下列不属于Javascript语法关键字/保留字的是?</strong></p>
<p> A: var</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: $</span></p>
<p> C: functiom</p>
<p> D: while</p>
<p><strong>29.下列不属于JavaScript DOM事件的是?</strong></p>
<p> A: onclick</p>
<p> B: onkeydown</p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">C: onbodyload</span></p>
<p> D: onmouseover</p>
<p><strong>30.下列PHP函数中不能直接在页面上输出字符串的函数是?</strong></p>
<p> A: echo </p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">B: sprintf</span></p>
<p> C: printf</p>
<p><strong>31.在PHP中,'+'操作符的功能不包括</strong></p>
<p> <span style="background-color: rgba(255, 0, 0, 1)">A: 字符串连接</span></p>
<p> B: 数组数据合并</p>
<p> C: 变量数据相加</p>
<p><strong>32.用php获取当前时间并打印,打印格式为2006-5-10 22:21:21</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(0, 128, 128, 1)">date</span>('Y-n-m H:i:s');</pre>
</div>
<p><strong>33,字符串转数组,数组转字符串,字符串截取,字符串替换,字符串查找的函数分别是什么?</strong></p>
<p> <strong>字符串转数组函数:</strong></p>
<p> str_split()</p>
<p> explode()</p>
<p> <strong>数组转字符串</strong></p>
<p> join()</p>
<p> implode()</p>
<p> <strong>字符串截取</strong></p>
<p> substr()</p>
<p> mb_substr()</p>
<p> <strong>字符串替换</strong></p>
<p> str_replace()</p>
<p> preg_replace()</p>
<p> <strong>字符串查找</strong></p>
<p> preg_match()</p>
<p> preg_match_all()</p>
<p> strops()</p>
<p> strrops()</p>
<p><strong>34.解释一下php类中pretect,public,private,interface,abstract,final,static的含义</strong></p>
<p> pretect:受保护的</p>
<p> public:公有的</p>
<p> private:私有的</p>
<p> interface:接口</p>
<p> abstract:抽象类或者抽象方法</p>
<p> final:最终版本的类或者方法</p>
<p> static:静态属性或者方法</p>
<p><strong>35.如何把字符串'08/26/2004'替换成'2004-08-26'?</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$date</span> = '08/26/2004'<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(0, 128, 128, 1)">preg_replace</span>('/(\d+)\/(\d+)\/(\d+)/',$3-$1-$2,<span style="color: rgba(128, 0, 128, 1)">$date</span>);</pre>
</div>
<p>36.<strong>从表login中选出name字段包含admin的前10条结果所有信息的sql语句</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre>select * from login where name '%admin%' limit 10;</pre>
</div>
<p> </p>
<p><strong>37.解释左连接,右连接,内连接,索引:</strong></p>
<p> 左连接: left join on</p>
<p> 左连接是以左边的表为主表,先输出左边表的所有数据,右边匹配输出,不匹配的为null</p>
<p> 右连接:right join on</p>
<p> 右连接是以右边的表为主表,先输出右边表的所有数据,左边匹配输出,不匹配的为null</p>
<p> 内连接:inner join on</p>
<p> 内连接必须同时符合条件的内容才会输出,相等于普通的多表查询</p>
<p><strong>38.写一个函数。尽可能高效的。从一个标准的url里取出文件的扩展名,已知url如下: $url = 'http://www.baidu.com/web/index.php?id=4&name=lisi';</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$arr</span> = <span style="color: rgba(0, 128, 128, 1)">parse_url</span>(<span style="color: rgba(128, 0, 128, 1)">$url</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(128, 0, 128, 1)">$arr2</span> = path_info(<span style="color: rgba(128, 0, 128, 1)">$arr</span>['path'<span style="color: rgba(0, 0, 0, 1)">]);
</span><span style="color: rgba(128, 0, 128, 1)">$ext</span> = <span style="color: rgba(128, 0, 128, 1)">$arr2</span>['extension'];</pre>
</div>
<p><strong>39.解决网站服务器大流量高并发的问题:</strong></p>
<p> 把apache服务器(3000)换成nginx服务器(30000)</p>
<p> 修改Apache或者nginx的默认配置,把其中的并发数调到最高</p>
<p> 多增加几台服务器同时对用户提供服务(负载均衡技术)</p>
<p> 减少客户在服务器上的链接时间断开时间</p>
<p> php代码的优化</p>
<p> 数据缓存(文件缓存,或者内存缓存redis,memcache等)</p>
<p><strong>40.如何设计或者配置mysql ,才能达到高效的目的</strong></p>
<p> 服务器优化:max_connections = 1500 并发链接数调到最大</p>
<p> wait_timeout = 10 链接关闭时间</p>
<p> 表优化:字段索引:主键索引,唯一索引,普通索引</p>
<p> 负载均衡(mysql主从复制)</p>
<p><strong>41.如何进行防sql注入</strong></p>
<p> 表单尽量使用post提交</p>
<p> 使用HTTP_REFERER检查源文件</p>
<p> 开启addslashes在特殊符号前加\</p>
<p> 使用htmlspecialchars对字符进行转义</p>
<p><strong>42.防止盗链</strong></p>
<p> 使用HTTP_REFERER检查源文件</p>
<p><strong>43.用PHP写出一个安全的用户登录系统需要注意哪些方面?</strong></p>
<p> 表单使用post提交</p>
<p> 限制错误登录次数</p>
<p> 使用验证码防止机器破解</p>
<p> 同时做前后端表单验证</p>
<p><strong>44.使用过哪些版本控制工具?</strong></p>
<p> svn</p>
<p> git</p>
<p><strong>45.什么是面向对象?主要特征是什么?</strong></p>
<p> 面向对象是程序的一种设计方式,它利用提高程序的重用性,使程序结构更加清晰</p>
<p> 主要特征:封装,继承,多态</p>
<p><strong>46.HTTP状态中302,403,500代码的含义:</strong></p>
<p> 302重定向,403服务器拒绝访问,500服务器内部错误</p>
<p><strong>47.linux下建立压缩包,解压缩包的命令是?</strong></p>
<p> tar czf test.tar.gz test.php</p>
<p> tar xzf test.tar.gz</p>
<p><strong>48.myisam和innodb的基本区别:</strong></p>
<p> 在增删改查方面,myisam要优于innodb表引擎,当数据量特别大时,他们的速度相差不大,<br> innodb支持事务,存储过程,行锁等等</p>
<p><strong>49.isset()和empty()的区别:</strong></p>
<p> isset 是判断变量是否存在,是否定义</p>
<p> empty 是判断变量是是否为空</p>
<p><strong>50.如何在页面之间传递变量(至少两种)</strong></p>
<p> get,post,ajax,curl,cookie,session</p>
<p><strong>51.写出匹配url的正则表达式:</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$url</span> = "wwww.baidu.com"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 128, 128, 1)">preg_match</span>('/^(\w+\.)?\w+\.\w+$/',<span style="color: rgba(128, 0, 128, 1)">$url</span>);</pre>
</div>
<p><strong>52.请写出常见的排序算法,并用PHP实现冒泡排序,将数组$a = array()按照从小到大的方式进行排序:</strong></p>
<p> 冒泡排序,快速排序</p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 255, 1)">function</span> mysort(<span style="color: rgba(128, 0, 128, 1)">$arr</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">for</span>(<span style="color: rgba(128, 0, 128, 1)">$i</span>=0;<span style="color: rgba(128, 0, 128, 1)">$i</span><<span style="color: rgba(0, 128, 128, 1)">count</span>(<span style="color: rgba(128, 0, 128, 1)">$arr</span>)-1;<span style="color: rgba(128, 0, 128, 1)">$i</span>++<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">for</span>(<span style="color: rgba(128, 0, 128, 1)">$j</span>=0;<span style="color: rgba(128, 0, 128, 1)">$j</span><<span style="color: rgba(0, 128, 128, 1)">count</span>(<span style="color: rgba(128, 0, 128, 1)">$arr</span>)-<span style="color: rgba(128, 0, 128, 1)">$i</span>-1;<span style="color: rgba(128, 0, 128, 1)">$j</span>++<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">if</span>(<span style="color: rgba(128, 0, 128, 1)">$arr</span>[<span style="color: rgba(128, 0, 128, 1)">$i</span>]><span style="color: rgba(128, 0, 128, 1)">$arr</span>[<span style="color: rgba(128, 0, 128, 1)">$j</span>+1<span style="color: rgba(0, 0, 0, 1)">]){
</span><span style="color: rgba(128, 0, 128, 1)">$x</span> = <span style="color: rgba(128, 0, 128, 1)">$arr</span>[<span style="color: rgba(128, 0, 128, 1)">$j</span><span style="color: rgba(0, 0, 0, 1)">];
</span><span style="color: rgba(128, 0, 128, 1)">$arr</span>[<span style="color: rgba(128, 0, 128, 1)">$j</span>] = <span style="color: rgba(128, 0, 128, 1)">$arr</span>[<span style="color: rgba(128, 0, 128, 1)">$j</span>+1<span style="color: rgba(0, 0, 0, 1)">];
</span><span style="color: rgba(128, 0, 128, 1)">$arr</span>[<span style="color: rgba(128, 0, 128, 1)">$j</span>+1] = <span style="color: rgba(128, 0, 128, 1)">$x</span><span style="color: rgba(0, 0, 0, 1)">;
}
}
}
</span><span style="color: rgba(0, 0, 255, 1)">return</span> <span style="color: rgba(128, 0, 128, 1)">$arr</span><span style="color: rgba(0, 0, 0, 1)">
}</span></pre>
</div>
<p><strong>53.在数据库test中的一个表student,字段是name,class,score,分别代表姓名,所在班级,分数</strong></p>
<p> <strong>查出每个班级中的学生,按照成绩降序排序</strong></p>
<p> select * from student order by class asc,score desc;</p>
<p> <strong>查出每个班的及格人数和不及格人数,格式为:class,及格人数,不及格人数</strong></p>
<p> select class,sum(if(score>=60,1,0)) jige,sum(if(score<60,1,0)) bujige from student group by class;</p>
<p><strong>54.请写出你认为语言中的高级函数</strong></p>
<p> array_filter()</p>
<p> array_map()</p>
<p> array_multisort()</p>
<p> array_count_values()</p>
<p> array_splice()</p>
<p> htmlspecialchars()</p>
<p><strong>55.表结构入下</strong></p>
<table style="height: 50px; width: 150px" border="1" cellspacing="20" cellpadding="40" align="left">
<tbody>
<tr>
<td>名称</td>
<td>类型</td>
</tr>
<tr>
<td>uid</td>
<td>int</td>
</tr>
<tr>
<td>name</td>
<td>varchar</td>
</tr>
<tr>
<td>age</td>
<td>tinyint</td>
</tr>
</tbody>
</table>
<p> </p>
<p> </p>
<p> </p>
<p><strong>需求:</strong></p>
<p> <strong>增加一个字段性别sex,写出修改语句</strong></p>
<div class="cnblogs_code">
<pre>alter table user add sex varchar(10) not <span style="color: rgba(0, 0, 255, 1)">null</span> <span style="color: rgba(0, 0, 255, 1)">default</span> '男';</pre>
</div>
<p> <strong>查询出年龄介于20到30岁之间的用户</strong></p>
<div class="cnblogs_code">
<pre>select uid,name,age from user where age>20 && age<30;</pre>
</div>
<p> <strong>如果提个web频繁的访问查询,上题的查询如何优化?</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 0, 0, 1)">给age字段添加索引
create index in_age on user(age);</span></pre>
</div>
<p> </p>
<p><strong>56.web开发的遇到的问题有哪些?</strong></p>
<p> 功能需求分析</p>
<p> 数据库设计</p>
<p> sql语句的优化</p>
<p> 前端编写js特效</p>
<p><strong>57.求两个日期的差数,例如:2007-2-5~2007-3-6的日期差数</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$s</span> = <span style="color: rgba(0, 128, 128, 1)">strtotime</span>('2007-3-6') - <span style="color: rgba(0, 128, 128, 1)">strtotime</span>('2007-2-5');<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">秒差</span>
<span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$s</span>/86400;<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">相差天数</span></pre>
</div>
<p><strong>58.写出如下程序运行结果</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$test</span> = 'hello'<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$abc</span> = &<span style="color: rgba(128, 0, 128, 1)">$test</span><span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">unset</span>(<span style="color: rgba(128, 0, 128, 1)">$test</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$abc</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?></pre>
</div>
<p><strong>正确答案:hello</strong></p>
<p><strong>59.在空表news中,字段id为自增主键,批量插入17条记录后,发现最后三条数据有误,删除此三条数据后重启mysql数据库,再重新插入三条记录,请问最后一条记录值的id是多少?</strong></p>
<p> myisam 引擎 18</p>
<p> innodb 引擎 20</p>
<p><strong>60.至少写出一种验证139开头的11位手机号码的正则表达式:</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$str</span> = "13911111111"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 128, 128, 1)">preg_match</span>('/^139\d{8}$/',<span style="color: rgba(128, 0, 128, 1)">$str</span>);</pre>
</div>
<p><strong>61.请写出一个函数,实现如下功能:</strong></p>
<p> <strong>字符串"open_door" 转换为 "OpenDoor","make_id"转换为"MakeId"</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$str</span> = "make_hello"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$arr</span> = <span style="color: rgba(0, 128, 128, 1)">explode</span>('_',<span style="color: rgba(128, 0, 128, 1)">$str</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(128, 0, 128, 1)">$str2</span> = ''<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">foreach</span>(<span style="color: rgba(128, 0, 128, 1)">$arr</span> <span style="color: rgba(0, 0, 255, 1)">as</span> <span style="color: rgba(128, 0, 128, 1)">$val</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$str2</span>.=<span style="color: rgba(0, 128, 128, 1)">ucfirst</span>(<span style="color: rgba(128, 0, 128, 1)">$val</span><span style="color: rgba(0, 0, 0, 1)">);
}
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$str2</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?></pre>
</div>
<p><strong>62.请写一个函数将1234567890转成1,234,567,890,每3位用逗号隔开的形式 </strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$str</span> = "1234567890"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$str2</span> = <span style="color: rgba(0, 128, 128, 1)">strrev</span>(<span style="color: rgba(128, 0, 128, 1)">$str</span>);<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">翻转字符串</span>
<span style="color: rgba(128, 0, 128, 1)">$arr</span> = <span style="color: rgba(0, 128, 128, 1)">str_split</span>(<span style="color: rgba(128, 0, 128, 1)">$str2</span>,3<span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(128, 0, 128, 1)">$str3</span> = <span style="color: rgba(0, 128, 128, 1)">join</span>(',',<span style="color: rgba(128, 0, 128, 1)">$arr</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(128, 0, 128, 1)">$str4</span> = <span style="color: rgba(0, 128, 128, 1)">strrev</span>(<span style="color: rgba(128, 0, 128, 1)">$str3</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$str4</span><span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">还有一个函数直接能搞定:</span>
<span style="color: rgba(128, 0, 128, 1)">$str</span> = "1234567890"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(0, 128, 128, 1)">number_format</span>(<span style="color: rgba(128, 0, 128, 1)">$str</span><span style="color: rgba(0, 0, 0, 1)">);
</span>?></pre>
</div>
<p><strong>63.有A(id,sex,par,c1,c2),B(id,age,c1,c2)两张表,其中A.id与B.id关联,现在要求写出一条sql语句,将B中的age>50的记录的c1,c2更新到A表中统一记录中的c1,c2字段中:</strong></p>
<div class="cnblogs_code">
<pre>update A,B set A.c1 = B.c1,A.c2 = B.c2 where A.id = B.id and B.age>50;</pre>
</div>
<p><strong>64.如何实现每天的0点钟重启linux服务器?</strong></p>
<div class="cnblogs_code">
<pre>crontab -<span style="color: rgba(0, 0, 0, 1)">e
</span>00 00 * * * /sbin/init 6</pre>
</div>
<p><strong>65.当前目录下有一个文件showdown.sh,如何修改文件,将其指定为使用/bin/bash运行,如何修改其权限为所有用户可读写,所有用户可执行?</strong></p>
<div class="cnblogs_code">
<pre>vim showdown.<span style="color: rgba(0, 0, 0, 1)">sh
</span><span style="color: rgba(0, 128, 0, 1)">#</span><span style="color: rgba(0, 128, 0, 1)">!/bin/bash</span>
<span style="color: rgba(0, 128, 128, 1)">chmod</span> 777 showdown.sh</pre>
</div>
<p><strong>66.当前目录下有一个文件为showdown.sh,如何修改其所有人为root</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">chown</span> root showdown.<span style="color: rgba(0, 0, 0, 1)">sh
</span><strong><span style="color: rgba(0, 128, 128, 1)">chown</span> root:root showdown.sh<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">修改所有人为root,并且修改所属组为root</span></strong></pre>
</div>
<p><strong>67.请用用php程序,编写读取www.baidu.com 的首页的内容,并将其存入字符串$str中</strong></p>
<div class="cnblogs_code">$str = file_get_contents('http://www.baidu.com');</div>
<p><strong>68.请用php将上题中读取出来的网页内容的<title>标签的值解析出来</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">preg_match</span>('/<title>(.*)<\/title>/',<span style="color: rgba(128, 0, 128, 1)">$str</span>,<span style="color: rgba(128, 0, 128, 1)">$arr</span>);</pre>
</div>
<p><strong>69.通过php函数的方式对目录进行遍历,写出程序:</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(0, 0, 255, 1)">function</span> delDir(<span style="color: rgba(128, 0, 128, 1)">$dir</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$files</span> = <span style="color: rgba(0, 128, 128, 1)">scandir</span>(<span style="color: rgba(128, 0, 128, 1)">$dir</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">foreach</span>(<span style="color: rgba(128, 0, 128, 1)">$files</span> <span style="color: rgba(0, 0, 255, 1)">as</span> <span style="color: rgba(128, 0, 128, 1)">$file</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">if</span>(<span style="color: rgba(128, 0, 128, 1)">$file</span>!='.' && <span style="color: rgba(128, 0, 128, 1)">$file</span>!='..'<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$path</span> = <span style="color: rgba(128, 0, 128, 1)">$dir</span>.'/'.<span style="color: rgba(128, 0, 128, 1)">$file</span><span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">if</span>(<span style="color: rgba(0, 128, 128, 1)">is_dir</span>(<span style="color: rgba(128, 0, 128, 1)">$path</span><span style="color: rgba(0, 0, 0, 1)">)){
delDir(</span><span style="color: rgba(128, 0, 128, 1)">$path</span><span style="color: rgba(0, 0, 0, 1)">);
}</span><span style="color: rgba(0, 0, 255, 1)">else</span><span style="color: rgba(0, 0, 0, 1)">{
</span><span style="color: rgba(0, 128, 128, 1)">unlink</span>(<span style="color: rgba(128, 0, 128, 1)">$path</span><span style="color: rgba(0, 0, 0, 1)">);
}
}
}
</span><span style="color: rgba(0, 128, 128, 1)">rmdir</span>(<span style="color: rgba(128, 0, 128, 1)">$dir</span><span style="color: rgba(0, 0, 0, 1)">);
}
</span>?></pre>
</div>
<p><strong>70.什么是数据库索引,主键索引,唯一索引的区别,索引的缺点是什么?</strong></p>
<p> 数据库索引是给数据库中的每张表建立索引,便于提高查询检索效率</p>
<p> 主键索引是给每张表的主键设置索引</p>
<p> 唯一索引是给每张表的唯一值字段设置索引</p>
<p> 索引的缺点是建立索引需要增加存储空间,空间利用率低,并且当数据发生变化时改索引资源消耗比较大</p>
<p><strong>71.通过js 实现前进和后退操作:</strong></p>
<div class="cnblogs_code">
<pre><a href="javascript:Window.history.go(1)">前进</a>
<a href="javascript:Window.history.go(-1)">后退</a></pre>
</div>
<p><strong>72.写出程序运行结果:</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$a</span> = 0<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = 0<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">if</span>(<span style="color: rgba(128, 0, 128, 1)">$a</span>=3 || <span style="color: rgba(128, 0, 128, 1)">$b</span> = 3<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$a</span>++<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span>++<span style="color: rgba(0, 0, 0, 1)">;
}
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>.",".<span style="color: rgba(128, 0, 128, 1)">$b</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?><br>正确答案是:1,1</pre>
</div>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$a</span> = 0<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = 0<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">if</span>(<span style="color: rgba(128, 0, 128, 1)">$a</span> = 4 | <span style="color: rgba(128, 0, 128, 1)">$b</span> = 3<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$a</span>++<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span>++<span style="color: rgba(0, 0, 0, 1)">;
}
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>.",".<span style="color: rgba(128, 0, 128, 1)">$b</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?><span style="color: rgba(0, 0, 0, 1)">
正确答案是:</span>8,4(未或运算)</pre>
</div>
<p><strong>73.写出下列代码的输出结果?</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(0, 0, 255, 1)">function</span> myfunc(<span style="color: rgba(128, 0, 128, 1)">$argument</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$argument</span>+10<span style="color: rgba(0, 0, 0, 1)">;
}
</span><span style="color: rgba(128, 0, 128, 1)">$variable</span> = 10<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> "myfunc(<span style="color: rgba(128, 0, 128, 1)">$variable</span>)=".myfunc(<span style="color: rgba(128, 0, 128, 1)">$variable</span><span style="color: rgba(0, 0, 0, 1)">);
</span>?><br>正确答案是:10myfunc(10)=;</pre>
</div>
<p><strong>74.请用尽可能少的语句实现对输出email地址进行验证功能:</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$email</span> = "test@qq.com"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 128, 128, 1)">preg_match</span>('/^\w+@\w+\.\w+$/',<span style="color: rgba(128, 0, 128, 1)">$email</span>,<span style="color: rgba(128, 0, 128, 1)">$arr</span>);</pre>
</div>
<p><strong>75.如何判断sql语句的运行效率,如何优化一个查询sql</strong></p>
<div class="cnblogs_code">
<pre>desc select *<span style="color: rgba(0, 0, 0, 1)"> from table;
explain select </span>*<span style="color: rgba(0, 0, 0, 1)"> from table;
给查询条件增加索引</span></pre>
</div>
<p><strong>76.apache默认使用的是进程管理还是线程管理?</strong></p>
<p> apache默认使用的是进程管理</p>
<p><strong>77.实现中文字符串截取无乱码的方法是?</strong></p>
<p> mb_substr();</p>
<p><strong>78.用php写出显示客户端ip和服务端的ip代码:</strong></p>
<p> $_SERVER['REMOTE_ADDR']</p>
<p> $_SERVER['SERVER_ADDR']</p>
<p><strong>79.在http1.0中,状态码为401的含义是?如果返回"找不到文件"的提示,则用header函数,其语句为?</strong></p>
<p> 401代表未被授权</p>
<p> header("HTTP/1.0 404 Not Found");</p>
<p><strong>80.在php中error_reporting这个函数的作用是?</strong></p>
<p> 设置错误级别与错误信息回报</p>
<p><strong>81.简述如何得到当前执行脚本路径,包括所得到的参数?</strong></p>
<p> $_SERVER['REQUEST_URI'];</p>
<p><strong>82.mysql_fetch_row和mysql_fetch_array之间的区别?</strong></p>
<p> mysql_fetch_row获取一个索引数组</p>
<p> mysql_fetch_assoc获取一个关联数组</p>
<p><strong>83.下面程序会输出什么?</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$num</span> = 10<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">function</span><span style="color: rgba(0, 0, 0, 1)"> multiply(){
</span><span style="color: rgba(128, 0, 128, 1)">$num</span> = <span style="color: rgba(128, 0, 128, 1)">$num</span>*10<span style="color: rgba(0, 0, 0, 1)">;
}
multiply();
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$num</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?><span style="color: rgba(0, 0, 0, 1)">
正确答案是</span>:10</pre>
</div>
<p><strong>84.写出下面程序的输出结果?</strong></p>
<p> </p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = 201<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$c</span> = 40<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$a</span> = <span style="color: rgba(128, 0, 128, 1)">$b</span>><span style="color: rgba(128, 0, 128, 1)">$c</span>:4:5<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?><span style="color: rgba(0, 0, 0, 1)">
正确答案是:</span>4</pre>
</div>
<p><strong>85.$a = 'abcdef';请取出$a的值并打印第一个字母:</strong></p>
<p> echo $a{0};</p>
<p><strong>86.请写出php5的权限修饰符</strong></p>
<p> public 公有的</p>
<p> private 私有的</p>
<p> protected 受保护的</p>
<p><strong>87.ftp://pub.foo.bar.com:2121/incoming/rls.sfv请给出这个url的各部分的含义</strong></p>
<p> ftp:// 是协议</p>
<p> pub.foo.bar.com 是域名</p>
<p> 2121 是端口</p>
<p> /incoming/ 是目录</p>
<p> rls.sfv 是文件</p>
<p><strong>88.服务器常用端口?</strong></p>
<p> 80 http协议</p>
<p> 21 ftp协议</p>
<p> 22 ssh协议</p>
<p> 53 dns协议</p>
<p> 443 https协议</p>
<p><strong>89.请写出5条linux命令</strong></p>
<p> ls</p>
<p> cd</p>
<p> pwd</p>
<p> mkdir</p>
<p> rmdir</p>
<p><strong>90.请列出5个常用的php操作mysql函数:</strong></p>
<p> mysql_connect()</p>
<p> mysql_query();</p>
<p> mysql_select_db()</p>
<p> mysql_fetch_assoc()</p>
<p> mysql_fetch_row</p>
<p><strong>91.有两张数据表,表user(id,name)记录了用户的id和昵称,表article(id,uid,title,content,time)记录了用户发表的文章标题,内容和时间,写一个sql语句打印出每个用户的昵称及其发表的文章总数?</strong></p>
<div class="cnblogs_code">
<pre>select user.name,<span style="color: rgba(0, 128, 128, 1)">count</span>(*) from user left <span style="color: rgba(0, 128, 128, 1)">join</span> article on user.id = article.id group by user.id;</pre>
</div>
<p><strong>92.把左连接中产生的null替换成"0":</strong></p>
<div class="cnblogs_code">
<pre>select user.name,<span style="color: rgba(0, 128, 128, 1)">count</span>(article.uid) from user left <span style="color: rgba(0, 128, 128, 1)">join</span> article on user.id = article.uid group by user.id;</pre>
</div>
<p><strong>93.请写出3个php中预定义全局变量</strong></p>
<p> __LINE__</p>
<p> __FILE__</p>
<p> __FOUCTION__</p>
<p><strong>94.请写出下列代码的执行结果</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$var1</span> = 5<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$var2</span> = 10<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">function</span> foo(&<span style="color: rgba(128, 0, 128, 1)">$my_var</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">global</span> <span style="color: rgba(128, 0, 128, 1)">$var1</span><span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$var1</span> +=2<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$var2</span> = 4<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$my_var</span> +=3<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">return</span> <span style="color: rgba(128, 0, 128, 1)">$var2</span><span style="color: rgba(0, 0, 0, 1)">;
}
</span><span style="color: rgba(128, 0, 128, 1)">$my_var</span> = 5<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> foo(<span style="color: rgba(128, 0, 128, 1)">$my_var</span>);<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">4</span>
<span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$my_var</span>;<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">8</span>
<span style="color: rgba(0, 0, 255, 1)">echo</span> var1;<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">7</span>
<span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$var2</span>;<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">10</span>
<span style="color: rgba(128, 0, 128, 1)">$bar</span> = 'foo'<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$my_var</span> = 10<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$bar</span>(<span style="color: rgba(128, 0, 128, 1)">$my_var</span>);<span style="color: rgba(0, 128, 0, 1)">//</span><span style="color: rgba(0, 128, 0, 1)">4</span>
?> </pre>
</div>
<p><strong>95.输出用户的ip地址,并判断用户的IP地址是否在192.168.1.100-----192.168.1.150之间</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$sip</span> = <span style="color: rgba(0, 128, 128, 1)">ip2long</span>('192.168.1.100'<span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(128, 0, 128, 1)">$eip</span> = <span style="color: rgba(0, 128, 128, 1)">ip2long</span>('192.168.1.150'<span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(128, 0, 128, 1)">$getip</span> = <span style="color: rgba(0, 128, 128, 1)">ip2long</span>('192.168.1.120'<span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">if</span>(<span style="color: rgba(128, 0, 128, 1)">$getip</span>>=<span style="color: rgba(128, 0, 128, 1)">$sip</span> and <span style="color: rgba(128, 0, 128, 1)">$getip</span><=<span style="color: rgba(128, 0, 128, 1)">$eip</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> 'yes'<span style="color: rgba(0, 0, 0, 1)">;
}</span><span style="color: rgba(0, 0, 255, 1)">else</span><span style="color: rgba(0, 0, 0, 1)">{
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> 'no'<span style="color: rgba(0, 0, 0, 1)">;
}</span></pre>
</div>
<p><strong>96.将二维数组按照name的长度进行重新排序,按照顺序将id赋值(从1开始),二维数组如下:</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$arr</span> = <span style="color: rgba(0, 0, 255, 1)">array</span><span style="color: rgba(0, 0, 0, 1)">(
</span><span style="color: rgba(0, 0, 255, 1)">array</span>('id'=>0,'name'=>'123833'),
<span style="color: rgba(0, 0, 255, 1)">array</span>('id'=>0,'name'=>'aaa'),
<span style="color: rgba(0, 0, 255, 1)">array</span>('id'=>0,'name'=>'dfsdfsdfsdfs'),
<span style="color: rgba(0, 0, 255, 1)">array</span>('id'=>0,'name'=>'12245'),
<span style="color: rgba(0, 0, 255, 1)">array</span>('id'=>0,'name'=>'122lll'<span style="color: rgba(0, 0, 0, 1)">)
);
实现代码如下:
</span><span style="color: rgba(0, 0, 255, 1)">foreach</span>(<span style="color: rgba(128, 0, 128, 1)">$arr</span> <span style="color: rgba(0, 0, 255, 1)">as</span> <span style="color: rgba(128, 0, 128, 1)">$val</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$arr2</span>[] = <span style="color: rgba(0, 128, 128, 1)">strlen</span>(<span style="color: rgba(128, 0, 128, 1)">$val</span>['name'<span style="color: rgba(0, 0, 0, 1)">]);
}
</span><span style="color: rgba(0, 128, 128, 1)">array_multisort</span>(<span style="color: rgba(128, 0, 128, 1)">$arr2</span>,<span style="color: rgba(128, 0, 128, 1)">$arr</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">foreach</span>(<span style="color: rgba(128, 0, 128, 1)">$arr</span> <span style="color: rgba(0, 0, 255, 1)">as</span> &<span style="color: rgba(128, 0, 128, 1)">$val2</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$val2</span>['id'] = ++<span style="color: rgba(128, 0, 128, 1)">$i</span><span style="color: rgba(0, 0, 0, 1)">;
}
</span><span style="color: rgba(0, 128, 128, 1)">print_r</span>(<span style="color: rgba(128, 0, 128, 1)">$arr</span>);</pre>
</div>
<p><strong>97.实现不用第三个变量交换,$a,$b的值,$a,$b的初始值自己定:</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(128, 0, 128, 1)">$a</span> = "linux"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = "php"<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = <span style="color: rgba(0, 0, 255, 1)">array</span>(<span style="color: rgba(128, 0, 128, 1)">$a</span>,<span style="color: rgba(128, 0, 128, 1)">$b</span><span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(128, 0, 128, 1)">$a</span> = <span style="color: rgba(128, 0, 128, 1)">$b</span>;
</span><span style="color: rgba(128, 0, 128, 1)">$b</span> = <span style="color: rgba(128, 0, 128, 1)">$b</span>;
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$a</span>;</pre>
</div>
<p><strong>98.用php打印前一天的日期格式为:2006-5-10 22:22:21:</strong></p>
<div class="cnblogs_code">
<pre><span style="color: rgba(0, 128, 128, 1)">date</span>('Y-n-d H:i:s' ,<span style="color: rgba(0, 128, 128, 1)">strtotime</span>('-1 day'));</pre>
</div>
<p><strong>99.下面程序输出什么?</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$int_a</span> = 5<span style="color: rgba(0, 0, 0, 1)">;
</span><span style="color: rgba(0, 0, 255, 1)">function</span><span style="color: rgba(0, 0, 0, 1)"> factorial(){
</span><span style="color: rgba(0, 0, 255, 1)">for</span>(<span style="color: rgba(128, 0, 128, 1)">$int_i</span>=<span style="color: rgba(128, 0, 128, 1)">$int_a</span>;<span style="color: rgba(128, 0, 128, 1)">$int_i</span>>0;<span style="color: rgba(128, 0, 128, 1)">$int_i</span>--<span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$int_a</span> = <span style="color: rgba(128, 0, 128, 1)">$int_a</span> * <span style="color: rgba(128, 0, 128, 1)">$int_i</span><span style="color: rgba(0, 0, 0, 1)">;
}
}
factorial();
</span><span style="color: rgba(0, 0, 255, 1)">echo</span> <span style="color: rgba(128, 0, 128, 1)">$int_a</span><span style="color: rgba(0, 0, 0, 1)">;
</span>?><span style="color: rgba(0, 0, 0, 1)">
正确答案是:</span>5</pre>
</div>
<p><strong>100.在项目开发中,需要上传超过8M的文件时,请说明php.ini需要修改的配置项</strong></p>
<div class="cnblogs_code">
<pre>upload_max_filesize = 8<span style="color: rgba(0, 0, 0, 1)">
post_max_size </span>= 9一定要大于等于上面的那个</pre>
</div>
<p><strong>101.php代码如下</strong></p>
<div class="cnblogs_code">
<pre><?<span style="color: rgba(0, 0, 0, 1)">php
</span><span style="color: rgba(128, 0, 128, 1)">$data</span> = <span style="color: rgba(0, 0, 255, 1)">array</span>('a','b','c'<span style="color: rgba(0, 0, 0, 1)">);
</span><span style="color: rgba(0, 0, 255, 1)">foreach</span>(<span style="color: rgba(128, 0, 128, 1)">$data</span> <span style="color: rgba(0, 0, 255, 1)">as</span> <span style="color: rgba(128, 0, 128, 1)">$key</span> => <span style="color: rgba(128, 0, 128, 1)">$val</span><span style="color: rgba(0, 0, 0, 1)">){
</span><span style="color: rgba(128, 0, 128, 1)">$val</span> = &<span style="color: rgba(128, 0, 128, 1)">$data</span>[<span style="color: rgba(128, 0, 128, 1)">$key</span><span style="color: rgba(0, 0, 0, 1)">];
}
</span>?></pre>
</div>
<p> <strong>问题1:程序执行时,每一次循环结束后变量$data的值是什么?请解释</strong></p>
<p> 第一次:</p>
<p> $data = array('a','b','c');</p>
<p> 第二次:</p>
<p> $data = array('b','b','c');</p>
<p> 第三次:</p>
<p> $data = array('b','c','c');</p>
<p> <strong>问题2:程序执行完成后,变量$data的值是什么?请解释</strong></p>
<p> $data = array('b','c','c');</p><br><br>
来源:https://www.cnblogs.com/lixiansen/p/11839015.html
頁:
[1]