更新时间:2023-11-22 15:52:16
您应该使用mysqli或pdo
您错过了3分:
修正您的查询:
1)确保您选择了所有必填字段。
$ filme_cart = mysql_query(SELECT * FROM cart_test GROUP BY name);
2)尝试使用: mysql_fetch_assoc
$ 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");
?>