PHP:等同于MySQL的功能SUBSTRING_INDEX吗? [英] PHP: equivalent of MySQL's function SUBSTRING_INDEX ?

问题描述

我喜欢 SUBSTRING_INDEX MySQL中的函数，尤其是因为您可以使用负索引从字符串的右侧开始搜索.

I love the SUBSTRING_INDEX function in MySQL, especially because you can use negative indexes to start searching from the right side of the string.

PHP中是否有与此功能等效的功能? (或者一种简单的方法，只需一点代码)

Is there an equivalent of this function in PHP? (or an easy way to do it with a bit of code)

推荐答案

没有一个库函数可以为您提供相同的功能，但是您可以得到一个单行代码:

There's no single library function that gets you this same functionality, but you can get a one-liner:

$str = "www.mysql.com";
echo implode('.', array_slice(explode('.', $str), 0, 2)); // prints "www.mysql"
echo implode('.', array_slice(explode('.', $str), -2));   // prints "mysql.com"

轻松将其转换为功能:

function substring_index($subject, $delim, $count){
    if($count < 0){
        return implode($delim, array_slice(explode($delim, $subject), $count));
    }else{
        return implode($delim, array_slice(explode($delim, $subject), 0, $count));
    }
}

这篇关于PHP:等同于MySQL的功能SUBSTRING_INDEX吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！