使用％s和％d的PHP MySQL查询 [英] PHP MySQL query with %s and %d

问题描述

SELECT COUNT(*) AS test FROM %s WHERE id = %d AND tmp_mail <> ''

%s和%d的用途是什么?

推荐答案

这些是使用的格式符号，例如通过sprintf().示例:

Those are format symbols used e.g. by sprintf(). Example:

<?php
 $sql_template = "SELECT COUNT(*) AS test FROM %s WHERE id = %d AND tmp_mail <> ''";
 $sql_real = sprintf($sql_template, 'sometable', 12345);
 echo $sql_real;
?>

输出:

SELECT COUNT(*) AS test FROM sometable WHERE id = 12345 AND tmp_mail <> ''

这篇关于使用％s和％d的PHP MySQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！