Im trying to input data to an sql database through a html submit button however I cant quite get it to work. I've looked at the other answers on here and I cant seem to get them to work either. I'm fairly certain that I have the column names are correct. where am I going wrong and are there any better ways of approaching this problem?
<?php
include('session.php');
if(isset($_POST['addHomework'])){
$link = mysqli_connect('host','user','userpw','database');
$class = mysqli_real_escape_string($link,$_POST['classDropdown']);
$dueDate = date('y-m-d', strtotime($_POST['dueDate']));
$title = mysqli_real_escape_string($link, $_POST['homeworkTitle']);
mysqli_query($link, "INSERT INTO events ('title', 'duedate', `event_id`) VALUES('$title', '$dueDate', '')");
}
?>
and this iis my html
<head>
<link type="text/css" href="css/ui-lightness/jquery-ui-1.9.1.custom.min.css" rel="stylesheet" />
<script src="https://code.jquery.com/jquery-1.10.2.js"></script>
<title>The Memory Bank</title>
<meta name="description" content="website description" />
<meta name="keywords" content="website keywords, website keywords" />
<meta http-equiv="content-type" content="text/html; charset=windows-1252" />
<link rel="stylesheet" type="text/css" href="style.css" title="style" />
</head>
<body>
<div id="main">
<div id="header">
<div id="logo">
<div id="logo_text">
<h1>The Memory Bank</h1>
</div>
</div>
<div id="menubar">
<ul id="menu">
<li ><a href="teacherWelcome.php">Home</a></li>
<li><a href="student.php">Classes</a></li>
<li class="selected"><a href="homework.php">Homework</a></li>
<li><a href="parent.php">Feedback</a></li>
<li><a href="HoD.php">Head of Department</a></li>
<li><a href="logout.php">Log Out</a></li>
</ul>
</div>
</div>
<aside>
<div id="site_content">
<h1>Welcome
<?php
echo $row['username'];
?>
</h1>
<form name ="addHomework" method="POST" action="homework.php">
<p>Enter in a title for your homework:<br/>
<input type="text" name ="homeworkTitle" value="" maxlength="45"></P>
<p>Enter a duedate for your homework:<br/>
<input type="date" name ="dueDate" value="" maxlength="45"></P>
<p>Select a Class:<br/>
<select name="classDropdown">
<?php
include ('classlist.php');
$classlist = new Classlist ();
echo $classlist -> show();
?>
</select>
<p><input type="submit" name="commit" id="commit" value="Add Homework"/></p>
</form>
</div>
</aside>
</script>
</div>
</div>
</div>
<div id="footer">
</div>
</div>
</body>
</html>