mtabe/

“用参数变量替换查询占位符”

维护者

详细信息

github.com/zechtz/replacer

源代码

问题

安装: 0

依赖: 0

建议: 0

安全: 0

星标: 1

关注者: 2

分支: 0

开放问题: 0

dev-master 2019-07-14 09:42 UTC

Requires

  • php: >=5.3.0

MIT 09f1dcef51dd4ce9b56d8637b2609ea952f5dc90

This package is auto-updated.

Last update: 2024-09-14 21:31:10 UTC

README

一个简单的PHP库，帮助用给定的参数替换SQL查询

测试文件包含在tests目录中

使用库

composer require mtabe/replacer

然后在您的项目中包含它

use Mtabe\Replacer;
$params = [
  'name'       => 'jonh snow',
  'start_date' => '12-01-2019',
  'end_date'   => '12-12-2019'
];

$query = "SELECT * FROM users WHERE first_name = '#P{name}' AND start_date = '#P{start_date}' AND end_date = '#P{end_date}'";

$response = Replacer::replaceWithParams($query, $params);

will return
SELECT * FROM users WHERE first_name = 'jonh snow' AND start_date = '12-01-2019' AND end_date = '12-12-2019'