› 看板 PHP 關於我們 聯絡資訊
作者youngwei (mooncolor)
看板PHP
標題[請益] PHP 輸入欄位多筆資料
時間Mon Jul 22 18:13:10 2013
想請問 要輸入兩筆資料，有新增欄位按鍵 如果在欄位輸入編號10和編號20這兩筆資料，從資料庫搜尋編號10和編號20的資料， 顯示在另一個網頁上，請問要怎麼編寫語法? -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 140.128.90.10
→ rickysu:這已經不是語法的問題了。首先你得具備以下基本技能 07/22 18:19
→ rickysu:HTML，SQL了解GET跟POST的差異... 07/22 18:20
→ dlikeayu:就只是單純傳兩個數字告訴後台這兩個數字間的SCOPE 07/23 00:22
推 a60301:[Database] 07/23 03:58
→ a60301:Table: mydata {id int INDEX, data text UTF8} 07/23 03:58
→ a60301:[insert.php] 07/23 03:58
→ a60301:<?php 07/23 03:58
→ a60301: $db = new PDO( 07/23 03:59
→ a60301: "mysql:host=localhost;dbname=mydb", 07/23 03:59
→ a60301: "root", 07/23 03:59
→ a60301: "pass", 07/23 03:59
→ a60301: array( 07/23 03:59
→ a60301: PDO::MYSQL_ATTR_INIT_COMMAND 07/23 03:59
→ a60301: => "SET NAMES UTF8" 07/23 03:59
→ a60301: ) 07/23 04:00
→ a60301: ); 07/23 04:00
→ a60301: if (isset($_POST["id"]) && isset($_POST["data"])) { 07/23 04:00
→ a60301: foreach ($_POST["id"] as $i => $id) { 07/23 04:00
→ a60301: $data = $_POST["data"][$i]; 07/23 04:00
→ a60301: $insert = $db->prepare( 07/23 04:00
→ a60301: "INSERT INTO `mydata` (`id`, `data`)" . 07/23 04:01
→ a60301: " VALUES (:id, :data)" 07/23 04:01
→ a60301: ); 07/23 04:01
→ a60301: $insert->bindParam(":id", $id); 07/23 04:01
→ a60301: $insert->bindParam(":data", $data); 07/23 04:01
→ a60301: $insert->execute(); 07/23 04:02
→ a60301: } 07/23 04:02
→ a60301: header("location: /"); 07/23 04:02
→ a60301: exit(); 07/23 04:02
→ a60301: } 07/23 04:02
→ a60301:?> 07/23 04:02
→ a60301:<!DOCTYPE html> 07/23 04:02
→ a60301:<meta charset="utf-8" /> 07/23 04:02
→ a60301:<script> 07/23 04:03
→ a60301: function more() { 07/23 04:03
→ a60301: var insert = document.getElementById("insert"); 07/23 04:04
→ a60301: var breaker= document.createElement("br"); 07/23 04:04
→ a60301: var label1 = document.createElement("label"); 07/23 04:04
→ a60301: var text1 = document.createTextNode("ID:"); 07/23 04:04
→ a60301: var input1 = document.createElement("input"); 07/23 04:04
→ a60301: var label2 = document.createElement("label"); 07/23 04:05
→ a60301: var text2 = document.createTextNode("Data:"); 07/23 04:05
→ a60301: var input2 = document.createElement("input"); 07/23 04:05
→ a60301: input1.name = "id[]"; 07/23 04:05
→ a60301: input2.name = "data[]"; 07/23 04:05
→ a60301: insert.appendChild(breaker); 07/23 04:05
→ a60301: insert.appendChild(label1); 07/23 04:05
→ a60301: insert.appendChild(text1); 07/23 04:06
→ a60301: insert.appendChild(input1); 07/23 04:06
→ a60301: insert.appendChild(label2); 07/23 04:06
→ a60301: insert.appendChild(text2); 07/23 04:06
→ a60301: insert.appendChild(input2); 07/23 04:06
→ a60301: } 07/23 04:06
→ a60301: more(); 07/23 04:06
→ a60301:</script> 07/23 04:06
→ a60301:<form action="insert.php" method="post"> 07/23 04:07
→ a60301: <div id="insert"></div> 07/23 04:07
→ a60301: <a href="javascript:more();">More</a> 07/23 04:07
→ a60301: <input type="submit" value="insert" /> 07/23 04:07
→ a60301:</form> 07/23 04:07
→ a60301:[list.php] 07/23 04:07
→ a60301:<?php 07/23 04:07
→ a60301: $db = new PDO( 07/23 04:08
→ a60301: "mysql:host=localhost;dbname=mydb", 07/23 04:08
→ a60301: "root", 07/23 04:08
→ a60301: "pass", 07/23 04:08
→ a60301: array( 07/23 04:08
→ a60301: PDO::MYSQL_ATTR_INIT_COMMAND 07/23 04:09
→ a60301: => "SET NAMES UTF8" 07/23 04:09
→ a60301: ) 07/23 04:09
→ a60301: ); 07/23 04:09
→ a60301: $list = $db->prepare("SELECT * FROM `mydata`"); 07/23 04:09
→ a60301: $list->execute(); 07/23 04:09
→ a60301: $tbody = ""; 07/23 04:09
→ a60301: while ($data = $list->fetch()) { 07/23 04:10
→ a60301: $tbody .= "<tr>"; 07/23 04:10
→ a60301: $tbody .= "<td>{$data['id']}</td>"; 07/23 04:10
→ a60301: $tbody .= "<td>{$data['data']}</td>"; 07/23 04:10
→ a60301: $tbody .= "</tr>\n"; 07/23 04:10
→ a60301: } 07/23 04:10
→ a60301:?> 07/23 04:10
→ a60301:<!DOCTYPE html> 07/23 04:10
→ a60301:<meta charset="utf-8" /> 07/23 04:11
→ a60301:<a href="insert.php">insert</a> 07/23 04:11
→ a60301:<table> 07/23 04:11
→ a60301: <thead> 07/23 04:12
→ a60301: <tr> 07/23 04:12
→ a60301: <th>ID</th> 07/23 04:12
→ a60301: <th>Data</th> 07/23 04:12
→ a60301: </tr> 07/23 04:12
→ a60301: </thead> 07/23 04:12
→ a60301: <tbody> 07/23 04:12
→ a60301: <?php echo($tbody); ?> 07/23 04:13
→ a60301: </tbody> 07/23 04:13
→ a60301:</table> 07/23 04:13
→ a60301:[2013/7/23] 07/23 04:13
推 joaner77:這推文... 07/23 11:19
→ PsMonkey:還縮排良好！ Orz 07/23 11:31
→ johnny1972:真厲害的推文 07/23 12:10
→ terrybob:給a60301：你可以用回文… 07/23 12:40
→ RedMapleWing:樓上，我覺得他故意的XD 07/23 13:31
→ RedMapleWing:推文縮排良好，結構清楚，推！ 07/23 13:31
推 small90214:神回覆！！ 07/23 14:11
推 heartinside:縮的真好.... 07/23 14:36
→ lucky1lk:神回覆 07/23 17:31
推 tkdmaf:這我已經不知道要怎麼形容了。光是不推文出錯就很厲害了。 07/23 19:14