PHP Tutorial: How to retrieve data based on a unique value of a column in a database

Question

I want to retrieve the values ​​of NEW_COLUMN_1 and NEW_COLUMN_2 columns from the database using the difference in the NUMBER column in the following function CR number:

function retrieveDistinctFilePaths(array $distinctCRNumbers, $database)
{
    $filePaths = [];

    echo "<pre>"; print_r($distinctCRNumbers); echo "

"; // Line A foreach ($distinctCRNumbers as $crNumber) { $query = " SELECT NEW_COLUMN_1, NEW_COLUMN_2 FROM your_table_name WHERE NUMBER = '$crNumber'"; //Execute the query and get the results from the database $database->executeStatement($query); // Get rows from results $row = $database->fetchRow(); if ($row) { $filePaths[$crNumber] = [ 'NEW_COLUMN_1' => $row['NEW_COLUMN_1'], 'NEW_COLUMN_2' => $row['NEW_COLUMN_2'] ]; } } echo "

"; print_r($filePaths); echo "

"; // Line Y return $filePaths; }

Line A in the above function prints the following:

Array
(
    [0] => AUTH-GOOD-MORNING
    [1] => GOOD-MORNING
)

Line Z in the above function outputs (prints) the following content. As you can see from the output of Line Z, the problem is that it is not printing the result based on the 'GOOD-MORNING' array value in Line A.

Array
(
    [AUTH-GOOD-MORNING] => Array
        (
            [0] => Array
                (
                    [NEW_COLUMN_1] =>
                    [NEW_COLUMN_2] =>
                )

        )

)

Problem Statement: I would like to know what changes I need to make in the above function so that Line Z prints the value based on the two array values ​​in Line A.

Answer 1

function retrieveDistinctFilePaths(array $distinctCRNumbers, $database)
{
    $filePaths = [];

    echo "<pre>"; print_r($distinctCRNumbers); echo "</pre>";  // Line A
    foreach ($distinctCRNumbers as $crNumber) {
        $query = "
        SELECT
            NEW_COLUMN_1,
            NEW_COLUMN_2
        FROM
            your_table_name
        WHERE
            NUMBER = '$crNumber'";

        // 执行查询并从数据库中获取结果
        $database->executeStatement($query);

        // 获取当前CR号的所有行
        $rows = $database->fetchAll();  // 获取所有行

        foreach ($rows as $row) {
            $filePaths[$crNumber][] = [
                'NEW_COLUMN_1' => $row['NEW_COLUMN_1'],
                'NEW_COLUMN_2' => $row['NEW_COLUMN_2']
            ];
        }
    }

    echo "<pre>"; print_r($filePaths); echo "</pre>";  // Line Z
    return $filePaths;
}