PHP Qq示例

示例#1

文件： search.php 项目： proea/IPManager.pro

        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;
}

示例#2

文件： search.php 项目： proea/IPManager.pro

    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);*/

示例#3

文件： search.cosmos.php 项目： proea/IPManager.pro

    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;
}