Check next record exists in database

Question

I am using Zend fetch method to fetch huge number of records from database for creating reports.Since fetchAll is costly as compared to fetch i am using it.And if its the last row i need to add some additinoal logic.So my question is that is there a way to check if next record exists or not inside the while loop. I am using it like the following

//$select is the select query
$objDb      = Zend_Registry::get('db');
$objAchQry = $objDb->query($select);
while($arrResult = $objAchQry->fetch()) {
  //Do something

  //I need to do something here if its the last record like
  /*
  if($last_rec)
    do something
  */
}

Is there a way to check if the current one is last record or if any other record exists. I know to do it by taking count of records and incrementing a counter inside the loop.But i dont need it.Any solutions.?

"is there a way to check if next record exists" The condition on your while loop does exactly just that. The loop won't execute any more if no more rows exist to fetch. — marekful, Nov 20 '13 at 11:24
one way, you can have a counter in the loop, and in the beggining total no of records. If counter < total then you have next record else you are on last record. — Suleman Ahmad, Nov 20 '13 at 11:24
@MarcellFülöp so i want to check the current one is last one or not inside while. i know it will stop execution if no more rows are there.But how will i know that current one is the last record — 웃웃웃웃웃, Nov 20 '13 at 11:29

marekful · Accepted Answer · 2013-11-20T11:55:44.337

1

"is there a way to check if next record exists" The condition on your while loop does exactly just that. The loop won't execute any more if no more rows exist to fetch.

Think of it this way:

while($arrResult = $objAchQry->fetch()) {

  //Do something

}

// Now I'm just after the last record
/*
do something
*/

If you really need to do something before the last row is processed, you could modify your code to

$total_records = // get total no of rows
$counter = 0;
while($arrResult = $objAchQry->current()) {
  //Do something
  $counter ++;

  //I need to do something here if its the last record like

  if( ! $bojAchQry->next()) {

    // The row currently being processed is the last one.

  } else {

    break;
  }
}

edited Nov 20 '13 at 11:55

answered Nov 20 '13 at 11:28

marekful

14,986
6
37
59

I dont want to go after the last record.I need it when it is the last record. – 웃웃웃웃웃 Nov 20 '13 at 11:32
I dont think there is a method named `current and next` in pdo. – 웃웃웃웃웃 Nov 20 '13 at 11:57

Suleman Ahmad · Answer 2 · 2013-11-20T11:46:50.760

1

One way - You can track with counter,

$total_records = // get total no of rows
$counter = 0;
while($arrResult = $objAchQry->fetch()) {
  //Do something
  $counter ++;

  //I need to do something here if its the last record like

  if($counter == $total_records  ) // this iteration will be the last one.
   //do something

}

edited Nov 20 '13 at 11:46

answered Nov 20 '13 at 11:37

Suleman Ahmad

2,025
4
28
43

Thanks for the answer.But i have mentioned in the question that i dont want to do the logic with a counter. – 웃웃웃웃웃 Nov 20 '13 at 11:38
@Deepu: you welcome, but sometimes we are bound to use the existing provided functions, and we use those functions for our problem. Similarly I do't think there is a any function in php mysql connection library that provides at a time the next row and previous row iterations. – Suleman Ahmad Nov 20 '13 at 11:46

Check next record exists in database

2 Answers2