求PHP添加代码

[nihao_110]

<input type="submit" name="submit" value="添加">

$db_host="127.0.0.1:3306";
$db_user="root";
$db_psw="";
$db_name="mysql";
$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");
mysql_select_db($db_name,$connection)or die("选择数据库失败");
mysql_close($connection);

[CunningBoy]

你要添加啥？

[nihao_110]

CREATE TABLE IF NOT EXISTS `hotel_activities_2` (
  `h_id` int(11) NOT NULL auto_increment,
  `hotel_id` int(11) default NULL,
  `start_date` timestamp NULL default NULL,
  `end_date` timestamp NULL default NULL,
  `content` text,
  `source` varchar(20) default NULL,
  `s_type` int(11) default NULL,
  PRIMARY KEY  (`h_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

这是我建的表往字段里添加

[nihao_110]

<form action="" method="post">
<table>
<tr>
<td>酒店名:</td>
<td><input type="text" name="hotel_id" value=""></td>
</tr>
<tr>
<td>入住时间:</td>
<td><input type="text" name="start_date" value=""></td>
</tr>
<tr>
<td>离店时间:</td>
<td><input type="text" name="end_date" value=""></td>
</tr>
<tr>
<td>content:</td>
<td><input type="text" name="content" value=""></td>
</tr>
<tr>
<td>source:</td>
<td><input type="text" name="content" value=""></td>
</tr>
<tr>
<td>s_type:</td>
<td><input type="text" name="s_type" value=""></td>
</tr>
<tr>
 <td colspan="3" align="center"><input type="submit" name="submit" value="添加"> 
 </td>
</tr>
</table>
</form>

[Dleno]

mysql_query("insert into `hotel_activities_2` set `hotel_id`='{$_POST[hotel_id]}',`start_date`='{$_POST[start_date]}',`end_date`='{$_POST[end_date]}',`content`='{$_POST[content]}',`source`='{$_POST[source]}',`s_type`='{$_POST[s_type]}'");

[CunningBoy]

<?php
$db_host="127.0.0.1:3306";
$db_user="root";
$db_psw="";
$db_name="mysql";
$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");
mysql_select_db($db_name,$connection)or die("选择数据库失败");
$sql = "insert into `hotel_activities_2` set `hotel_id`='{$_POST[hotel_id]}',`start_date`='{$_POST[start_date]}',`end_date`='{$_POST[end_date]}',`content`='{$_POST[content]}', `source`='{$_POST[source]}',`s_type`='{$_POST[s_type]}')"; 
mysql_query($sql);
mysql_close($connection);
?>

[nihao_110]

hotel_id`='{$_POST[hotel_id]}是什么意思能解释解释么
是不是相当与.net中的 hotel_id.text

[nihao_110]

还是不行啊 添加不进去 也不报错
<form action="login.php" method="post">
<table>
<tr>
<td>酒店名:</td>
<td><input type="text" name="hot" value=""></td>
</tr>
<tr>
<td>入住时间:</td>
<td><input type="text" name="start" value=""></td>
</tr>
<tr>
<td>离店时间:</td>
<td><input type="text" name="end" value=""></td>
</tr>
<tr>
<td>content:</td>
<td><input type="text" name="ctn" value=""></td>
</tr>
<tr>
<td>source:</td>
<td><input type="text" name="sre" value=""></td>
</tr>
<tr>
<td>s_type:</td>
<td><input type="text" name="s_tp" value=""></td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="submit" value="添加">
</td>
</tr>
</table>
</form>

<?php
$db_host="127.0.0.1:3306";
$db_user="root";
$db_psw="";
$db_name="mysql";
$connection=mysql_connect($db_host,$db_user,$db_psw)or die("连接服务器失败");
mysql_select_db($db_name,$connection)or die("选择数据库失败");

$sql = mysql_query("insert into `hotel_activities_2` set `hot`='{$_POST[hot]}',`start`='{$_POST[start]}',`end`='{$_POST[end]}',`ctn`='{$_POST[ctn]}', `sre`='{$_POST[sre]}',`s_tp`='{$_POST[s_tp]}')"); 
mysql_close($connection);
?>