|
PHP - Textarea Being Truncated On The Way To Mysql
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. Similar TutorialsI have some data that when I type in a string in a text box, (e.g. John Smith), the data is trunctated when it is inserted into the database (only 'John; would show up). I noticed that it seems to cut the data off after a white space. If I combine the words, then they are inserted properly. Does this sound like something simple I'm missing or is it something more complex? The text size is 20 and the db field is Varchar 30. Any help would be appreciated. Thanks. need your suggestion here is my problem i have field varchar(1000) in my sql server 2008 DB but if i mssql_fetch_object($result) my field value truncated and only show 256 character, why ? in my DB . my field value really 1000 character long . 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"/> What's wrong with this code? Code: [Select] <textarea name="description" cols="60" rows="10"><?= $description ?></textarea> The textarea box returns null. Hi, the problem that I have goes like this. If i do a regular Select query and display it in a table everything is there but if i am filling a input box of a form to use for modifying the values it does not return the entire value: Exemple with the same value in a table = product_name : Amd Athlon X2 In input field : Amd Here is my code Code: [Select] <? $sql = "SELECT * FROM tbl_product WHERE product_code = '$_POST[productcode]'"; $result = mysql_query($sql); if(!$result){ die("Error running $sql:" . mysql_error()); } ?> <? while($row = mysql_fetch_array($result)) { echo " <form action='functions/moditem.php' method='post'> <input type='hidden' name='productid' value=". $row['product_id'] ."> Product code : <input type='text' name='productcode' value=". $row['product_code'] ." /><br /> Product Name : <input type='text' name='productname' value=". $row['product_name'] ." /><br /> Product Price: <input type='text' name='productprice' value=". $row['product_price'] ." /><br /> <input type='submit' value='Modify' /> </form> "; } Hello! I run into this simple problem and couldn't find any solutions from web, so I came here to ask you guys I don't understand what happens to linebreaks when I post textarea and save value to Mysql... Btw, I notided that linebreaks works properly if I don't use mysqli_real_escape_string, but I like to keep script as secure as possible... If I input this in to textarea: row1 row2 row4 row6 I get this in textarea and html-code: 1\r\n2\r\n3\r\n4\r\n5 This is how I try to do it: <? //>>> Connect to Mysql // Secure $_POST -data $_POST['mytext'] = mysqli_real_escape_string($db, $_POST['mytext']); // Insert to Mysql mysqli_query($db, "INSERT INTO mysql_table (mytext) VALUES ('$_POST[mytext]')"); // Get data from Mysql $query = mysqli_query($db, "SELECT mytext FROM mysql_table';"); $row = mysqli_fetch_array($query); mysqli_free_result($query); ?> <textarea name="mytext"><? print $row['mytext']; ?></textarea> <? // nl2br function $row['mytext'] = nl2br($row['mytext']); // print text echo $row['mytext']; ?> Hi Guys, My 2nd issue with my new blog is that the code used to limit the amount of content displayed from each post, is on occasion truncating the closing html tags along with the excess text! Very often this will result in any following posts being entirely italic or bold, which as you can imagine looks ridiculous. The Code that limits the content: # Limit Post function the_content_limit($max_char, $more_link_text = '', $stripteaser = 0, $more_file = '') { $content = get_the_content($more_link_text, $stripteaser, $more_file); $content = apply_filters('the_content', $content); $content = str_replace(']]>', ']]>', $content); $content = strip_tags($content, '<h1>,<h2>,<h3>,<strong>,<em>, '); if (strlen($_GET['p']) > 0) { I'd be very grateful if someone could help me out with this. Thanks Steve Hello, is it possible to insert somehow information from textarea to mysql? For example i have 3 lines in text area: John Tacker is a bad guy Tom Tacker has a big nose Ted Tacker is the same person as John Tacker and i want to insert them in table's different rows Hi Guys, I have a textarea on a html page with XXX amount of lines. How can I in php insert a separate mysqlrow for EACH line on the html textarea? Thanks G I have a form that generates html code, and displays it in a textarea with submit button. I want to submit button to take the data entered in that textarea1 on page 1, and upload to textarea2 on page 2 How can I do this? I have no idea where to start. This is driving me mad. I've looked in my books and on the Internet but I cannot find the answer. I have a form with a textarea and I need to retain the linebreaks. Obviously, before I send the data to MySQL, I run it through mysqli_real_escape_string and the result is: (In form) "Foo" Bar (In phpMyAdmin) \"Foo\"\r\nBar When I extract the data from MySQL, I use stripslashes($var) to get the quote back and end up with: "Foo"rnBar The problem I am having is changing the \r\n or rn to newlines so that it looks correct in the form. I have tried using nl2br before stripslashes. Even tried using str_replace to change the /r/n to <br /> but I just end up with "Foo"<br />Bar in the textarea box. There must be some simple thing that's causing the problem or people wouldn't be using textareas. Help! hey guys i need to refresh on blur to get to post the upc code inserted in the textarea for product search..
i got the but i can't find the way to post the item
<script>
function reload() {
window.location.assign("http://store.radioauto.ca/POS/auto.php?Item=upc code here")
}
</script>
<input type="text" id="upc" name="upc" onblur="reload()" value="<?=$_GET['item']?>"/>
Please help refresh my memory... It seems to me that there is some combination with nl2br that is a no-no... I am thinking I need to remove nl2br in this code... <textarea id="comments" name="comments" cols="50" rows="15"><?php if (isset($comments)){echo nl2br(htmlentities($comments, ENT_QUOTES));} ?></textarea> Debbie I have a textarea displaying data from a mysql table. However, a user discovered today that if they use a carriage return in the textarea, the data comes out with "rn" at the location in the text where the carriage return goes. I have been searching the forums for a while this afternoon and have found quite a few references to this, but have been unable to fix my problem. I am using mysql_real_escape_string before inserting into database (I am not using anything else at insertion time). Is there something else that I should be using at either the insertion into the database or when I display the data? I have tried various combinations of htmlspecialchars() and htmlentities() and nl2br() with no luck. Here is a sample of the output in my textarea: Quote copy diagonal lines and a square with no more than 1/4" overlap or gap at point of closure(modified).rn2.Patient will draw a person ........ Should look like: Quote copy diagonal lines and a square with no more than 1/4" overlap or gap at point of closure(modified). 2.Patient will draw a person ........ Thanks for the help. Matt 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> Displays data from a MySQL database (field $notes, VARCHAR(250) ) and this;
<tr><td class=textboxlabel><label for="notes">Notes:</label> displays nothing????
Not sure how much info to provide........ Edited November 20, 2019 by cyberRobotAdded a more meaningful post title I'm trying to add a textarea box at the bottom of this form so I can type in note or comments. The issue I'm running into is, the textarea box does not cover the full width of the form...can someone take a look at this code & help me out? I've also attached a .jpg of what I'm seeing in the browser. Thanks Code: [Select] <td> <textarea name="comments" cols"100" rows="5"> </textarea><br> </td> has just solved it, can be deleted. |
|||||||