how to remove indexes form an array in php?

Question

I am looking to except single element from array. My array is:

Array
(
    [0] => Array
        (
            [0] => Array
                (
                    [COUNT(ID)] => 0
                )
        )
)

I have already use PHP functions basename and array_shift, but they didn't give me proper value. I want only single string COUNT(ID) value.

Here is my function using in cakephp model:

$res = $this->query("select COUNT(ID) from users where Username = '".$Username['Username']."'");
if ($res[0][0]['COUNT(ID)'] >= 1)
{
    return false; 
}
else
{
    return true;
}

I don't need $res[0][0], I need only COUNT[ID]. Is there any easy way to find only COUNT[ID].

Why are you creating a manual query in Cake? It's built to return data like that... — scrowler
– scrowler, Commented Jul 14, 2014 at 10:32
Have you tried any of the solutions given below?? There isn't any reply from you there!! — Shaunak Shukla
– Shaunak Shukla, Commented Jul 14, 2014 at 11:35
@centiva-madhavi This is not how it is done in CakePHP! Use the answer from Shaunak Shukla or remove the cakephp tag (as this is then just PHP/MYSQL). — mark
– mark, Commented Jul 14, 2014 at 12:14

Shaunak Shukla · Accepted Answer · 2014-07-14 11:36:57Z

6

If you are using CakePHP, it's good to use model and inbuilt functions to get answer what you want...

$this->loadModel('User');    //If you are in controller
$total = $this->User->find('count', array(
    'conditions' => array('Username' => $Username['Username'])
));

You'll get answer in single variable..!!

edited Jul 14, 2014 at 11:36

answered Jul 14, 2014 at 10:44

Shaunak Shukla

2,3472 gold badges19 silver badges30 bronze badges

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

Comments

Community · Accepted Answer · 2017-03-20 10:29:34Z

0

Your output is produced by code like this

$data = array(
    array(
        array(
            'COUNT(ID)' => 0
        )
    )
);

You can access its value by calling directly

$data[0][0]['COUNT(ID)']

This could be wrong problem you are solving, as it seems like database query result that should not look like that and could be done with more ease. You should show your original function/problem, that this script is part of.

edited Mar 20, 2017 at 10:29

CommunityBot

11 silver badge

answered Jul 14, 2014 at 10:20

Deele

3,6792 gold badges35 silver badges52 bronze badges

Comments

Michaël van de Weerd · Accepted Answer · 2014-07-14 10:21:54Z

0

Let's say you array's name is $myArray, than you can assign the value of $myArray[0][0]['COUNT(ID)'] to $value in the way you usually assign a value: $value = $myArray[0][0]['COUNT(ID)'];.

If you want to delete an index from an array, use unset() like this: unset($myArray[0][0]['COUNT(ID)']). I hope this answers your question.

answered Jul 14, 2014 at 10:21

Michaël van de Weerd

7981 gold badge8 silver badges16 bronze badges

Comments

wIRELESS · Accepted Answer · 2014-07-14 10:22:09Z

0

If you know the exact count of nesting in array you can just access it with indexes

$array[0][0]['COUNT(ID)']

If no, you might want to use the function which will recursively find you the first nested element that is not an array

function getStringFromArray($array) {
    if (is_array($array)) {
        foreach ($array as $key => $value) {
            if (is_array($value)) {
                return getStringFromArray($value);
            } else {
                return $value;
            }
        }
    } else {
        throw new Exception("Not an array given");
    }
}

answered Jul 14, 2014 at 10:22

wIRELESS

1963 silver badges3 bronze badges

Comments

Rajeev Ranjan · Accepted Answer · 2014-07-14 10:33:01Z

0

If you are sure that array structure will remain same then this could be useful :-

function array_values_recursive($ary)
 {
   $lst = array();
    foreach( array_keys($ary) as $k ){
      $v = $ary[$k];
      if (is_scalar($v)) {
         $lst[] = $v;
      } elseif (is_array($v)) {
     $lst = array_merge( $lst,
        array_values_recursive($v)
     );
   }
 }
 return $lst;
}

 $arr=array(array(array('COUNT(ID)'=>5)));
 $res=array_values_recursive($arr);
 echo '<pre>';print_r($res);

output :-

Array
 (
  [0] => 5
 )

answered Jul 14, 2014 at 10:33

Rajeev Ranjan

4,1523 gold badges30 silver badges42 bronze badges

Comments

techguy0911 · Accepted Answer · 2014-07-14 10:39:26Z

0

You can probably fetch it by associative array to reduce dimension but you can remove index. May be you can use foreach to automatically use indexs.

answered Jul 14, 2014 at 10:39

techguy0911

1

Comments

shadyyx · Accepted Answer · 2014-07-14 12:56:14Z

0

Try this code:

public $uses = array('User');
$count = $this->User->find('count', array(
    'conditions' => array('Username' => $Username['Username'])
        ));
if ($count >= 1) {
    return false;
} else {
    return true;
}

edited Jul 14, 2014 at 12:56

shadyyx

16.1k7 gold badges62 silver badges98 bronze badges

answered Jul 14, 2014 at 12:09

Indrajeet Singh

2,99927 silver badges28 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:54:02Z

0

You can use following technique for your solution. i did not get you what you want to do with your array but you can try below solution

$arr = Set::extract("/0/COUNT(ID)",$data);

where $data is your input array.

you will get following output

Array
(
  [0] => 5
)

you can refer below link

Remove array key from array in cakephp

edited May 23, 2017 at 11:54

CommunityBot

11 silver badge

answered Jul 15, 2014 at 9:53

Dhaval Rajani

3111 gold badge3 silver badges15 bronze badges

Collectives™ on Stack Overflow

how to remove indexes form an array in php?

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related