zacharyrankin / named-sql-params
Named parameters in sql strings
Installs: 14
Dependents: 0
Suggesters: 0
Security: 0
Stars: 2
Watchers: 1
Forks: 0
pkg:composer/zacharyrankin/named-sql-params
Requires
This package is not auto-updated.
Last update: 2025-10-15 15:16:11 UTC
README
Named parameters in sql strings
Usage
$named = new NamedSqlParams; $sql = <<<SQL SELECT id, username, email FROM :!users_table WHERE country = :country AND gender IN (:genders) SQL; $params = [ 'users_table' => 'users', 'country' => 'USA', 'genders' => ['M', 'F'] ]; list($prepared_sql, $prepared_params) = $named->prep($sql, $params); // $prepared_sql will be: // SELECT // id, // username, // email // FROM users // WHERE country = ? // AND gender IN (?, ?) // $prepared_params will be: // ['USA', 'M', 'F']
TODO
- More documentation
- Refactor code some more
- Push to packagist