bindParamsFromArray to also accept associative arguments

[geertvanbommel]

In PDO it's common to also provide an associative array of variables in the form of ":name", as well as question mark placeholders. (http://php.net/manual/en/pdostatement.bindparam.php)

So it would be awesome if $query->bindParamsFromArray($args); also supported this.

// Example:
$stmt = 'update table set foo=:bar, foo2=:bar2 where id=:id';

$args = array(':bar'=>'my value',':bar2'=>"my \"second\" value", ':id'=>123);
// or without semicolons:
$args = array('bar'=>'my value',  'bar2'=>"my \"second\" value", 'id'=>123);

// Desired result:
update table set foo='my value', foo2='my "second" value' where id=123

// Potential error in case of mismatching
// SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

[clue]

Yes, please! Would love to see this feature in here. I see there's already some pseudo code in place here: https://github.com/friends-of-reactphp/mysql/blob/master/src/Query.php#L124

Now that the test suite has seen some significant improvements with #39, I suppose this would not be too much work to implement this here. I'm not working on this myself at the moment, but I suppose PRs would be very much appreciated!

[tonix-tuft]

Hi, I've created a decorator for the binding of associative parameters, check it out if you are interested:

https://github.com/tonix-tuft/reactphp-mysql-decorator

[WyriHaximus]

Hi, I've created a decorator for the binding of associative parameters, check it out if you are interested:

tonix-tuft/reactphp-mysql-decorator

Cool, could you add it to: https://github.com/reactphp/react/wiki/Users

[tonix-tuft]

OK! I've added it in the Databases section.