I try many type of code.
How to store user new line input in SQL Database(PHP mysql admin)
i use this code .
<?php
include 'tcfdatabase.php';
$table=$_GET['table'];
$id=$_GET['id'];
$name=$_GET['name'];
$icon=$_GET['icon'];
$post=$_GET['post'];
$date=$_GET['date'];
$category=$_GET['category'];
$userid=$_GET['userid'];
$sql1 = "INSERT INTO $table (ID, Name, Icon, Post, Date, Category,UserID)
VALUES ('$id', '$name', '$icon', '$post', '$date', '$category', '$userid')";
if ($conn->query($sql1) === TRUE) {
echo "true";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>
Rogerio_Rios
(Professional Support)
August 4, 2021, 5:08pm
#2
1- Did you make this code?
2- What have you tried and failed according to your PHP script?
3- Have you already created Kodular blocks to be used with your PHP script?
data insert success but user enter data with new line . new line converte to normal text
Rogerio_Rios
(Professional Support)
August 4, 2021, 5:24pm
#4
What ? I did not understand.
I try to say that
User input :-
to day is a
good day.
store input :-
to day is a good day.
i want insert data like this :-
to day is a
good day.
Rogerio_Rios
(Professional Support)
August 4, 2021, 5:31pm
#6
In field inside your table , in your database ?
Did You try /r/n in your Values ?
Chr(10) And ,Chr(13)?
user when enter data in text box use new line user not type \n
Rogerio_Rios
(Professional Support)
August 4, 2021, 6:00pm
#8
Did tou try nl2br function and strip_tags ?
Please send code
thanks for help