Форумы портала PHP.SU :: Версия для печати :: Вывод данных с возможностью редактирования

Страниц (1): [1]

1. alezander - 15 Февраля, 2017 - 20:07:59 - перейти к сообщению

Проблема в следующем имееться список операций к примеру в поле № договора (отметил красным на скрине ) есть записи котрая записанна через пробел так вот часть текста не выводиться в чем проблема и как это можно решить ?

Спойлер (Отобразить)

CODE (htmlphp):
скопировать код в буфер обмена

                        <?php
                        $id = $_GET['id'];
                                $query = mysqli_query($connection,"SELECT kassa.id, kassa.numberdocument, kassa.numberagreement, kassa.nameofclient, nameofbase.nameofbase, kassa.base, kassa.coming, kassa.consumption, kassa.bodyloan, kassa.interest, kassa.fine, kassa.well, kassa.date, kassa.idofoffice, kassa.idofuser, kassa.dateofpost FROM kassa INNER JOIN nameofbase ON nameofbase.idofbase = kassa.base  WHERE `id`='$id'"); //выборка
                        while($row = mysqli_fetch_array($query)):
        Print "<form action=editkassa.php method=post>";
        Print "<tr>";
    Print "<td>" . "<input type=number name=id value=" . $row['id'] . " </td>";
    Print "<td>" . "<input type=number name=numberdocument value=" . $row['numberdocument'] . " </td>";
    Print "<td>" . "<input type=text name=numberagreement value=" . $row['numberagreement'] . " </td>";
    Print "<td>" . "<input type=text name=nameofclient value=" . $row['nameofclient'] . " </td>";
    Print "<td>" . "<input type=text name=base value=" . $row['base'] . " </td>";
    Print "<td>" . "<input type=number name=coming step=0.01 value=" . $row['coming'] . " </td>";
    Print "<td>" . "<input type=number name=consumption step=0.01 value=" . $row['consumption'] . " </td>";
    Print "<td>" . "<input type=number name=bodyloan step=0.01 value=" . $row['bodyloan'] . " </td>";
    Print "<td>" . "<input type=number name=interest step=0.01 value=" . $row['interest'] . " </td>";
    Print "<td>" . "<input type=number name=fine step=0.01 value=" . $row['fine'] . " </td>";
    Print "<td>" . "<input type=number name=well step=0.01 value=" . $row['well'] . " </td>";
    Print "<td>" . "<input type=date name=date value=" . $row ['date'] . " </td>";
    Print "<td>" . "<input type=submit name=update value=обновить" . " </td>";
        Print '</tr>';
        Print "</form>";
                    endwhile;

$query = mysqli_query($connection,"SELECT kassa.id, kassa.numberdocument, kassa.numberagreement, kassa.nameofclient, nameofbase.nameofbase, kassa.base, kassa.coming, kassa.consumption, kassa.bodyloan, kassa.interest, kassa.fine, kassa.well, kassa.date, kassa.idofoffice, kassa.idofuser, kassa.dateofpost FROM kassa INNER JOIN nameofbase ON nameofbase.idofbase = kassa.base WHERE `id`='$id'"); //выборка

while($row = mysqli_fetch_array($query)):

$form = '<form action="editkassa.php" method="post">';

$form .= '<td><input type="number" name="id" value="' . $row['id'] . '" /> </td>';

$form .= '<td><input type="number" name="numberdocument" value="' . $row['numberdocument'] . '" /></td>';

$form .= '<td><input type="text" name="numberagreement" value="' . $row['numberagreement'] . '" /></td>';

$form .= '<td><input type="text" name="nameofclient" value="' . $row['nameofclient'] . '" /></td>';

$form .= '<td><input type="text" name="base" value="' . $row['base'] . '" /></td>';

$form .= '<td><input type="number" name="coming" step="0.01" value="' . $row['coming'] . '" /> </td>';

$form .= '<td><input type="number" name="consumption" step="0.01" value="' . $row['consumption'] . '" /></td>';

$form .= '<td><input type="number" name="bodyloan" step="0.01" value="' . $row['bodyloan'] . '" /></td>';

$form .= '<td><input type="number" name="interest" step="0.01" value="' . $row['interest'] . '" /></td>';

$form .= '<td><input type="number" name="fine" step="0.01" value="' . $row['fine'] . '" /></td>';

$form .= '<td><input type="number" name="wel"l step="0.01" value="' . $row['well'] . '" /></td>';

$form .= '<td><input type="date" name="date" value="' . $row ['date'] . '" /></td>';

$form .= '<td><input type="submit" name="update" value="обновить" /></td>';