Seeing default value inserted into columns when calling query() function with question mark placeholders

[ducnguyenvn]

Hi,

The below is my code:

$sql = 'insert into my_table (name, amount) values (?, ?)'
$params = array( 0 => "Messi", 1 => 100)
$db->query($sql, $params);

Then I check database and see that a new row inserted but with default values instead of my values.

Could you please correct me?

Thanks.

[joejordanbrown]

I've not used this in a while but i think this is how it should be.

$sql = 'INSERT INTO my_table (name, amount) VALUES (?, ?)';
$params = array("Messi", 100);
$db->query($sql, $params);

[ducnguyenvn]

Thanks but it's same code. Still error.

[joejordanbrown]

Actually reviewing the source code it doesn't look to accept that method. Is there any reason you can't use the other method?

What about just plain PHP PDO prepare?

$prep = $dbh->prepare('INSERT INTO my_table (name, amount) VALUES (?, ?)');
$prep->execute(array('Messi', 100));

[ducnguyenvn]

Yes, Seem this lib doest not support that. This is the bind function in DB.class.php in this lib:

public function bind($para, $value)
    {
          $this->parameters[sizeof($this->parameters)] = [":" . $para , $value];
    }

And I updated it to followings so that it works in my case:

public function bind($para, $value)
    {
        if (is_int($para)) {
          $this->parameters[sizeof($this->parameters)] = [++$para , $value];
        } else {
          $this->parameters[sizeof($this->parameters)] = [":" . $para , $value];
        }
    }