fatal error:call to a member function result_array() on a non-object

Question

Iam trying get some data from database and with that data iam sending one email to the user in the same controller only.but here iam getting one fatal error: My controller:call to a member function result_array() on a non-object, How to solve this ...

$current_order = $this->Eventsmodel->get_user_events_order($id,$type,$txnid,$payuId);

             foreach($current_order->result_array() AS $row) {
                 $order_mob = $row['mobile'];
                 $order_venue = $row['venue_name'];
                 $order_evt_date = $row['event_date'];

                 $order_adlts = $row['adults'];


             }

            $fullMessage = '<html><body>';
            $fullMessage .= '<img src="http://domain.com/images/black.png" alt="company name" />';
            $fullMessage .= '<table rules="all" style="border-color: #666;" cellpadding="10">';


            $fullMessage .= "<tr><td><strong>Mobile Number:</strong> </td><td>" . $order_mob . "</td></tr>";



            $fullMessage .= "<tr><td><strong>Event Venue:</strong> </td><td>" . $order_venue . "</td></tr>";

            $fullMessage .= "<tr><td><strong>Event Date:</strong> </td><td>" . $order_evt_date . "</td></tr>";

            $fullMessage .= "<tr><td><strong>Ticket Type:</strong> </td><td>" . $order_tkt_type . "</td></tr>";


            $fullMessage .= "</table>";
            $fullMessage .= "</body></html>";

                     $config = Array(
                    'protocol'  => 'smtp',
                    'smtp_host' => 'relay-hosting.secureserver.net',
                    'smtp_port' => '25',
                    'smtp_user' => '[email protected]',
                    'smtp_pass' => 'passwd',
                    'mailtype'  => 'html',
                    'starttls'  => true,
                    'newline'   => "\r\n"
                );

            $this->load->library('email', $config);
            $this->email->from('[email protected]', 'Company Name');
            $this->email->to($_POST['email']);
            $this->email->subject('Sample Emailer');
            $this->email->message($fullMessage);
            if($this->email->send()){
                //Success email Sent
             $this->email->print_debugger();

             }else{
                //Email Failed To Send
                $this->email->print_debugger();

             }

And My Model:

function get_user_events_order($id,$type,$txnid)

    {
       $query = $this->db->query('SELECT o.type,e.name,e.event_address,o.modified, o.event_date, o.show_time, o.payment_status,o.adults,o.childrens,o.totalamount,u.name AS uname,u.email,u.mobile,o.payment_id,o.ticket_type,o.transaction_id FROM orders AS o, events As e, users AS u WHERE o.event_play_nightlife_id=e.id AND u.id=o.user_id AND o.user_id='. $this->session->userdata('user_id').' AND o.type="'.$type.'" AND o.event_play_nightlife_id='.$id.' AND o.payment_id="'.$txnid.'"');

        return $query->result();

    }

Abdulla Nilam · Accepted Answer · 2015-07-13 07:46:06Z

1

Check now

In model

function get_user_events_order($id,$type,$txnid)    
{
    $query = $this->db->query('SELECT o.type,e.name,e.event_address,o.modified, o.event_date, o.show_time, o.payment_status,o.adults,o.childrens,o.totalamount,u.name AS uname,u.email,u.mobile,o.payment_id,o.ticket_type,o.transaction_id FROM orders AS o, events As e, users AS u WHERE o.event_play_nightlife_id=e.id AND u.id=o.user_id AND o.user_id='. $this->session->userdata('user_id').' AND o.type="'.$type.'" AND o.event_play_nightlife_id='.$id.' AND o.payment_id="'.$txnid.'"');
    $result =$query->result_array();
    return $result;    
}

In Controller

$current_order = $this->Eventsmodel->get_user_events_order($id,$type,$txnid,$payuId);

    foreach($current_order AS $row)
    {
        $order_mob = $row['mobile'];
        $order_venue = $row['venue_name'];
        $order_evt_date = $row['event_date'];

        $order_adlts = $row['adults'];
    }

answered Jul 13, 2015 at 7:46

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

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

1 Comment

user3232285 Over a year ago

Getting the same Error:Fatal error: Call to a member function result_array() on a non-object in

Collectives™ on Stack Overflow

fatal error:call to a member function result_array() on a non-object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related