Qq(); break; case 'ip': $typeSI = "ASC"; $typeSO = "s_ip"; $where = "`ip` LIKE '" . str_replace("_", "", $dataMySQL->real_escape_string($_POST['data'])) . "%'"; Qq(); break; case 'idc': $typeSI = "ASC"; $typeSO = "room"; $where = "`idc` LIKE '" . str_replace("_", "", $dataMySQL->real_escape_string($_POST['data'])) . "%'"; Qq(); break; case 'tel': $typeSI = "ASC"; $typeSO = "room"; $_POST['data'] = str_replace("_", "", $dataMySQL->real_escape_string($_POST['data'])); while (substr($_POST['data'], -1) == "-") { $_POST['data'] = substr($_POST['data'], 0, -1); } $where = "`tel` LIKE '" . $dataMySQL->real_escape_string($_POST['data']) . "%'"; Qq(); break; case 'all': $typeSI = "ASC"; $typeSO = "F"; $where = "`F` LIKE '" . $dataMySQL->real_escape_string($_POST['F']) . "%' \n\t\t\t\t\tAND `I` LIKE '" . $dataMySQL->real_escape_string($_POST['I']) . "%'\n\t\t\t\t\tAND `room` LIKE '" . $dataMySQL->real_escape_string($_POST['room']) . "%'\n\t\t\t\t\tAND `ip` LIKE '" . $dataMySQL->real_escape_string($_POST['ip']) . "%'\n\t\t\t\t\tAND `idc` LIKE '" . $dataMySQL->real_escape_string($_POST['idc']) . "%'"; Qq(); break; }
case 'room': $typeSI = "ASC"; $typeSO = "room"; $where = "`room` LIKE '" . $dataMySQL->real_escape_string($_POST['data']) . "%'"; $content .= Qq(); break; case 'status': $typeSI = "ASC"; $typeSO = "end"; $where = "`status` LIKE '" . $dataMySQL->real_escape_string($_POST['data']) . "%'"; $content .= Qq(); break; case 'ip': $typeSI = "ASC"; $typeSO = "ip"; $where = "`ip` LIKE '" . str_replace("_", "", $dataMySQL->real_escape_string($_POST['data'])) . "%'"; $content .= Qq(); break; case 'all': $typeSI = "ASC"; $typeSO = "room"; $where = "`F` LIKE '" . $dataMySQL->real_escape_string($_POST['F']) . "%' "; $where .= "AND `status` LIKE '" . $dataMySQL->real_escape_string($_POST['status']) . "%'"; $where .= "AND `room` LIKE '" . $dataMySQL->real_escape_string($_POST['room']) . "%'"; $where .= "AND `ip` LIKE '" . $dataMySQL->real_escape_string($_POST['ip']) . "%'"; $content .= Qq(); break; } //print_r($_POST); /*echo count($seldataArray); print_r($seldataArray);*/
case 'F': $typeSI = "ASC"; $typeSO = "F"; $where = "`F` LIKE '" . $dataMySQL->real_escape_string($_POST['data']) . "%'"; $seldataArray = Qq(); break; case 'I': $typeSI = "ASC"; $typeSO = "I"; $where = "`I` LIKE '" . $dataMySQL->real_escape_string($_POST['data']) . "%'"; $seldataArray = Qq(); break; case 'room': $typeSI = "ASC"; $typeSO = "F"; $where = "`room` LIKE '" . $dataMySQL->real_escape_string($_POST['data']) . "%'"; $seldataArray = Qq(); break; case 'idc': $typeSI = "ASC"; $typeSO = "F"; $where = "`idc` LIKE '" . $dataMySQL->real_escape_string($_POST['data']) . "%'"; $seldataArray = Qq(); break; case 'all': $typeSI = "ASC"; $typeSO = "room"; $where = "`F` LIKE '" . $dataMySQL->real_escape_string($_POST['F']) . "%' \n\t\t\t\t\tAND `I` LIKE '" . $dataMySQL->real_escape_string($_POST['I']) . "%'\n\t\t\t\t\tAND `room` LIKE '" . $dataMySQL->real_escape_string($_POST['room']) . "%'\n\t\t\t\t\tAND `idc` LIKE '" . $dataMySQL->real_escape_string($_POST['idc']) . "%'"; $seldataArray = Qq(); break; }