MeekroDB and PDO query return associative array with ONLY strings

Question

I have the following code on a PHP script:

$DB = new MeekroDB($host, $user, $pass, $dbIntra, $port, $encoding);    
$DB->throw_exception_on_error = true;
$DB->error_handler = false;
$DB->throw_exception_on_nonsql_error = true;

$result = $DB->query("SELECT usr_id, usr_username, usr_blocked, usr_language, usr_nickname, entc_id FROM usuario LIMIT 1");

var_dump($result);

Resulting in the following:

array(1) {
  [0]=>
  array(6) {
    ["usr_id"]=>
    string(1) "1"
    ["usr_username"]=>
    string(12) "[email protected]"
    ["usr_blocked"]=>
    string(1) "0"
    ["usr_language"]=>
    string(2) "ES"
    ["usr_nickname"]=>
    string(5) "Ivan1"
    ["entc_id"]=>
    string(1) "1"
  }
}

Is there any way to have MeekroDB respect the datatypes assigned in the database model?

UPDATE

Also tried with PDO with the same result, it seems it is not MeekroDB but PHP:

$dbh = new PDO('mysql:host=...;dbname=...', $user, $pass); 
$query="SELECT usr_id, usr_username, usr_blocked, usr_language, usr_nickname, entc_id FROM usuario LIMIT 1";
$data = $dbh->query($query);
$result = $data->fetchAll(PDO::FETCH_ASSOC);
var_dump($result);

UPDATE

I would expect something like this:

array(1) {
  [0]=>
  array(6) {
    ["usr_id"]=>
    int(1) 1                          // Notice int
    ["usr_username"]=>
    string(12) "[email protected]"
    ["usr_blocked"]=>
    int(1) 0                          // Notice int
    ["usr_language"]=>
    string(2) "ES"
    ["usr_nickname"]=>
    string(5) "Ivan1"
    ["entc_id"]=>
    int(1) 1                          // Notice int
  }
}

The associative array should have the same datatype defined in the database.

@jaro1989 The associative array should have the same datatype defined in the database. (updated question) — supercoco
– supercoco, Commented Sep 9, 2016 at 21:40
so.. it's a duplicate to this question: stackoverflow.com/questions/16129432/… — jaro1989
– jaro1989, Commented Sep 9, 2016 at 21:42
wasn't really a duplicate since originally asked for MeekroDB (uses mysqli behind the scenes)... later tried with PDO... but thanks for the feedback — supercoco
– supercoco, Commented Sep 9, 2016 at 21:47
and here's for mysqli: stackoverflow.com/questions/5323146/…. MeekroDB is just a little upgrade over mysqli and nothing more. I'd better not use such (bad written btw) approaches. But it's up to you. — jaro1989
– jaro1989, Commented Sep 9, 2016 at 22:02

Your Common Sense · Accepted Answer · 2016-10-13 15:50:46Z

1

With Meekro you cannot get typed results, as it is not using prepared statements - the only way to get the data type right off the fetch.

With PDO, it is possible only if PDO is built upon mysqlnd and emulation mode is turned off. Having there prerequisites, you can have your results already in corresponding types

answered Oct 13, 2016 at 15:50

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

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

Collectives™ on Stack Overflow

MeekroDB and PDO query return associative array with ONLY strings

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related