我有桌子:
class | name |
--------+-------+
mage | merlim|
warrior | gatz |
rogue | zoro |
如何获得给定班级的名称?就像Excel的PROCV函数一样。
在我的PHP代码中:
//$table is the result returned from a call to the db shown above
$classes_required = array("mage","warrior","rogue");
foreach($classes_required as $class){
$$class = PROCV_equivalent($table, $class);
}
var_export($ table);的结果
array (
0 => array ( 0 => 'class', 1 => 'name'),
1 => array ( 0 => 'mage', 1 => 'merlim'),
2 => array ( 0 => 'warrior', 1 => 'gatz'),
3 => array ( 0 => 'rogue', 1 => 'zoro'),
)
您可以构建一个将类映射到名称的关联数组:
$classname = array();
for ($i = 1; $i < count($table); $i++) {
$row = $table[$i];
$classname[$row[0]] = $row[1];
}
foreach ($classes_required as $class) {
$name = $classname[$class];
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句