PHP正则表达式获取SQL语句中的表名

<?php
function sqltype($sql){
        $expression=array(
            'update'=>'/UPDATE[\s`]+?(\w+[\.]?\w+)[\s`]+?/is',
            'insert'=>'/INSERT[\s]{1,}INTO[\s]{1,}[`]?([A-Za-z0-9\_]{1,}[\.]?([A-Za-z0-9\_]{1,})?)[`]?/is',
            'delete'=>'/DELETE\s+?FROM[\s`]+?(\w+[\.]?\w+)[\s`]+?/is',
            'select'=>'/((SELECT.+?FROM)|(LEFT\\s+JOIN|JOIN|LEFT))[\\s`]+?(\\w+[\.]?\\w+)[\\s`]+?/is'
        );
        foreach($expression as $type=>$e){
            $ret = preg_match_all($e, $sql, $matches);
            var_dump($matches);
            if(is_int($ret) and $ret){
                if ($type == "insert") {
                    return array($type=>array_unique($matches[1]));
                }
                return array($type=>array_unique(array_pop($matches)));
            }
        }
        return array();
    }
$sql = "INSERT INTO showapp_rooms.room_statuslog(`userid`,`roomid`,`from`,`old_status`,`new_status`,`change_time`,`info`) VALUES('632919318','1142_632919318',3,1,1,'2017-09-06 10:56:41','request:http://biz111.live.xunlei.com/caller?c=room&a=setstatus&roomid=1142_632919318&status=1  android 2.13.96.0 m1 metal')";
$sqlInfo = sqltype($sql);
var_dump(implode(current($sqlInfo)));

https://www.awaimai.com/2067.html

PHP正则表达式获取SQL语句中的表名

微信号：腾讯云折扣返现

技术讨论QQ群： 863102326

作者: catherine

搜索

标签