I'm not very good with php or mysql so I can't figure out what I'm doing wrong.
I get this error: Failed You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tests,'20120508,'5.5,'20120508)' at line 1
I'm using WAMP. MySQL 5.5.16 and PHP 5.3.8
The following is my script.
<html>
<head>
<style type="text/css">
body{
background-color: #000;
font-family: "Arial";
color: #fff;
}
#mainwrapper{
width: 1024px;
background-color: #a1a1a1;
margin-left:auto;
margin-right:auto;
padding: 5px;
}
</style>
</head>
<body>
<div id="mainwrapper">
<form name="projectEnter" method="post" action="includes/progress-form.php">
<table width="800" border="0">
<tr>
<td>Project Name</td>
<td><label for="projectName"></label>
<input type="text" name="projectName" id="projectName"></td>
</tr>
<tr>
<td>Date Started (YYYY-MM-DD)</td>
<td><label for="dateStarted"></label>
<input type="text" name="dateStarted" id="dateStarted"></td>
</tr>
<tr>
<td>Completion Estimation</td>
<td><label for="completeEstimation"></label>
<input type="text" name="completeEstimation" id="completeEstimation"></td>
</tr>
<tr>
<td>Date Closed (YYYY-MM-DD)</td>
<td><label for="dateClosed"></label>
<input type="text" name="dateClosed" id="dateClosed"></td>
</tr>
</table>
<input type="submit" name="submit" id="submit" value="Submit">
</form>
</div>
</body>
</html>
USER and PASS both have the correct user information. Just didn't want to post it here.
<?php
$conn = mysql_connect("localhost","USER","PASS");
$db = mysql_select_db("project_progress",$conn);
?>
<?php
# Variables for field names.
$_projectName = $_POST['projectName'];
$_dateStarted = $_POST['dateStarted'];
$_completeEstimation = $_POST['completeEstimation'];
$_dateClosed = $_POST['dateClosed'];
# Inserting information into table.
$sql = "INSERT INTO progress values(".$_projectName.",'".$_dateStarted.",'".$_completeEstimation.",'".$_dateClosed.")";
$query = mysql_query($sql);
if (!$query) {
echo "Failed " .mysql_error();
} else {
echo "Data entered ";
}
?>
projectName is varchar(50)
dateStarted is date
completeEstimation is float
dateClosed is date
I want to put validation in my script too, but right now I'm just trying to get it to insert into the table.
