DJ Unique Posted November 17, 2007 Share Posted November 17, 2007 I have the following varchar text in my MySql database: ARTIST_ALBUM_SINGLE I have this stored in my php script as $cdcode. How to split this into three variables? So I want to split $cdcode into: $cdcodeatist $cdcodealbum $cdcodesingle I don’t want any of the underscores, just the text. Can anyone help? Link to comment https://forums.phpfreaks.com/topic/77719-solved-i-want-to-split-a-variable-into-three/ Share on other sites More sharing options...
Lumio Posted November 17, 2007 Share Posted November 17, 2007 There are many ways to split that into 3 vars. I show it with the easiest: <?php list($cdcodeartist, $cdcodealbum, $cdcodesingle) = explode('_', $fullVar, 3); ?> Link to comment https://forums.phpfreaks.com/topic/77719-solved-i-want-to-split-a-variable-into-three/#findComment-393406 Share on other sites More sharing options...
kratsg Posted November 17, 2007 Share Posted November 17, 2007 $string = "ARTIST_ALBUM_SINGLE"; $string = strtolower($string);//make everything lowercase list($artist,$album,$single) = explode("_",$string); $artist = ucfirst($artist);//capitalizes first letter $album = ucfirst($album);//capitalizes first letter $single = ucfirst($single);//capitalizes first letter The list() function is peculiar if you've never seen it used in context. If you take a string and break it up into an array of 3 elements, the list function could define each element as a single variable. See if the above works. I also added string manipulation functions if you NEED them. If the Artist, Album, and Single are all properly capitalized, you don't need them. Link to comment https://forums.phpfreaks.com/topic/77719-solved-i-want-to-split-a-variable-into-three/#findComment-393408 Share on other sites More sharing options...
DJ Unique Posted November 17, 2007 Author Share Posted November 17, 2007 Fantastic - list($artist,$album,$single) = explode("_",$string); works just how I need it to. The text in my sql db are all capitals, so it was just the above needed ;0) Thanks for the help guys. Link to comment https://forums.phpfreaks.com/topic/77719-solved-i-want-to-split-a-variable-into-three/#findComment-393482 Share on other sites More sharing options...
wsantos Posted November 17, 2007 Share Posted November 17, 2007 Great, don't foget to click "Topic Solved" Link to comment https://forums.phpfreaks.com/topic/77719-solved-i-want-to-split-a-variable-into-three/#findComment-393483 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.