我有一些在其中使用SQL select语句的工作代码。作为一段静态代码,它工作得很好,然而,我希望能够在其中使用变量。所以,在我的研究中,每个人都说你应该使用PHP Prepare语句,以保证安全。所以,我的旧代码看起来像这样:
/*** MY OLD WORKING CODE ***/
/*** SQL Query ***/
$sql = "SELECT tickets.ref AS `Ticket Number` ......
.....BLAH................INTERVAL 30 DAY) AND
organizations.name = 'NAMEIWANTTOUSE' ";
/*** For Each Loop to Build Table ***/
foreach ($dbh->query($sql) as $row){
echo "<tr>";
echo "<td bgcolor=89FF95 align=center>".$row['Ticket Number']."</td>";
ETC..................
}
$sql->closeCursor();我的新代码,我正在试着开始工作..似乎什么也没做。我知道我不太了解它,但是我就是不知道应该把哪个变量放入我的FOREACH循环中。或者如果我真的把PHP Prepare语句弄对了呢?
有什么建议吗?
/*** MY NEW NOT WORKING CODE ***/
/*** Variables ***/
$NAME = 'NAMEIWANTTOUSE';
$DAYS = '30';
/*** Prepare the SQL Query ***/
$stmt = $sql->prepare("SELECT tickets.ref AS `Ticket Number` .......
....BLAH................INTERVAL :DAYS DAY) AND
organizations.name = :NAME ");
$stmt->bindParam(":DAYS", $DAYS);
$stmt->bindParam(":NAME", $NAME);
$stmt->setFetchMode(PDO::FETCH_ASSOC);
$stmt->execute();
/*** Put each return from SQL into a Variable? ***/
$MySQLQuery = $stmt->fetchAll();
/*** For Each Loop to Build Table ***/
foreach ($dbh->query($MySQLQuery) as $row){
echo "<tr>";
echo "<td>".$row['Ticket Number']."</td>";
ETC..................
}
$sql->closeCursor();谢谢
发布于 2012-10-07 05:56:38
您几乎拥有它,只是您不应该在循环中调用query()。结果集已提取到$MySQLQuery中。fetchAll() returns a 2D array,不像旧的mysql_query()返回一个需要用mysql_fetch_*()循环的结果资源。
// Following fetchAll(), $MySQLQuery is a 2D array containing your rowset.
foreach ($MySQLQuery as $row){
echo "<tr>";
echo "<td>".$row['Ticket Number']."</td>";
ETC.........
} https://stackoverflow.com/questions/12764187
复制相似问题