$stmt = $conn->prepare("
select `YEAR`, `Groups` , count(*) as Total from clients where YEAR > ? GROUP BY `YEAR` with ROLLUP ") ;
$stmt->bind_param("s", $Date );
$stmt->execute();
$stmt->store_result();
$resultrow = array();
stmt_bind_assoc($stmt, $resultrow);
if ($stmt->num_rows > 0)
{
while($stmt->fetch())
{
print json_encode($resultrow);
}
} else {
print json_encode("Not found");
}
$stmt->close();
function stmt_bind_assoc(&$stmt, &$out)
{
$data = mysqli_stmt_result_metadata($stmt);
$fields = array();
$out = array();
$fields[0]=$stmt;
$count=1;
while ($field = mysqli_fetch_field($data))
{
$fields[$count] = &$out[$field->name];
$count++;
}
call_user_func_array('mysqli_stmt_bind_result', $fields);
}