mysql语句中的冒号是什么意思？
mysql语句中的冒号是什么意思？
——解决方案——————–
$db->bandVars(); 传递值
echo $check_query; 就知道了。
——解决方案——————–
可以看看手册的pdo类
- PHP code
<?php/* Execute a prepared statement by binding PHP variables */$calories = 150;$colour = 'red';$sth = $dbh->prepare('SELECT name, colour, calories FROM fruit WHERE calories bindParam(':calories', $calories, PDO::PARAM_INT);$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);$sth->execute();?><br /><font color='#e78608'>------解决方案--------------------</font><br />没有别的意思符号而已，以便区别于 sql 的语法成分<br />bindVars 方法将定义的符号与实际的变量关联起来<br /><font color='#e78608'>------解决方案--------------------</font><br /><dl class='code'>PHP code<pre class="prettyprint linenums">Example #1 Execute a prepared statement with named placeholders<?php/* Execute a prepared statement by binding PHP variables */$calories = 150;$colour = 'red';$sth = $dbh->prepare('SELECT name, colour, calories FROM fruit WHERE calories bindParam(':calories', $calories, PDO::PARAM_INT);$sth->bindParam(':colour', $colour, PDO::PARAM_STR, 12);$sth->execute();?>Example #2 Execute a prepared statement with question mark placeholders<?php/* Execute a prepared statement by binding PHP variables */$calories = 150;$colour = 'red';$sth = $dbh->prepare('SELECT name, colour, calories FROM fruit WHERE calories bindParam(1, $calories, PDO::PARAM<mark>（本文来）源gaodaimacom搞#^代%!码&网(</mark><pre>搞gaodaima代码
_INT);$sth->bindParam(2, $colour, PDO::PARAM_STR, 12);$sth->execute();?>
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：mysql语句中的冒号是什么意思？该怎么解决
转载请注明原文链接：mysql语句中的冒号是什么意思？该怎么解决
