mysqli returning bits and ints as string

Question

I have a project made in flex, using PHP data services to access an SQL server database, and I need to convert it to MySQL, I have changed all my PHP services from sqlsrv to mysqli.
Something like this:

$this->connection = mysqli_connect(SERVER,USERNAME,PASSWORD,DATABASE); // Start Connection
$ssqlstring = "select * from Users";
$runssql = mysqli_query($this->connection, $ssqlstring);
while($user = mysqli_fetch_array($runssql)) 
{
  $users[$user["ID"]] = $user;
}
return $users;

It worked fine on sqlsrv but with mysqli it returns to flex the INT, BIT, or DATE values as string

the main Datatypes on MySQL are INT, VARCHAR, BIT(1), DATETIME, DATE (same as sqlsrv)
and on the flex the return types are mainly as object[]

possible duplicate of Accessing PHP MySQLI predefined constants via respective value? — Wrikken
– Wrikken, Commented Feb 24, 2012 at 18:03
Does this answer your question? How do I make sure that values from MySQL keep their type in PHP? — Dharman
– Dharman ♦, Commented May 13, 2020 at 0:13
Does this answer your question? MySQL integer field is returned as string in PHP — tim
– tim, Commented Oct 17, 2020 at 23:27

Wrikken · Accepted Answer · 2012-02-24 16:28:14Z

4

from the manual

Returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in resultset.

There are relatively few native types in PHP, in short, possibles are INT, FLOAT and STRING (where STRING is the default for all the rest, like BIT and DATE etc.). PDO is a bit better at using more close-to-actual types, but still defaults to strings a lot. In mysqli, you could use mysqli_result_fetch_fields to get the type of field returned, and cast it to a desired format, see also the MYSQLI_TYPE_* constants.

answered Feb 24, 2012 at 16:28

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Joaolvcm Over a year ago

based on your response i found this stackoverflow.com/questions/6537212/… , thank you

Collectives™ on Stack Overflow

mysqli returning bits and ints as string

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related