PHP mssql_fetch_array并获取数据库数据类型

Question

I have a category Table:

categoryId: int

categoryName: string

I retrieved my data from Database using:

while($rows[] = mysql_fetch_array($result,MSSQL_ASSOC)){}

And I want to display the result in json format.

$response = array('success' => true, 'data' => $rows);
echo json_encode($response);

It returns:

{"success":true,"data":[{"categoryId":"1","categoryName":"Car"}]}

Is it possible to return the categoryId as integer ({"categoryId":1) instead of string? I know that mssql_fetch_array will return string. Any good way to retain the database data type when I json_encode my fetch result?

Answer 1

in mysql_fetch_array documentation , it is clearly written

Returns an array of strings that corresponds to the fetched row, or FALSE if there are no more rows. The type of returned array depends on how result_type is defined.

so you better change the datatype by type casting

$foo = (int) $bar;