check array is empty doesn't work using cast?

Question

$stmt = $db->prepare("SELECT * FROM task where uId = ?");

$stmt->bind_param('s',$userId);

if($stmt->execute()){
    $user = $stmt->get_result();
    while ($obj = $user->fetch_object()) {
         $task[] = $obj;
    }

    if(count((array)$task)){
        $main[0]->tasks = $task;
    }
}

line $main[0]->tasks = $task; shows an error of Undefined variable: task. In my case there is no task in my record so the execution failed. But I expect it just skip and continue because I already put it within the 'if', which check whether the task object is empty.

how many rows this query supposed to return? if only one - why loops and arrays at all? — Your Common Sense
– Your Common Sense, Commented May 9, 2014 at 5:48
It's already an array. You just need to define it before your while loop. $task = array();. — Rikesh
– Rikesh, Commented May 9, 2014 at 5:48

user3470953 · Accepted Answer · 2014-05-09 05:48:01Z

2

do something like

if($stmt->execute()){
    $task = array();
    $user = $stmt->get_result();
    while ($obj = $user->fetch_object()) {
         $task[] = $obj;
    }

    if(count($task)){ //or if($task){
        $main[0]->tasks = $task;
    }
}

answered May 9, 2014 at 5:48

user3470953

11.4k2 gold badges19 silver badges18 bronze badges

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

1 Comment

user3522457 Over a year ago

so I forgot to init the $task array?

Collectives™ on Stack Overflow

check array is empty doesn't work using cast?

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