my live search in working perfectly, but my tags are not in td. I can't figure out what is the problem. The picture, and the code are below. Thank you in advance. The problem is down there in td, the the tags. how it looks like
enter code here
<?php
@include('./config/constants.php');
$output = '';
if (isset($_POST['query'])) {
$search = $_POST['query'];
$stmt = $conn->prepare("SELECT * FROM clients WHERE full_name LIKE CONCAT('%',?,'%') OR email LIKE CONCAT('%',?,'%')");
$stmt->bind_param("ss", $search, $search);
} else {
$stmt = $conn->prepare("SELECT * FROM clients");
}
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$output = "<tr>
<th>ID</th>
<th>Full Name</th>
<th>E-mail</th>
<th>Phone</th>
<th>City</th>
<th>Address</th>
<th>Actions</th>
</tr>
";
while ($row = $result->fetch_assoc()) {
$output .= "<tr>
<td>" . $row['id'] . "</td>
<td>" . $row['full_name'] . "</td>
<td>" . $row['email'] . "</td>
<td>" . $row['phone'] . "</td>
<td>" . $row['city'] . "</td>
<td>" . $row['address'] . "</td>
<td>"
?>
<a href="<?php echo SITEURL; ?>/update-client.php?id=<?php echo $row['id']; ?>" >Update Client</a>
<a href="<?php echo SITEURL; ?>/delete-client.php?id=<?php echo $row['id']; ?>" >Delete Client</a>
<?php
"</td>
</tr>";
}
echo $output;
} else {
echo "<h3>No Records found!</h3>";
}
CodePudding user response:
You're outputting the links before the table rows.
You output them directly and then later output the rows in the variable $output
.
Remove the ?>
and <?php
tags in your while loop and have the buttons be part of the $output
string
while ($row = $result->fetch_assoc()) {
$output .= "<tr>
<td>" . $row['id'] . "</td>
<td>" . $row['full_name'] . "</td>
<td>" . $row['email'] . "</td>
<td>" . $row['phone'] . "</td>
<td>" . $row['city'] . "</td>
<td>" . $row['address'] . "</td>
<td>" . '<a href="'.SITEURL.'/update-client.php?id='.$row['id'].'" >Update Client</a>'.
'<a href="'.SITEURL.'/delete-client.php?id='.$row['id'];.'" >Delete Client</a>'.
."</td>
</tr>";
}