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, Feb 08 '17 at 09: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 http://stackoverflow.com/questions/1053424/how-do-i-get-php-errors-to-display — PhpDude, Feb 08 '17 at 09:48
@PhpDude When I did var_dump every record shows but not in table — RamZes, Feb 08 '17 at 10:42

score 1 · Answer 1 · answered Feb 08 '17 at 11:23

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>

score 0 · Answer 2 · answered Feb 08 '17 at 13:07

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!

PHP - Inputting data into MySQL cell

2 Answers2