Menu
I'm retrieving data from the database using an unique id. Now the problem is, all the values are being retrieved and are being printed in a single line. I want them below one another. I tried "
" "\n
" and also nl2br. If anyone could help me. Thanks in advance.
PHP file:
<?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'DB';
$db = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if(mysqli_connect_errno())
{
die("connection couldn't be established");
}
if(isset($_POST['EnrNo']) === true && empty($_POST['EnrNo']) === false) {
//$Enr = $_POST['EnrNo'];
$EnrNo = mysql_real_escape_string ($_POST['EnrNo']);
$query = "Select * FROM cert WHERE EnrNo = '$EnrNo'";
$result = $db->query($query);
$total_num_rows = $result->num_rows;
while ($row=$result->fetch_array())
{
echo ("EnrNo: " .$row["EnrNo"]);
echo ("Name: " .$row["Name"]);
echo ("Batch Code: " .$row["Batch Code"]);
echo ("Start Date: " .$row["Start Date"]);
echo ("End Date: ".$row["End Date"]);
echo ("Course: " .$row["Course"]);
echo ("Duration: " .$row["Duration"]);
} mysqli_free_result($result);
} else {
echo ('Data not found');
};
?>
HTML file:
<!DOCTYPE html>
<html>
<head>
</head>
<body>
Enr No: <input type="text" name="EnrNo" id="EnrNo" /><br/><br />
<input type="submit" name="retrieve" value="retrieve" id="EnrNo-sub" />
<div id="EnrNo-data"></div>
<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>
<script type="text/javascript">
$('input#EnrNo-sub').on('click', function() {
var EnrNo = $('input#EnrNo').val();
if (EnrNo != '') {
$.post('retrieve.php', {EnrNo: EnrNo}, function(data) {
$('div#EnrNo-data').text(data);
});
}
});
</script>
</body>
</html>
525
asked Dec 04 '25 10:12
Try "
", instead of "\n",
Example:
echo "Value1 :".$value1."<br>";
echo "Value2 :".$value2."<br>";
echo "Value3 :".$value3."<br>";
echo "Value4 :".$value4."<br>";
echo "Value5 :".$value5."<br>";
Did you simply try:
echo ("Duration: " .$row["Duration"]."<br>");
\n is only visible in the source code, while <br> affects the html.
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
