单词“数组"指的是数组.打印而不是数据库信息 [英] The word "array" prints instead of databse information

问题描述

我的代码始终打印"array"一词，而不是数据库信息.当我尝试使用print_r()或var_dump()时，它会回显有关数组的所有信息

My code keeps on print the word "array" instead of the database information. When i try to use print_r() or var_dump() it echos all the information about the array

这是var_dump

array(1){[" Team] => string(8)" Oakville} array(1){[" Team] => string(8)" Brampton} array(1){["团队] =>字符串(7)"多伦多}数组(1){["团队"] =>字符串(11)密西沙加"}

array(1) { ["Team"]=> string(8) "Oakville" } array(1) { ["Team"]=> string(8) "Brampton" } array(1) { ["Team"]=> string(7) "Toronto" } array(1) { ["Team"]=> string(11) "Mississauga" }

这是我的代码

if(isset($_REQUEST['submit2'])){
$leaguename = $_POST['league'];
$db_host = '**';
$db_user = '**';
$db_pwd = '**';
$database = '**';
$db = new mysqli($db_host, $db_user, $db_pwd, $database);


$sql = "SELECT Team FROM Games WHERE League = '$leaguename' AND Team <> ''";

$result = mysqli_query($db, $sql) or die ("no query");

if (!$result) {
    die('Invalid query: ' . mysqli_error());
}

$array = array();
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){
    $array[] = $row;
}

$teamnumber=count($array);
echo $teamnumber . "<br>";

foreach($array as $teams=>$team){
    var_dump($team);
}

我正在尝试打印从数据库中提取并放入数组的运动队的名称.

I'm trying to print the names of sports teams that are being fetched from a database and put into an array.

推荐答案

您的数组是一个多维数组，一个包含一个或多个数组的数组.

Your array is a Multidimensional Arrays, an array containing one or more arrays.

因此，您正在打印外部数组var_dump().您应该使用双循环:

Because of that you are printing the outer array var_dump(). You should use a double loop:

foreach($array as $teams){
    foreach($teams as $team){
        echo $team . "<br>";
    }
} 

这篇关于单词“数组"指的是数组.打印而不是数据库信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！