Echo an error message if query result is empty instead of ERRORS (Codeigniter)

Question

My target is to show an echo "No data" when the query result is empty. What happening currently is that when my query is empty, it shows an error. (Please see the picture below for the error) I provided my codes below and my screenshot. Any help will be appreciated. Thank you

Controller:

public function new1($arenaID=0) {
       
        $data['activeNav'] = "";
        $data['subnav'] = "arenas";
        $this->header($data);
        $this->nav();
        
        $data['k1']=$this->arenas->meron1();
       
        $this->load->view('new', $data);
        $this->footer();
       
    }

Model:

function meron1(){
      
        $query = $this->db->query("SELECT fightID FROM fight_entries where position='meron' ORDER BY fightID DESC LIMIT 1");  
        
            return  $query->row()->fightID+1;
          
        
         
    }

Maroof · Accepted Answer · 2021-02-18 13:15:10Z

2

A better way to do this is just to check the number of rows being returned.

function meron1(){
 $query = $this->db->query("SELECT fightID FROM fight_entries where position='meron' ORDER BY fightID DESC LIMIT 1");
    if($query->num_rows() > 0){
     $query = $query->rows();
     return  $query->fightID+1;        
    }else{
    $message = "No Data";
    return $message;
    }

answered Feb 18, 2021 at 13:15

Maroof

2082 silver badges8 bronze badges

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

1 Comment

Jake G Over a year ago

Thank you so much, worked like a magic. :D

Collectives™ on Stack Overflow

Echo an error message if query result is empty instead of ERRORS (Codeigniter)

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