新手的php 面試題目及答案-填空題與程式設計題-php教程-PHP中文網

新手的php 面試題目及答案-填空題與程式設計題

WBOY

發布： 2016-07-25 08:59:18

原創

1101 人瀏覽過

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;
}
}

}}

複製程式碼

14.簡述論壇中無限分類的實現原理。答:

/*
資料表結構如下:
ATEATE TABLE `category` (
`categoryID` smallint(5) unsigned NOT NULL auto_increment,
`categoryParentID` smallint(5) unsigned NOT NULL default '0′,
`categoryName` varchar(50) Ndefault '0′,
`categoryName` varchar(50) Ndefault ' PRIMARY KEY (`categoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
INSERT INTO `category` ( `categoryParentID`, `categoryName`) VALUES(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 “
{
echo “
if ($level > 0)
{
echo “>” . str_repeat( ” “, $level ) . ” ” . $category[ '名稱'] . “n”;
}
else
{
echo “>” . $category['name'] . “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;
}
?>>return $options;
}

?> >