参数绑定在CodeIgniter 3.1查询构建器

发布于 01-22 18:45 字数 677 浏览 4 评论 0原文

我有一个

$column = 1234;
$sql = "SELECT * FROM TABLE WHERE COLUMN = ?";
$result = $this->db->query($sql,[$column])->row();

完全可以正常工作的查询但是，当我拥有联合条款时，我必须两次传递参数

$sql = "SELECT * FROM TABLE1 WHERE COLUMN = ?
       UNION
       SELECT * FROM TABLE2 WHERE COLUMN = ?";
$result = $this->db->query($sql,[$column,$column])->result();

，我们有以下代码之类的东西来实现上述结果，我只能传递一个值，因为它们两个都需要相同的值。

$sql = "SELECT * FROM TABLE1 WHERE COLUMN = :column
       UNION
       SELECT * FROM TABLE2 WHERE COLUMN = :column";
$result = $this->db->query($sql,['column' => $column])->result();

原文

I have a query

$column = 1234;
$sql = "SELECT * FROM TABLE WHERE COLUMN = ?";
$result = $this->db->query($sql,[$column])->row();

which works completely fine
But when i have union clause i have to pass the parameter twice

$sql = "SELECT * FROM TABLE1 WHERE COLUMN = ?
       UNION
       SELECT * FROM TABLE2 WHERE COLUMN = ?";
$result = $this->db->query($sql,[$column,$column])->result();

Do we have something like below code to achieve the above result where i could pass only one value since both of them requires same value.

$sql = "SELECT * FROM TABLE1 WHERE COLUMN = :column
       UNION
       SELECT * FROM TABLE2 WHERE COLUMN = :column";
$result = $this->db->query($sql,['column' => $column])->result();

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

你的他你的她2025-01-29 18:45:05

好吧，您可以使用：

$column = 1234;
$sql = "SELECT * FROM TABLE1 WHERE COLUMN = " . $column . "
       UNION
       SELECT * FROM TABLE2 WHERE COLUMN = " . $column . ";
$result = $sql->result();

Well you can just use :

$column = 1234;
$sql = "SELECT * FROM TABLE1 WHERE COLUMN = " . $column . "
       UNION
       SELECT * FROM TABLE2 WHERE COLUMN = " . $column . ";
$result = $sql->result();

回复收藏 0 原文

~没有更多了~