PHP + MySQL + CodeIgniter: Check if current row exists

Question

I would like to optimize the script a little and save cpu some work, so I have to create for loop. In this loop I will work with some data from database and below is my current code:

$result = $this->Model->function();
for ($i = 0; $i < $result->num_rows(); $i++)
{
    echo $result->row_array($i)['row'];
}

What do I need here is to check if the next row exists. This one would be on the top of all code in for loop in if statement, but there is some problem. If I type $result->num_rows()+1 in for loop and echo the last row (which doesn't exist) out, the value of it isn't null, but it's same as row before.

How do I check if current row is null?

kchason · Accepted Answer · 2013-07-09 16:52:15Z

1

Or rather than have the boolean checked every time, plus you don't call the num_rows method a second time:

$result = $this->Model->function();
$y = $result->num_rows();
for ($i = 0; $i < $y-1; $i++)
{        
    echo $result->row_array($i)['row'];
}
echo 'last row';
echo $result->row_array($y-1)['row'];

answered Jul 9, 2013 at 16:52

kchason

2,88522 silver badges29 bronze badges

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

Comments

fillibuster · Accepted Answer · 2013-07-08 09:31:57Z

0

You can do this for example:

$result = $this->Model->function();
$y = $result->num_rows();
$y--;
for ($i = 0; $i < $result->num_rows(); $i++)
{
    if ($i == $y)(
        echo 'last row';
    )
    echo $result->row_array($i)['row'];
}

answered Jul 8, 2013 at 9:31

fillibuster

7084 gold badges16 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP + MySQL + CodeIgniter: Check if current row exists

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related