PHP经典面试题(基础型)附答案(3)

category_id int(4) not null auto_increment;

categroy_name varchar(40) not null;

用户输入文章时，通过选择下拉菜单选定文章分类

写出如何实现这个下拉菜单

//以下使用的adodb

$cnn =& NewADOConnection('mysql');

$cnn -> Connect($db_hostspec, $db_username, $db_password, $db_database);

$cnn -> SetFetchMode(ADODB_FETCH_ASSOC);

if (!$cnn) message("无法连接数据库 $db_database");

$sql = "SELECT * FROM `category` WHERE 1;

$rst =& $cnn -> Execute($sql);

if (!$rst) die($cnn -> ErrorMsg());

$arr_categroy = $rst -> GetArray();

<select>

<?php foreach ($arr_categroy as $i => $row): ?>

<option value="<?php echo $i;?> "><?php echo $row;?></option>

<?php endforeach; ?>

</select>