public function get_by_id($item_number) { $pay = null; //ARRAY OBJECT PASS GARNA $pay_list = array(); //DATABASE CONNECTION $this->db->connect(); //SELECT BY ID $sql = "SELECT * FROM donations WHERE item_number=?"; //PREPARE $stmt = $this->db->initialize($sql); //BIND $stmt->bind_param("i", $item_number); //EXECUTE $stmt->execute(); //BIND RESULT $stmt->bind_result($pay_id, $item_name, $payment_amount, $txn_id, $payer_email, $item_number); while ($stmt->fetch()) { //instantiate object $paypal = new Paypal(); $paypal->set_pay_id($pay_id); $paypal->set_item_name($item_name); $paypal->set_payment_amount($payment_amount); $paypal->set_txn_id($txn_id); $paypal->set_payer_email($payer_email); $paypal->set_item_number($item_number); array_push($pay_list, $paypal); } //CLOSE CONNECTION $this->db->close(); return $pay_list; }