create database cadastro;
use cadastro;
create table funcionarios(
id int not null auto_increment,
nome varchar(30),
cargo varchar(20),
primary key (id)

)default charset = utf8;

<?php
/*Configuration for database connection*/

$host = "localhost";
$username = "root";
$password = "";
$dbname = "cadastro";
$dsn = "mysql:host=$host;dbname=$dbname";
$options = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);

?>

<?php include "templates/header.php"; ?>

<form>
    <label for="firstname">First Name</label>
    <input type="text" name="firstname" id="firstname">
    <label for="profession"> profession </label>
    <input type="text" name="profession" id="profession">
    <input type="submit" name="submit" value="submit"><br><br>
</form>
<?php
    if(isset($_POST['submit'])){
        require "config.php";

        try {

            $connection = new PDO($dsn,$username,$password,$options);
            $new_user = array(
            "fistname" => $_POST['firstname'],
            "profession" => $_POST['profession']
            );



            $sql = sprintf(
                    "INSERT INTO %s (%s) VALUES (%s)",
                    "funcionarios",
                    implode(",", array_keys($new_user)),
                    ":".implode(", :", array_keys($new_user))
            );
            $statement = $connection->prepare($sql);
            $statement->execute($new_user);

        } catch (PDOException $error) {

            $error -> getMessage();

        }
    }

 ?>

<a href="index.php"><input type="submit" name="btnHome" value="Home"></a>  Back to Home

<?php include "templates/footer.php"; ?>