Help please

[Shaun Demellweek]

Two things I am not sure about, and would appreciate an answer to.

1) This may be simple. When creating a form to insert data into a table, I
seem to loose all the returns when data is inputted. I use the following
script:

page1.php:
<form action="page2.php">
<textarea name="textbox"></textarea>
<input type="submit">
</form>

page2.php:
<?php
include("dblogin.php"); // Loads database password, username and opens
database line.
$query = "INSERT INTO table1 (column1) VALUES ('$textbox')";
$result = mysql_query($query);
?>

All the carrige returns dissappear, meaning i have to use <br> or the <p>
tags, but this is not possible for users of a site to have to type in <br>
instead of return. Any ideas?

2) Even easier. Does anyone know where there is a good tutorial for creating
..png images automatically from data.

Many thanks in advance
Shaun
http://www.shaund.com - My Homepage
http://www.green-cabbage.co.uk - My Plymouth Argyle Site (UK Soccer Team)

[Savut]

You may need to catch the variable from the textbox if your php.ini config
has Global variable disabled which is the best option for security issues.

<?php
$textbox = $_POST["textbox"];
include("dblogin.php"); // Loads database password, username and opens
database line.
$query = "INSERT INTO table1 (column1) VALUES ('$textbox')";
$result = mysql_query($query);
?>

2nd: you have to replace \n (return) by <br> with the function

str_replace("\n", "<br>", $textarea);

"Shaun Demellweek" <sh***@shaund.com> a écrit dans le message de
news:bk**********@newsg2.svr.pol.co.uk...

Two things I am not sure about, and would appreciate an answer to.

1) This may be simple. When creating a form to insert data into a table, I
seem to loose all the returns when data is inputted. I use the following
script:

page1.php:
<form action="page2.php">
<textarea name="textbox"></textarea>
<input type="submit">
</form>

page2.php:
<?php
include("dblogin.php"); // Loads database password, username and opens
database line.
$query = "INSERT INTO table1 (column1) VALUES ('$textbox')";
$result = mysql_query($query);
?>

All the carrige returns dissappear, meaning i have to use <br> or the <p>
tags, but this is not possible for users of a site to have to type in <br>
instead of return. Any ideas?

2) Even easier. Does anyone know where there is a good tutorial for creating .png images automatically from data.

Many thanks in advance
Shaun
http://www.shaund.com - My Homepage
http://www.green-cabbage.co.uk - My Plymouth Argyle Site (UK Soccer Team)

[Geoff Berrow]

I noticed that Message-ID: <8A*******************@news20.bellglobal.com>
from Savut contained the following:

2nd: you have to replace \n (return) by <br> with the function

str_replace("\n", "<br>", $textarea);

or use the new line to <br> function

nltobr($textarea);

--
Geoff Berrow
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[sam]

"Shaun Demellweek" <sh***@shaund.com> wrote in message
news:bk**********@newsg2.svr.pol.co.uk...

Two things I am not sure about, and would appreciate an answer to.

1) This may be simple. When creating a form to insert data into a table, I
seem to loose all the returns when data is inputted. I use the following
script:

page1.php:
<form action="page2.php">
<textarea name="textbox"></textarea>
<input type="submit">
</form>

page2.php:
<?php
include("dblogin.php"); // Loads database password, username and opens
database line.
$query = "INSERT INTO table1 (column1) VALUES ('$textbox')";
$result = mysql_query($query);
?>

All the carrige returns dissappear, meaning i have to use <br> or the <p>
tags, but this is not possible for users of a site to have to type in <br>
instead of return. Any ideas?

$textbox = nl2br($textbox);

This way you replace carrige returns with <br>'s
2) Even easier. Does anyone know where there is a good tutorial for creating .png images automatically from data.

Many thanks in advance
Shaun
http://www.shaund.com - My Homepage
http://www.green-cabbage.co.uk - My Plymouth Argyle Site (UK Soccer Team)