will sometimes not post and other times it will</a></h1> </div> <div class="grid fw-wrap pb8 mb16 bb bc-black-075"> <div class="grid--cell ws-nowrap mr16 mb8" title="2016-01-12 19:07:53Z"> <span class="fc-light mr2">Asked</span> <time itemprop="dateCreated" datetime="2020-11-23T23:20:24.090" class="fromnow">Nov 23 '20 at 23:20</time> </div> <div class="grid--cell ws-nowrap mr16 mb8"> <span class="fc-light mr2">Active</span> <time class="fromnow" title="2020-11-24T11:07:13.117" datetime="2020-11-24T11:07:13.117">Nov 24 '20 at 11:07</a> </div> <div class="grid--cell ws-nowrap mb8" title="Viewed 25 times"> <span class="fc-light mr2">Viewed</span> 25 times </div> </div> <div id="mainbar" role="main" aria-label="questions and answers"> <div id="question" class="question" data-questionid="64978030" data-ownerid="12994303" data-score="0"> <div class="post-layout"> <div class="votecell post-layout--left"> <div class="js-voting-container grid jc-center fd-column ai-stretch gs4 fc-black-200" data-post-id="64978030"> <button class="js-vote-up-btn grid--cell s-btn s-btnunset c-pointer"><svg aria-hidden="true" class="m0 svg-icon iconArrowUpLg" width="36" height="36" viewBox="0 0 36 36"><path d="M2 26h32L18 10 2 26z"></path></svg></button> <div class="js-vote-count grid--cell fc-black-500 fs-title grid fd-column ai-center" itemprop="upvoteCount" data-value="0">0</div> <button class="js-bookmark-btn s-btn s-btnunset c-pointer py4"> <svg aria-hidden="true" class="svg-icon iconBookmark" width="18" height="18" viewBox="0 0 18 18"><path d="M6 1a2 2 0 00-2 2v14l5-4 5 4V3a2 2 0 00-2-2H6zm3.9 3.83h2.9l-2.35 1.7.9 2.77L9 7.59l-2.35 1.7.9-2.76-2.35-1.7h2.9L9 2.06l.9 2.77z"></path></svg> <div class="js-bookmark-count mt4" data-value=""></div> </button> </div> </div> <div class="postcell post-layout--right"> <div class="s-prose js-post-body" itemprop="text"><p>Here is an example on text that has been pasted into a textarea and then posted to database:</p> <p>This text gets passed from textarea to database:</p> <blockquote> <p>Theodore John Kaczynski (/kəˈzɪnski/; born May 22, 1942), also known as the Unabomber (/ˈjuːnəbɒmər/), is an American domestic terrorist, anarchist, and former mathematics professor.[2][3][4] He was a mathematics prodigy,[5] but he abandoned his academic career in 1969 to pursue a more primitive lifestyle. Between 1978 and 1995, he killed three people and injured 23 others in an attempt to start a revolution by conducting a nationwide bombing campaign targeting people involved with modern technology. In conjunction with this effort, he issued a social critique opposing industrialization while advocating a nature-centered form of anarchism.[6]</p> <p>In 1971, Kaczynski moved to a remote cabin without electricity or running water near Lincoln, Montana, where he lived as a recluse while learning survival skills in an attempt to become self-sufficient. He witnessed the destruction of the wilderness surrounding his cabin and concluded that living in nature was untenable; he began his bombing campaign in 1978. In 1995, he sent a letter to The New York Times and promised to "desist from terrorism" if the Times or The Washington Post published his essay Industrial Society and Its Future, in which he argued that his bombings were extreme, but necessary to attract attention to the erosion of human freedom and dignity by modern technologies that require large-scale organization.</p> </blockquote> <p>This text doesn't get passed from textarea to database:</p> <blockquote> <p>Kaczynski was the subject of the longest and most expensive investigation in the history of the Federal Bureau of Investigation. Before his identity was known, the FBI used the case identifier UNABOM (University and Airline Bomber) to refer to his case, which resulted in the media naming him the "Unabomber". The FBI and Attorney General Janet Reno pushed for the publication of Industrial Society and Its Future, which led to a tip from Kaczynski's brother David, who recognized the writing style.</p> <p>After his arrest in 1996, Kaczynski tried unsuccessfully to dismiss his court-appointed lawyers because they wanted him to plead insanity in order to avoid the death penalty, whereas he did not believe that he was insane. In 1998, a plea bargain was reached under which he pleaded guilty to all charges and was sentenced to life in prison without possibility of parole.</p> </blockquote> <p>And one last thing. ASCII art wont also be passed to database.</p> <p>Here's my code:</p> <pre><code><?php date_default_timezone_set('Europe/Oslo'); include 'include/dbh_post.inc.php'; include 'include/post.inc.php'; if (isset($_SESSION['userid'])) { $userid = $_SESSION['userid']; $username = $_SESSION['username']; } else { $userid = 0; $username = 'Anonymous'; } echo"<form method='POST' action'".setPost($conn)."'> <div style='display: grid; grid-template-columns: 1fr; overflow: hidden; box-sizing: border-box; margin-top: 10px; width: 100%; padding: 0.4em; padding-bottom: 0px; border: solid 2px; border-radius: 5px;'> <input type='hidden' name='idUsers' value='".$userid."'> <input type='hidden' name='date' value='".date('Y-m-d H:i:s')."'> <textarea maxlength='300' name='title' placeholder='Title' rows='2' style='width: 100%; box-sizing: border-box; border-radius: 4px; background-color: #f2eecb;'></textarea> <div style='padding-top: 0.25em;'> <textarea maxlength='50000' name='post' placeholder='Text' rows='20' style='width: 100%; box-sizing: border-box; border-radius: 4px; background-color: #f2eecb;'></textarea> </div> <div style='margin-top: 0.1em; margin-bottom: 0.1em; text-align: center; line-height: 2;'> <h1 class='signuptext' style='float: left;'>Status:".$username."</h1> <button type='submit' name='postSubmit' class='post'>Post</button> <div> </div> </form>"; ?> function setPost($conn) { if (isset($_POST['postSubmit'])) { if (isset($_SESSION['userid'])) { $idUsers = $_SESSION['userid']; $sql1 = "SELECT * FROM post WHERE idUsers='$idUsers' ORDER BY date DESC LIMIT 1"; $result1 = $conn->query($sql1); while ($row = $result1->fetch_assoc()) { $lastTime = strtotime($row['date']); } $now = time(); $interval = abs($lastTime - $now); $minutes = round($interval / 60); if ($minutes >= 0) { $idUsers = $_POST['idUsers']; $date = date('Y-m-d H:i:s'); $title = $_POST['title']; $post = $_POST['post']; $one = '1'; $zero = '0'; $sql = "INSERT INTO post (idUsers, date, title, post, report, save, views, upvote, downvote, tru, fals) VALUES ('$idUsers', '$date', '$title','$post', '$zero', $one, '$one', '$one', '$one', '$one', '$one')"; $result = $conn->query($sql); echo "<script type='text/javascript'>alert('Article successfully posted');history.go(-1);</script>"; } elseif ($minutes < 5) { $minutes = 5 - $minutes; $message = "You have to wait $minutes minutes."; echo "<script type='text/javascript'>alert('$message');history.go(-1);</script>"; } } else { $message = "You can create articles if you have an account"; echo "<script type='text/javascript'>alert('$message');</script>"; } } } </code></pre></div> <div class="mt24 mb12"> <div class="post-taglist grid gs4 gsy fd-column"> <div class="grid ps-relative"> <a href="../../questions/tagged/php" class="post-tag js-gps-track" title="show questions tagged 'php'" rel="tag">php</a> <a href="../../questions/tagged/mysqli" class="post-tag js-gps-track" title="show questions tagged 'mysqli'" rel="tag">mysqli</a> <a href="../../questions/tagged/sql-injection" class="post-tag js-gps-track" title="show questions tagged 'sql-injection'" rel="tag">sql-injection</a> </div> </div> </div> <div class="mb0"> <div class="mt16 grid gs8 gsy fw-wrap jc-end ai-start pt4 mb16"> <div class="grid--cell mr16 fl1 w96"></div> <div class="post-signature grid--cell"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="edited Nov 24 '20 at 11:07">edited Nov 24 '20 at 11:07</time> <a href="../../users/1839439/dharman" class="s-avatar s-avatar32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/1839439.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Dharman" /> </a> <div class="s-user-card--info"> <a href="../../users/1839439/dharman" class="s-user-card--link">Dharman</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">30,962</li> <li class="s-award-bling s-award-blinggold" title="25 gold badges">25</li> <li class="s-award-bling s-award-blingsilver" title="85 silver badges">85</li> <li class="s-award-bling s-award-blingbronze" title="135 bronze badges">135</li> </ul> </div> </div> </div> <div class="post-signature owner grid--cell"> <div class="s-user-card s-user-card"> <time class="s-user-card--time" datetime="asked Nov 23 '20 at 23:20">asked Nov 23 '20 at 23:20</time> <a href="../../users/12994303/chess125" class="s-avatar s-avatar32 s-user-card--avatar"> <img class="s-avatar--image" src="../../users/profiles/12994303.webp" data-jdenticon-width="32" data-jdenticon-height="32" data-jdenticon-value="Chess125" /> </a> <div class="s-user-card--info"> <a href="../../users/12994303/chess125" class="s-user-card--link">Chess125</a> <ul class="s-user-card--awards"> <li class="s-user-card--rep" title="reputation score">1</li> <li class="s-award-bling s-award-blingbronze" title="2 bronze badges">2</li> </ul> </div> </div> </div> </div> </div> </div> <div class="post-layout--right js-post-comments-component"> <div id="comments-64978030" class="comments js-comments-container bt bc-black-075 mt12 " data-post-id="64978030" data-min-length="15"> <ul class="comments-list js-comments-list" data-remaining-comments-count="0" data-canpost="false" data-cansee="true" data-comments-unavailable="false" data-addlink-disabled="true"> <li id="comment-114877424" class="comment js-comment " data-comment-id="114877424" data-comment-owner-id="2129574" data-comment-score="3"> <div class="js-comment-actions comment-actions"> <div class="comment-score js-comment-edit-hide"> <span title="number of 'useful comment' votes received" class="warm">3</span> </div> </div> <div class="comment-text js-comment-text-and-form"> <a name="comment114877424_64978030"></a> <div class="comment-body js-comment-edit-hide"> <span class="comment-copy">Very simple and essential remedy: use a prepared statement.</span> – <a href="../../users/2129574/tim-morton" title="2,614 reputation" class="comment-user ">Tim Morton</a> <span class="comment-date" dir="ltr"><a class="comment-link" href="../../questions/64978030/textarea-will-sometimes-not-post-and-other-times-it-will#comment114877424_64978030"><span title="2020-11-23T23:28:18.760 License: CC BY-SA 4.0" class="relativetime-clean">Nov 23 '20 at 23:28</span></a></span> </div> </div> </li> <li id="comment-114877474" class="comment js-comment " data-comment-id="114877474" data-comment-owner-id="2129574" data-comment-score="2"> <div class="js-comment-actions comment-actions"> <div class="comment-score js-comment-edit-hide"> <span title="number of 'useful comment' votes received" class="warm">2</span> </div> </div> <div class="comment-text js-comment-text-and-form"> <a name="comment114877474_64978030"></a> <div class="comment-body js-comment-edit-hide"> <span class="comment-copy">see https://phpdelusions.net/mysqli</span> – <a href="../../users/2129574/tim-morton" title="2,614 reputation" class="comment-user ">Tim Morton</a> <span class="comment-date" dir="ltr"><a class="comment-link" href="../../questions/64978030/textarea-will-sometimes-not-post-and-other-times-it-will#comment114877474_64978030"><span title="2020-11-23T23:31:00.637 License: CC BY-SA 4.0" class="relativetime-clean">Nov 23 '20 at 23:31</span></a></span> </div> </div> </li> <li id="comment-114877544" class="comment js-comment " data-comment-id="114877544" data-comment-owner-id="2129574" data-comment-score="2"> <div class="js-comment-actions comment-actions"> <div class="comment-score js-comment-edit-hide"> <span title="number of 'useful comment' votes received" class="warm">2</span> </div> </div> <div class="comment-text js-comment-text-and-form"> <a name="comment114877544_64978030"></a> <div class="comment-body js-comment-edit-hide"> <span class="comment-copy">and better yet, imo, [use pdo](https://phpdelusions.net/pdo)</span> – <a href="../../users/2129574/tim-morton" title="2,614 reputation" class="comment-user ">Tim Morton</a> <span class="comment-date" dir="ltr"><a class="comment-link" href="../../questions/64978030/textarea-will-sometimes-not-post-and-other-times-it-will#comment114877544_64978030"><span title="2020-11-23T23:35:10.897 License: CC BY-SA 4.0" class="relativetime-clean">Nov 23 '20 at 23:35</span></a></span> </div> </div> </li> <li id="comment-114877640" class="comment js-comment " data-comment-id="114877640" data-comment-owner-id="12994303" data-comment-score="0"> <div class="js-comment-actions comment-actions"> <div class="comment-score js-comment-edit-hide"> </div> </div> <div class="comment-text js-comment-text-and-form"> <a name="comment114877640_64978030"></a> <div class="comment-body js-comment-edit-hide"> <span class="comment-copy">yeah, I did some testing and the textarea can accept every symbol known to man except apostrophes</span> – <a href="../../users/12994303/chess125" title="1 reputation" class="comment-user owner">Chess125</a> <span class="comment-date" dir="ltr"><a class="comment-link" href="../../questions/64978030/textarea-will-sometimes-not-post-and-other-times-it-will#comment114877640_64978030"><span title="2020-11-23T23:41:49.323 License: CC BY-SA 4.0" class="relativetime-clean">Nov 23 '20 at 23:41</span></a></span> </div> </div> </li> <li id="comment-114877695" class="comment js-comment " data-comment-id="114877695" data-comment-owner-id="12994303" data-comment-score="0"> <div class="js-comment-actions comment-actions"> <div class="comment-score js-comment-edit-hide"> </div> </div> <div class="comment-text js-comment-text-and-form"> <a name="comment114877695_64978030"></a> <div class="comment-body js-comment-edit-hide"> <span class="comment-copy">Thanks for the link. Tim Morton</span> – <a href="../../users/12994303/chess125" title="1 reputation" class="comment-user owner">Chess125</a> <span class="comment-date" dir="ltr"><a class="comment-link" href="../../questions/64978030/textarea-will-sometimes-not-post-and-other-times-it-will#comment114877695_64978030"><span title="2020-11-23T23:44:15.033 License: CC BY-SA 4.0" class="relativetime-clean">Nov 23 '20 at 23:44</span></a></span> </div> </div> </li> </ul> </div> </div> </div> </div> <div id="answers"> <a name="tab-top"></a> <div id="answers-header"> <div class="answers-subheader grid ai-center mb8"> <div class="grid--cell fl1"> <h2 class="mb0" data-answercount="9">0 Answers<span style="display:none;" itemprop="answerCount">0</span></h2> </div> </div> </div> </div> </div> </div> </div> <script src="../../static/js/stack-icons.js"></script> <script src="../../static/js/fromnow.js"></script> </body> </html>