I’m new to stack overflow and I’m still a beginner at PHP/Web Development so please bear with me. I have a simple blogging application that requires 5 forms but only one needs WYSIWYG (description). My PHP should be fine for inserting the actual data:
// Prepare the query
$insert_query = "INSERT INTO characters (name,rarity,constellation,affiliation,description, element_id, image_id, url) VALUES (:name,:rarity,:constellation,:affiliation,:description, :element,:id, :url)";
// Prepare the databaase object
$statement = $db->prepare($insert_query);
//print_r($sanitized_post);
// Bind values to the placeholders
$statement->bindValue(':name', $sanitized_post['name']);
$statement->bindValue(':rarity', $sanitized_post['rarity']);
$statement->bindValue(':constellation', $sanitized_post['constellation']);
$statement->bindValue(':affiliation', $sanitized_post['affiliation']);
$statement->bindValue(':description', $sanitized_post['description']);
$statement->bindValue(':element', $sanitized_post['element']);
$statement->bindValue(':id', $imageID, PDO::PARAM_INT);
$statement->bindValue(':url', slug($url));
And the HTML forms for my fields look like this:
<!-- Main post form -->
<div class="form-group">
<form method='post' enctype='multipart/form-data'>
<p>
<label for="name">Name</label>
<input name="name" id="name" />
</p>
<p>
<label for="rarity">Rarity</label>
<input name="rarity" id="rarity" />
</p>
<p>
<label for="constellation">Constellation</label>
<input name="constellation" id="constellation" />
</p>
<p>
<label for="affiliation">Affiliation</label>
<input name="affiliation" id="affiliation" />
</p>
<p>
<label>Description</label>
<textarea name="description" id="description" class="form-control"></textarea>
<script>
$('#description').summernote({
placeholder: 'Text',
tabsize: 2,
height: 100,
toolbar: [
['style', ['style']],
['font', ['bold', 'underline', 'clear']],
['color', ['color']],
['para', ['ul', 'ol', 'paragraph']],
['table', ['table']],
['insert', ['link', 'picture', 'video']],
['view', ['fullscreen', 'codeview', 'help']]
]
});
</script>
</p>
On my view.php, my data is returned like so:
<ul>
<li>Rarity: <?=$row['rarity']?></li>
<li>Constellation: <?=$row['constellation']?></li>
<li>Affiliation: <?=$row['affiliation']?></li>
<li>Vision: <?=$row['element']?></li>
<h2><?= $row['description'] ?></h2>
But for some reason, on my view.php if I were to type “aaaaa”, it would print out as:
<p>aa<b>a</b>aa</p>
Which is odd, my peers confirm their code is functionally very similar to mine and they didn’t have this issue.
My tag in the HTML includes this:
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/3.4.1/js/bootstrap.min.js"></script>
<!-- include summernote css/js -->
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/summernote.min.css" rel="stylesheet">
<script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/summernote.min.js"></script>
Please, any help is appreciated. My summernote is about 90% implemented. This appears to be the final roadblock.
