Unable to ECHO PostgreSQL Query Results - PHP

Question

I've successfully connected to a PostgreSQL database and even the query is running successfully.

But when I try to print the data using this code echo $data I get error as Array to String Conversion.

Tried searching in the forum and google. Nothing was fruitful.

Please help me.

Code used to convert it to array and print it.

if ( ! $myquery ) {
    echo pg_error();
    die;
}

$data = array();
for ($x = 0; $x < pg_num_rows($myquery); $x++) {
    $data[] = pg_fetch_assoc($myquery);
}
// echo json_encode($data);

// $data2 = array_shift($data);

echo $data;

pg_close($server);

Tosx · Accepted Answer · 2013-12-31 09:50:16Z

1

Read the error :

Array to String Conversion

Try to display it using var_dump or print_r because it's an array. The error says that you want to display an array with echo which can only display string.

exemple : var_dump($data);

answered Dec 31, 2013 at 9:50

Tosx

6063 silver badges8 bronze badges

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

5 Comments

Unknown User Over a year ago

array(2) { [0]=> array(2) { ["Label"]=> string(3) "One" ["Count"]=> string(1) "1" } [1]=> array(2) { ["Status"]=> string(7) "Two" ["Count"]=> string(1) "3" } }

- I got a result like this. Can you please say me now how will I select pass this value to a jquery sparkline chart?

Tosx Over a year ago

I need more information. To select a specific value you can do like this : $value = $data[0]['Label']; or $value = $data[1]['Status'];

Unknown User Over a year ago

Here's the link. I just wanted to how to pass that two numbers 1 and 3 into that jquery sparkline. I need to do like this? <?php $value?>

Tosx Over a year ago

I'm not sure but i think you will have to print you value in html balise (hidden filed for exemple) and retrieve it using javascript : document.getElementById

Tosx Over a year ago

can you mark this post as solved ? we will discuss in the other one.

Community · Accepted Answer · 2023-11-17 19:26:01Z

1

To just print the array (for debuging) use var_dump() like this:

var_dump($data)

But if you want to echo every line in the array you have to loop:

foreach ($data as $row) {
    echo $row;
}

edited Nov 17, 2023 at 19:26

CommunityBot

11 silver badge

answered Dec 31, 2013 at 9:51

Matthias Dunkel

3052 silver badges14 bronze badges

2 Comments

Unknown User Over a year ago

array(2) { [0]=> array(2) { ["Label"]=> string(3) "One" ["Count"]=> string(1) "1" } [1]=> array(2) { ["Status"]=> string(7) "Two" ["Count"]=> string(1) "3" } }

- I got a result like this. Can you please say me now how will I select pass this value to a jquery sparkline chart?

Matthias Dunkel Over a year ago

The function var_dump($data) is only for debuging. Don't use this for actual coding... I don't know jQuery very well, but you could try to pass it to a JS variable like this var data = <?php echo json_encode($data); ?> (This code hase to be in your JS block)

Mahmood Rehman · Accepted Answer · 2013-12-31 09:51:00Z

0

You are pinting array with echo.Try print_r(); that will print array. Like this print_r($data);

answered Dec 31, 2013 at 9:51

Mahmood Rehman

4,3377 gold badges43 silver badges76 bronze badges

Comments

Adarsh Nahar · Accepted Answer · 2013-12-31 09:59:25Z

0

Try using var_dump($var) or print_r($var) functions

answered Dec 31, 2013 at 9:59

Adarsh Nahar

3193 silver badges10 bronze badges

Collectives™ on Stack Overflow

Unable to ECHO PostgreSQL Query Results - PHP

4 Answers 4

5 Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related