Ander probleem, ik probeer een grote tekst over de 2000 tekens naar de database te sturen, maar ik krijg maar 500 tekens naar de database gestuurd.
Nu vraag ik me af waar het aan ligt, is het de database of moet ik iets aan de values doen?
Textarea kan je heel veel tekens in kwijt, maar zodra ik in de bron kijk, stuurt ie maar 500 tekens en de post is over de 2000 tekens, waar of wat moet ik aanpassen/veranderen?
in de database heb ik mediumtext voor de grote tekenreeks
<?php
if($_GET['menu'] == 'bio' && $_GET['action'] == 'write') {
echo "<form action='index.php?menu=bio&action=preview' method='POST'>
<div class='write-grid0'>
<div class='write-item'>
<input type='text' name='title' placeholder='Write a catchy title here'>
</div>
<div class='write-item'>
<textarea name='story' placeholder='Write your advertising story here'></textarea>
</div>
<div class='write-item' id='button-a'><input type='submit' name='submit' value='Preview'>
</div>
</form>";
} elseif($_GET['menu'] == 'bio' && $_GET['action'] == 'preview') {
$pretitle = $_POST['title'];
$prestory = $_POST['story'];
echo "<div class='write-grid'>
<div class='write-item1'>".htmlspecialchars($pretitle)."
<input type='hidden' name='title' value='".$pretitle."'></div>
<div class='write-item2'>".nl2br($prestory, true)."
<textarea hidden name='story' value='".$prestory."'></div>
<div class='write-item'><button id='button-a'><a href='index.php?menu=bio&action=postit'>Post Story</a></button></div>
</div>";
} elseif($_GET['menu'] == 'bio' && $_GET['action'] == 'postit') {
$pretitle = $_GET['title'];
$prestory = $_GET['story'];
$sql = "SELECT * FROM Story WHERE User_ID = ".$_SESSION['ID']."";
$result = mysqli_query($connect, $sql);
$rows = mysqli_num_rows($result);
if($rows == 0) {
$sql = "INSERT INTO Story(User_ID, Title, Bio) VALUES ('".$_SESSION['ID']."', '".$pretitle."', '".$prestory."')";
$result = mysqli_query($connect, $sql);
} else {
$sql = "UPDATE Story SET Title='".$pretitle."', Bio='".$prestory."' WHERE ID = ".$_SESSION['ID']."";
$result = mysqli_query($connect, $sql);
}
} else {
/* Bio view */
$sql = "SELECT * FROM Story WHERE User_ID = ".$_SESSION['ID']."";
$result = mysqli_query($connect, $sql);
$rows = mysqli_num_rows($result);
if($rows == 0) {
echo "<div id='button'><a href='index.php?menu=bio&action=write'>No \"BIO\" set!!<br />Click here to write your story</a></div>";
} else {
$story = mysqli_fetch_all($result, MYSQLI_ASSOC);
foreach($story as $bio) {
$title = $bio['Title'];
$bio = $bio['Bio'];
}
echo"<div class='write-grid'>
<div class='write-item1'>".$title."</div>
<div class='write-item2'>".nl2br($bio,true)."</div>
</div>";
}
}
?>
