Filling a result-string with variables?

Something like this

DB::table('your_table')->selectRaw("replace(your_column, '$username', '?')", [$username])->get();

Thank you. Can you proide an example how i can replace the variables within the string after i got it from the database? I'm kind of on the edge right now.

If you do this

$user = 'Tray2';

echo "Hello my name is $user"

It will print

Hello my name is Tray2

However comming from the database you need to tell the interpriter to run it as php. That can be done by using eval. However that is really really dangerous.

https://stackoverflow.com/questions/41406/how-do-i-execute-php-that-is-stored-in-a-mysql-database

I would suggest you use sprintf, something like this

$user = 'Tray2';

echo sprintf('Hello my name is %s', $user);

https://www.w3schools.com/php/func_string_sprintf.asp

I think I give you an example. If in your database you have stored "This is something from $username" then part of string $username will be replaced with data stored in variable $username.

The string i get from the database is "This is my $string" - and i want to change $string within the string to a value i got earlier like $string ="Test". So the result should be "This is my Test". But defining the $string doesnt give me the wanted "replacement" within the string.

Here replace Model with your model what you use and field wih your column in database.

$model = Model::first();

$string = "Test";

$model->field = str_replace("$string", $string , $model->field);

I have done it like this.

  $results = TextToSpeech::first();
        $title ="Das ist mein Testtitel";
        $newString = str_replace("$title", $title , $results->phrase);
        return $newString;

The result from the database is

This is a testphrase. We are now playing $title

But after the str_replace the result is still:

This is a testphrase. We are now playing $title

I dont know where the problem is :(

I have not replaced the text "$title" with "{{title}}" and did:

 $newString = str_replace("{{title}}", $title , $results->phrase);

now it works. seems like the $-char did some messups.

@kangaroomusique It was problem with double quotes

$results = TextToSpeech::first();

$title = "Das ist mein Testtitel";

$newString = str_replace('$title', $title , $results->phrase);

return $newString;

But if you can it will be better if you don't save text with normal variable inside, use something different how you mentioned in the last post.