php - PDO 使用 while 和 foreach 获取

Question

我用了你所有的小费:更改为该但 Mysql 语句没有获取值...

看:

try {
  $sql = "SELECT a_idname FROM t_users WHERE a_zone_num <> -1;";
  $users = $conn3->query($sql);
  while ($row = $users->fetch()) {
    $result = $users->fetch(PDO::FETCH_ASSOC);
    foreach($result as $value) {
      echo $value;
      $Add_Cash = $conn1->prepare("UPDATE bg_user SET cash = cash + ':cash' WHERE user_id = ':result';");
      $Add_Cash->bindParam(':cash', $cash);
      $Add_Cash->bindParam(':result', $value);
      $Add_Cash->execute();
      $Count++;
    }
  }
  $conn3 = null;
}
catch (PDOexception $e) {
  echo "Error is: " . $e-> etmessage();
}

Answer 1

将 $sql 更改为

$sql = "SELECT a_idname FROM t_users WHERE a_zone_num <> -1;";