How to write PHP code inside a variable output?

Question

I have a user table where I have to display a delete button and I need to make sure the current user cannot delete themselves.
In order to do that, I wrote some code as shown below, but it doesn't work.

The user table appears with the delete button in all the users, but I need to make sure the current user cannot delete their own user account.

while($row = mysqli_fetch_array($result)) {
$output .='<tr>  
            <td>'.$row["user_id"].'</td>  
            <td>'.$row["fullname"].' </td>
            <td>'.$row["user_role"].'</td>
            <td>'.$row["username"].'</td>
            <td>'.$row["password"].'</td> 
            <td>'.$row["branch_id"].'</td>
            <td>'.$row["registered_date"].'</td>  
            <td>
                <button id="'.$row["user_id"].'" class="btn btn-warning btn-xs edit_data"><i class="fa fa-edit "></i></button>&nbsp;
            if('.$_SESSION['username'].'!='.$row["username"].') {
            <a id="'.$row["user_id"].'"  class="btn btn-danger btn-xs delete"><i class="fa fa-times"></i></a> } </td> 
        </tr>';
}
$output .= '</table>';
echo $output;

why is jquery tagged?? removing it now.

bipen
– bipen

2017-11-29 11:47:57 +00:00
Commented Nov 29, 2017 at 11:47 — bipen
– bipen, Commented Nov 29, 2017 at 11:47
need some answer bro??

sagar neupane
– sagar neupane

2017-11-29 11:57:02 +00:00
Commented Nov 29, 2017 at 11:57 — sagar neupane
– sagar neupane, Commented Nov 29, 2017 at 11:57

BritishWerewolf · Accepted Answer · 2017-11-29 12:32:24Z

1

You can not execute PHP in a string, you need to split your string creation.

while ($row = mysqli_fetch_array($result)) {
    $output .='<tr>  
                <td>'.$row["user_id"].'</td>  
                <td>'.$row["fullname"].' </td>
                <td>'.$row["user_role"].'</td>
                <td>'.$row["username"].'</td>
                <td>'.$row["password"].'</td> 
                <td>'.$row["branch_id"].'</td>
                <td>'.$row["registered_date"].'</td>  
                <td>
                    <button id="'.$row["user_id"].'" class="btn btn-warning btn-xs edit_data"><i class="fa fa-edit "></i></button>';
                    if ($_SESSION['username'] != $row["username"]) {
                        $output .= '<a id="'.$row["user_id"].'"  class="btn btn-danger btn-xs delete"><i class="fa fa-times"></i></a>';
                    }
    $output .= '</td></tr>';
}
$output .= '</table>';
echo $output;

edited Nov 29, 2017 at 12:32

BritishWerewolf

3,9785 gold badges34 silver badges54 bronze badges

answered Nov 29, 2017 at 12:02

madalinivascu

32.4k4 gold badges41 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

madalinivascu Over a year ago

@sagarneupane don't forget the green check:)

Atural · Accepted Answer · 2017-11-29 11:59:35Z

Since you output your variable right after the loop - you can do the following

<table>
<?php
while($row = mysqli_fetch_array($result))
{
?>
    <tr>
        <td><?=$row['user_id']; ?></td>
        <td><?=$row['fullname']; ?></td>
        <td><?=$row['user_role']; ?></td>
        <td><?=$row['username']; ?></td>
        <td><?=$row['password']; ?></td>
        <td><?=$row['branch_id']; ?></td>
        <td><?=$row['registered_date']; ?></td>
        <td>
        <?php
        if($_SESSION['username'] != $row['username'])
        {
        ?>
         <a id="<?=$row['user_id']; ?>"  class="btn btn-danger btn-xs delete"><i class="fa fa-times"></i></a>
        <?php
        }
        ?>
        </td>
    </tr>
<?php
}
?>
</table>

Collectives™ on Stack Overflow

How to write PHP code inside a variable output?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related