PHP Explode - Remove first part of string, then last part

Question

I'm creating a simple database restore script, but I ran into a bump in the road.

Database dump files are created with the script as well, and have the following filename format: datestamp-dbname.sql

With the restore script, I need to remove the datestamp, the hyphen and the .sql, to just leave the dbname.

I currently have this, which removes the first part, but I need to remove the .sql as well.

$getfilename = $_GET['filename'];
$dbname = explode("-", $getfilename[2]);

Thanks.

KingCrunch · Accepted Answer · 2011-07-28 18:40:50Z

4

list ($timestamp, $dbname) = explode('-', basename($filename, '.sql'));

basename() (with optional second argument) removes the file extension. The rest is trivial.

Another solution:

$dbname = substr($filename, strpos($filename, '-') + 1, -4);

Just take the string between - (excluding: +1) and 4 characters before the end of the string.

I would prefer the first solution, because it feels a little bit cleaner to me (and even more readable)

answered Jul 28, 2011 at 18:13

KingCrunch

133k22 gold badges158 silver badges174 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

phihag · Accepted Answer · 2011-07-28 18:13:59Z

0

The first element of an array has the index zero, not one. You want:

$tmp = explode('-', $getfilename);
$dbname = $tmp[1];

answered Jul 28, 2011 at 18:13

phihag

289k75 gold badges475 silver badges489 bronze badges

David Nguyen · Accepted Answer · 2011-07-28 18:14:16Z

0

$getfilename = $_GET['filename'];
$dbname = explode("-", $getfilename);
$dbname[1] // this is what you need

answered Jul 28, 2011 at 18:14

David Nguyen

8,5182 gold badges35 silver badges50 bronze badges