每行的PHP / SQL删除按钮 [英] PHP/SQL Delete button for each row
问题描述
好的，我有一个SELECT
$ filme_cart = mysql_query（SELECT name，price FROM cart_test GROUP BY name ）;
然后我有一个如下所示的PHP代码：
<？php
while（$ film_cart = mysql_fetch_object（$ filme_cart））
{
echo< tr> ;
echo< td align ='left'>;
echo $ film_cart-> name;
回声< / td>;
echo< td class ='cart-product-setting'>;
echo $ film_cart-> price;
echo< a href ='delete.php？delete_film =。$ film_cart ['id_film']。''class ='remove-pro'rel ='tooltip'data-title ='Delete'> ;< i class ='icon-trash'>< / i>< / a>< / td>;
回声< / tr>;
}
？>
我的delete.php文件如下所示：
<？php
include'config.php';
$ delete_film = $ _ GET ['id_film'];
$ delete_cart = mysql_query（DELETE FROM cart_test WHERE id_film ='$ delete_film'）;
？>
所以，当我将PHP代码放入网页时，我的< ; body> 消失。
我做错了什么？
您应该使用mysqli或pdo
您错过了3分：
修正您的查询：
1）确保您选择了所有必填字段。
$ filme_cart = mysql_query（SELECT * FROM cart_test GROUP BY name）;
2）尝试使用： mysql_fetch_assoc < （$ film_cart = mysql_fetch_assoc（$ filme_cart））
$ b $ $ $ $ $ $ $ $ $ b {
echo< tr>;
echo< td align ='left'>;
echo $ film_cart ['name'];
回声< / td>;
echo< td class ='cart-product-setting'>;
echo $ film_cart ['price'];
echo< a href ='delete.php？delete_film =。$ film_cart ['id_film']。''class ='remove-pro'rel ='tooltip'data-title ='Delete'> ;< i class ='icon-trash'>< / i>< / a>< / td>;
回声< / tr>;
}
？>
然后： 3）通过 $ _GET ['delete_film']
<？php
包括'config.php';
$ delete_film = $ _ GET ['delete_film'];
$ delete_cart = mysql_query（DELETE FROM cart_test WHERE id_film = $ delete_film limit 1）;
？>
Ok, so I have a SELECT
$filme_cart = mysql_query("SELECT name, price FROM cart_test GROUP BY name");
and then I have a PHP code that looks like this:
<?php
while($film_cart=mysql_fetch_object($filme_cart))
{
echo "<tr>";
echo "<td align='left'>";
echo $film_cart->name;
echo "</td>";
echo "<td class='cart-product-setting'>";
echo $film_cart->price;
echo "<a href='delete.php?delete_film=".$film_cart['id_film']."' class='remove-pro' rel='tooltip' data-title='Delete'><i class='icon-trash'></i></a></td>";
echo "</tr>";
}
?>
And my delete.php file looks like this:
<?php
include 'config.php';
$delete_film=$_GET['id_film'];
$delete_cart = mysql_query("DELETE FROM cart_test WHERE id_film='$delete_film'");
?>
So, when I put that PHP code in my web page, my <body> disappears.
What am I doing wrong?
You should use mysqli or pdo
You have missed 3 points:
fix your query:
1) make sure you have selected all required fields.
$filme_cart = mysql_query("SELECT * FROM cart_test GROUP BY name");
2) Try using: mysql_fetch_assoc
<?php
while($film_cart=mysql_fetch_assoc($filme_cart))
{
echo "<tr>";
echo "<td align='left'>";
echo $film_cart['name'];
echo "</td>";
echo "<td class='cart-product-setting'>";
echo $film_cart['price'];
echo "<a href='delete.php?delete_film=".$film_cart['id_film']."' class='remove-pro' rel='tooltip' data-title='Delete'><i class='icon-trash'></i></a></td>";
echo "</tr>";
}
?>
And then : 3) get value by $_GET['delete_film']
<?php
include 'config.php';
$delete_film=$_GET['delete_film'];
$delete_cart = mysql_query("DELETE FROM cart_test WHERE id_film=$delete_film limit 1");
?>
这篇关于每行的PHP / SQL删除按钮的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
