🗡️ 🙍🏽 😬 Display textarea format for echo from database

</texta...">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

<body>
  
  <header class="page-header js-page-header">
    <a class="page-header-logo-container" href="https://geek-answers.imtqy.com/index.html"></a>
    <div class="page-header-text">Geek Answers Handbook</div>
  </header>
  <section class="page js-page"><div itemscope="" itemtype="http://schema.org/QAPage" class="page"><div class="main-col" itemprop="mainEntity" itemscope="" itemtype="http://schema.org/Question"><div class="question-header"><h1 itemprop="name">  Display textarea format for echo from database </h1></div><div class="question"><div class="question-row"><div class="question-text"><div class="description" itemprop="text"><p>  I created a form </p><pre class="prettyprint-override"><code class="hljs xml"><span class="hljs-tag"><<span class="hljs-name">form</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"form1"</span> <span class="hljs-attr">method</span>=<span class="hljs-string">"post"</span>></span> <span class="hljs-tag"><<span class="hljs-name">textarea</span> <span class="hljs-attr">rows</span>=<span class="hljs-string">"5"</span> <span class="hljs-attr">cols</span>=<span class="hljs-string">"20"</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"ta1"</span>></span><span class="hljs-tag"></<span class="hljs-name">textarea</span>></span> <span class="hljs-tag"><<span class="hljs-name">input</span> <span class="hljs-attr">type</span>=<span class="hljs-string">"submit"</span> <span class="hljs-attr">name</span>=<span class="hljs-string">"submit"</span> /></span> <span class="hljs-tag"><<span class="hljs-name">textarea</span> <span class="hljs-attr">rows</span>=<span class="hljs-string">"5"</span> <span class="hljs-attr">cols</span>=<span class="hljs-string">"20"</span>></span><span class="php"><span class="hljs-meta"><?php</span> <span class="hljs-keyword">echo</span> $_POST[<span class="hljs-string">'ta1'</span>]; <span class="hljs-meta">?></span></span><span class="hljs-tag"></<span class="hljs-name">textarea</span>></span> <span class="hljs-tag"></<span class="hljs-name">form</span>></span></code> </pre> <p>  And php code </p><pre class="prettyprint-override"> <code class="hljs xml"><span class="php"><span class="hljs-meta"><?php</span> <span class="hljs-keyword">if</span> ($_POST[<span class="hljs-string">'submit'</span>]) { $llo = $_POST[<span class="hljs-string">'ta1'</span>]; $con1 = mysql_connect(<span class="hljs-string">"localhost"</span>, <span class="hljs-string">"FreeUser"</span>, <span class="hljs-string">"123456"</span>); mysql_select_db(<span class="hljs-string">"database"</span>, $con1); mysql_query(<span class="hljs-string">"insert into test (ttta) values ('$llo')"</span>); $q1 = mysql_query(<span class="hljs-string">"select * from test"</span>); $res = mysql_fetch_array($q1); <span class="hljs-keyword">echo</span> $res[<span class="hljs-string">'ttta'</span>]; } <span class="hljs-meta">?></span></span></code> </pre><p>  Database table test </p><pre class="prettyprint-override"> <code class="hljs nginx"><span class="hljs-attribute">id</span> Auto_Increment ttta mediumtext <span class="hljs-number">500</span></code> </pre><p>  only two fields in the table </p><p>  Now that I will print something in textarea as formatted below </p><pre class="prettyprint-override"> <code class="hljs nginx"><span class="hljs-attribute">Rafee</span> Web Developer XYZ Company New York</code> </pre><p>  When I click the submit button, the same content with the same formatting structure is stored / displayed in the database table / text box </p><p>  But when I <code>echo</code> this value is displayed on one line without any format.  How can we achieve this. </p><p>  And I added an image for a better understanding. </p><p><img alt="enter image description here" data-src="/img/8a89abe31337842a579c96ce8c901215.png" class=" lazyloaded" src="https://fooobar.com//img/8a89abe31337842a579c96ce8c901215.png"></p></div><div class="favorite hidden"><i class="far fa-star"></i></div><div class="votes-question"><i class="glyphicon glyphicon-arrow-ups"></i><div class="vote-count greenc" itemprop="upvoteCount">  +4 </div><i class="glyphicon glyphicon-arrow-down"></i></div><div class="tags">  <a href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" class="tag" title="show questions tagged with 'php'" rel="tag">php</a> <a href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" class="tag" title="show questions tagged with 'mysql'" rel="tag">mysql</a> <a href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" class="tag" title="show questions tagged with 'format'" rel="tag">format</a> <a href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" class="tag" title="show questions tagged with 'echo'" rel="tag">echo</a> </div><div class="clearfix"></div><div class="action-time">  <span itemprop="author" itemscope="" itemtype="http://schema.org/Person"><span itemprop="name"><a href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" rel="noopener" target="_blank">Rafee</a></span></span> <time title="2012-06-20 07:52" itemprop="dateCreated" datetime="2012-06-20T07:52:18+0000">  Jun 20  '12 at 7:52 </time></div>  <a class="aa-link" href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" target="_blank" rel="noopener">source</a> <a class="s-link" href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" title="share">share</a> <div class="clearfix"></div></div></div></div><ins style="height: 90px;display: block;" data-zxname="zx-adnet" data-zxadslot="ZX-QRST" data-zxw="0" data-zxh="90" data-zxid="2" data-overlay="false"></ins><div class="answers " id="answers_hash"><div class="answers-header">  <span class="pull-left"><span itemprop="answerCount">1</span> answer</span> <div class="clearfix"></div></div><div class="answer-pager hidden"></div><div class="answer accepted last rltd" id="4404954_hash" itemscope="" itemtype="http://schema.org/Answer" itemprop="acceptedAnswer"><div class="answer-row"><div class="answer-text"><div class="desc" itemprop="text"><p>  Using </p><pre class="prettyprint-override"> <code class="hljs bash"><span class="hljs-built_in">echo</span> nl2br(<span class="hljs-variable">$res</span>[<span class="hljs-string">'ttta'</span>]);</code> </pre><p>  This will convert <code>\n</code> to HTML tag <code><br /></code> </p><p>  In HTML, visible line brakes require the use of an HTML tag <code><br /></code> , but in your PHP the stored data is <code>"Rafee\nWeb Developer\nXYZ Company\nNew York\n"</code> , so you need the function to turn <code>"\n"</code> to <code>"<br />"</code> . </p><p>  Link: <a href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" rel="nofollow noreferrer" src="">http://php.net/manual/en/function.nl2br.php</a> </p></div><div class="votes-answer"><i class="glyphicon glyphicon-arrow-ups"></i><div class="vote-count greenc" itemprop="upvoteCount">  +8 </div><i class="glyphicon glyphicon-arrow-down"></i></div><div class="clearfix"></div><div class="action-time">  <span itemprop="author" itemscope="" itemtype="http://schema.org/Person"><span itemprop="name"><a href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" rel="noopener" target="_blank">Alvin wong</a></span></span> <time title="2012-06-20 07:53" itemprop="dateCreated" datetime="2012-06-20T07:53:59+0000">  Jun 20  '12 at 7:53 </time></div>  <a class="aa-link" href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" target="_blank" rel="noopener">source</a> <a itemprop="url" class="s-link" href="https://translate.googleusercontent.com/translate_c?depth=1&rurl=translate.google.com&sl=ru&sp=nmt4&tl=en&u=" title="share">share</a> <div class="clearfix"></div></div></div></div><ins style="height: 90px;display: block;margin-top: 15px;" data-zxname="zx-adnet" data-zxadslot="ZX-QRST" data-zxw="0" data-zxh="90" data-zxid="3" data-overlay="false"></ins><div class="answer-pager hidden"></div></div></div></div>
<section class="more-articles-navigation-panel js-more-articles-navigation-panel">
<h4>More articles:</h4>
<nav class="list-of-articles-container js-list-of-articles-container"><ul class="list-of-pages js-list-of-pages">
<li><a href="../1418890/index.html">Adding zeros in front of a vector - arrays</a></li>
<li><a href="../1418891/index.html">Highlight the selected image in the HorizantalListView in android, and it will remain selected until another image is clicked. - android</a></li>
<li><a href="../1418892/index.html">How to serialize to raw block of memory? - c ++</a></li>
<li><a href="../1418893/index.html">Invalid EIP value for buffer overflow - c</a></li>
<li><a href="../1418894/index.html">Destination 'id </head><body> <MFMessageComposeViewControllerDelegate>' from an incompatible type MainViewController * - ios</a></li>
<li><a href="../1418896/index.html">Additional column in SlickGrid - slickgrid</a></li>
<li><a href="../1418897/index.html">eclipse complaint compilation error for playback 2.0.1 - eclipse</a></li>
<li><a href="../1418898/index.html">Displaying record information in a table / grid using Crystal Report - c #</a></li>
<li><a href="../1418899/index.html">linq-To-Sql: filter with enumeration (flags) - c #</a></li>
<li><a href="../1418900/index.html">How does folder name transfer work in international versions of Windows 7? - windows</a></li>
</ul></nav>
</section><br />
<a href="../../allArticles.html"><strong>All Articles</strong></a>
<script src="../../js/main.js"></script>

<script type="text/javascript" >
  (function (d, w, c) {
      (w[c] = w[c] || []).push(function() {
          try {
              w.yaCounter62683636 = new Ya.Metrika({
                  id:62683636,
                  clickmap:true,
                  trackLinks:true,
                  accurateTrackBounce:true,
                  webvisor:true
              });
          } catch(e) { }
      });

var n = d.getElementsByTagName("script")[0],
          s = d.createElement("script"),
          f = function () { n.parentNode.insertBefore(s, n); };
      s.type = "text/javascript";
      s.async = true;
      s.src = "https://mc.yandex.ru/metrika/watch.js";

if (w.opera == "[object Opera]") {
          d.addEventListener("DOMContentLoaded", f, false);
      } else { f(); }
  })(document, window, "yandex_metrika_callbacks");
</script>
<noscript><div><img src="https://mc.yandex.ru/watch/62683636" style="position:absolute; left:-9999px;" alt="" /></div></noscript>

<script>
    window.ga = function () { ga.q.push(arguments) }; ga.q = []; ga.l = +new Date;
    ga('create', 'UA-166339405-1', 'auto'); ga('send', 'pageview')
  </script>
  <script src="https://www.google-analytics.com/analytics.js" async defer></script>

</section>

<footer class="page-footer">
  <div class="page-footer-legal-info-container page-footer-element">
    <p>
      Geek Answers | <span class="page-footer-legal-info-year js-page-footer-legal-info-year">2019</span>
    </p>
  </div>
  <div class="page-footer-counters-container page-footer-element">
    <a class="page-footer-counter-clustrmap" href='#'  title='Visit tracker'><img src='https://clustrmaps.com/map_v2.png?cl=698e5a&w=271&t=t&d=IDRwb302jFsed82JlnSkxjeQ3C5_AObCmGX74jggris&co=3a3a3a&ct=ffffff'/></a>
  </div>
</footer>
  
</body>

</html>