How to return string with multiple words as one

Question

In my MySQL database I have this table which contains multiple artists. They are placed in a field called formated_name and returns strings like for example Lady Gaga, so far so good. What I want to achieve is that it returns ladygaga so I can use it for my url later on. My whole function looks like this:

public function artistname_get($artist_id)  
{ 
    $this->load->database();

    $sql = "SELECT formated_name FROM artists WHERE artist_id = '".$artist_id."'";
    $query = $this->db->query($sql);
    $data = $query->result();

    if($data) {
        $this->response($data, 200);
    } else {
        $this->response(array('error' => 'Couldn\'t find any artist with that name!'), 404);
    }
}

So how can I achieve this?

you want to remove space and convert strings to lowercase, right? — dikesh, Apr 04 '14 at 10:20
Yes, that was originally the title of my question, but got edited!? Whats the method called? preg_replace? — SHT, Apr 04 '14 at 10:22
strtolower(implode("", explode(" ", $data))) - but urlencode is more appropiate for you later! — Misiur, Apr 04 '14 at 10:23
To use it in a url: make it into a slug. here's how: http://stackoverflow.com/questions/2955251/php-function-to-make-slug-url-string — DoXicK, Apr 04 '14 at 10:32

score 1 · Answer 1 · edited Jul 07 '15 at 07:20

1

Try out this simple way.

To remove spaces in string.

By using PHP

$string = 'Lady Ga ga';

$value=str_replace(' ','',$string);

echo strtolower($value);

By using MySQL

$sql = "SELECT REPLACE( formated_name, " ", "" ) FROM artists WHERE artist_id = '".$artist_id."'";

edited Jul 07 '15 at 07:20

Shahzad Barkati

2,532
6
25
33

answered Jul 07 '15 at 06:17

Prashant G Patil

927
1
8
22

score 0 · Answer 2 · answered Apr 04 '14 at 10:23

Mysql offers string function for this as well if you do not want to do it with php.

ToLower function:

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_lower

Replace to replace spaces:

http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace

But you should additionally use something for url_encode and url_decode within php. Otherwise you may experiance problems with artists like "A & B"

score 0 · Answer 3 · answered Apr 04 '14 at 10:24

0

Use

str_replace() and `strtolower()`

to remove space and to convert string to lowercase.

answered Apr 04 '14 at 10:24

dikesh

2,977
2
16
26

score 0 · Answer 4 · answered Apr 04 '14 at 10:24

0

PHP version:

$string = strtolower(str_replace(' ', '', $string));

answered Apr 04 '14 at 10:24

sunshinejr

4,834
2
22
32

score 0 · Answer 5 · answered Apr 04 '14 at 10:24

0

$artist_url = strtolower(str_replace(' ', '', $artist_formatted_name));

answered Apr 04 '14 at 10:24

Oleg

67
2

score 0 · Answer 6 · answered Apr 04 '14 at 10:25

0

$string = strtolower(str_replace(' ', '', $string));

answered Apr 04 '14 at 10:25

Davide Bellone

89
2
10

score 0 · Answer 7 · answered Apr 04 '14 at 10:26

0

Try this,

SELECT LOWER(REPLACE(formated_name, ' ', '')) AS formated_name

You have to do is Just use mysql functions LOWER and REPLACE together to get rid of space and capital letters

answered Apr 04 '14 at 10:26

Manoj Solanki

1
3

score 0 · Answer 8 · answered Apr 04 '14 at 10:27

0

Try Something like this.....

<?php 
$string = 'Lady Gaga';
$value=str_replace(' ','',$string);
echo strtolower($value);

?>

answered Apr 04 '14 at 10:27

ssss

76
8

score 0 · Answer 9 · answered Apr 04 '14 at 10:27

If you want to put it in URL you should clear also from special characters etc.

Use this function to convert string into alias.

function toAlias ($string) {
    return strtolower (preg_replace('/[^A-Za-z0-9\-]/', '', str_replace(' ', '-', $string)));
}

How to return string with multiple words as one

9 Answers9