Jump to content

php cant print all the rows from database


sakibd2k

Recommended Posts

Hello,

 

I am trying to query and show it by fetching all the row  but actually only one row shows up

not all the rows by defined condition.

 

The code is

 

<?php

$db=pg_connect("host=localhost dbname=xxxx  user=xxxx  password=xxxx ");

..........................................................

 

 

$result=pg_query($db,"select  id,credit from cc_cdr where id<=20500 AND id>=10501 AND credit<5 ORDER BY id ASC");

 

$row=pg_fetch_array($result);

echo $row["id"];

echo  $row["credit"];

 

?>

 

i can see only one , the first row

if i change pg_fetch_all($result)

 

nothing show up

 

what will  i do in this case?

 

 

Link to comment
Share on other sites

Here is the exact description from php.net: "pg_fetch_array — Fetch a row as an array"

 

So, you'll have to loop through all the rows. Something like this:

$all_rows = array();
while ($row = pg_fetch_array($result)){
  $all_rows[] = $row;
}
print_r($all_rows);

Link to comment
Share on other sites

pg_fetch_array() only fetches one row from the result set each time it is called. You would need to use it in a loop (i.e. what F1Fan posted above) to iterate over all the rows in the result set.

 

pg_fetch_all() fetches all the rows from the result set into an array. You would need to use php's array functions, such as foreach(), to iterate over all the rows in the array.

Link to comment
Share on other sites

Thank you F1fan. I knew i was missing the array or something like that but do not know how does it solve.

 

I am very happy at least this one solved.

 

But the out put showing all the thing like following

 

Array ( [0] => Array ( [0] => 10505 [id] => 10505 [1] => 0.1016 [credit] => 0.1016 [2] => 2259217297 [username] => 2259217297 ) [1] => Array ( [0] => 10506 [id] => 10506 [1] => 0.0260 [credit] => 0.0260 [2] => 9273294177 [username] => 9273294177 ) [2] => Array ( [0] => 10507 [id] => 10507 [1] => 0.3040 [credit] => 0.3040 [2] => 6944787983 [username] => 6944787983 ) [3] .................................................

 

I want to show them like following

 

id        credit          username

 

10505  0.1016    2259217297

........................................

 

to view This manner  what i need to do?

 

Link to comment
Share on other sites

Thanks F1Fan

one last request  is it than possible

 

when i put condition under select query put it in variable  which will be choosed by user

 

i mean when i am using this query in parantheses  i want here instead of id<=20500  id<=$var

 

select  id,credit from cc_cdr where id<=20500 AND id>=10501 AND credit<5 ORDER BY id ASC

 

Where $var will be given by input in html file and php will process

 

this way at least thing will come easier.

 

Thanks again

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.