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? Quote Link to comment 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); ?> Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.