Блог

Я пытаюсь отобразить имя и возраст в одном поле таблицы, и я хочу, чтобы данные отображались вместо amp;nbsp; . Я попробовал приведенный ниже код, но он не работает.

код:

 <?php
    $con=mysqli_connect("localhost","root","","dva");
    // Check connection
    if (mysqli_connect_errno()) {
       echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    $result = mysqli_query($con,"SELECT * FROM apform");

    while($row = mysqli_fetch_array($result)) {
        echo "My Mood: ";
        echo $row['mood'];
        echo "<br>";
    }
?>

<thead>
    <tr>    
        <th>ID</th>
        <th>Name</th>
        <th>Doctor</th>
        <th>Telephone</th>
        <th>Mobile</th>
        <th>Meeting Time</th>
        <th>Fee</th>
        <th>Date</th>
    </tr>
</thead>
<tbody>
    <tr>
        <td data-title="Name"><span> <?php echo $row['name']; ?> </span></td>
        <td data-title="Relationship"><span>amp;nbsp;</span></td>
        <td data-title="Address"><span>amp;nbsp;</span></td>
        <td data-title="Telephone"><span>amp;nbsp;</span></td>
        <td data-title="Mobile"><span>amp;nbsp;</span></td>
        <td data-title="Contact at night"><span>amp;nbsp;</span></td>
        <td data-title="Next of kin"><span>amp;nbsp;</span></td>
        <td data-title="Delete"><span>amp;nbsp;</span></td>
    </tr>
  

Вы можете легко добиться того, что вам нужно, поместив цикл while внутри вашей таблицы и повторив все соответствующие поля.

 <?php
    $con=mysqli_connect("localhost","root","","dva");
    // Check connection
    if (mysqli_connect_errno()) {
       echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    $result = mysqli_query($con,"SELECT * FROM apform");

    while($row = mysqli_fetch_array($result)) {
        echo "My Mood: ";
        echo $row['mood'];
        echo "<br>";
    }
?>

<thead>
    <tr>    
        <th>ID</th>
        <th>Name</th>
        <th>Doctor</th>
        <th>Telephone</th>
        <th>Mobile</th>
        <th>Meeting Time</th>
        <th>Fee</th>
        <th>Date</th>
    </tr>
</thead>
<tbody>
    <?php while($row = mysqli_fetch_array($result)) { ?>
    <tr>
        <td data-title="Name"><span><?php echo $row['name']; ?></span></td>
        <td data-title="Relationship"><span><?php echo $row['relationship']; ?></span></td>
        <td data-title="Address"><span><?php echo $row['address']; ?></span></td>
        <td data-title="Telephone"><span><?php echo $row['telephone']; ?></span></td>
        <td data-title="Mobile"><span><?php echo $row['mobile']; ?></span></td>
        <td data-title="Contact at night"><span><?php echo $row['contact']; ?></span></td>
        <td data-title="Next of kin"><span><?php echo $row['nok']; ?></span></td>
        <td data-title="Delete"><span><a href="delete/<?php echo $row['id']; ?>">Delete</a></span></td>
    </tr>
    <?php } ?>
</tbody>