PHP 正则判断常用示例

$mobile = '18409060101';
$g = '/^1[34578]\d{9}$/';
if ( !preg_match($g, $mobile) ) {
     echo '非手机号';
}

// "^"符号表示必须是1开头;
// "[ ]"的意思是第二个数字必须是中括号中一个数字;
// 而 \d 则表示0-9任意数字,后跟{9}表示长度是9个数字;
// 后面的$表示结尾;
// 开始和结尾的 / 是正则表达式必须放在这个中间, 有的后面可能还跟模式 

$g = '/^1[34578]{1}\d{9}$/';
$g = '/^1[34578][0-9]{9}$/';
$g = '/^(13[0-9]|15[0|3|6|7|8|9]|18[8|9])\d{8}$/';
$g = '/^(1(([35][0-9])|(47)|[8][01236789]))\d{8}$/';
$g = '/^13[\d]{9}$|^14[5,7]{1}\d{8}$|^15[^4]{1}\d{8}$|^17[0,6,7,8]{1}\d{8}$|^18[\d]{9}$/'; 

$g = '/^0\d{2,3}(\-)?\d{7,8}$/'; 

$email = 'abc-123@123.com.cn';
$pattern = '/^([0-9A-Za-z\\-_\\.]+)@([0-9a-z]+\\.[a-z]{2,3}(\\.[a-z]{2})?)$/i';
if ( !preg_match($pattern, $email) ) {
     echo '非邮箱';
} 

// \ 将下一个字符标记为或特殊字符、或原义字符、或向后引用、或八进制转义符。
// 例如， 'n' 匹配字符 'n'。'\n' 匹配换行符。序列 '\\' 匹配 "\"，而 '\(' 则匹配 "("。
// + 匹配一个或者多个，等价于 {1,}
// ? 匹配前面的子表达式零次或一次，等价于 {0,1} ，或指明一个非贪婪限定符。要匹配 ? 字符，请使用 \?
// * 匹配前面的子表达式零次或多次，等价于{0,} 。要匹配 * 字符，请使用 \*
// . 匹配除换行符 \n 之外的任何单字符。要匹配 . ，请使用 \.
// /内容/i 构成一个不区分大小写的正则表达式 

$pattern = '/^[a-z]([a-z0-9]*[-_\.]?[a-z0-9]+)*@([a-z0-9]*[-_]?[a-z0-9]+)+[\.][a-z]{2,3}([\.][a-z]{2})?$/i';
$pattern = '/^[a-z]([a-z0-9]*[-_]?[a-z0-9]+)*@([a-z0-9]*[-_]?[a-z0-9]+)+[\.][a-z]{2,3}([\.][a-z]{2})?$/i';
$pattern = '/^\w[-\w.+]*@([A-Za-z0-9][-A-Za-z0-9]+\.)+[A-Za-z]{2,14}$/';
$pattern = '/^([a-z0-9]*[-_\.]?[a-z0-9]+)*@([a-z0-9]*[-_]?[a-z0-9]+)+[\.][a-z]{2,3}([\.][a-z]{2})?$/i';
$pattern = '/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,})$/i'; 

$userinfo = "Name: <b>PHP</b> <br> Title: <b>Programming Language</b>";
preg_match_all ("/<b>(.*)<\/b>/U", $userinfo, $pat_array);
print_r($pat_array[0]);

/**
 * 数据库转为Excel
 * @param string $filePath
 * @return bool
 * @throws \PhpOffice\PhpSpreadsheet\Exception
 * @throws \PhpOffice\PhpSpreadsheet\Writer\Exception
 */
public function actionTableToExcel($filePath = 'vipone.sql')
{
    if (!file_exists($filePath)) {
        echo  "file is not exist: " .$filePath ."\r\n";
        return true;
    }

    $fileInfo = file_get_contents($filePath);
    preg_match_all("/CREATE TABLE[\d\D]*;[\r]?\n/U", $fileInfo, $matches);

    if (count($matches[0]) == 0) {
        echo "未匹配到数据\r\n";
        return true;
    }

    // 准备excel数据
    $excel_data = [];

    foreach ($matches[0] as $item)
    {
        // 表数据
        $table_data = [];
        // 表头数据
        $table_name_data = [];
        // 表列数据
        $table_column_data[] = ["字段", "数据类型与长度", "字段备注"];

        $explodedArray = explode("\n  ", $item);

        foreach ($explodedArray AS $key => $value)
        {
            if ($key == 0 || $key == (count($explodedArray) -1)) {
                /*分析表名及注释*/
                // 分析表名
                if ($key == 0) {
                    preg_match("/`.+`/", $value, $table_name);
                    $table_name = str_replace("`", "", $table_name[0]);

                    array_push($table_name_data, $table_name);
                }

                // 分析表名注释
                if ($key == count($explodedArray) -1) {
                    preg_match("/COMMENT='.*';/", $value, $table_name_comment);
                    if (!empty($table_name_comment[0])) {
                        $table_name_comment = str_replace("COMMENT='", "", $table_name_comment[0]);
                        $table_name_comment = str_replace("';", "", $table_name_comment);
                    } else {
                        $table_name_comment = "";
                    }

                    array_push($table_name_data, $table_name_comment);
                }
            } else {
                /*分析字段名及注释*/
                preg_match("/^`.+`/", $value, $column_name);
                if (!isset($column_name[0])) {
                    continue;
                }

                $column_name = str_replace("`", "", $column_name[0]);

                preg_match("/` [\S]+/", $value, $column_type);
                $column_type = str_replace("` ", "", $column_type[0]);

                preg_match("/COMMENT '.+'/", $value, $column_comment);
                if (!empty($column_comment[0])) {
                    $column_comment = str_replace("COMMENT '", "", $column_comment[0]);
                    $column_comment = str_replace("'", "", $column_comment);
                } else {
                    $column_comment = "";
                }

                $table_column_data[] = [$column_name, $column_type, $column_comment];
            }
        }

        array_push($table_data, ["表名", "表名备注"], $table_name_data);
        $table_data = array_merge($table_data, $table_column_data);
        $excel_data = array_merge($excel_data, $table_data, [[]], [[]]);

        unset($table_data, $table_name_data, $table_column_data);
    }

    /*导出为excel*/
    $data = $excel_data;
    $title = explode('.',$filePath)[0];

    $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
    $spreadsheet->getProperties()
        ->setCreator("vip")
        ->setLastModifiedBy("vip")
        ->setTitle( $title )
        ->setSubject( $title )
        ->setDescription( "" )
        ->setKeywords( "" )
        ->setCategory( "" );

    $sheet = $spreadsheet->getActiveSheet();
    $sheet->fromArray($data, null, 'A1');

    // 设置背景色
    foreach ($sheet->getRowIterator() as $row)
    {
        $cellIterator = $row->getCellIterator();
        foreach ($cellIterator as $cell) {
            $txt = $cell->getValue();
            if ($txt == "表名" || $txt == "表名备注" || $txt == "字段" || $txt == "数据类型与长度" || $txt == "字段备注") {
                $cell->getStyle()->getFont()->setBold(true);
                $cell->getStyle()->getFill()->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)->getStartColor()->setARGB('dce6f1');
//                    $sheet->getRowDimension($cell->getRow())->setRowHeight(20);
            }
        }
    }

    // 设置列宽
    $toCol = $sheet->getColumnDimension($sheet->getHighestColumn())->getColumnIndex();
    for($i = 'A'; $i <= $toCol; $i++) {
        $sheet->getColumnDimension($i)->setAutoSize(true);
    }
    $sheet->calculateColumnWidths();

    // 保存
    $fileName = "./" .$title .".xlsx";
    if (file_exists($fileName))
    {
        $fileName = "./" .$title .time() .random_int(100, 999) .".xlsx";
    }
    $writer = new \PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
    $writer->save( $fileName );

//        $fileName = "./" .$title .".pdf";
//        if (file_exists($fileName))
//        {
//            $fileName = "./" .$title .time() .random_int(100, 999) .".pdf";
//        }
//        $writer = new \PhpOffice\PhpSpreadsheet\Writer\Pdf\Tcpdf($spreadsheet);
//        $writer->save( $fileName );

    // 清除内存
    $spreadsheet->disconnectWorksheets();
    unset($spreadsheet);

    echo "成功：" .$fileName ."\r\n";
    return true;
}