title: Saving text from Textarea in mysql database with php (apostrophes)
body: <p>html</p>
  
  <pre><code>&lt;form id = "recall_TextArea2" method="post" action="SaveRecall2.php"&gt;
      &lt;center&gt;&lt;textarea name="recall_Info" cols="60" rows="30em"&gt;&lt;/textarea&gt;&lt;/center&gt;
  &lt;/form&gt; 
  </code></pre>
  
  <p>php</p>
  
  <pre><code>if (isset($_POST['recall_Info'])) {
      $recall_Info = $_POST['recall_Info'];
  }
  else {
      echo "nothing was recalled.";
  }
  
  $recall_Info = stripslashes($recall_Info);
  $recall_Info = mysqli_real_escape_string($recall_Info);
  $update_sql = "UPDATE  `participants` SET  `recall_1` =  '$recall_Info' WHERE  `school_id` =825776 LIMIT 1 ;";
  </code></pre>
  
  <p>I want to be able to type in text in the text area that has apostrophes, but every time i try, it doesn't work.</p>
  
  <p>It saves normal text (no apostrophes) when i take out</p>
  
  <pre><code>$recall_Info = stripslashes($recall_Info);
  $recall_Info = mysqli_real_escape_string($recall_Info);
  </code></pre>