MySQL integer field returned as an integer in PHP

Question

I know when MySQL returned data, it is returned as strings, no metter of the MySQL data type.

So why when i run this prepared statement i get a integer ?

    $id = '1';

    sql = "SELECT * FROM
            USER
            WHERE user_id = ? ";

    $stmt = $this->conn->prepare($sql);
    $stmt->bind_param('i', $id);
    $stmt->execute();

    $user = $stmt->get_result();

    return ($user->num_rows == 1) ? $user : NULL ;


    if ($user) {

    while($row = $result->fetch_assoc()) {
        $data = array();
        $data["user_id"]      = $row["user_id"];

    return $data;

When i run php gettype($data['user_id']) i get an integer.

I thought that datatype will always be converted to a string.

The 'i' is telling the mysqli binding function that this database column is an integer and $id should be treated as such when the parameter is replaced by this value. It is not describing what the contents of $id are — RiggsFolly
– RiggsFolly, Commented Feb 19, 2017 at 9:28
@RiggsFolly So if i replace 'i' to 's' the query will work? beacuse the id column in database are integer. — yakir30
– yakir30, Commented Feb 19, 2017 at 9:35

Tasnim Fabiha · Accepted Answer · 2017-02-19 10:00:19Z

2

It does not always return as string. Maybe you are using PHP version upper than 5.3( the version of PHP 5.3 is compiled with mysqlnd (and not old libmysql)), uses mysqlnd as the native driver and the native driver returns integer types appropriately. Please check which version you are currently using. For more details you can go through this link. http://blog.ulf-wendel.de/2008/pdo_mysqlnd-the-new-features-of-pdo_mysql/

edited Feb 19, 2017 at 10:00

answered Feb 19, 2017 at 9:50

Tasnim Fabiha

1,2381 gold badge19 silver badges33 bronze badges

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

2 Comments

yakir30 Over a year ago

This is break my app, when i use the mysqli non prepared statement i always get a string, and now when i moved to prepared statement i always get a integer no metter if i passed $stmt->bind_param('s', $id); $_SESSION['id'] === $_GET['id'] not ture.

Jones G Over a year ago

even now it is still breaking, sometimes is string, sometimes is integer, it seems to be a bug?

Collectives™ on Stack Overflow

MySQL integer field returned as an integer in PHP

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related