自学php,也看了一些解决的方法,但还是不行。遇到以下情况,不能成功向添加数据到数据库里,希望大神指点。这是我的表


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>
<body>
<form method="POST">
<table>
<tr><td>c_id</td><td><input type="c_id" size="20"></td></tr>
<tr><td>c_name</td><td><input type="c_name" size="20"></td></tr>
<tr><td>sector</td><td><input type="sector" size="50"></td></tr>
<tr><td>e_address</td><td><input type="e_address" size="50"></td></tr>
<tr><td>mail_address</td><td><input type="mail_address" size="50"></td></tr>
<tr><td>classification</td><td><input type="classification" size="50"></td></tr>
<tr><td>started_date</td><td><input type="started_date" size="50"></td></tr>
<tr><td>contact</td><td><input type="contact" size="50"></td></tr>
<tr><td>con_address</td><td><input type="con_address" size="50"></td></tr>
<tr><td><input type="Submit" value="添加"></td></tr>
</table>
</form>
<?php
$db = mysql_connect("localhost", "root", "root");
mysql_select_db("test", $db);
if(isset($_POST['submit'])&&$_POST['submit'])
{
$sql="insert into customers_id(c_id,c_name,sector,e_address,mail_address,classification,started_date,contact,con_address)
values('$_POST[c_id]','$_POST[c_name]','$_POST[sector]','$_POST[e_address]','$_POST[mail_address]','$_POST[classification]''$_POST[started_date]','$_POST[contact]','$_POST[con_address]''now()'";
mysql_query($sql);
echo "成功";
}
?>
echo "注册成功";
?>
</body>
</html>
------解决方案--------------------
1、表单控件的定义不对,都改成下面这样的:
<input name="c_id" size="20" type="text">
2、提交按钮没有name值,不会进入if分支里面。
<input type="Submit" value="添加" name="submit">