Remove line break after each INSERT

Question

I own a textarea in my code, where the user will insert access vouchers separated by ENTER.

My PHP code treats the typed values as follows:

$voucher = explode("\n",$voucher);
      foreach ($voucher as &$varray)
      {
        $gravar = mysqli_query("INSERT INTO `vouchers` (voucher, tempo) VALUES ('$varray','$tempoBD')");
      }

Where: $voucher is the value of the textarea received via $_POST and $tempoBD is the value that the user select converted in format 00:00:00.

The problem is: The voucher field is saving the value of the line + line break (\n)!

What correction to my code need to be done to remove the line break in the voucher field for each record entered in the table?

Thank you!

Answer 1

Use the trim() to remove line breaks.

$voucher = explode("\n",$voucher);
foreach ($voucher as &$varray){
    $gravar = mysqli_query("INSERT INTO `vouchers` (voucher, tempo) VALUES ('".trim($varray)."','$tempoBD')");
}

Answer 2

Use strip_tags next to Trim, strip_tags will remove any html or php code from your file and Trim will remove the spaces from the beginning and the end.

$voucher = explode("\n",$voucher);
foreach ($voucher as &$varray){
    $formata = strip_tags(trim($varray));
    $gravar = mysqli_query("INSERT INTO `vouchers` (voucher, tempo) VALUES ('".$formata."','$tempoBD')");
}