[請益] 如何寫入資料庫

看板PHP作者caca33 (sweet heart)時間19年前 (2006/01/22 21:19)推噓2(2推 0噓 1→)

留言3則, 2人參與討論串1/2 (看更多)

先描述我的需求..我是要寫網路問卷選擇好選項之後送出到資料庫但是有一個問題就是好像無法寫入資料庫在此附上程式碼..請各位大大幫忙一下附註我是用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">  </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