I want to create a form that should have a textarea as bulk input, then every row of that textarea can be store able as separate value in table via PHP.
What should I do?
Asked
Active
Viewed 401 times
-4
-
Start building some HTML / PHP code and show that here if you get stuck. – putvande Aug 20 '14 at 15:46
-
Not a Good description. – Ashesh Kumar Aug 20 '14 at 15:48
-
Welcome to SO. Try and add a bit of the code you tried, and where you got stuck in order to receive better answers. Often times you can find the answer to your question while writing it. – Vlad Preda Aug 20 '14 at 15:50
-
[I want to create a replica of The Empire State Building, but it's already been done.](http://www.google.com) – Funk Forty Niner Aug 20 '14 at 15:51
-
@AsheshKumar My description is good Vlad answered me. – H.Clean Aug 20 '14 at 16:04
-
@H.Clean He told "Try and add a bit of the code you tried, and where you got stuck in order to receive better answers" – Ashesh Kumar Aug 20 '14 at 16:17
2 Answers
2
The key piece of code is:
$values = explode("\n", $_POST['textarea_name']);
Don't forget to sanitize your inserts :)
Vlad Preda
- 9,780
- 7
- 36
- 63
-
-
You should read about sql injection: http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php?rq=1 – Vlad Preda Aug 20 '14 at 15:54
-
-
It's great that you're using `MySQLi`, but you should really read about SQL injection. Go to the link I gave in my first comment and read both the question and answers. – Vlad Preda Aug 20 '14 at 16:03
-
for insert to database, data should be string. How I can convert it to string? I want to make each row to a record! – H.Clean Aug 20 '14 at 18:14
-1
I use this code
$values = explode("\n", $_POST['textarea_name']);
mysqli_query($con,"INSERT INTO `table` (`col`) VALUES ($values)");
data should be string. How I can convert it to string? I want to make each row to a record! make my code compelet!
H.Clean
- 25
- 3