作者caca33 (sweet heart)
看板PHP
标题[请益] 如何写入资料库
时间Sun Jan 22 21:27:43 2006
先描述我的需求..我是要写网路问卷
选择好选项之後送出到资料库
但是有一个问题就是好像无法写入资料库
在此附上程式码..请各位大大帮忙一下
附注我是用php+appserv+mysql
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5" />
<title>从众</title>
<?
if($a1 and $b1 and $c1 and $d1 and $e1 and $f1 and $g1 and $h1 and $i1 and $j1)
{ //判断新输入的栏位值是否存在
$link_ID= mysql_connect("localhost","root","3230");//连接Mysql伺服器
mysql_select_db("data1");//指定使用data1资料库
$str="insert into test(a1, b1, c1,d1,e1,f1,g1,h1,i1,j1)
value('$a1','$b1','$c1','$d1','$e1','$f1','$g1','$h1','$i1','$j1')";
//设定查询字串,将新输入栏位新增到资料表
mysql_query($str,$link_ID);//送出查询字串
mysql_close($link_ID);//关闭资料库
};
?>
//下面是问卷的内容
<style type="text/css">
<!--
#Layer1 {
position:absolute;
left:99px;
top:24px;
width:716px;
height:524px;
z-index:1;
}
.style1 {
font-size: 24px;
font-weight: bold;
font-family: "新细明体";
color: #000000;
}
.style3 {font-size: 16px}
.style6 {font-size: 16px; font-family: "新细明体"; }
.style7 {font-family: "新细明体"; font-size: 18px; }
-->
</style>
</head>
<body>
<div id="Layer1">
<table width="800" border="1" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td height="43"><p class="style1">一<b>、</b>产品涉入部分</p></td>
</tr>
<tr>
<td height="28"><p class="style7">此部分在於了解您对下列产品的重视程度。</p></td>
</tr>
<tr>
<td height="35"><p class="style7">以下每题都是由一组对立的形容词组成的，选项从左至右代表倾向哪一边的大小程度。 </p></td>
</tr>
</table>
<table width="800" border="0">
<tr>
<td> </td>
</tr>
<tr>
<td><span class="style7">数位相机对我而言是：</span></td>
</tr>
</table>
<form id="form1" name="form1" method="post" action="index.php">
//传出输入资料後,会传送到原来的index.php
<table width="500" border="1" cellpadding="5" cellspacing="0" bordercolor="#000000">
<tr>
<td bordercolor="#666666"><span class="style6">重要的</span></td>
<td bordercolor="#666666">
<input name="a1" type="radio" value="v1" />
<input name="a1" type="radio" value="v2" />
<input name="a1" type="radio" value="v3" />
<input name="a1" type="radio" value="v4" />
<input name="a1" type="radio" value="v5" />
<input name="a1" type="radio" value="v6" />
<input name="a1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">不重要的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">无聊的</span></td>
<td bordercolor="#666666"><input name="b1" type="radio" value="v1" />
<input name="b1" type="radio" value="v2" />
<input name="b1" type="radio" value="v3" />
<input name="b1" type="radio" value="v4" />
<input name="b1" type="radio" value="v5" />
<input name="b1" type="radio" value="v6" />
<input name="b1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">有趣的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">关系重大的</span></td>
<td bordercolor="#666666"><input name="c1" type="radio" value="v1" />
<input name="c1" type="radio" value="v2" />
<input name="c1" type="radio" value="v3" />
<input name="c1" type="radio" value="v4" />
<input name="c1" type="radio" value="v5" />
<input name="c1" type="radio" value="v6" />
<input name="c1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">无关紧要的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">令人兴奋的</span></td>
<td bordercolor="#666666"><input name="d1" type="radio" value="v1" />
<input name="d1" type="radio" value="v2" />
<input name="d1" type="radio" value="v3" />
<input name="d1" type="radio" value="v4" />
<input name="d1" type="radio" value="v5" />
<input name="d1" type="radio" value="v6" />
<input name="d1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">不令人兴奋的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">对我没有意义的</span></td>
<td bordercolor="#666666"><input name="e1" type="radio" value="v1" />
<input name="e1" type="radio" value="v2" />
<input name="e1" type="radio" value="v3" />
<input name="e1" type="radio" value="v4" />
<input name="e1" type="radio" value="v5" />
<input name="e1" type="radio" value="v6" />
<input name="e1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">对我是有意义的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">有魅力的</span></td>
<td bordercolor="#666666"><input name="f1" type="radio" value="v1" />
<input name="f1" type="radio" value="v2" />
<input name="f1" type="radio" value="v3" />
<input name="f1" type="radio" value="v4" />
<input name="f1" type="radio" value="v5" />
<input name="f1" type="radio" value="v6" />
<input name="f1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">不吸引人的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">迷人的</span></td>
<td bordercolor="#666666"><input name="g1" type="radio" value="v1" />
<input name="g1" type="radio" value="v2" />
<input name="g1" type="radio" value="v3" />
<input name="g1" type="radio" value="v4" />
<input name="g1" type="radio" value="v5" />
<input name="g1" type="radio" value="v6" />
<input name="g1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">通俗的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">没有价值的</span></td>
<td bordercolor="#666666"><input name="h1" type="radio" value="v1" />
<input name="h1" type="radio" value="v2" />
<input name="h1" type="radio" value="v3" />
<input name="h1" type="radio" value="v4" />
<input name="h1" type="radio" value="v5" />
<input name="h1" type="radio" value="v6" />
<input name="h1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">有价值的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">我关心的</span></td>
<td bordercolor="#666666"><input name="i1" type="radio" value="v1" />
<input name="i1" type="radio" value="v2" />
<input name="i1" type="radio" value="v3" />
<input name="i1" type="radio" value="v4" />
<input name="i1" type="radio" value="v5" />
<input name="i1" type="radio" value="v6" />
<input name="i1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">我不关心的</span></td>
</tr>
<tr>
<td bordercolor="#666666"><span class="style3">非必需的</span></td>
<td bordercolor="#666666"><input name="j1" type="radio" value="v1" />
<input name="j1" type="radio" value="v2" />
<input name="j1" type="radio" value="v3" />
<input name="j1" type="radio" value="v4" />
<input name="j1" type="radio" value="v5" />
<input name="j1" type="radio" value="v6" />
<input name="j1" type="radio" value="v7" /></td>
<td bordercolor="#666666"><span class="style3">必需的</span></td>
</tr>
</table>
<input type="submit" name="Submit" value="送出" />
</form>
</div>
</body>
</html>
--
告诉自己要有勇气去面对
不要担心...害怕...要去接受它
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 210.59.106.102
1F：推 EAFV:你php的register_globals有开吗? 01/22 21:49
2F：→ EAFV:没开的话要用$_POST['a1']抓资料 01/22 21:49
3F：推 johnney:错误讯息？一并给吧 01/22 23:00