PHP - Inputting data into MySQL cell

Question

I am trying put row['user'] into cell but it doesn't work.

When I uncomment "echo" it works fine.

PHP:

function mod_Something($database)
{
    $sql = "SELECT user FROM table_name";
    if ($result = mysqli_query($database, $sql)) {
        while ($row = mysqli_fetch_assoc($result)) {
            $html = $html . '<tr><td>' . $row['user'] . '</td></tr>';
            // echo $row['user'];
        }
    return $html;
    }
}

I also have a HTML view file where I have:

<table id="data-table-basic" class="table table-striped">
    <thead>
    <tr>
        <th>user</th>
    </tr>
    </thead>
    <tbody>
         %mod_Something%
    </tbody>
</table>

I know that HTML isn't a function but I must return it because there is a script which allows to return "view".

You might want to define $html before the while loop, otherwise the first time it tries to prepend it to the table row it doesn't exist. Also, try changing the final return $html to echo $html — jonners99
– jonners99, Commented Feb 8, 2017 at 9:46
rather than echo do a var_dump() and let us know the output, also set error reporting on it will tell you whats up stackoverflow.com/questions/1053424/… — PhpDude
– PhpDude, Commented Feb 8, 2017 at 9:48

PhpDude · Accepted Answer · 2017-02-08 11:23:11Z

1

try this:

   function mod_Something($database)
    {
        $sql = "SELECT user FROM table_name";
        if ($result = mysqli_query($database, $sql)) {
            while ($row = mysqli_fetch_assoc($result)) {
                echo '<tr><td>' . $row['user']; . '</td></tr>';
            }
        return $html;
        }
    }


<table id="data-table-basic" class="table table-striped">
    <thead>
    <tr>
        <th>user</th>
    </tr>
    </thead>
    <tbody>
         <?php mod_Something(); ?>
    </tbody>
</table>

answered Feb 8, 2017 at 11:23

PhpDude

1,6102 gold badges21 silver badges34 bronze badges

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

Comments

Niklesh_Chauhan · Accepted Answer · 2017-02-08 13:07:05Z

0

You are not getting anything from the function mod_Something because you are not building & returning HTML properly. See the below code.

function mod_Something($database)
{
    $html = "";
    $sql = "SELECT user FROM table_name";
    if ($result = mysqli_query($database, $sql)) {
        while ($row = mysqli_fetch_assoc($result)) {
            $html .= '<tr><td>' . $row['user'] . '</td></tr>';            
        }    
    }
    return $html;
}

Hope this works for you!

answered Feb 8, 2017 at 13:07

Niklesh_Chauhan

6575 silver badges16 bronze badges

Collectives™ on Stack Overflow

PHP - Inputting data into MySQL cell

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related