Format string in PHP

Question

I have below code, which gets me file path as voicetube/record/1985150721112615 but I need only 1985150721112615 exploding first two folders,please help me on this

$sql = "SELECT filePath FROM user_recordings ORDER BY recordDate ASC";
$result = mysql_query($sql);
$var = array();
while ($row = mysql_fetch_array($result)) 
{
    $var[] = $row['filePath'];
}

You can just split the string everytime there's a `/` and the question:"How to do that?", is definitely a duplicate — Loko, Jul 21 '15 at 11:43

score 3 · Answer 1 · answered Jul 21 '15 at 11:44

3

You are looking for basename();

   $var[] = basename($row['filePath']);

answered Jul 21 '15 at 11:44

donald123

5,638
3
26
23

score 0 · Answer 2 · answered Jul 21 '15 at 13:02

0

You can use explode function, and grab it's last index.

while ($row = mysql_fetch_array($result)) 
{
    $arr = explode('/', $row['filePath']);
    $var[] = $arr[count($arr) -1];
}

answered Jul 21 '15 at 13:02

kamal pal

4,187
5
25
40

Thank you its working fine now – Sagar H Jul 21 '15 at 13:06

Format string in PHP

2 Answers2