Saving regex expressions to DB

Does it look right if you run it through stripcslashes after getting it from the db?

$data = stripcslashes($data);

I get the following;

Malformed UTF-8 characters, possibly incorrectly encoded"

This should do the job

data = utf8_decode($data);

Im still getting the same error :( ... Should I be doing something on the insert command?

It is weird, I myself passed your encoded string to utf8_decode and it showed expected output. What data type are you using for the regex string column by the way?

Manually encode the string before inserting to database and decode like the following while retrival.

//encode while inserting
Model::create([
	'col' => addslashes($string)
	...
])

//decode while retrieving 
$data = stripslashes($model->col)

That addslashes and stripslashes didn't work, It just gave me the same output that I had in my question

What solution are you exactly looking for? When you insert an expression in database, it encodes the result and you want to decode it while retrieving right?

Im trying to build a catalog of bad expressions used in coding.

Would it work if i base64 encoded it on insert and decode on extraction?

If you dont need to be able to read it in the database directly, you could try base64 encoding it (you can add mutators and accessors to make this process automatic)

//encode while inserting
Model::create([
	'col' => base64_encode($string)
	...
])

//decode while retrieving 
$data = base64_decode($model->col)

I think this might be the best solution.

Thank you @sinnbeck

public function getRegexAttribute($value)
{
    return base64_decode($value);
}

public function setRegexAttribute($value)
{
    $this->attributes['regex'] =  base64_encode($value);
}