Put this in your html file. I use text type on mysql column data. I use textarea when input the text on html. It has some breakline on the data. Then i echo it on regular html. You can see the result on kopsyahaba.com/index.php
<?php $order = array("\r\n", "\n", "\r"); $replace = '<br />'; $ambilintro=mysqli_fetch_array(mysqli_query($con,"SELECT * from home"),MYSQLI_NUM); $databaru=str_replace($order, $replace, $ambilintro[0]); echo $databaru; ?>