正则表达式???(急,急,急)在线等 字符串 CREATE TABLE `aa_2` ( 中TABLE `aa_2` 的正则表达式 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $somecontent = CREATE TABLE `aa_2` (;preg_match_all ("/(???)/", $somecontent, $matches); CREATE TABLE `aa_2` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `desca` varchar(200) NOT NULL, `testint` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;CREATE TABLE `bb_2` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `desca` varchar(200) NOT NULL, `testint` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;把 TABLE 后的 ‘aa_2’,'bb_2' 改为 ‘aa_3’'bb_3' echo preg_replace('#(create\s*table\s*[`]?)(\w+)(\d+)([`]?)#iU', '$1${2}3$4', $sql); 还有个问题 当‘aa’ 改为 ‘aa_1’ 当为‘aa_1’改为‘aa_2’ 以此类推 $sql =<<<docCREATE TABLE `aa_2` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `desca` varchar(200) NOT NULL, `testint` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;CREATE TABLE `bb` ( `id` int(5) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `desca` varchar(200) NOT NULL, `testint` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `id` (`id`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;doc;function replaceSql($m){ unset($m[0]); $m[3] = $m[3] != '' ? ++$m[3] : '_1'; return join($m);}echo preg_replace_callback('#(create\s*table\s*[`]?)([^\d\s`]+)([\d]*)([`]?)#i', 'replaceSql', $sql); 为什么 true 输出 1,可是 false 却什么也不输出呢? 如何做链接的点击量统计? 关于数据按条分别取出显示的问题?一条一条显示出来 wamp5中Apache服务无法启动 PHP 分割特殊字符? 急 大散分!有好的解决方案者,另有大分奉送! 讨论一个算法 oracle 子查询(急——) 取得前一页的url不带参数的地址 一个关于GD library 的问题。 这个功能要如何写? 用了Smarty的页面 CSS样式不显示了 ,这是怎么回事?要怎么样才可以让CSS样式在php文件里也显示出来?
preg_match_all ("/(???)/", $somecontent, $matches);
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`desca` varchar(200) NOT NULL,
`testint` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `bb_2` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`desca` varchar(200) NOT NULL,
`testint` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;把 TABLE 后的 ‘aa_2’,'bb_2' 改为 ‘aa_3’'bb_3'
echo preg_replace('#(create\s*table\s*[`]?)(\w+)(\d+)([`]?)#iU', '$1${2}3$4', $sql);
$sql =<<<doc
CREATE TABLE `aa_2` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`desca` varchar(200) NOT NULL,
`testint` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
CREATE TABLE `bb` (
`id` int(5) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`desca` varchar(200) NOT NULL,
`testint` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
doc;
function replaceSql($m)
{
unset($m[0]);
$m[3] = $m[3] != '' ? ++$m[3] : '_1';
return join($m);
}
echo preg_replace_callback('#(create\s*table\s*[`]?)([^\d\s`]+)([\d]*)([`]?)#i', 'replaceSql', $sql);