Danny_PHP

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
    <br><br>
    <a href="create.php">Създаване</a><br>
    <a href="edit.php">Редактиране</a><br>
    <a href="delete.php">Изтриване</a><br>


</body>
</html>

/*! */

<?php

$host = 'localhost';
$user = 'root';
$pass = '';
$name = 'lab10';

try {
    $db = new PDO("mysql:host={$host};dbname={$name}", $user, $pass);
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

} catch(PDOException $err) {
    echo $err->getMessage();
}

/*! */

<?php

require_once 'config.php';

if(isset($_POST['input'])){
    $zaglavie = $_POST['zaglavie'];
    $avtor = $_POST['avtor'];
    $izda = $_POST['izdatelstvo'];
    $godina = $_POST['godina'];

    $sql = 'INSERT INTO book_info (name_book, author, izdatelstvo, year) VALUES (' . $zaglavie . ', ' . $avtor . ', ' . $izda . ', ' . strtotime($godina) . ')';

    $stmt = $db->prepare($sql);
    $result = $stmt->execute();

    if($result > 0)
        echo "Insert was successful";
    else
        echo "There was a problem.";
}

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
    <form method="post">
        Заглавие: <input type="text" name="zaglavie"/><br>
        Автор: <input type="text" name="avtor"/><br>
        Издателство: <input type="text" name="izdatelstvo"/><br>
        Година: <input type="text" name="godina"/><br>
        <button type="submit" name="input">Въведи</button>
    </form>
</body>
</html>