Untitled

<html>
<head>
<title>insert data in database using PDO (php data object)</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>

<div id="main">
<h2>Input Data</h2>
<div id="login">
<h2>Data Mata Pelajaran</h2>
</hr>
<form action="" method="post">
<label>Nama:</label>
<input type="text" name="nama" id="name" required"="required"
placeholder="Mata Pelajaran"/><br /><br />
<label>Jurusan:</label>
<input type="text" name="nama" id="name" required"="required"
placeholder="Jurusan"/><br /><br />
<label>Kelas:</label>
<input type="text" name="nama" id="name" required"="required"
placeholder="Kelas"/><br /><br />
<input type="submit" value=" simpan data" name="submit"/><br />
</form>
</div>
<!-- Right Side Div -->

</div>
<?php
if(isset($_POST["submit"])){
$hostname='localhost';
$username='root';
$password='';

try {
$dbh = new PDO
("mysql:host=$hostname;dbname=eresha",$username,$password);

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //<== add this line
$sql = "INSERT INTO mahasiswa (nama, jurusan)
VALUES ('".$_POST["nama"]."','".$_POST["jurusan"]."')";
if ($dbh->query($sql)) {
echo "<script type= 'text/javascript'>alert
('New Record Inserted Successfully Inserted.');<script>";
}
else{
echo "<script type= 'text/javascript'>alert
('Data not Successfully Inserted.');</script>";
}
header("location:datamhs.php");
$dbh = null;
}
catch(PDOException $e)
{
echo $e->getMessage();
}

}