Codeigniter function returning an empty query

Question

I have this function on my model, which receives a parameter so I can pre-load some information on the view page, but somehow is coming back empty:

function addTicket($idt)
    {
        //Db Connection
        $DB2 = $this-> load-> database('DB2', TRUE);
        if (!empty($idt)){

            $query = $DB2->query ("
                    Select TROUBLE_ID, ASSIGNED_DATE, CREATOR, PROBLEM_DESCRIPTION, RESOLUTION, RESOLVED_DATE 
                    FROM TABLE1
                    WHERE TROUBLE_ID = ".$idt." 
                    "); 

        if($query){

            return $query->result_array();
        }
        else 
            {

        echo 'No Queries to display';
            }
        }
        else {echo 'No results to display';}
    }

I have an Oracle DB with a ton of entries, but the query keeps coming back empty, Just in case I did an echo 'id:'.$idt.; to check if the ID is being passed. And yes it is. Also Im getting this message: Fatal error: Call to a member function result_array() on a non-object

On my view page i have this code:

foreach($results as $row){ }

And im getting this message now: A PHP Error was encountered Severity: Warning Message: Invalid argument supplied for foreach() Any idea why this is not working?

Marc · Accepted Answer · 2013-06-04 17:48:26Z

2

Is this CodeIgniter? If so a better way to check for results is if($query->num_rows() > 0) { } rather than just if($query) { }

Also if its CodeIgniter make sure you have db_debug set to TRUE in the config/database.php otherwise you won't get to see the database errors.

answered Jun 4, 2013 at 17:48

Marc

5144 silver badges15 bronze badges

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

7 Comments

NinjaCoder Over a year ago

Yes, it is codeigniter 1.7.2, After I changed the db_debug to TRUE, i got this: ` A Database Error Occurred Error Number: Select TROUBLE_ID, ASSIGNED_DATE, CREATOR, PROBLEM_DESCRIPTION, RESOLUTION, RESOLVED_DATE FROM TABLE1 WHERE TROUBLE_ID = ABC000001067442`

Marc Over a year ago

I think stack stripped out some of that can you provide a screenshot? the error doesn't make any sense...

Marc Over a year ago

Oh nevermind. because your trouble_id is a string you need to put single quotes around it.

NinjaCoder Over a year ago

My trouble_id is a varchar2 and im receiving a string ABC00001, that makes sense, I just changed it and it worked, thanks!

NinjaCoder Over a year ago

Nevermind, now is not showing any errors, but is not loading any data

|

exussum · Accepted Answer · 2013-06-04 18:19:24Z

0

For some reason the query is failing

$this->db->_error_message();

should tell you why

$this->output->enable_profiler(TRUE);

Should give you much more information about the query

Update:

    $DB2 = $this-> load-> database('DB2', TRUE);
    if (!empty($idt)){

        $query = $DB2->query ("

change ^^ to vv

    $DB2 = $this-> load-> database('DB2', TRUE);
    if (!empty($idt)){

        $query = $this->DB2->query ("

edited Jun 4, 2013 at 18:19

answered Jun 4, 2013 at 17:52

exussum

18.6k8 gold badges35 silver badges67 bronze badges

1 Comment

exussum Over a year ago

wouldnt it be $this->DB2->query() ?

NinjaCoder · Accepted Answer · 2013-06-05 13:08:23Z

0

Finally I was able to fix this problem when in my query condition i used single quotes before double quotes, like this:

Select TROUBLE_ID, ASSIGNED_DATE, CREATOR, PROBLEM_DESCRIPTION, RESOLUTION, RESOLVED_DATE 
FROM TABLE1
WHERE TROUBLE_ID = '" . $idt . "'

answered Jun 5, 2013 at 13:08

NinjaCoder

391 gold badge2 silver badges9 bronze badges

Collectives™ on Stack Overflow

Codeigniter function returning an empty query

3 Answers 3

7 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related