作者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