我尝试编写获取mysql_query变量的函数,然后获取并给我一个数组。我写这些代码:
$select_query = mysql_query("...");
fetch_query_objects($select_query);
function fetch_query_objects($query){
$counter = 0;
while ($fetch_query = mysql_fetch_assoc($query)) {
$fields_name = array_keys($fetch_query);
for ($i=0; $i < count($fields_name); $i++) {
$objects[$fields_name[$i]][$counter] = $fetch_query[$fields_name[$i]];
}
$counter++;
}
return $objects;
}
但是在此函数中,我无法识别$query
是否为mysql_query字符串。我怎么能发现呢?
我找到答案:
$select_query = mysql_query("...");
fetch_query_objects($select_query);
function fetch_query_objects($query){
$objects = array();
if (gettype($query)=="resource") {
if ((get_resource_type ($query))=="mysql result") {
$counter = 0;
while ($fetch_query = mysql_fetch_assoc($query)) {
$fields_name = array_keys($fetch_query);
for ($i=0; $i < count($fields_name); $i++) {
$objects[$fields_name[$i]][$counter] = $fetch_query[$fields_name[$i]];
}
$counter++;
}
}
}
return $objects;
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句