Passing the values of mysql_fetch_array to an Array()?

Question

this is my code:

$scontain = "SELECT id FROM voting";
$qcontain = mysql_query($scontain);

$r_idarray = array();
while ($rcontain = mysql_fetch_array($qcontain))
{
    $r_idarray[] = $rcontain['id'];
    //let's say there are 5 names here//
}

echo $r_idarray;

I was trying to get the whole content of my table 'voting'. Inside the while loop it successfully prints out the whole content of the table which is under the column 'id' but when I tried to echo it outside the while loop it prints 'Array'? Can anyone knows how to solve this. Thank you in advance...

Can you rewrite your code without "enter code here" ? Too unreadable — NightWhisper
– NightWhisper, Commented Jan 31, 2013 at 7:33
print_r recursively prints an array showing all keys and values. echo does not, and is intended for scalar values. — rynhe
– rynhe, Commented Jan 31, 2013 at 7:38
Another thing, my real objective was to use $r_idarray; how do I do that, do I still need to declare a variable and use print_r($r_idarray); like, $a = print_r($r_idarray); Thank you :) — Rtrack07
– Rtrack07, Commented Jan 31, 2013 at 7:53

codaddict · Accepted Answer · 2013-01-31 07:34:42Z

1

To print the array you can do:

print_r($r_idarray);

instead of

echo $r_idarray;

answered Jan 31, 2013 at 7:34

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

1 Comment

Rtrack07 Over a year ago

Another thing, my real objective was to use the values inside $r_idarray; to use it for comparison in my If else, how do I do that, do I still need to declare a variable and use print_r($r_idarray); like, $a = print_r($r_idarray); Thank you :)

Samy · Accepted Answer · 2013-01-31 07:34:46Z

0

You have to use print_r($r_idarray) .

echo is used for printing strings.

use print_r for printing arrays.

answered Jan 31, 2013 at 7:34

Samy

6324 silver badges14 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

Use `print_r` or `var_dump` for printing the `array`

Replace:

echo $r_idarray;

With:

print_r($r_idarray);

Or:

var_dump($r_idarray);

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 31, 2013 at 7:35

Praveen Kumar Purushothaman

167k27 gold badges215 silver badges261 bronze badges

Comments

Devang Rathod · Accepted Answer · 2013-01-31 07:35:29Z

0

If you want to display whole content

SELECT id FROM voting

To

SELECT * FROM voting

And after that you can use print_r($r_idarray);

answered Jan 31, 2013 at 7:35

Devang Rathod

6,7342 gold badges25 silver badges32 bronze badges

Comments

JohnRDOrazio · Accepted Answer · 2013-01-31 07:39:06Z

0

You can't "echo" an array, you can only "echo" a string. Of course you will see 'Array'. In order to print out the contents of an array, you either have to iterate through it's contents, or do a "var_dump($array)".

while($val in $array){
  echo $val;
}

or:

print_r($array);

or:

var_dump($array);

answered Jan 31, 2013 at 7:39

JohnRDOrazio

1,6242 gold badges20 silver badges31 bronze badges

Comments

Muhammad Raheel · Accepted Answer · 2013-01-31 07:45:37Z

0

One thing youe query should be like this to select all columns

$scontain = "SELECT * FROM voting";

You only have to do this

$i=0;
while ($rcontain = mysql_fetch_array($qcontain))
{
    $r_idarray[$i] = $rcontain;
    $i++;
}
echo '<pre>';
print_r($r_idarray);

And if you need particular columns from result

$i=0;
while ($rcontain = mysql_fetch_array($qcontain))
{
    $r_idarray[$i]['id'] = $rcontain['id'];
    $r_idarray[$i]['column1'] = $rcontain['column1'];
    $r_idarray[$i]['column2'] = $rcontain['column2'];
    $r_idarray[$i]['column3'] = $rcontain['column3'];
    $i++;
}

echo '<pre>';
print_r($r_idarray);

edited Jan 31, 2013 at 7:45

answered Jan 31, 2013 at 7:39

Muhammad Raheel

19.9k7 gold badges69 silver badges106 bronze badges

Collectives™ on Stack Overflow

Passing the values of mysql_fetch_array to an Array()?

6 Answers 6

1 Comment

Comments

Use `print_r` or `var_dump` for printing the `array`

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Use print_r or var_dump for printing the array

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related

Use `print_r` or `var_dump` for printing the `array`