<?php
require "admin.php";
?>

<form action="sovetred.php" method="post">
    <?php
    include ('../db.php');

    if(isset($_GET['redid_id'])){


        $ss = 'SELECT * FROM sovet WHERE `id` = '.$_GET['redid_id'];
        $sql = mysqli_query($connection, $ss);
        $result = mysqli_fetch_assoc($sql);


    echo'
    <table>
        <tr>
            <td>name</td>
            <td><input type="text" name="name" value="'.$result['name'].'"></td>
        </tr>
          <tr>
            <td>Совет</td>
            <td><textarea rows="10" cols="50" type="text"  name="sovet">
            '.$result['sovet'].'</textarea></td>
        </tr>
        <tr>
<td><input type="submit" name="save1" value="Сохранить"></td>
 </tr>
</table>
</form>';
    }

?>

<?php

include ('../db.php');
if(!empty($_POST['save1'])) {

        $name = htmlspecialchars($_POST['name']);
        $sovet = htmlspecialchars($_POST['sovet']);


    $sql1 = ' UPDATE sovet
            SET
                       `name` = '.$name.',
                       `sovet` = '.$sovet.'

           WHERE id = '.$result['id'].'

            ';

     $query = mysqli_query($connection, $sql1);

    if ($query) { //если данные отправлены выводим:
            echo 'Запись обновлена';
        }
        else {
            echo 'Ошибка! Запись не обновлена.';
        }
 }
 ?>