How to store text-area data in database in PHP?

Question

I have a form with three fields two are of input type="text" and one is text area. I am not able to store the data of text area in database. HELP

<table>
  <form name="email" method="post">
    <tr>
      <td width="90">
        Email Id : <input name="Receiver1" type="text" size="70"/><br>
        Subject :<input name="Sub" type="text" size="70" /><br>

          <textarea cols="80" rows="30" >
          </textarea>

       Content:<input type="submit" name="Send" value="Send" />

  </form>
<?php
 require('connection.php');
 if(isset($_POST['Send']))
 {
   $Reciever = $_POST['Receiver1'];
   $Subject = $_POST['Sub'];
   $text = mysql_real_escape_string($_POST['textarea']);
   mysql_query("INSERT INTO EmailData VALUES ('$Reciever','$Subject', '$text')");
}

What error do you get? (Not that you're actually checking). FYI, you are wide open to [SQL injections](http://stackoverflow.com/q/60174). — John Conde, May 07 '14 at 19:33
**Danger**: You are using [an **obsolete** database API](http://stackoverflow.com/q/12859942/19068) and should use a [modern replacement](http://php.net/manual/en/mysqlinfo.api.choosing.php). You are also **vulnerable to [SQL injection attacks](http://bobby-tables.com/)** that a modern API would make it easier to [defend](http://stackoverflow.com/questions/60174/best-way-to-prevent-sql-injection-in-php) yourself from. — Quentin, May 07 '14 at 19:34
Give your text area a name and look for it in $_POST, just like any other form variable. — , May 07 '14 at 19:35
Please [learn to love labels](http://www.456bereastreet.com/archive/200711/use_the_label_element_to_make_your_html_forms_accessible/) — Quentin, May 07 '14 at 19:36
Next time, add error reporting to the top of your file(s) `error_reporting(E_ALL); ini_set('display_errors', 1);` and save us all the typing trouble. — Funk Forty Niner, May 07 '14 at 19:37
^--« There you go, see? It works! ;-) Invaluable tool isn't it? So do `` and you'll be on your way to happiness ;-) — Funk Forty Niner, May 07 '14 at 19:43

score 1 · Answer 1 · answered May 07 '14 at 19:34

1

You have to give a textarea a name attribute for it to be a successful form control.

You are not allowed a form around a table row element. Some browsers will move the form outside the table and leave the form controls behind. Use a validator.

answered May 07 '14 at 19:34

Quentin

914,110
126
1,211
1,335

nice point abt form being in tr :) +1 – M.chaudhry May 07 '14 at 19:37

score 1 · Answer 2 · answered May 07 '14 at 19:35

1

You need to name the textarea:

<textarea cols="80" rows="30" name="textarea">
</textarea>

answered May 07 '14 at 19:35

fnightangel

416
3
10

not working and the error is Undefined index: textarea – user3613632 May 07 '14 at 19:42

score 1 · Answer 3 · answered May 07 '14 at 19:35

1

name your textarea :)

<textarea name="textarea_name" cols="80" rows="30" >
          </textarea>

  </form>
<?php
 require('connection.php');
 if(isset($_POST['Send']))
 {
   $Reciever = $_POST['Receiver1'];
   $Subject = $_POST['Sub'];

   $text = mysql_real_escape_string($_POST['textarea_name']);
   mysql_query("INSERT INTO EmailData VALUES ('$Reciever','$Subject', '$text')");
}

answered May 07 '14 at 19:35

M.chaudhry

651
1
6
13

it gives the error Undefined index: textarea_name – user3613632 May 07 '14 at 19:59
it means your textarea is nt named as textarea_name :) – M.chaudhry May 08 '14 at 10:21

score 0 · Answer 4 · edited May 23 '17 at 10:26

0

You have to name your <textarea> just like you name your <input>s:

<textarea cols="80" rows="30" name="sometext">
</textarea>

You can then refer to it as $_POST['sometext'].

That being said, please read up on SQL injection and how to program against it.

edited May 23 '17 at 10:26

Community

1
1

answered May 07 '14 at 19:36

Bart Friederichs

33,050
15
95
195

How to store text-area data in database in PHP?

4 Answers4