CODEWITHSUNDEEP
phphtml
Jason
Jason

Reputation: 1

How to print PHP syntax in HTML

I dont know the correct syntax to print out the values from the database after the Get values button is submitted without getting the Invalid argument supplied error.. please help

<form action="index.php" method="post">
<input type="text" name="user_name" placeholder="User Name">
<input type="text" name="first_name" placeholder="First Name">
<input type="email" name="email" placeholder="email">
<input type="submit" name='submit' value="Submit">
<input type="submit" name='seeDatabase' value="Get Values">
</form>

<table>
<tr>
    <th>User_Name   </th>
    <th>First_Name  </th>
    <th>Email</th>
</tr>
<?php
$sqlSelect = "Select * From user";
$myResult2 = $connection->query($sqlSelect);
foreach ($myResult2 as $item): ?>
<tr>
    <td><?php echo $item['user_name'] ?></td>
    <td><?php echo $item['first_name'] ?></td>
    <td><?php echo $item['email'] ?></td>
    <td>
        <form action="delete.php" method="post">
        <input type="hidden" name="userName" value="<?php echo                      
      $item['user_name']  ?>">
        <input type="submit" name="delete" value="Delete">
        </form>
    </td>
</tr>
<?php endforeach; ?>
</table>

Upvotes: 0

Views: 45

Answers (1)

Rotimi
Rotimi

Reputation: 4825

You need to check if the array is empty before looping to prevent getting the invalid argument error

if(!empty($myResult2) && count($myResult2) > 0) {
//you can loop over 
foreach ($myResult2 as $item) {
//foreach stuff
}
} else {
//array is empty 
echo 'no result found';
}

Upvotes: 1

Related Questions