PHP, checking values from My-Sql data

Question

$result = $this->db->query($query)->result_array();


        if($result[9]['b_code'] != FALSE)
            {

        $result_array = array(
                            '0' => $result[0]['b_code'],
                            '1' => $result[1]['b_code'],
                            '2' => $result[2]['b_code'],
                            '3' => $result[3]['b_code'],
                            '4' => $result[4]['b_code'],
                            '5' => $result[5]['b_code'],
                            '6' => $result[6]['b_code'],
                            '7' => $result[7]['b_code'],
                            '8' => $result[8]['b_code'],
                            '9' => $result[9]['b_code']
                        );


                return $result_array;
            }
        else
            return FALSE;

It extracts 10 data in rows and make it a new array as $result_array;

Sometimes, it won't have 10 results and may extract 5 or 8.

So, I wanna check wether there is a value for last one, which is $result[9]['b_code] or not.

Should I use isset?

hakre · Accepted Answer · 2012-04-05 07:34:58Z

2

Should I use isset?

Yes, isset^Docs is the right language construct if you want to test if a value is set (e.g. set and not NULL^Docs).

In your particular case you can also check the length of $result, that is done with count^Docs:

$numberOfElements = count($result);

Some example code with isset:

if (!isset($result[9]))
{
    return FALSE;
}

return array_map(function($v) {return $v['b_code'];}, $result);

Note that in this example we're preventing to repeat ourselves 10 times only to copy each b_code element. Instead, this is done with array mapping, see array_map^Docs.

A probably more readable variant, this time with count:

if (10 != count($result))
{
    return FALSE;
}

$resultArray = array();
foreach ($result as $v)
{
    $resultArray[] = $v['b_code'];
}
return $resultArray;

This variant is making use of foreach^Docs to prevent assigning 10 elements one by one.

edited Apr 5, 2012 at 7:34

answered Apr 5, 2012 at 7:17

hakre

200k55 gold badges454 silver badges865 bronze badges

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

Comments

Rukmi Patel · Accepted Answer · 2012-04-05 07:05:14Z

0

you can check it by count function too ..

if(count($result) == 10 && $result[9]['b_code'] != '') {
   // your code...

}

answered Apr 5, 2012 at 7:05

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

Comments

aifarfa · Accepted Answer · 2012-04-05 07:06:59Z

0

$last_index = sizeof($result) - 1;

if(!$result[$last_index]['b_code']){
 //...
}

answered Apr 5, 2012 at 7:06

aifarfa

3,9392 gold badges25 silver badges35 bronze badges

Comments

Daan · Accepted Answer · 2012-04-05 07:17:23Z

0

Can't you simply do this?

$result = $this->db->query($query)->result_array();

$result_array = array();

foreach($result as $key=>$value) { 
    $result_array[$key] = $value['b_code'];
}

This should work for any number of results.

answered Apr 5, 2012 at 7:17

Daan

3,34825 silver badges19 bronze badges

Comments

safarov · Accepted Answer · 2012-04-05 07:25:15Z

0

You dont need to assign whole array again to new one.

 $result_array = $this->db->query($query)->result_array();

   if(array_key_exist($result_array, 9) && isset($result_array[9]['b_code'])) {
      return $result_array;
   }

 return false;

edited Apr 5, 2012 at 7:25

answered Apr 5, 2012 at 7:05

safarov

7,7942 gold badges38 silver badges52 bronze badges

2 Comments

safarov Over a year ago

@hakre seems i misunderstand question

hakre Over a year ago

Well the idea is still good to map instead of to copy 10 elements one by one.

Collectives™ on Stack Overflow

PHP, checking values from My-Sql data

5 Answers 5

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related