Connect with us

WEB SOLUTIONS DONE

how to get single row record in php with mysql

mysql

how to get single row record in php with mysql

 

 

 

 

 

 

 

 

how to get single row record in php with mysql

<?php

echo “<div>”;
echo “<table>”;
echo “<tr><th>ID</th><th>First Name</th><th>Last Name</th><th>Cnic</th><th>Cell no</th><th>house address</th><th>business address</th><th>email</th><th>asset name</th><th>asset value</th><th>advance</th><th>installment</th><th>tenure</th><th>Guaranter address</th><th>Gu no</th></tr>”;

if ($result = mysqli_query($connect,”SELECT * FROM user_info ORDER BY id”))

while($row = mysqli_fetch_array($result)) {
    echo “<tr>”;
    echo “<td>”.$row[‘id’].”</td>”;
    echo “<td>”.$row[‘f_name’].”</td>”;
    echo “<td>”.$row[‘l_name’].”</td>”;
    echo “<td>”.$row[‘cnic’].”</td>”;
    echo “<td>”.$row[‘cell_no’].”</td>”;
    echo “<td>”.$row[‘h_address’].”</td>”;
    echo “<td>”.$row[‘b_address’].”</td>”;
    echo “<td>”.$row[’email’].”</td>”;
    echo “<td>”.$row[‘asset_name’].”</td>”;
    echo “<td>”.$row[‘asset_value’].”</td>”;
    echo “<td>”.$row[‘advance’].”</td>”;
    echo “<td>”.$row[‘tenure’].”</td>”;
    echo “<td>”.$row[‘installment’].”</td>”;
    echo “<td>”.$row[‘guaranteer_address’].”</td>”;
    echo “<td>”.$row[‘guaranteer_no’].”</td>”;
    
 
  echo “</tr>”;
 
  echo “</table>”;
  echo “</div>”;
}

?>

Continue Reading
You may also like...

More in mysql

Advertisement




To Top