 |
ดู Code PHP ให้หน่อยคับ ผมเขียนผิดตรงไหน ช่วยแก้ไขหน่อยคับ เรื่อง Delete |
|
 |
|
|
 |
 |
|
Code (PHP)
<?php
$conn = db2_connect("TEST", "db2admin", "password123");
$sql = "SELECT * FROM animals
ORDER BY id";
echo "<center>";
echo "<p><a href='show_insert.php'>ADD NEW DATA</a></p>";
echo "<table border=1>";
echo "<tr>";
echo "<td>id</td>";
echo "<td>breed</td>";
echo "<td>name</td>";
echo "<td>weight</td>";
echo "<td colspan=2>operator</td>";
echo "</tr>";
if ($conn) {
$stmt = db2_exec($conn, $sql); //, array('cursor' => DB2_SCROLLABLE));
while ($row = db2_fetch_array($stmt)) {
echo "<tr>";
echo "<td>".$row[0]."</td>";
echo "<td>".$row[1]."</td>";
echo "<td>".$row[2]."</td>";
echo "<td>".$row[3]."</td>";
echo "<td>edit</td>";
echo "<td><a href='del.php?id=".$row['0']."'>del</td>";
echo "</tr>";
//print "$row[0] $row[1] $row[2] $row[3]";
}
}
echo "</table>";
echo "</center>";
?>
Code (PHP)
<?php
$conn = db2_connect("TEST", "db2admin", "password123");
// Create the test table
//$create = 'CREATE TABLE animals (id INTEGER, breed VARCHAR(32),
// name CHAR(16), weight DECIMAL(7,2))';
//$result = db2_exec($conn, $create);
//if ($result) {
// print "Successfully created the table.\n";
//}
// Populate the test table
$animals = array($_POST['data']);
foreach ($animals as $animal) {
$rc = db2_exec($conn, "DELETE FROM animals WHERE id = {$animals[0]}");
if ($rc) {
echo "<a href='index.php'>GO HOME</a>";
}
}
?>
ERROR
Notice: Undefined index: data in C:\xampp2\htdocs\DB2\del.php on line 13
Warning: db2_exec(): Statement Execute Failed in C:\xampp2\htdocs\DB2\del.php on line 16
Tag : PHP, MySQL, HTML/CSS
|
|
 |
 |
 |
 |
Date :
2015-06-09 19:22:03 |
By :
kidding |
View :
685 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
foreach ($animals as $animal) {
16.
$rc = db2_exec($conn, "DELETE FROM animals WHERE id = {$animals[0]}");
สีแดงควรเป็นตัวแปรเดียวกัน
แต่ ส่งค่ามาเป็น GET ใช้โค๊ดข้างบนก็ผิด
น่าจะเป็นแบบนี้
$rc = db2_exec($conn, "DELETE FROM animals WHERE id = ". intval($_GET['id']) );
$_POST['data'] เอามาจากไหน
ไม่ได้มีส่งค่าแบบ POST มาเลย
|
ประวัติการแก้ไข 2015-06-09 20:01:21 2015-06-09 20:03:20
 |
 |
 |
 |
Date :
2015-06-09 19:58:06 |
By :
Chaidhanan |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
 |
|
|
 |
 |
|
อ่าได้แล้วคับ ขอบคุณคับ
|
 |
 |
 |
 |
Date :
2015-06-09 20:12:01 |
By :
kidding |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
|
|