方法一
$val = "[ sql ] [ SQL ] INSERT INTO `frame_order` (`nickname` , `card` , `phone` , `address` , `quota` , `ip`) VALUES ('王**' , '5321281*******15' , '134********' , '江西省********' , '500万' , '127.0.0.1') [ RunTime:0.013832s ]";
$start_str = "INSERT INTO `frame_order`";
$end_str = "[ RunTime:";
//首次出现的位置
$stripos_start = strpos($val, $start_str);
//结束出现的位置
$stripos_end = strpos($val, $end_str);
if($stripos_start && $stripos_end){
//获取结束字符串之前的字符串
$strstr = strstr($val, $end_str, 1);
//获取开始字符串之后的字符串
echo strstr($strstr, $start_str);
}
方法二
$val = "[ sql ] [ SQL ] INSERT INTO `frame_order` (`nickname` , `card` , `phone` , `address` , `quota` , `ip`) VALUES ('王**' , '5321281*******15' , '134********' , '江西省********' , '500万' , '127.0.0.1') [ RunTime:0.013832s ]";
$start_str = "INSERT`";
$end_str = "[ RunTime:";
//首次出现的位置
$stripos_start = strpos($val, $start_str);
//结束出现的位置
$stripos_end = strpos($val, $end_str);
if($stripos_start && $stripos_end){
echo substr($val, $stripos_start, $stripos_end-strlen($start_str)-strlen($end_str)).";\r\n";
}