php 如何从while循环内部调用变量到循环外部[duplicate]

mrfwxfqh 于 2023-01-01 发布在 PHP

关注(0)|答案(1)|浏览(141)

- 此问题在此处已有答案**：

（29个答案）
2天前关闭。
调用while循环外的变量会出错调用变量的正确方法是什么？

$gettingusername = $_GET['username'];
global $connectionDB;
$sql = "SELECT name, lastname FROM admin WHERE username=:username";
$stmt = $connectionDB->prepare($sql);
$stmt->bindValue(':username', $gettingusername);
$stmt->execute();
$result = $stmt->rowCount();
if($result==1){
    while ($fetch = $stmt->fetch()){
        $existingname = $fetch['name'];
        $existinglastname = $fetch['lastname'];
    }
}

<html>
<?php echo $existingname;?> //OUTPUT UNDEFINED VARIABLE HOW TO FIX IT?
<?php echo $existinglastname;?> //OUTPUT UNDEFINED VARIABLE HOW TO FIX IT?
</html>

php

来源：https://stackoverflow.com/questions/74948626/how-to-call-a-variable-from-within-the-while-loop-to-the-outside-of-the-loop

1条答案

按热度按时间

atmip9wb1#

在while和if之前创建变量

$gettingusername = $_GET['username'];
global $connectionDB;
$sql = "SELECT name, lastname FROM admin WHERE username=:username";
$stmt = $connectionDB->prepare($sql);
$stmt->bindValue(':username', $gettingusername);
$stmt->execute();
$result = $stmt->rowCount();
$existingname = '';
$existinglastname = '';
if($result==1){
  while ($fetch = $stmt->fetch()){
    $existingname = $fetch['name'];
    $existinglastname = $fetch['lastname'];
  }
}

<html>
<?php echo $existingname;?> //OUTPUT UNDEFINED VARIABLE HOW TO FIX IT?
<?php echo $existingname;?> //OUTPUT UNDEFINED VARIABLE HOW TO FIX IT?
</html>

赞(0）回复(0）举报 2023-01-01

我来回答

php 如何从while循环内部调用变量到循环外部[duplicate]

1条答案

相关问题

热门标签

最新问答