show array from database

Question

I have this db

id | domain    | whois_server         |
---------------------------------------
1  | ac        | whois.nic.ac         |
2  | ae        | whois.nic.ae         |
3  | id        | whois.pandi.or.id    |

How to show array form array without id ?

array (
    'ac' => 'whois.nic.ac',
    'ae' => 'whois.nic.ae',
    'id' => 'whois.pandi.or.id',
)

I have done the following code:

$sql = "SELECT * FROM whois_server ";
$result = $db->prepare($sql);
$result->execute();
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
    $whoisservers =  array_merge($whoisservers, array_map('trim', explode(",", $row[1])));
}

but what appears is :

array (
    [0] => whois.nic.ac
    [1] => whois.nic.ae
    [2] => whois.pandi.or.id
)

Why you don't use this query `SELECT domain, whois_server FROM whois_server` ? — executable, Mar 22 '19 at 15:54

score 2 · Accepted Answer · answered Mar 22 '19 at 15:57

2

$sql = "SELECT * FROM whois_server ";
$result = $db->prepare($sql);
$result->execute();
$dataReturn = [];
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
      $dataReturn[$row['domain']] = $row['whois_server'];
}
print_r($dataReturn);

answered Mar 22 '19 at 15:57

CodeZi.pro

229
5
8

score 1 · Answer 2 · answered Mar 22 '19 at 15:57

In your loop you can add the key to the $whoisseervers variable for each value:

$sql = "SELECT domain, whois_server FROM whois_server";
$result = $db->prepare($sql);
$result->execute();

$whoisservers = [];
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
    $whoisservers[$row['domain']] =  $row['whois_server'];
}

print_r($whoisservers);

score 1 · Answer 3 · answered Mar 22 '19 at 15:57

1

$whoisservers = array();
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
  $whoisservers[$row["domain"]] = $row["whois_server"];
}

would be simpler (and clearer).

And as mentioned in the comments, in the SQL don't select fields you don't need.

answered Mar 22 '19 at 15:57

ADyson

57,178
14
51
63

score 1 · Answer 4 · answered Mar 22 '19 at 15:57

Add to the $whoisservers array, by pushing the index as $row['domain'] and the value as $row['whois_server'].

$whoisservers = [];
$sql = "SELECT * FROM whois_server ";
$result = $db->prepare($sql);
$result->execute();
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
    $whoisservers[$row['domain']] =  $row['whois_server'];
}
print_r($whoisservers);

score 1 · Answer 5 · answered Mar 22 '19 at 16:04

A little different from other answers solution with fetchAll and PDO::FETCH_KEY_PAIR:

$sql = "SELECT domain, whois_server FROM whois_server";
$result = $db->prepare($sql);
$result->execute();
$whoisservers = $result->fetchAll(PDO::FETCH_KEY_PAIR);
print_r($whoisservers);

show array from database

5 Answers5