Databases
StackOverflow2013
Postsdbo
POPhpmyadmin SQL result doesn't give the proper result
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPhpmyadmin SQL result doesn't give the proper result
    text
    copied!<p>I'm using PHPMyAdmin to manage my database, and I'm currently trying to use one for a project for school.</p> <p>I'm using a TinyMCE text editor to make people add text. This eventually get stored into the database with some &lt;> attached.</p> <p>When I want the user to look into his written review, he sees the following <a href="http://i.imgur.com/zp3kupn.png" rel="nofollow">http://i.imgur.com/zp3kupn.png</a>.</p> <p>I want the <code>&lt;p&gt;</code> to be gone. But it's right from the database. </p> <p>The code I'm using is the following: </p> <pre><code>} else { $code = $_POST['view_id']; $sql = 'SELECT * FROM review WHERE `Reviewnr` = :code '; $std = maakConnectie()-&gt;prepare($sql); $std-&gt;bindValue (":code", $code, PDO::PARAM_STR); $std-&gt;execute(); $result = $std-&gt;fetchAll(PDO::FETCH_ASSOC); if(count($result) ==0) { echo 'U heef geen review geschreven, &lt;a href="schrijven_review.php"&gt;Klik hier &lt;/a&gt; om een review te schrijven'; } else { echo '&lt;table&gt;'; foreach ($result as $index =&gt; $value){ $code = $value['Reviewnr']; echo ' &lt;tr&gt; &lt;td class="bold"&gt; Review nr: &lt;/td&gt; &lt;td&gt; '.$value['Reviewnr'].'&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="bold"&gt; Laatst gewijzigd op: &lt;/td&gt; &lt;td&gt; '.$value['Laatste_wijzigingsdatum'].'&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="bold"&gt; Geplaatst op:&lt;/td&gt; &lt;td&gt;'. $value['Plaatsings_datum'].'&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td class="bold"&gt; Titel: &lt;/td&gt; &lt;td&gt;'. $value['Titel'].'&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;table&gt; &lt;tr&gt; &lt;td class="bold"&gt; Review: &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;textarea readonly style="resize: none" rows="10" cols="50" name="review"&gt;'. $value['Inhoud'].'&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; '; } echo '&lt;/table&gt; </code></pre> <p>The textarea where it's all about but I figured I post something more so you know it's print from the database.</p> <p>Please help me get rid of the "&lt; p>" in the text area. </p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload