如何从databse中提取数据到2d数组中?

I am wondering if anyone can help. I am new to php, so apologies for my poor coding. I am trying to pull data from the database and for each lecturer I want to create a 2d array $lecturer1 [] [], lecturer2 [] [] etc and place each lecturer's id number in [0] [0]. I am a bit lost so any help would be really appreciated.

我想知道是否有人能帮忙。我是php新手，所以为我糟糕的代码感到抱歉。我正试图从数据库中提取数据，我想为每个讲师创建一个2d数组$朝尔1[]，讲师2[][]等，并将每个讲师的id号放在[0][0]中。我有点迷路了，所以任何帮助都是非常感谢的。

<?php
require ('mysqli_connect.php');

$lecturers_temp = array(array());
$i = 1;

$q2 = "SELECT `uninum` FROM `availabilityindex` ORDER BY `availibility`";

    $result2 = @mysqli_query($dbcon,$q2);

    while ($row2 = mysqli_fetch_array ($result2, MYSQLI_ASSOC)){
            $lecturers = $row2['uninum']; 
            $lecturers_temp.$i = array(array());
            $lecturers_temp.$i [0] [0] = $row2["uninum"];
            $i++;

            echo $lecturers_temp.$i [0] [0];


    }


?>

1 个解决方案

#1

Below is a partial answer.....but I wonder if there is anyway I could create a separate array for each person, store their uninum in [0] [0] and leave the other part of the 2d array free for other data...eventually I want to have lecturer1 (A34567 (1,0,1,0,1,0,1,0)

下面是部分答题卡……但我想知道是否有办法为每个人创建一个单独的数组，将它们的uninum保存在[0][0]中，让2d数组的另一部分对其他数据保持空闲……最后我想要的是讲师1 (A34567 (1,0,1,0,1,0,1,0)

<?php
    require ('mysqli_connect.php');

    $lecturers_temp = array(array());
    $i = 0;

    $q2 = "SELECT `uninum` FROM `availabilityindex` ORDER BY `availibility`";

        $result2 = @mysqli_query($dbcon,$q2);

        while ($row2 = mysqli_fetch_array ($result2, MYSQLI_ASSOC)){
                $lecturers = $row2['uninum']; 
                $lecturers_temp = array(array());
                $lecturers_temp [$i] [0] = $row2["uninum"];


                echo $lecturers_temp [$i] [0] . "<BR><BR>";
                $i++;


        }


    ?>

1 个解决方案

#1

更多相关文章

随机推荐