php - 我想从数据库中获取数据，并动态更改查询并将数据库中的 id 存储在数组中，然后使用它来调用函数

Question

我是 PHP 新手，谁能帮我解决这个问题。我想做的是调用一个函数，该函数从表中获取 id 并将 id 存储在数组中，然后在循环中调用另一个方法，使得数组元素应该是在函数中传递的参数。

<?php

include 'connection.php';

$releaseidarr=array();

function getreleaseid($p)
{
    $releaseid=array();
    $releaseidp="select release_id from `release` where project_id=".$p.";";
    $query4=mysql_query($GLOBALS['db'],$releaseidp);
    while($row=mysqli_fetch_array($query4))
    {
        $releaseid[]=$row['release_id'];
    }
    return $releaseid;

}
$p=1;
while($p<8)
{
    //echo "hi";
    $releaseidarr=getreleaseid($p);
    echo $releaseidarr[$p];
    $p++;
}

?>

Connection.php contains

<?php

$GLOBALS['server']="******";
$GLOBALS['username']="*****";
$GLOBALS['password']="****";
$GLOBALS['database']="dashtest";

$GLOBALS['conn']= mysqli_connect($server,$username,$password,$database);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
//echo "Connected successfully";    

$GLOBALS['db'] = mysqli_connect($server,$username,$password,$database);
//echo "connected";

?>

Answer 1

这里不要同时使用mysql和mysqli。只用于在mysqli中写入。并在 foreach 循环中使用数组推送方法。首先声明一个空数组，例如

$array = [];
foreach($a as $k){
array_push($array,$k);
}
return $array;