php foreach($row as id=>$val),MySQL整数字段在PHP中作为字符串返回

我的解决方案是传递查询结果$rs并获取转换数据的关联数组作为返回：

function cast_query_results($rs) {

$fields = mysqli_fetch_fields($rs);

$data = array();

$types = array();

foreach($fields as $field) {

switch($field->type) {

case 3:

$types[$field->name] = 'int';

break;

case 4:

$types[$field->name] = 'float';

break;

default:

$types[$field->name] = 'string';

break;

}

}

while($row=mysqli_fetch_assoc($rs)) array_push($data,$row);

for($i=0;$i

foreach($types as $name => $type) {

settype($data[$i][$name], $type);

}

}

return $data;

}用法示例：

$dbconn = mysqli_connect('localhost','user','passwd','tablename');

$rs = mysqli_query($dbconn, "SELECT * FROM Matches");

$matches = cast_query_results($rs);

// $matches is now a assoc array of rows properly casted to ints/floats/strings