php面试宝典

    ID                             int                            not null,

name                           varchar(50)                    not null,

primary key (ID)

);

create table tbl_score

(

    ID                             int                            not null,

score                          dec(6,2)                       not null,

subject                        varchar(20)                    not null

);

insert into tbl_user (ID,name) values (1,'beimu');

insert into tbl_user (ID,name) values (2,'aihui');

insert into tbl_score (ID,score,subject) values (1,90,'语文');

insert into tbl_score (ID,80,'数学');

insert into tbl_score (ID,subject) values (2,86,96,'语文');

select A.id,sum(B.score) as sumscore

from tbl_user A left join tbl_score B

on A.ID=B.ID

group by A.id

74、 在PHP中，heredoc是1种特殊的字符串，它的结束标志必须____

答：结束标识符所在的行不能包括任何其它字符除";"

75、写1个函数，能够遍历1个文件夹下的所有文件和子文件夹。

<?php

function my_scandir($dir)

{

    $files=array();

if(is_dir($dir))

     {

if($handle=opendir($dir))

         {

while(($file=readdir($handle))!==false)

             {

if($file!="." && $file!="..")

                 {

if(is_dir($dir."/".$file))

                     {

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!