Need php help

[Isource]

need a bit of help for some php code, I can pay a couple of dollars but I am sure it would be really easy for a good php dev.
Discord-TiGeR#9650

 

[Zyger]

Just post the problem here

 

[Isource]

I need each line from a textarea to be inserted into the db
Each line a seperate piece of data

^problem, no one has been able to solve it so far, I have had multiple devs dm me.

 

[Zyger]

I need each line from a textarea to be inserted into the db
Each line a seperate piece of data

^problem, no one has been able to solve it so far, I have had multiple devs dm me.

Are the lines properly split using enter, or just moved over to the next line because of a word wrap?

 

[Isource]

Are the lines properly split using enter, or just moved over to the next line because of a word wrap?

sorry what

 

[Zyger]

sorry what

When finished with typing a line, is enter pressed to move it to the next line, or are you relying on it automatically moving the text over to the next line when it reaches the side of the box?

 

[Isource]

When finished with typing a line, is enter pressed to move it to the next line, or are you relying on it automatically moving the text over to the next line when it reaches the side of the box?

Oh I am pasting mc accounts in the textarea so its automatically like that basically.

 

[Zyger]

Then use preg_split to split it into an array, and then insert the lines into the database

Example:

$str = $_POST['textarea'];
print_r(preg_split('/\r\n|[\r\n]/', $str));

 

[Isource]

Then use preg_split to split it into an array, and then insert the lines into the database

Example:

$str = $_POST['textarea'];
print_r(preg_split('/\r\n|[\r\n]/', $str));

So what value would I exactly be inserting?

 

[Zyger]

So what value would I exactly be inserting?

...the textarea name

 

[Isource]

$sql = "INSERT INTO test (test)
VALUES ('$str)";

So that?[DOUBLEPOST=1536654903][/DOUBLEPOST]

...the textarea name

 

[Zyger]

$sql = "INSERT INTO test (test)
VALUES ('$str)";

So that?

Thought you were meaning posting the textarea data, didn't realize you didn't know how to read the code.
You'd need to loop over each line and insert it into the database.
There's better ways to do it, but it'd probably get too complicated.

 

[Isource]

Thought you were meaning posting the textarea data, didn't realize you didn't know how to read the code.
You'd need to loop over each line and insert it into the database.
There's better ways to do it, but it'd probably get too complicated.

How would I go about looping each line, sorry. Very very new to php

 

[Zyger]

How would I go about looping each line, sorry. Very very new to php

Why are you trying to make a website without learning basic PHP?

 

[Isource]

Why are you trying to make a website without learning basic PHP?

I haven't seen getting input from a textarea and inserting each line separately in any basic php tutorials

 

[Zyger]

I haven't seen getting input from a textarea and inserting each line separately in any basic php tutorials

This is the array you need to loop over

$arr = preg_split('/\r\n|[\r\n]/', $str)

[DOUBLEPOST=1536656200][/DOUBLEPOST]Also read these:
- https://stackoverflow.com/questions/8834186/php-split-the-content-of-text-area-and-insert-into-mysql
- https://stackoverflow.com/questions/28907537/get-the-lines-from-textarea-and-insert-to-mysql
- https://wordpress.stackexchange.com...d-echo-each-line-separately-wrapped-with-html

 

[Isource]

This is the array you need to loop over

$arr = preg_split('/\r\n|[\r\n]/', $str)

[DOUBLEPOST=1536656200][/DOUBLEPOST]Also read these:
- https://stackoverflow.com/questions/8834186/php-split-the-content-of-text-area-and-insert-into-mysql
- https://stackoverflow.com/questions/28907537/get-the-lines-from-textarea-and-insert-to-mysql
- https://wordpress.stackexchange.com...d-echo-each-line-separately-wrapped-with-html

I have been looking at the links you send and I am confused as to why this is not working:

$input = $_POST['accs'];

$arr = explode("\n", $input);
foreach ($arr as $arr1) {
    $sql = "INSERT INTO accs (account)
    VALUES ($arr1)";

 

[Zyger]

Did you execute the query? And what data type & length is 'account'?[DOUBLEPOST=1536757189][/DOUBLEPOST]And you need to close the loop plus you should rename $arr1 to $line