PHP - Textarea Box Help Needed!

i have a textarea and the content is description. how do i save this to database, because sometimes it has ' and " so it fails when i insert it into database, what should i use addslashes?

Hi All,

New to PHP so any help appreciated

 

Can anyone explain why this;

      <tr><td><label for="notes">Notes:</label> 
          <td><input type="text" id="notes" name="notes" maxlength="250" size="70" value="<?php if (!empty($notes)) echo $notes; ?>"></input></td>
      </tr>

Displays data from a MySQL database (field $notes, VARCHAR(250) )

and this;

  <tr><td class=textboxlabel><label for="notes">Notes:</label> 
      <td><textarea id="notes" name="notes" rows="4" cols="70" maxlength="250" value="<?php if (!empty($notes)) echo $notes; ?>"></textarea></td>
  </tr>

displays nothing????

 

Not sure how much info to provide........

Edited November 20, 2019 by cyberRobot
Added a more meaningful post title

I have the pre tags stored in the database like in the following example:

<pre> ... </pre>

I am looking to avoid having the code rendered, when querying it into a textarea.   Any suggestions?

Hello, iam almost done with my project .. except there is one more thing left which somehow i cant manage to figure it out....... i manged to make a proxy array which rotates proxies randomly on every try..... but i want for my users to be able to add them manually via the textarea... so they put their proxies and
as much as they want...... so then i guess explode should be used to fetch the proxies that were added by the user from the textarea and put them in an array like u see down and then with the curl array_rand it randomises them on evry try The real problem is i dnt know how to indetidy the explode cause iam not adding them manually they will be added via textare by users....... so when they add the ips they need to be fetched from the textare.
THNX IN ADVACE

$proxies = array(  
    '000.000.000.00:000',   <----------------- should i keep this ? cause ips will be added from textarea by users ?
    '000.000.000.00:000',  
    '000.000.000.00:000',  
    '000.000.000.00:000',  

);  
curl_setopt($ch, CURLOPT_PROXY,$proxies[array_rand($proxies)]);  <----- AFTER and array is made using exploit this will call it :)

<textarea cols='22' class='area' rows='14' name='proxies'>PROXIES</textarea><br><input type='submit' value='Test'><br></p><p align='center' dir='ltr'><b>  

Edited by madmike3, 20 August 2014 - 05:29 AM.

What's wrong with this code?

Code: [Select]
<textarea name="description" cols="60" rows="10"><?= $description ?></textarea>
The textarea box returns null.

has just solved it, can be deleted.

I've spent the past 2 days googling and trying different methods that people have recommended other people try yet still I come up with the same problem.  I am new to coding and I am learning the basic functions so all feedback is welcome in aiding my learning endeavor.  I am using a form and all of the inputs are submitting to the database other than the text area which comes up blank.  I do not get an error when submitting the form I just get a blank value for the text area 'Comments'.   FORM   <form action="contactdb.php" method="post" form="contactdb"/>

I have a php form which shows all comments of the webpage  stored in  the database.
When i click on the edit button the corresponding 'comments' datas should appear in the textarea.

how can i do this,
pasting my piece of code


                                         $query="select *from comments order by id desc";
         
         $result=mysql_query($query);
         echo "<table width='700' align='center' border=1><tr bgcolor='green' align='center'><td><font color='black'>&nbsp;SlNo&nbsp;</font></td><td><font color='black'>Comment</font></td><td><font color='black'>&nbsp;&nbsp;Date Posted&nbsp;&nbsp;</font></td><td>Edit/Delete</td></tr></b>";
         while($row = mysql_fetch_row($result))
         {
            $d=$row['0'];
            $id=$row['0'];
            $name=$row['1'];
            $date_uploaded=$row['2'];
            
            echo    "<td>$id</td><td>$name</td>".
                "<td>$date_uploaded</td>".
                "<td><a href='edit_comments.php?id=$id'>Edit </a></td>".
                "</tr>";
         }
         
         echo   "</table>";
         
      }
      if(isset($_GET['id']))
{

   $id    = $_GET['id'];
   mysql_connect('localhost','root','') or die("Cannot connect to the Host");
mysql_select_db('sample') or die("Cannot connect to the Database !!");
   $query = "SELECT comments FROM comments_tble WHERE id = '$id' ";
   
   $result = mysql_query($query);
   $row=mysql_fetch_row($result);
   echo"<input type='text' col id='edit_comments' value='$row[0]' width='250' height='10' >";
   
   
   
   exit;
}

Hi,
This is driving me to distraction. I have been using this code Code: [Select]
<?php
$mailto = "edwin@btconnect.com";
$subject = "enquiry";
$message = "Values submitted from web site form:";
$header = "From: ".$_POST['email'];
foreach ($_POST as $key => $value)
{
   if (!is_array($value))
   {
      $message .= "\n".$key." : ".$value;
   }
   else
   {
      foreach ($_POST[$key] as $itemvalue)
      {
         $message .= "\n".$key." : ".$itemvalue;
      }
   }
}
mail($mailto, $subject, stripslashes($message), $header);
?>
very successfully but now I want to receive information from a 'textarea' in a form but it just doesn't get treated as input.
The form is here;
         <form name="enquiry" method="post" action="feedback.php">
              <tr>
                <td align="left">Name:</td>
                <td align="right"><input type="text" name="name" size="25" value=""></td>
              </tr>
            <tr>
              <td align="left">email:</td>
              <td align="right"><input type="text" name="email" size="25" value=""></td>
            </tr>
            <tr>
              <td align="left" valign="top">Blurb:</td>
              <td align="right"><textarea rows="4" cols="19" value=""></textarea></td>
            </tr>
        <tr><td colspan="2" align="right">  <input name="submit" type="image" src="report.gif" width="40" height="20" border="0">
        </td></tr></form>
Can anyone please help?
edwind

Hi, I have a form containg three text inputs and one text area.  On the php page that processes the form, I want to check first to make sure the user entered something (input field is not empty) before processing the form. I'll just provide a skeleton of form processing page below. *(I'm save space and time by omitting the form itself but he text inputs fields have the following name attributes "name", "company", "email",  and the textarea field's name attribute is  "message" )  I'll do my best to explain the code in further detail within the code comments.


Code: [Select]




<?php




//Turn on output buffering. Allows for headers to be called anywhere on script. See pg228 Ulman.
ob_start();


if (isset($_POST['submit'])) {

// Initialize a session to keep tract of error and success messages:
session_start();


//Define a session variable that keeps tract of how many times user accesses page.
$_SESSION['views'] = 1;
 

// Connect to the database.

        require('config/config.php');


//Check for errors.


//Check to make sure they entered their name.

if (!empty ( $_POST['name']))  {

        $a = TRUE;

    } else {

        $a = FALSE;

        //This variable will be echoed on the form if field is missing a value
        $_SESSION['name'] = '*Please enter a valid name.'; 


   }



//Check to make sure they entered their company name.

if (!empty ( $_POST['company'])) {

        $b = TRUE;

    } else {

        $b = FALSE;

        //This variable will be echoed on the form if field is missing a value
        $_SESSION['company'] = '*Please enter the name of an institution you are affiliated with.';  


   }



//Check to make sure email is valid.

if(eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $_POST['email'])) { 
 

         $c = TRUE; 


}else { 

         $c = FALSE;

      //This variable will be echoed on the form if field is missing a value or email format is wrong.
      $_SESSION['email'] = '*Please enter a valid email address.'; 

      } 




//Check to make sure they entered their message.

if (!empty ( $_POST['message'])) {

        $d = TRUE;

    } else {

        $d = FALSE;

       //This variable will be echoed on the form if field is missing a value
        $_SESSION['message']  = '*Please enter your message.';     


   }




 

//If no errors

if (empty($_SESSION['name'] ) && empty($_SESSION['company'] ) && empty($_SESSION['email'] ) && empty($_SESSION['message'] ) ) {


//Insert data into database.

        $query = "INSERT INTO table...     ;
       
        $result = mysql_query($query) or die("Data could not be inserted into table because: " .mysql_error());



if (mysql_affected_rows() == 1) {

    
         // Display success message

                //This variable will be echoed on the form if everything is filled out correctly.
          $_SESSION['sent'] =     "Your email has been sent.  We will get back to you shortly.";


         // Display contact page (the page containing the form)

header("Location: contact_page.php");

        exit();


}else{die(mysql_error());}
            


//Display error messages.


} else {// if errors array is not empty


         // Display page (page containing the form)

header("Location: contact_page.php"); 

exit();


        
    }//End of if there are errors.


}//End of if submit.




?>







So there it is. Everything works fine except that the part which checks if the textarea (named "message") is empty, doesn't work.   If I click the submit button without filling out any field, the appropriate error messages are printed for the text input fields but not the text area field.  If I fill out all fields correctly and leave the "message" field blank, the form gets processed correctly and values are placed in the database and the success message is printed out.  This is also the case when I enter a value for "message" textarea field.  Now I tried something.  I changed the textarea to a text field and the $_SESSION['message'] variable finally got echoed when I left this field blank.  So apparently, the problem arises from the fact that the named attribute from a textarea tag is not being processed correctly??  Who knows what's going wrong here?

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=333153.0

I hope someone can help me out with this. What I would like to do is import a text file dircetly to a text area. I can't seem to find any examples on this (Yes I did search Google). I know how to upload but I'm not interested in storing files on the server - but rather just importing them directly to a textarea.

Can anyone point me in the right direction?

I can upload:

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
Upload: <input name="uploadedfile" type="file" /><br />
<input type="submit" value="Upload File" />
</form>


I can read:

$myFile = "testFile.txt";
$fh = fopen($myFile, 'w')


But I'm not interested in either of these as they are unnecessary steps (or are they?). Is there not a way to simply browse/import a text file directly to a textarea  (or anywhere for that matter) without having to actually save the file to the server?

Something like this:

<form enctype="multipart/form-data" action="uploader.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
Upload: <input name="uploadedfile" type="file" /><br />
<input type="submit" value="Upload File" />
</form>



//uploader.php

if (isset($_POST['submit'])) {

        $content = $_POST['"grab the contents of the file"'];
        echo "<textarea>";
        echo $content;
        echo "</textarea>";
}

When I add some text to the front end of the textarea it displays
Code: [Select]
bla <br/>
bla <br/>
bla <br/> How can I stop it from showing the html tags?
Thanks.

echo'<textarea id="info" style="width:80%; height:60px;">';
            }
            echo $profile['info'];
            if($_SESSION['user_id'] == $id) {
    echo'</textarea><input type="submit" style="width:70%" 
    value="send" 
    onclick="updateInterests(document.getElementById(\'info\').value)" />';

Hello PHP geniuses,

I'm having a bit of trouble here. I've built a WYSIWYG e-mail editor with the help of TinyMCE. I'm using a textarea to pull the innerHTML from the iframe where the actual editor is.

The textarea will be hidden in production, but it's shown now for debugging reasons. I have a JS function that grabs the HTML from the iframe and puts it into the textarea, and this works great. The entire HTML gets populated in the textarea. When I go to save the e-mail (using a simple query that posts it and sends it straight to the database). The HTML is truncated in the database field to around ~255 characters. (it varies depending on what I have in there, but it's usually between 252 and 255)

I really can't figure out why this would be cutting off like this. I've looked everywhere, I don't know what else to do.


I wanted to add that the field is a text field in the database, that was the first and most obvious thing to check. I can confirm that my database holds the full text no problem. I can go into phpMyAdmin and copy+paste infinite amounts of data into the html field and it saves it without an issue.


Thank you as always <3

If you need more information to help me, I will provide whatever helps.