How to push new index and value to php array?

Question

I am fetching data from a table using group by payment method. What happen is in group by the data comes up corresponding to those data only which are in table . But I want all payment types to be shown in result . I am using following query.

 $query = "select  paytype ,sum(totalamount)  from `tbl_payments` group by paytype";

There are 5(cash,credit,paypal..) types of payment . I want all the payment methods with the result , so that if paytype is not find by query result it should be appended like ['credit'] =>[0] , means paytype => amount(which should be 0 at that case).

Please help me on this.

Please show us full code.

Death-is-the-real-truth
– Death-is-the-real-truth

2015-05-14 06:51:29 +00:00
Commented May 14, 2015 at 6:51 — Death-is-the-real-truth
– Death-is-the-real-truth, Commented May 14, 2015 at 6:51
A schema may help aswell

glend
– glend

2015-05-14 07:06:55 +00:00
Commented May 14, 2015 at 7:06 — glend
– glend, Commented May 14, 2015 at 7:06

Lorenz Meyer · Accepted Answer · 2015-05-14 07:08:15Z

1

You didn't tell about the table paytype containing the list of valid payment methods.

To get all the payment methods in the result, you must use a left join. Something like :

select pt.paytype, sum(p.totalamount)
from `tbl_paytypes` pt
left join `tbl_payments` p 
on pt.paytype = p.paytype 
group by pt.paytype

answered May 14, 2015 at 7:08

Lorenz Meyer

20.1k23 gold badges83 silver badges129 bronze badges

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

Comments

Jamsheer Kandoth · Accepted Answer · 2015-05-14 07:11:23Z

0

Get all payment types using a Left Join with the paymettypes tables

answered May 14, 2015 at 7:11

Jamsheer Kandoth

1921 gold badge3 silver badges12 bronze badges

Comments

zafirov · Accepted Answer · 2015-05-14 07:56:06Z

0

Best way is to use entity class, ex.

class PaymentTypes{  private $cash;  private $credit;  private $paypal;  ....

//constructor

//setters and getters }

in constructor you can set a default parameters for the fields if you dont get any values

public function __construct($array){   $someDefaultValue = '';   if(!empty($array['name_of_column_in_databaseTable'])){   $this->$cash
= $array['name_of_column_in_databaseTable'];  }else{   $this->$cash = $someDefaultValue; } ... }

Result from database is like array(array(), array(), ...)

so you can make:

foreach($result as $key=>$value){
 $paymentTypes[] = new PaymentTypes($value);
}

answered May 14, 2015 at 7:56

zafirov

3921 gold badge4 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to push new index and value to php array?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related