PHP Calculating each row with column values and store in a variable

Question

In this example, how to calculate in each row how many NULL values, how many zeros(0) and how many ones(1) and each values store in a variable.

+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
| StdID | day1S1 | day1S2 | day1S3 | day2S1 | day2S2 | day2S3 | day3S1 | day3S2 | day3S3 |
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
|     3 | NULL   |      1 |      0 |      1 |      1 |      0 | NULL   |      1 |      1 |
|     4 | 1      |      1 |      0 |      1 |      0 |      0 | NULL   |      1 |      1 |
+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+

O/p

**StdID = 3**
$null = 2;
$zeros = 2;
$ones = 5;

**StdID = 4**
$null = 1;
$zeros = 3;
$ones = 5;

I dont know how to do this, but I am trying with the following code

$check = isset($day1['day1S1'])  ? "1" : "0"; doesnt work

$values = $day1['day1S1']+$day1['day1S2']+$day1['day1S3'] etc

Please help me to solve this. Thanks

Consider revising your schema

Strawberry
– Strawberry

2019-05-06 17:38:29 +00:00
Commented May 6, 2019 at 17:38 — Strawberry
– Strawberry, Commented May 6, 2019 at 17:38

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

array_walk - Apply a user supplied function to every member of an array

array_count_values - Counts all the values of an array

You can use array_walk,array_count_values function, for example

$arr = [
  'StdID' => [
    '3' => ['NULL',1,0,1,1,0,'NULL',1,1],
    '4' => [1,1,0,1,0,0,'NULL',1,1]
  ]
];
$res=[];
array_walk($arr['StdID'], function($v, $k) use (&$res){
   $res['StdID'][$k] = array_count_values($v);
});
echo '<pre>';
print_r($res);

output

Array
(
  [StdID] => Array
    (
        [3] => Array
            (
                [NULL] => 2
                [1] => 5
                [0] => 2
            )

        [4] => Array
            (
                [1] => 5
                [0] => 3
                [NULL] => 1
            )

    )

)

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 6, 2019 at 17:26

Rakesh Jakhar

6,4082 gold badges13 silver badges20 bronze badges

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

3 Comments

user2594154 Over a year ago

Could you please answer me some more specific?

user2594154 Over a year ago

Thanks Rakesh, code works fine. Only a small doubt, if values 0 (zero) is not in DB, it shows an error 'Undefined offset: 0'. The same way is NULL is not there it shows error. How to solve it, sorry for the disturbance Rakesh

Rakesh Jakhar Over a year ago

@user2594154 the result is displaying based on the array values, if array have 0 you should get the 0 index else not

Collectives™ on Stack Overflow

PHP Calculating each row with column values and store in a variable

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related