Home >Backend Development >PHP Tutorial >php中sql变量需要单引号的时候变量如何设置？
php中sql变量需要单引号的时候变量如何设置？
- WBOYOriginal
- 2016-06-23 13:13:451604browse
$coupons = pdo_fetchall("select * from ".tablename('wangniu_activity')." where flag = 0 and isopen = 1 and ischeck = 1 and start_time < ".time()." and end_time > ".time()." and weid = ".$weid." and storeid = '".$id."'. order by type asc"); 其中sql执行为：
select * from `ims_wangniu_activity` where flag = 0 and isopen = 1 and ischeck = 1 and start_time 1458445852 and weid = 2 and storeid = 'B0FFF4YWV2' . order by type asc
多了一个点，这个点怎么去掉？
回复讨论(解决方案)
... " and storeid = '".$id."' order by type asc"
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：100分的挑战Next article：[LNMP自动化集成]使用jenkins进行PHP持续集成--自动化代码检查、分析和单例测试