如果mysql在查询中没有返回任何内容，如何重定向或强制页面

Question

working on a small project and having a small problem. i am querying mysql, i am able to get the array and everything works well but i am adding a additional condition if returns 0 or id does not match the query then redirect.

This is what i have so far.

$q = "SELECT TEST.*,
             EMPLOYEE.EMP_ID                     
        FROM TEST
        LEFT JOIN EMPLOYEE ON TEST.EMP_ID = EMPLOYEE.EMP_ID 
        WHERE ITEM_ID=".$db->qstr($item_id);

if(!$item_id = $db->execute($q)){
    force_page('system', 'Nothing found');
    exit;
} else {
    $view = $item_id->GetArray();
}

return $view;
}

so the above returns the array, query grabs $item_id from the url so it could be anything. i would like to check if that id exists if not then force the page as shown in the above. any suggestion on what i am doing wrong?

Answer 1

I don't think there is any function like force_page(); in php You need to redirect like header("Location: Your_url");

And If you have function force_page(); please post code of that.