mysql.bind
mysql.bind
Function
Appends a set of normal binding parameters.
Syntax
mysql(dsn).query(sql).bind(value1, value2, ...)
Parameters
| Parameters | Type | Required | Default value | Description |
|---|---|---|---|---|
| valueN | Any | No | None | The value to bind to the ? placeholder. |
Return value
| Type | Description |
|---|---|
| Mysql | Returns the new MySQL query builder. |
Example
db = mysql('mysql://user:pass@127.0.0.1/test') result = db.query('select * from user where id=?').bind(1001).sql() // Output: select * from user where id=1001 print result
Notes
- Bind can be called multiple times, and parameters will be appended in the order of calls.