使用php将mysql转换成json_php – 使用正确的类型将mysql结果转换为json

下面的代码只是一个概念证明.它需要在函数/方法中进行封装,并在生产中使用它之前进行一些抛光(例如,在循环中调用mysqli_fetch_field()并在处理任何行之前存储它返回的对象,而不是每行一次).

// Get the data

$result = mysqli_query($db, "SELECT * FROM table WHERE id=1");

$row = mysqli_fetch_assoc($result);

// Fix the types

$fixed = array();

foreach ($row as $key => $value) {

$info = mysqli_fetch_field($result);

if (in_array($info->type, array(

MYSQLI_TYPE_TINY, MYSQLI_TYPE_SHORT, MYSQLI_TYPE_INT24,

MYSQLI_TYPE_LONG, MYSQLI_TYPE_LONGLONG,

MYSQLI_TYPE_DECIMAL,

MYSQLI_TYPE_FLOAT, MYSQLI_TYPE_DOUBLE

))) {

$fixed[$key] = 0 + $value;

} else {

$fixed[$key] = $value;

}

}

// Compare the results

echo('all strings: '.json_encode($row)."\n");

echo('fixed types: '.json_encode($fixed)."\n");