Questions & Answers

I have stored \r\n in a table (for 'crlf' and 'newline') and it worked (I can see that visually in HeidiSQL), BUT when I do this:

$config = [];
foreach ($this->db->query("SELECT name, value from _email where name = 'crlf' OR name = 'newline'")->result() as $t) {

  $config[$t->name] = $t->value; 

  if ($t->value === '\r\n'){
    $config["what1"] = $t->value;
  }
  if ($t->value === '\\r\\n'){
    $config["what2"] = $t->value;
  }
}

file_put_contents("email.txt", implode("|", $config));
file_put_contents("email.json", json_encode($config));

email.txt is showing:

\r\n|\r\n|\r\n|\r\n

email.json is showing:

{
  "crlf": "\\r\\n",
  "what1": "\\r\\n",
  "what2": "\\r\\n",
  "newline": "\\r\\n"
}

On this server MySQL is version 5.7.41 and PHP is version 7.4

How this is possible?

How to accurately determine what is stored in those variables, because I think that $t->value is changed by PHP itself?

Because variables are somehow changed and I don't know their exact values. The script to send emails is not working (I am to comply with RFC 822). But if I add this just under the code:

$config["crlf"] = "\r\n";
$config["newline"] = "\r\n";

The script is sending emails normally.

SOLUTION: I've found a working solution by using stripcslashes function:

$config = [];
foreach ($this->db->query("SELECT name, value from _email where name = 'crlf' OR name = 'newline'")->result() as $t) {

  $config[$t->name] = stripcslashes($t->value); 

}