Getting wrong array php sql

Question

I have an table called user like this

id | user
 1 | test
 2 | test1

I have an query like this:

$arr = array(0 => 1 , 1=> 2);
$sql = "SELECT user 
    FROM user 
    WHERE id IN (".implode(',',$arr).") 
    ORDER BY id";
$gg = mysqli_query($conn, $sql);
if(!$gg) {
    echo mysqli_error($conn);
} else {
    while ($row = mysqli_fetch_array($gg)) {
        print_r($row[0]);
    }
}

Ouput always shows as testtest1 but i want it in array like ([0] => test, [1] => test1) or even test,test1 is ok but it should work outside loop as well. Help appreciated.

and where is the error? you print the array with key 0 so add that value tu an array and it's done — law_81
– law_81, Commented Sep 21, 2018 at 14:43
The amount of keys can vary and I wont be knowing how much are there — ggwp
– ggwp, Commented Sep 21, 2018 at 14:45

dustytrash · Accepted Answer · 2018-09-21 14:46:58Z

1

Create an array, then print the array. (And/or do whatever you want with the array)

E.G:

$arr = array(0 => 1 , 1=> 2);
$sql = "select user from user where id IN (".implode(',',$arr).") ORDER by id";
$gg = mysqli_query($conn, $sql);
$arrayOfResults = array();

if(!$gg){
    echo mysqli_error($conn);
}
else {
    while ($row = mysqli_fetch_array($gg))
    {
        array_push($arrayOfResults, $row[0]);
    }

    print_r($arrayOfResults);
}

answered Sep 21, 2018 at 14:46

dustytrash

1,5901 gold badge11 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

naive pro-grammar · Accepted Answer · 2018-09-21 15:00:16Z

0

mysqli_fetch_array($gg, MYSQLI_ASSOC) will return you an associative array. you can verify using var_dump($row) also, you can use MYSQLI_NUM (for index as number) or MYSQLI_BOTH (for index as number as well as column name) instead of MYSQLI_ASSOC

otherwise you can also use mysqli_fetch_assoc e.g. here

edited Sep 21, 2018 at 15:00

answered Sep 21, 2018 at 14:51

naive pro-grammar

3494 silver badges10 bronze badges

Collectives™ on Stack Overflow

Getting wrong array php sql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related