Xin mọi người xem code mình sai chỗ .
database
Code:
CREATE TABLE IF NOT EXISTS `fruit` (
`fruit_id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL,
`variety` varchar(50) NOT NULL,
PRIMARY KEY (`fruit_id`)
);
file index.php
Code:
<?php
$dsn = "mysql:host=localhost; dbname=fruitdb";
$username = "root";
$password ="";
try {
$pdo = new PDO ($dsn,$username,$password);
} catch (Exception $e) {
die("Could not connect to the DB \n");
}
$sql = "SELECT * FROM fruit";
$result = $pdo->query($sql);
?>
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td colspan="4" bgcolor="#FFFFFF" align="center"><strong>Edit - Delete data in mysql</strong></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Fruit Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Variety</strong></td>
<td align="center" bgcolor="#FFFFFF"> </td>
</tr>
<?php
foreach ($result as $rows) {
?>
<tr>
<td bgcolor="#FFFFFF"><?php echo $rows['fruit_id']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><?php echo $rows['variety']; ?></td>
<td bgcolor="#FFFFFF"><a href="delete_ac.php?id=<? echo $result['fruit_id']; ?>">delete</a></td>
</tr>
<?php
}
?>
</table>
Code:
<?php
$dsn = "mysql:host=localhost; dbname=fruitdb";
$username = "root";
$password ="";
try {
$pdo = new PDO ($dsn,$username,$password);
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$pdo->exec('SET NAMES "utf8"');
} catch (Exception $e) {
die("Could not connect to the DB \n");
}
$fruit_id=$_GET['id'];
$sql= "DELETE FROM fruit WHERE fruit_id = '$fruit_id'";
$result = $pdo->query($sql);
if($result){
echo "Deleted successfully";
echo "<br>";
echo "<a href = 'index.php'>Back to main page</a>";
}
else{
echo "ERROR";
echo mysql_error();
}
Nhờ mọi người giúp đỡ em với
Bookmarks