php for each loop conditional total

Question

I have a foreach loop, I am trying to get total count value which works fine. But the problem is that, most of the hard_disk3 column rows in database contains value "None", I want php to not count where row value is "None".

Here is the php code, what can I do to achieve this?

<?php
    $type="systype, hard_disk3";
    $typeQuery = $basequery." GROUP BY ".$type;
    // Perform the Query
    $objDbResultByType = $objDatabase->Query($typeQuery);
    $imran9 = array();
    foreach ($objDbResultByType as $row) {

        $result = "{ label: \"".$row['systype']." ".$row['hard_disk3']."\", y: " .$row['total']." },";
        array_push($imran9,$result);
    }
    $lastIndex = count($imran9)-1;
    $lastValue = $imran9[$lastIndex];
    $imran9[$lastIndex] = rtrim($lastValue, ',');
?>

Paul Karam · Accepted Answer · 2017-02-12 21:25:12Z

2

You can achieve this in two ways, first one is already mentioned by Sherif (which is the better way to do that), second one in PHP is really easy. Try this:

<?php
    $type="systype, hard_disk3";
    $typeQuery = $basequery." GROUP BY ".$type;
    // Perform the Query
    $objDbResultByType = $objDatabase->Query($typeQuery);
    $imran9 = array();
    foreach ($objDbResultByType as $row) {
        if ($row['hard_disk3'] == "None") 
        {
            continue;
        }
        $result = "{ label: \"".$row['systype']." ".$row['hard_disk3']."\", y: " .$row['total']." },";
        array_push($imran9,$result);
    }
    $lastIndex = count($imran9)-1;
    $lastValue = $imran9[$lastIndex];
    $imran9[$lastIndex] = rtrim($lastValue, ',');
?>

Or you could try:

if ($row['hard_disk3'] != "None") {
    $result = "{ label: \"".$row['systype']." ".$row['hard_disk3']."\", y: " .$row['total']." },";
    array_push($imran9,$result);
}

edited Feb 12, 2017 at 21:25

answered Feb 12, 2017 at 21:18

Paul Karam

4,2908 gold badges36 silver badges59 bronze badges

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

2 Comments

user2107349 Over a year ago

This works absolutely fine, but there is one problem, if all rows have value "None" it does not return anything, is there a way to get actual value for example total = 0?

Paul Karam Over a year ago

You can use the count() method to get the count of values inside your array, for example in your case you can use $totalValues = count($imran9);

Sherif · Accepted Answer · 2017-02-12 21:15:38Z

1

You should instead just specify that in your SQL query. SELECT COUNT(hard_disk3) FROM table WHERE hard_disk3 != "None" that way your dbms just returns the total row count and you neither need a foreach loop nor do you need PHP to do any real work to get to your result.

answered Feb 12, 2017 at 21:15

Sherif

12k3 gold badges35 silver badges58 bronze badges

3 Comments

user2107349 Over a year ago

Thats another way to achieve this, but I want to avoid this, otherwise I have to write so many long sql queries, I want to do this on php level, is it possible?

Sherif Over a year ago

Of course it's possible, but it begs the question why you would want to avoid something that makes your life easier? It's also unclear why you would have to "write so many long sql queries" as you say. The alternative is that you have to write more PHP code. Not sure why you believe that one is necessarily avoidable and the other isn't.

user2107349 Over a year ago

I appreciate your help, I only paste the fraction of php code here, actually I have one universal sql query that I use with several hundred graphs that I generate with javascript, hence I want to avoid writing a new sql query for each graph, I hope this answers your question. Thank you

Collectives™ on Stack Overflow

php for each loop conditional total

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related