php sprintf 替换多个,php - 如何更换里面的sprintf多个％S在DATE_FORMAT？ - SO中文参考 - www.soinside.com...

如何更换里面的sprintf多个％S在DATE_FORMAT？

问题描述 投票：0回答：1

我试图与给定天全部更换%s查询。但它抛出我错在Date_format.在%s的fcst_date是越来越正确更换。请帮忙

$day1 = date('Y-m-d');

$day2 = date('Y-m-d', strtotime("+1 days"));

$day3 = date('Y-m-d', strtotime("+2 days"));

$day4 = date('Y-m-d', strtotime("+3 days"));

$day5 = date('Y-m-d', strtotime("+4 days"));

$day6 = date('Y-m-d', strtotime("+5 days"));

$day7 = date('Y-m-d', strtotime("+6 days"));

$day8 = date('Y-m-d', strtotime("+7 days"));

$day9 = date('Y-m-d', strtotime("+8 days"));

$day10 = date('Y-m-d', strtotime("+9 days"));

$query = sprintf('SELECT blk_id,blk_name,fcst_date,temp_max,max_temp,date,temp_stn_block.stn_id FROM temp_stn_block RIGHT JOIN temp_stn_normals ON temp_stn_block.stn_id=temp_stn_normals.stn_id INNER JOIN block_imd_gfs_forecast ON blk_id=block_id JOIN block_s ON block_s.id=blk_id WHERE DATE_FORMAT(date, "%%m-%%d") IN DATE_FORMAT("%s,%s,%s,%s,%s,%s,%s,%s,%s,%s", "%%m-%%d") AND fcst_date IN (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", $day1, $day2, $day3, $day4,$day5, $day6, $day7,$day8,$day9,$day10, $day1, $day2, $day3, $day4,$day5, $day6, $day7,$day8,$day9,$day10);

$res = $this->db->query($query);

return $res->result();

php

mysql

codeigniter

1个回答

0

投票

我宁愿使用一个名为PARAM准备好的发言这只是一个更可读的代码。但是，那么你就必须更新你的CodeIgniter数据库配置使用PDO的驱动程序。

对于sprintf，只用编号占位符：

$qry_str = 'SELECT

blk_id,blk_name,fcst_date,temp_max,max_temp,date,temp_stn_block.stn_id

FROM temp_stn_block

RIGHT JOIN temp_stn_normals

ON temp_stn_block.stn_id=temp_stn_normals.stn_id

INNER JOIN block_imd_gfs_forecast

ON blk_id=block_id JOIN block_s ON block_s.id=blk_id

WHERE

DATE_FORMAT(date, "%%m-%%d") BETWEEN *day1* AND *day10*

AND

fcst_date IN (%1$s, %2$s, %3$s, %4$s, %5$s, %6$s, %7$s, %8$s, %9$s, %10$s)"

';

$query = sprintf($qry_str, $day1, $day2, $day3, $day4, $day5, $day6, $day7, $day8, $day9, $day10);

$res = $this->db->query($query);

我想与您的查询的问题是%s的使用是一个说明符“秒”在DATE_FORMAT

热门问题