How to add to an array

[ollie007]

How do you add to an array from a textarea input?

 

I guess if you add a comma, then you can add a straight array??

 

$array = ("$_POST[$string]");

 

How would you do it for linebreaks??

 

and secondly, is it a security risk if you allow input like this to your DB?

[Garethp]

Ok

 

A) You add it like this

$array[] = "Input";

 

B) You'd do it like

$array[] = mysql_real_escape_string($_POST[$string']);

 

The mysql_real_escape_string escapes the string, so it's no long a security risk

 

On a side note

$W00T = mysql_real_escape_string($_POST['200TH!']);

[ollie007]

cool ty.

 

how do i insert with a linebreak??

 

eg

 

data1

data2

data3

 

instead of

data1,data2,data3

 

 

 

[trq]

Care to be a little more descriptive?

 

Do you meen 'how do I retain linebreaks when inserting data into a database?'

 

Unless you go out of your way to remove them, linebreaks are saved with your data.

[Garethp]

Exactly. But, you want to retain your line breaks as <br>'s, you use nl2br()

[trq]

Exactly. But, you want to retain your line breaks as <br>'s, you use nl2br()

 

Not on the way into your database though.

[ollie007]

i just need each line to be a set of data, linebreaks means nothing internally

 

they are a way for the user to see what they are entering

 

or maybe a linebreak is take by array[] as a single data?

[ollie007]

Profile Menu:\r\n
\r\n
http://yakkityyak.x24hr.com
\r\n

 

i tried the "mysql_real_escape_string" and i got the \r\n on the output??

[trq]

Again, you need to explain what it is you are doing. Your statements don't mean allot to people reading your posts.

[ollie007]

welll

 

when people post

 

data1,data2,data3 FROM one textarea

 

i would like it to be inserted into a database (already done), and THEN to be retrieved into an array,

 

ie  data1,data2,data3 into one cell !!!

 

So data from one cell delineated by comma BUT manipulated as single data entities??

 

Are we on the same page?

 

PS. I am NOT adding to the array the normal way like array[];

 

I am just gonna grab the data from the db and write out the array !!

 

$string='apples, oranges, bannana'

 

$array = ($string);

 

 

[jxrd]

You mean like

$post = $_POST['textarea'];
$post = explode("\n", $post);

?

 

 

oooooh wait, you mean like....

 

$sql= /*your sql data*/;
$data = array();
while($fetch = $mysql_fetch_array($sql))
{
$array = explode(',', $fetch['row']);
array_push($data, $array);
}

[ollie007]

I am NOT adding to the array the normal way like array[];

 

I am just gonna grab the data from the db and write out the array !!

 

$string='apples, oranges, bannana'

 

$array = ($string);

 

the reverse of this to be honest

 

$sql= /*your sql data*/;
$data = array();
while($fetch = $mysql_fetch_array($sql))
{
$array = explode(',', $fetch['row']);
array_push($data, $array);
}

 

but i want to remove line breaks and add the commas where line breaks are

[jxrd]

str_replace("\n", ',', $data);

??

 

I'm having a hard time understanding tbh...

[trq]

If you have a string that looks like this "foo,bar,bob" and you want to turn it into an array you will need to use implode. eg;

 

$stringfromdb = "foo,bar,bob";
$array = implode(',', $stringfromdb);

[jxrd]

If you have a string that looks like this "foo,bar,bob" and you want to turn it into an array you will need to use implode. eg;

 

$stringfromdb = "foo,bar,bob";
$array = implode(',', $stringfromdb);

 

What? Doesn't implode create a string from an array..?

[trq]

Sorry, my bad. You need explode.

[jxrd]

You mean like

$post = $_POST['textarea'];
$post = explode("\n", $post);

?

 

 

oooooh wait, you mean like....

 

$sql= /*your sql data*/;
$data = array();
while($fetch = $mysql_fetch_array($sql))
{
$array = explode(',', $fetch['row']);
array_push($data, $array);
}

 

Yeah, already suggested that. Apparently it's unsatisfactory though...

[ollie007]

$stringfromdb = "foo,bar,bob";
$array = implode(',', $stringfromdb);

 

hahha almost there LOL

 

what about

$stringfromdb = "foo bar bob";

 

with the spaces?? or linebreaks? what does mysql do with a linebreak on insert?

[jxrd]

...creates a line break.

[trq]

what does mysql do with a linebreak on insert?

 

Nothing. I said that several replies ago.

 

if you want to split on a space use....

 

$array = explode(' ' , $stringfromdb);

[ollie007]

how how does explode deal with the linebreak? is it removed automatically?

[jxrd]

What do you actually want to do? Split on a space, line break, create from an array, fetch data from the database or what? You've suggested all of these and we've provided a solution.

 

I still don't understand what you actually want to do.

 

You're not being very clear...

 

 

And explode removes the delimiting character and creates an array of each part around it. You can read the manual for more info.

[trq]

is it removed automatically?

 

No, why would it be?

 

Do you want to split on a line break?

[ollie007]

$post = $_POST['textarea'];
$post = explode("\n", $post);

 

what does this do??

[jxrd]

explode.