Hi All,
I have another problem ... just as things were going well :^(
I have a web site that allows a free text input which gets sanitised and subsequently added to a MySQL database. The sanitisation process is by :
$problem_description = mysqli_real_escape_string($conn, $_POST['problem_description']);
It is then inserted into the database with:
$insert_data = $conn->prepare("INSERT INTO raw_data (Contact_Name, Problem_Description) VALUES (?, ?)"); $insert_data->bind_param("ss", $contact, $description); $contact = $contact_name; $description = $problem_description;
When it is retrieved if the user has entered line breaks by pressing the enter key it gives:
text block 1\n\rtext block 2
instead of
text block 1
text block 2
The retrieval process is:
<?php $data = "SELECT * FROM raw_data WHERE id='$ticket_number'"; $result = mysqli_query($conn, $data); $value = mysqli_fetch_array($result); ?> <textarea id='edit_problem_description' name='problem_description' required readonly="readonly"><?php echo $value['Problem_Description']?></textarea>
How do I make the text show as required please?
I have scoured the internet and nothing I try seems to help. With this in mind I have doubled the usual reward - I have 2 virtual nights out on the town to offer, but they cant be taken until the world is free of this nasty COVID-19 virus.
See more