<?php

$DB_host = "localhost";
$DB_user = "root";
$DB_pass = "";
$DB_name = "new";
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf-8');
try
{
	$DB_con = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);
	$DB_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	$DB_con->exec('SET NAMES utf8');
}
catch(PDOException $e)
{
	$e->getMessage();
}
?>
 <?php
$stmt = $DB_con->query("SELECT * FROM strela    ");

while ($row = $stmt->fetch())
{



   echo'
        <form  method="post">
            <input type="text" name="name"  value="'.$row['name'].'">
            <input type="text" name="desc"   value="'.$row['desc'].'">
            <input type="hidden" name="del"  value="'.$row['id'].'">
            <input type="submit" name="delete" value="del">
            <input type="hidden" name="upd" size="1" value="'.$row['id'].'">
            <input type="submit" name="update" value="REdact">
        </form>
    ';

}

?>
<?php
    if(isset($_POST['delete'])){
    $del = $_POST['del'];
    $sql = "DELETE FROM strela WHERE id = '$del'";
    $stmt = $DB_con->query($sql);
    }
    if(!$stmt) {
    exit("Не удалось удалить строку из таблицы");
    } else {
       echo"Удалено";
    }
?>
<?php
    if(isset($_POST['update'])){
    $id = $_POST['upd'];
    $name = $_POST['name'];
    $desc = $_POST['desc'];

    $stmt = $DB_con->prepare("UPDATE strela SET name =:name, desc = :name  WHERE id=:id'");
    var_dump($name);
    var_dump($desc);
    var_dump($id);
    $stmt->bindParam(':name', $name, PDO::PARAM_STR,100);
    $stmt->bindParam(':desc', $desc, PDO::PARAM_STR);
    $stmt->execute();
    }
?>