$rs3 = mysql_fetch_array($query3); if ($rs3) { $countF = $rs3[0]; } else { $countF = 0; } $sex = "[{value:'" . $countM . "', name:'male'},{value:'" . $countF . "',name:'female'},]"; $json_sex = json_encode($sex); echo $json_sex; } else { if ($flag == "f5") { $month = array(); $countMonth = array(); $sum = array(); $sql = "select insertmonth,count(insertmonth) from action"; if (setInsertTime($startTime, $endTime)) { $where = getInsertTime($where, $startTime, $endTime); } $where .= " group by insertmonth "; $sql .= $where; $query = mysql_query($sql); while ($rs = mysql_fetch_array($query)) { if ($rs[0] != null) { $month[] = $rs[0]; $countMonth[] = $rs[1]; } } $sum[0] = $month; $sum[1] = $countMonth; $json_sum = json_encode($sum); print_r($json_sum);
if (hasCondition($sex, $state, $country)) { $where = setCondition($where, $sex, $state, $country); } if (hasTime($startMonth, $endMonth, $beforeMonth, $afterMonth, $onMonth)) { $where = setconfirmedTime($where, $startMonth, $endMonth, $beforeMonth, $afterMonth, $onMonth); } $where .= " GROUP BY left(confirmtime,7)"; } else { if ($question == "firsttimeuser") { $sql = "select insertmonth, COUNT(insertmonth) from action "; $where .= " and isfirst = 'T' "; if (hasCondition($sex, $state, $country)) { $where = setFirstCondition($where, $sex, $state, $country); } if (hasTime($startMonth, $endMonth, $beforeMonth, $afterMonth, $onMonth)) { $where = setInsertTime($where, $startMonth, $endMonth, $beforeMonth, $afterMonth, $onMonth); } if (hasUser($user)) { $where = setUser($where, $user); } $where .= " GROUP BY insertmonth"; } } } } else { echo "something wrong happens"; exit; } $sql = $sql . $where; //echo $sql; $result = creatTrend($sql);